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""
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello,
The correct format is:
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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)
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.
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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"
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"
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »