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

TOPIC: csv imoprt is truncating data

csv imoprt is truncating data 9 years 8 months ago #1884

  • ajw3208
  • ajw3208's Avatar
  • Offline
  • Новый участник
  • Posts: 12
  • Karma: 0
hi,

I have noticed that the CSV import facility is truncating the import randomly.

the files attached demonstrate the problem.

first file shows a line that is correct.
file 2 shows a item that is incorrect.
file 3 shows what is in the d/base (data does not match csv file)
file 4 is the import file

Importantly, the info in the d/base is appearing in the item info. The issue is in the import to dbase. there are "-" in the text, but the column is delimited by "". all the lines in the csv file are essentially the same. The first line is imported OK , but the remainder are being truncated (particulary those with "-" in them)

This is a MAJOR problem as I am about to go live with this and if all goes well, will consider upgrading to the paid version, but until this issue is resolved, I can't proceed an will be forced to look for alternative (which would be a shame as this is a good component. It'd be great is it had a option for multiple single costs such as setup costs)

Joomla version 3.3.3 (fully pacthed)
iprice version 1.11.1 (latest version)
Last Edit: 9 years 8 months ago by ajw3208.
Login or register to post message.

csv imoprt is truncating data 9 years 7 months ago #1923

  • support
  • support's Avatar
  • Offline
  • Администратор
  • Posts: 1905
  • Thank you received: 311
  • Karma: 59
It seems that you use not UTF-8 encoding for your CSV import file. Try to convert your CSV file to UTF-8 encoding and then do import.
Last Edit: 9 years 3 months ago by support.
Login or register to post message.

solved - csv imoprt is truncating data 9 years 7 months ago #1962

  • ajw3208
  • ajw3208's Avatar
  • Offline
  • Новый участник
  • Posts: 12
  • Karma: 0
Thanks,

I haven;t had the issue before but you are correct utf-8 required.
Login or register to post message.
Moderators: support

Subscribe



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

Login