Thank you for your inquiry.
I think maybe such error has occurred by different the number of columns because there is contained the comma in the string data that you want to import.
That matter will resolve likely if you make the appropriate escape.
For example,
Inappropriate CSV file:
ID,name,gender,age,user_id,profile,created
,Firstname Lastname,male,20,1,If in the string data that contains the comma, you should make the appropriate escape.,2016/6/25 0:00
Note: The first line of the CSV is the index of the column name
Specifies to the setting of “Prepend Indices Line” in the same column name order as the first line of the CSV when you import.
Then it will occur error after you import.
The reason is as follows:
The candidate of importing column: 7 columns
| ID | name | gender | age | user_id | profile | created |
The actual column of data: 8 columns
| | Firstname Lastname | male | 20 | 1 | If in the string data that contains the comma | you should make the appropriate escape. | 2016/6/25 0:00 |
Exactly it the number of the column does not match.
In order to import correctly at this example, we should change the data of CSV in the following.
Properly escaped CSV file:
ID,name,gender,age,user_id,profile,created
,Firstname Lastname,male,20,1,"If in the string data that contains the comma, you should make the appropriate escape.",2016/6/25 0:00
Please wrap at quote of strings that contains the comma.
Thank you,
