I successfully connected Google Sheets to Pigment. After initiating the data import from Google Sheets to Pigment, I receive a message indicating that the import was successful, but the data is not imported into Pigment and I get the following error message:
"Missing column in CSV Some header(s) in the mapping configuration are not found in the CSV."
However, the headers in the imported file are identical to those in the Pigment list.
You will find the screenshots below.
Hi
You can try the following :
1-Download the file that was pushed from GSheet. You can do that from the “…” next to Edit in the Import Summary Screenshot.
2-Check if the file is aligned with your GSheet view. You might have a missing column in that file. In that case you will need to update the GSheet configuration page to include the missing one as it wasn’t correctly setup.
3-If it matches, then try to load this csv file directly using the same configuration but first edit the configuration using this file. You might have a mismatch in the file columns and the Transaction list properties : one is not correctly mapped (check for a red settings next to the properties).
Hope this helps,
Hi there,
We recommend downloading the Gsheet file using the Pigment add-on option “Download export data as CSV.” Once downloaded, use the CSV file to review and update your existing import configuration in Pigment. You should notice some discrepancies in the configuration mapping. After making the necessary updates, your import from Gsheet to Pigment should work as expected.
If you’re still facing difficulties after completing these steps, please let us know!
Thank you, and have a wonderful day!
Hi there,
Thank you for your guidance. I applied all your instructions as described, but I am still having the same error message:
"Missing column in CSV - Some header(s) in the mapping configuration are not found in the CSV."
I used the CSV file to review and update my existing import configuration in Pigment, and it worked ("the Items were Imported"). However, when I pushed the data from Google Sheets to Pigment using the same CSV file, it does not work. I tried to do this with the Pigment Connector add-in for Excel, and it gives me the same error message.
Thank you for your help, and have a wonderful day!
Hi there,
Thank you for your response!
Could you please create a Support ticket with us using the following link: https://support.pigment.com/en/support/home, so we can take a closer look at the issue?
Many thanks!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.