Chrome extension to add a metadata layout on top of the standard Salesforce UI to improve the productivity and joy of Salesforce configuration, development, and integration.
328
stars
124
forks
source link
(Up|in)sert Excel format with cell starting with `"` fails to parse data #248
Paste into salesforce inspector with Excel format checked
Expected
The preview shows headers and the only line well parsed
Actual
The parsing fails with Error: unexpected token ' '
Cause analysis
Excel format seems to rely on csv-parser.js which checks for " at start of cell content as string identificator. In turn, the content until next " is considered for cell value (pseudo in my repro data), then cell separator is expected. It fails du to finding anything but cell separator ( in my repro data).
This is NOT helpfull for Excel content
Possible workarround
Sanitize cells by adding a space before starting " ( used for now)
Hi,
When attempting to upsert (or insert) data from Excel format fails to parse it if some cells start with
"
.Steps to reproduce
Create an excel workbook and sheet containing
Copy sheet content from excel
Paste into salesforce inspector with Excel format checked
Expected
The preview shows headers and the only line well parsed
Actual
The parsing fails with
Error: unexpected token ' '
Cause analysis
Excel format seems to rely on
in my repro data). This is NOT helpfull for Excel content
csv-parser.js
which checks for"
at start of cell content as string identificator. In turn, the content until next"
is considered for cell value (pseudo
in my repro data), then cell separator is expected. It fails du to finding anything but cell separator (Possible workarround
"
( used for now)`