search

ckan / datapusher

A standalone web service that pushes data files from a CKAN site resources into its DataStore
GNU Affero General Public License v3.0
77 stars 155 forks source link

DataPusher / DataStore is truncating decimals and dropping columns with decimals from XLS / XLSX files #88

Closed ageara closed 9 years ago

ageara commented 9 years ago

When xls and xlsx files are uploaded with columns/fields with decimals - the decimal columns are truncated if they are identified as latitude, lat, longitude, long and not pushed into the datastore if they are labelled with anything else.

See examples loaded to demo site http://demo.ckan.org/dataset/new-dataset-test-for-truncation

ageara commented 9 years ago

Resolved issue on our site by updating the version of datapusher to 0.0.6. Truncation may be the result of different versions of SQLAlchemy drivers?