[ckan-dev] Issues loading large excel file

Brook Elgie brook.elgie at okfn.org
Fri May 15 07:38:44 UTC 2015

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,


On 14 May 2015 at 13:15, Lynn Greenwood <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 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
> 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
> 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/c4dcb042/attachment-0003.html>

More information about the ckan-dev mailing list