[ckan-dev] Issues loading large excel file

Fri May 15 08:40:32 UTC 2015

Thanks for the reply, I’ve updated any/all duplications I can find but it fails with the same error.

https://opendata.akvo.org/dataset/vanuatu-wash-assessment-april-2015/resource/9f05c411-cff9-41f6-9653-df8192c5e5e8

> On 15 May 2015, at 09:38, Brook Elgie <brook.elgie at okfn.org> wrote:
> 
> Hi Lynn,
> 
> It looks like the problem may be non-unique headers. For example: Columns AS and AW have the same header "Is there another SANITATION key issue?"
> 
> If I remove all the other columns, leaving only those two, I can't upload to the datastore without an error. However, if I make the headers unique, I can upload.
> 
> Obviously, the error message coming back hasn't been very helpful.
> 
> Hope this helps,
> 
> Brook
> 
> On 14 May 2015 at 13:15, Lynn Greenwood <lynn at akvo.org <mailto:lynn at akvo.org>> wrote:
> 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://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
> 
> 
> 
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org <mailto:ckan-dev at lists.okfn.org>
> https://lists.okfn.org/mailman/listinfo/ckan-dev <https://lists.okfn.org/mailman/listinfo/ckan-dev>
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev <https://lists.okfn.org/mailman/options/ckan-dev>
> 
> 
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20150515/e2029b97/attachment-0003.html>