[Qgis-user] Points layer from table tool truncating texts

[Bernd Vogelgesang]

Hi,
ok, this looks like a bug!

When I chose sqlite after performing "fixed distance buffer" function and  
naming the layer "test", the constructed file name in the dialog is indeed  
"test.sqlit" and saving it, it becomes "test.sqlit.shp"
But when I just add the "e" to the path of "test.sqlit" -> "test.sqlite",  
it saves the file as a SQLITE layer as it should!

Can anyone borrow an "e" to the developers?
Seems like none ever used this format before?


Apart from that, I do not fully understand what this sqlite layer is. It's  
not spatialite cause I can't connect over "Add spatialite layer" but just  
over normal "Add vector layer" and the fields all have lenght and  
precision zero, but neverthelless contain everthing that was in the  
original (can't test with strings longer than 255 cause I havent got any  
source for such at the moment).

Anyway, just try adding the "e" for .sqlite manually and have a test with  
the resulting sqlite layer and please report back how things worked out.


Am 03.12.2014, 12:59 Uhr, schrieb <anderso at anlaggarna.se>:

> Thank you for helping out.
>
> Comments below:
>
>> Did you create the layer as a temporary one? So then its stored as an  
>> ESRI
>> shape and the dbf will not store more characters.
>
> Used temporary before and i understand the problem better now.
>
>> Or did you also try to save it directly into another format which  
>> supports
>> longer fields (errm, here I'm lost too, cause I do not know most of the
>> formats available, but maybe try sqlite)
>
> I've tried "all" possible file-formats that can be selected in the  
> "Points
> Layer from Table" tool and it seems like they all store the result like
> shape files (using a dbf database file).
>
> Selecting sqlite-format:
> sqll.sqlit.dbf
> sqll.sqlit.prj
> sqll.sqlit.qbj
> sqll.sqlit.shp
> sqll.sqlit.shx
>
> I'm rather confused here, i expected to find raw files with the selected
> format as output?
>
> So this is leading in the direction that i can't use the tool if i want
> longer text fields.
>
> Some other ideas (partly evaluated):
> - The EVIS database tools seem to support longer strings but have issues
> with national characters and fails to add all points "missing  
> georeference
> infomation)?
> - The "SAGA convert table to points" seems to be missing/removed in QGIS?
>
>>
>> Cheers
>> Bernd
>>
>
> Thanks
>
> /AO
>
>>
>> Am 03.12.2014, 10:07 Uhr, schrieb <anderso at anlaggarna.se>:
>>
>>> Hi!
>>>
>>> I'm having a problem with the "Points Layer from Table" tool.
>>>
>>> The source data contain string/text data longer than 255 characters
>>> (memo
>>> fields from MS Access)
>>>
>>> The fields are truncated to 255 characters in the resulting point layer
>>> when looking in the "attribute table window"
>>>
>>> When opening the source data layer in the "attribute table window" the
>>> fields are not truncated so the problem must be in the tool itself.
>>>
>>> The source layer is created using "create vector
>>> layer->Database->ODBC->...."
>>>
>>> Does anyone have a workaround for this?
>>>
>>> I found some tips about using the SAGA "create points from table" tool
>>> instead but i can't find it in QGIS?
>>>
>>> I'm using QGIS 2.6.1
>>>
>>> BR
>>>
>>> /AO
>>> _______________________________________________
>>> Qgis-user mailing list
>>> Qgis-user at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>>
>> --
>> Bernd Vogelgesang
>> Siedlerstraße 2
>> 91083 Baiersdorf/Igelsdorf
>> Tel: 09133-825374
>>
>>
>


-- 
Bernd Vogelgesang
Siedlerstraße 2
91083 Baiersdorf/Igelsdorf
Tel: 09133-825374