Using CSV as a Data Source
1. Why are my CSV file uploads encountering errors when sending out documents?
Errors in inputs or formatting may result in docCentral being unable to send out the documents as indicated in the CSV file. If you are encountering errors, do check your CSV file before trying to upload and send documents with your CSV file again.
The table below outlines the types of errors that would trigger an error message:
** Accepted date formats: “DD/MM/YYYY”, “D/M/YYYY”, “DD/MM/YY”, “D/M/YY”, “DD MMM YYYY”, “D MMM YYYY”, “DD MMM YY”, “D MMM YY”, “DD MMMM YYYY”, “D MMMM YYYY”, “DD MMMM YY”, “D MMMM YY”, “DD-MM-YYYY”, “D-M-YYYY”, “DD-MM-YY”, “D-M-YY”, “DD-MMM-YYYY”, “D-MMM-YYYY”, “DD-MMM-YY”, “D-MMM-YY”, “DD-MMMM-YYYY”, “D-MMMM-YYYY”, “DD-MMMM-YY”, “D-MMMM-YY”
2. Why is my document displaying duplicated zero values for cells left blank in my CSV file?
If you are using number placeholders, a value of 0 will appear when the corresponding column cell is left empty. To avoid this, consider using short/long placeholders instead.
Before
After
