CSV Import - Error decoding JSON data: Syntax error - Cobalt 8

Quote

Total posts: 178
26 Sep 2018 20:17

I'm doing a CSV import that has worked fine in the past but now I get the following error at the last stage: Error decoding JSON data: Syntax error This is with Cobalt 8.762 that I just installed a couple weeks ago. I haven't tracked down in the code where this is happening yet but it's almost like it's thinking it's json data instead of csv even though it seems to read it properly in stage 2. Any ideas where the problem is?

Last Modified: 04 Oct 2018

Quote

pepperstreet VIP

Total posts: 3,837
30 Sep 2018 23:35

Hello, did you add any new field type? Maybe that message is not referring to the entire import process but a single field. Or its multiple values.

Quote

nblgeoweb

Total posts: 178
01 Oct 2018 12:07

Thanks for the suggestion. That got me on the right track. I was using a previously saved import settings. When I created a new one, the process worked. I tried creating new import settings, which were actually identical to the settings that were saved, and it worked.

I looked in the js_res_import table and verified that they were identical. I think the problem is in the crossids column of that table. It looks like it has something to do with the unique id checking for updates. It's a json string and the last value was truncated for some reason. It might have been a strange character in a file I loaded last time that might have caused the problem.

Quote

pepperstreet VIP

Total posts: 3,837
04 Oct 2018 01:38

nblgeoweb Thanks for the suggestion. That got me on the right track.

Phew! Lucky me ;)

CSV Import - Error decoding JSON data: Syntax error

Login (copy)