Unexpected errors in CSV upload
-
Hi
I’m struggling with an error in the csv upload process.
I have a CSV file with 7 rows inc Header.
I’ve created a target table using Data Designer for the data to be loaded into,
mapped CSV to the table with headings set correctly ( I think ) and validated the load using preview – all looks as expectedBut … I’m getting errors in the CSV load process
I can send screenshots of the CSV preview, mapping and error ( looks like I can’t upload them here )
Any help welcomed – thanks
Messages from load copied below
Reading CSV file info…
Validating column mapping…
Enabling buffering…
Reading CSV file…
Connecting to database…
Error: Unknown column ‘cinnamon’ in ‘field list’
Error:
Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘violet,null,null,’https://xxxx/uploads/2020/08/image….’ at line 1
Error: Unknown column ‘blackcurrant’ in ‘field list’
Error: Unknown column ‘green’ in ‘field list’
Error: Unknown column ‘green’ in ‘field list’
Error: Unknown column ‘blackcurrant’ in ‘field list’
Import ready!0 rows inserted
7 errors (not inserted)Mike
- The topic ‘Unexpected errors in CSV upload’ is closed to new replies.