CSV file import problems
Permalink Browser Info Environment
I'm unable to find the sample cvs file you suggest downloading so the format is correct. Can you point me in that direction? (From the getting started page).
Thanks.
Thanks.
Type: | Pre-Sale |
---|---|
Status: | Resolved |
Thank you, With this format I get the error "too many columns"... so if I create my doc in google docs then export as .csv then import, I get this error:
An exception occurred while executing 'INSERT INTO bthwstorelocation(name, address, city, state, country, zip, phone, email, url, urltext, extra, gID) values ( 'Square B Tack','4401 County Rd 7','Florence','AL','USA','35633','256-767-5203','','' )': SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1
Please advise. Thank you!
An exception occurred while executing 'INSERT INTO bthwstorelocation(name, address, city, state, country, zip, phone, email, url, urltext, extra, gID) values ( 'Square B Tack','4401 County Rd 7','Florence','AL','USA','35633','256-767-5203','','' )': SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1
Please advise. Thank you!
Thank you, With this format I get the error "too many columns"... so if I create my doc in google docs then export as .csv then import, I get this error:
An exception occurred while executing 'INSERT INTO bthwstorelocation(name, address, city, state, country, zip, phone, email, url, urltext, extra, gID) values ( 'Square B Tack','4401 County Rd 7','Florence','AL','USA','35633','256-767-5203','','' )': SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1
Please advise. Thank you!
An exception occurred while executing 'INSERT INTO bthwstorelocation(name, address, city, state, country, zip, phone, email, url, urltext, extra, gID) values ( 'Square B Tack','4401 County Rd 7','Florence','AL','USA','35633','256-767-5203','','' )': SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1
Please advise. Thank you!
It looks like Google docs has removed some columns. You only have 9 columns you are trying to import.
Open the csv file in text editor and review the amount of columns.
Ed
Open the csv file in text editor and review the amount of columns.
Ed
Are you still experiencing these issues?
Ed
Ed
Yes! All good. Thanks for your help with that!
go to Import stores and on the top right you will see a button Export sample CSV
Ed