Hello,
The file that I had import have ( " ) in there rows like this for example:
0010068191 8434264004757 Camiseta "non hai ferramenta para.." chocolate home xl "non hai ferram 19,95 GLG "NON HAI MALA FERRAMENTA PARA O BO TRABALLADOR REIZENTOLO http://imagenes.serlogal.com/imagenes_big/8434264/843426400475.JPG 10 3 Merchandising Merchandising > REIZENTOLO 21,00
----------------------------------------------------
like you can see in the part of the text "NON HAI MALA FERRAMENTA PARA O BO TRABALLADOR there is not finall ("
and the next line have it
--------------------------------------
0010068193 8434264004733 Camiseta "non hai mala ferramenta.." chocolate home m "non hai mala fe 19,95 GLG "NON HAI MALA FERRAMENTA PARA O BO TRABALLADOR" REIZENTOLO http://imagenes.serlogal.com/imagenes_big/8434264/843426400473.JPG 10 5 Merchandising Merchandising > REIZENTOLO 21,00
-----------------------------------------------
In the template configuration I have in file--> Text Enclosure --> "
The problem is that when This happend; after the import the products that are in the next line of a product that don´t have close the (", that products create wrong.
My Question is, in the TEXT ENCLAUSURE of my import template, I can delete (" and get it blank to solve this problem?
Accepted Answer
Pending Moderation
Hello,
If you specify no text enclosure, PHP will use the " by default. Although I have to say I haven't tried leaving it empty and import a file like yours. You could try with 1 product and see if it works for you. I don't understand your data though, where does one field start and the next end.
By the CSV standard if you have " in your text you should enclose the fields as well. A sentence would look like this:
If you specify no text enclosure, PHP will use the " by default. Although I have to say I haven't tried leaving it empty and import a file like yours. You could try with 1 product and see if it works for you. I don't understand your data though, where does one field start and the next end.
By the CSV standard if you have " in your text you should enclose the fields as well. A sentence would look like this:
123,"this is ""some"" code"
now CSV readers know that the word is "some". 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
Hi Rolandd
I have import with the Text Enclosure in blank an take by default " like you said.
The problem is taht the archive that we import it can´t be change or fix that products, so What solution can you give to me for that cases???
I have import with the Text Enclosure in blank an take by default " like you said.
The problem is taht the archive that we import it can´t be change or fix that products, so What solution can you give to me for that cases???
Accepted Answer
Pending Moderation
Hello,
Can you send me a copy of the file you are importing? You can do that in a private message if you don't want to share it publicly.
Can you send me a copy of the file you are importing? You can do that in a private message if you don't want to share it publicly.
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
hello Rolandd,
I sent you the url where you can find the file.
THE LINES between are the rong products are between lines 64700 and 64900 if you dont want to import o review all the file.
Thanks
I sent you the url where you can find the file.
THE LINES between are the rong products are between lines 64700 and 64900 if you dont want to import o review all the file.
Thanks
Accepted Answer
Pending Moderation
Hello,
Thanks, downloading that 358MB file I will check and let you know what I find.
Thanks, downloading that 358MB file I will check and let you know what I find.
if you dont want to import o review all the file.No, I don't want to review a 358MB file :P So thank you for those line numbers.
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
Hello,
So I had a look and if I set the Auto-detect delimiters to Yes, your file looks fine in the preview, no problems there. Did you try that?
So I had a look and if I set the Auto-detect delimiters to Yes, your file looks fine in the preview, no problems there. Did you try that?
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 »