search

gltn / stdm

STDM is a free and open source pro-poor land recordation system based on QGIS, PostgreSQL and PostGIS.
http://stdm.gltn.net/
GNU General Public License v2.0
30 stars 30 forks source link

Exporting STDM data fails #347

Closed vutegha closed 3 years ago

vutegha commented 5 years ago

@gkahiu The data exportation tool is misbehaving when trying to export data in .csv file.

The data exportation tool is misbehaving when trying to export data in .csv file. The output file is well created with column names but it cannot write data into the created file. The error says: wrong number or type of arguments for arguments for overloaded function ‘Feature_SetField’

exporting data

gkahiu commented 5 years ago

@wondie could you have a look at this.

@vutegha could you please send Wondie a backup of the database and the configuration file? Also indicate which entity/table (and corresponding columns) you were trying to export?

wondie commented 5 years ago

@vutegha this error happens when OGR (the library we are using for exporting) does not support a data type. If the table has geometry, I suggest you export it using qgis save as layer. If it has no geometry, I suggest you to export it from postgres.

vutegha commented 5 years ago

@wondie

@wondie could you have a look at this.

@vutegha could you please send Wondie a backup of the database and the configuration file? Also indicate which entity/table (and corresponding columns) you were trying to export?

@gkahiu I am trying to export a party entity. Okay @wondie . it works from postgres. The entity I am trying to export does not have geometry. However, it has related entity , loopup and varying text data type. Can one of this prompt this error?

wondie commented 5 years ago

@vutegha I don't think they cause a problem. Do you have a whole number type? And date or date_time type?

vutegha commented 5 years ago

Dear Wondie, Yes, there is date_time type.

I wanted to raise this to see if we can find a possible solution.

On Tue, Oct 2, 2018 at 1:45 PM Wondimagegn Tesfaye notifications@github.com wrote:

@vutegha https://github.com/vutegha I don't think they cause a problem. Do you have a whole number type? And date or date_time type?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/gltn/stdm/issues/347#issuecomment-426243352, or mute the thread https://github.com/notifications/unsubscribe-auth/AVfq1ejxj4hOiCkmH1a0MqgLGDZ861wOks5ug1HVgaJpZM4XBYmM .

-- :: :: Serge K. VUTHEGHA LIS & GIS Specialist

sergyo.vutegha@congoinitiative.org (+243) 99 24 05 948, 81 60 05 404 Skype: sergyo.vutegha

pgathogo commented 5 years ago

This issue is now fixed.