Error Importing: {FIELD_NAME} must not be empty
- Paul Delannoy (Unlicensed)
Problem
User uploads cardholder data using the excel template. The data is all filled in, yet the uploader cannot read one of the field names and says it is empty for all rows in the file.
Solution
The issue seems to lie with the use of the SheetJS library referenced in xlsxworker.js. Instead of debugging the JavaScript, I converted the Excel file to XML format for upload.
Convert the 2 date columns to string format.
Here is an Excel formula to convert the date columns to string format:
= CONCATENATE(YEAR(E2), "-", RIGHT(CONCATENATE("0", MONTH(E2)), 2), "-", RIGHT(CONCATENATE("0", DAY(E2)), 2))Open the Excel file below to save your data in the XML format.
Copy all the data from the original file to the XML export file.
Now go to the DEVELOPER tab and choose Export to save your file in XML format.
You can now upload your file using PCOCDS.
Attached Document
