1. GabrielB
  2. RO CSVI
  3. Friday, 15 July 2016
  4.  Subscribe via email
I need import a csv file and its text include " because I need to indicate that a value are inchs.
But when I import the file this give me error.
The text that I need to import contain:
ABRAZADERA CAÑO DE ESCAPE 2"

How I can indicate in file the " for inchs?
Thanks!!
Accepted Answer Pending Moderation
Hello,
You need to duplicate the " to use it as inchs, For example
"product_desc"
"ABRAZADERA CAÑO DE ESCAPE 2""
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello,

The correct format is:
"product_desc";"product_sku"
"ABRAZADERA CAÑO DE ESCAPE 2""";"ABC"
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Thanks for you answer, I did that you said me but it not works.
I send screens
- csv file
- screen import preview
- screen set import template

Can you any error in that?
I add "" in each text that I need.

The rest of the products see well in the import preview, so may do a problem with the ""
What I do?
Thanks
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,

You haven't fully understood the CSV requirements. The image called csvfile is not a CSV file but an image of a spreadsheet. In your spreadsheet you only need to write 2 double quotes. However your CSV file, the file you will import is going to require text enclosures. So you need to set the text enclosure in your template settings as well.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
I undertand and I did a txt as this and works, but I have a excell with 1700 products for importing. So I convert the excell to csv file for importing.

Are 1700 products, if I need to do a file text I would spend many time. How I can convert the excell for importing?
How I can do when I have many products to import?
Thanks

---------------------------------------------
"product_sku";"product_name";product_desc";"category_path";"product_aplicacion";"product_modelo";"product_oem1";"product_oem2";"product_sistema";"product_rubro";"product_subrubro";"manufacturer_name";"published";"metarobot";"file_url"
"ACE001";"ABRAZ.CAÑO DE ESCAPE 2""";"ABRAZADERA CAÑO DE ESCAPE 2""";"01 SISTEMAS/ACCESORIOS/ABRAZADERA|02 APLICACION/UNIVERSAL";"ACCESORIOS";"UNIVERSAL";UNIVERSAL";;"ABRAZADERAS";"ABRAZADERAS DE ESCAPE";;"PERFECTO";"1";"ABRAZADERA CAÑO DE ESCAPE 2""";"ACE.jpg"
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
As you still have not provided the CSV file you want to import I am going to ask you for it. Post a sample of the file you want to import after you saved it with Excel. Although Excel is horrible at supporting CSV files, a better option is to use LibreOffice or OpenOffice as explained in the Save a CSV file as UTF-8 document.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!