Geotrace and Geoshape points are lost because of the maximum number of characters is 255

[mylesmcd]

Hi all, My issue relates closely to #471. We are trying to collect trace data but are hitting the 255 character limit. I attach to this issue an xml that uses the suggested odk:length syntax. In our case I have set the length to 50000.

Here is the xml of a test project: test_polytrace3.txt

When I check this table in Postgis the odk:length instruction works for the field with size 99 but not for the 50000 length field, which is fixed at 255. See attached screenshot of the table definition SQL.

Until this is fixed we have to use a very labourious workaround... Best, Myles

[mathieubossaert]

Hi,

I don-t know the workaround you use but you can increase the length of the field to prevent such a problem. https://docs.opendatakit.org/aggregate-field-length/

[ggalmazor]

Thanks for answering, @mathieubossaert. That's the way to work around this problem.