Last year I wrote a C3 program that needed a big array. I put the data in Excel and wrote some VBA code to export it to JSON. Then I added the file to Construct 3.
This works perfectly every time.
Now I'm working on a new program and I want to replicate what I did before. I grabbed the Export code from my old program and put it in my new one, but I can't get it to import into C3. First, I validated the JSON file with json lint (it's perfect). Then I thought the issue was some Spanish characters I had in the text files. So as a test I replaced all the sentences with English, and made sure there were no trailing characters.
It still won't import into Construct 3.
Finally, I said 'screw it' and I just made a copy of the old program and replaced the old text with my new (English only) text.
It STILL won't import into Construct 3.
This makes NO sense to me. Does anyone have ANY idea what the problem could be???
OLD JSON (imports perfectly)
{"c2array": true,"size": [3,7,1],"data": [[[""],[""],[""],[""],[""],[""],[""]],[["7/23/2023"],["gapes"],["croon"],["blare"],["Do you remember mood rings? I have been wearing one since the 1980's, but I seem to have lost it."],["I'm not sure how to feel about that."],["0"]],[["7/24/2023"],["eek"],["reek"],["jut"],["Every weekend we take Mom to a restaurant called \"Aunt Alice's\". Their sign says: \"Breakfast! Any time!\""],["So I like to tell our waitress, Amanda: \"Pancakes, please… during the Renaissance.\""],["0"]]]}
NEW JSON (won't import into C3)
{"c2array": true,"size": [3,5,1],"data": [[["Spanish"],["English"],["Category"],["Bucket"],["Schedule"]],[["Hola"],["Hello"],["General Conversation"],["New"],["New"]],[["Hola"],["Hello"],["General Conversation"],["New"],["New"]]]}
Again, these two files were generated using the EXACT SAME code, from a simple Excel sheet with x,y rows of text. (Both of the JSON files have this encoding: UTF-8-BOM.)