Hitting Excel limits with large JSON in a cell #54
Labels
bug
Something isn't working
External Bug
It is not my fault (anonymous Geologist)
Ingest Setup
Knobs and Levers you move while thinking about feelings and metadata and CSV files
Milestone
What?
Discovered yesterday. Excel as a design limit of 32767 chars per cell. CSV has no limit. But because we use the
PHPSpreadsheet
as generalized way of reading anything the using the Spreadsheet AMI Import Plugin, and somehow someone decide it was a good idea to put a truncation method on read (while would you do that? I mean worst case put it on write back!) large JSONs (not your usual JSONs, we are speaking about hundred of objects in an imported finding EAD) get cut after import and JSON is no longer valid. Of course nothing "fails" it just skips that data.Solution: Identify the file first, if its a CSV the use the native PHP method (we already have a method in our AMI Service for that) to fetch the data via ::getData()
The text was updated successfully, but these errors were encountered: