import csv errors

6 years 4 months ago #3385 by info@skelp.org
import csv errors was created by info@skelp.org
Using store locater version 2.3.0 on a joomla 3.6.0 site
I am trying to import a csv file but get the error message:

Found: 64 locations. Imported: 0 locations. Errors: 64 locations.
Error Importing Row: 1 - Incorrect number of columns. Make sure you Have 18+ Columns
Error Importing Row: 2 - Incorrect number of columns. Make sure you Have 18+ Columns
Error Importing Row: 3 - Incorrect number of columns. Make sure you Have 18+ Columns
Error Importing Row: 4 - Incorrect number of columns. Make sure you Have 18+ Columns
etcetra.

The import file I'm using is created via the export function of store locator Version 1.7.5.3 and a joomla 2.5.28 site.

I opened the csv file to compare it with the example file (created from the new site) and as far as I can see the file meets the needed requirements.

Could you tell me what I should do to make it work?

Thanks in advance.
The topic has been locked.
More
6 years 4 months ago #3391 by sysgenmedia
Replied by sysgenmedia on topic import csv errors
I believe the 1.7.5.3 version has a different column configuration.

The easiest way to fix, is to update the J2.5 site to the latest J2.5 compatible version of the store locator (v.1.8.11 as of this writing) and then try the export again.
The topic has been locked.
More
6 years 4 months ago #3392 by info@skelp.org
Replied by info@skelp.org on topic import csv errors
Thank you,

I will try updating to that version first. Where/how can I download it? (My subscription was expired some months ago and i only need for exporting with the right column configuration :( ). Or how can I change the column configuration.

Kind regards,
Liesbeth
The topic has been locked.
More
6 years 4 months ago #3393 by sysgenmedia
Replied by sysgenmedia on topic import csv errors
Please contact support directly and we can help you.
The topic has been locked.
More
6 years 4 months ago #3394 by info@skelp.org
Replied by info@skelp.org on topic import csv errors
Hi,

One day ago I contacted you via e-mail. Did you get my message?

Liesbeth.
The topic has been locked.
More
6 years 4 months ago #3395 by info@skelp.org
Replied by info@skelp.org on topic import csv errors
Hello,

Again, did you get my e-mail message? I did not get a reply until now.
Could you please let me know what am I supposed to do? You can contact me via This email address is being protected from spambots. You need JavaScript enabled to view it.
The topic has been locked.
More
6 years 3 months ago #3398 by sysgenmedia
Replied by sysgenmedia on topic import csv errors
Please check your email, we found your email and replied! Sorry for the wait!
The topic has been locked.
More
6 years 3 months ago #3400 by info@skelp.org
Replied by info@skelp.org on topic import csv errors
Thank you, it works perfect now
The topic has been locked.
More
5 years 8 months ago - 5 years 8 months ago #3515 by ovg
Replied by ovg on topic import csv errors
Dear Support,

I have exactly the same problem. Import a file gives me also the error:

Error Importing Row: 1 - Incorrect number of columns. Make sure you Have 18+ Columns

Even if I export the sample file and import the sample file, it won't work. Please help!

I used version 2.2.0 and Joomla 3.6.5. It's no problem for me to buy the latest version, but I want to know if this problem will resolved in a new version.

I attached a file that I can usely import without problems. But no I got the columns error.

Kind regards,
OVG
Attachments:
Last edit: 5 years 8 months ago by ovg.
The topic has been locked.
  • ovg
5 years 6 months ago #3535 by sysgenmedia
Replied by sysgenmedia on topic import csv errors
Hi OVG,

If you are still having an issue please email the CSV file to support and we can take a look.

Thanks
The topic has been locked.
More