IPrice minimart
powerfull & flexible online Store, price-lists and catalogs for Joomla
Welcome, Guest
Username: Password: Remember me

TOPIC: CSV Import

CSV Import 9 years 1 month ago #2489

  • Meszros
  • Meszros's Avatar
I am having problems with CSV import. First of all, I don't understand why you guys changed the delimiter from comma to semicolon. CSV = Comma Separated Values

Anyway, I have a long list of products. and would like to import it. The problem comes here, EXCEL cannot handle semicolon separated CSV files. I have tried everything, I changed (replaced) the commas to semicolon in the csv, I changed the settings from comma to semicolon in iPrice, no luck. It always imports 1 line only.

The other thing, if the category name does not exist, it won't be created. It should be, according to the manual.

Message I get: "Line 1: Error! Category name "Category 1" not found !
Import finished succesfully"

The admin backend and your manual says different things about the headers.

This is the manual: www.iprice-web.ru/en/iprice-calculator-u...dministration-import

This is backend:


1.Category name
2.Item name
3.Cost
4.Short description
5.Full description
5.Type of item select (0 - checkbox; 1 - count select; 2 - radio button )
6.ID of radio group (for items with select type=2 only).

Order is completely different. Anyway, can you provide me a CORRECT CSV sample file?

Attached the File I am trying to use.
Last Edit: 9 years 1 month ago by Meszros.
Login or register to post message.

CSV Import 9 years 1 month ago #2490

  • support
  • support's Avatar
  • Offline
  • Администратор
  • Posts: 1905
  • Thank you received: 311
  • Karma: 59
You have confused the different components. You use IPrice calculator LIGHT and so You need to use the user guide for IPrice calculator LIGHT, but not for IPrice calculator: www.iprice-web.ru/en/products/iprice-light-overview
Login or register to post message.

CSV Import 9 years 1 month ago #2491

  • Meszros
  • Meszros's Avatar
Thanks for the quick answer. But still not working. Still
just one line is imported. No error message. Please find attached the csv I am trying to use. Can you please check it? I am using the option: File has field headers : No

Another question. I purchased com_ipricecalc_1_5_XX_J25-30.zip, but this is not working with Joomla 3.2. Can I get the newer version without buying a new licence? I purchased it already after all.

Thanks,

My CSV:

Category 1;Item name 1;100
Category 2;Item name 2;100
Category 3;Item name 3;100
Last Edit: 9 years 1 month ago by Meszros.
Login or register to post message.

CSV Import 9 years 1 month ago #2492

  • support
  • support's Avatar
  • Offline
  • Администратор
  • Posts: 1905
  • Thank you received: 311
  • Karma: 59
I will check CSV import for IPrice calculator LIGHT today evening.
Let me know please an order date for iPrice calculator.
Login or register to post message.

CSV Import 9 years 1 month ago #2493

  • Meszros
  • Meszros's Avatar
It was almost a year ago.
Login or register to post message.
Moderators: support

Subscribe



Subscribe to our newsletter and social networks to be updated with the latest updates.

Login