[ckan-dev] Issues loading large excel file

Thu May 14 12:15:22 UTC 2015

Hi there

We’re looking for some advice.

We’re been trying to get https://opendata.akvo.org/dataset/vanuatu-wash-assessment-april-2015/resource/9f05c411-cff9-41f6-9653-df8192c5e5e8 <https://opendata.akvo.org/dataset/vanuatu-wash-assessment-april-2015/resource/9f05c411-cff9-41f6-9653-df8192c5e5e8> this resource to load correctly to the datastore but it keeps throwing up one error after another.

We’ve managed to get rid of some errors by removing the offending data but right now, there is nothing else we can remove, as the data would then be meaningless.

When we load this we currently get a very un-user friendly error :Error: CKAN DataStore bad response. Status code: 500 Internal Server Error. At: http://opendata.akvo.org:8080/api/3/action/datastore_create.
HTTP status code: 500
Response: <html> <head> <title>Server Error</title> </head> <body> <h1>Server Error</h1> An internal server error occurred </body> </html>
Requested URL: http://opendata.akvo.org:8080/api/3/action/datastore_create <http://opendata.akvo.org:8080/api/3/action/datastore_create>

It seems like it has something to do with the headers of the columns as if I update the column header names to ‘a, b, c, d,e, f, aa,bb,cc’ etc the file loads without any problem.

I’ve removed all of the funny characters, numbers, etc but it still won’t load.

Any ideas or anyone with a similar issue?

thanks
Lynn

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20150514/5769dc4c/attachment-0002.html>