1. icinfo
  2. RO CSVI
  3. Wednesday, 31 January 2018
  4.  Subscribe via email
Hi,
can we import product details with ® (copyright) symbol to Virtuemart? Seems that import gets messed up when using ® symbol.
This is the line that get's messed up in the import:
(product_desc)
"HELPPO JA NOPEA tapa lisätä turvallisuutta Checkpoint® ja Dustite® -osoittimilla varmistat helposti ja nopeasti • että pyörän pultit ja mutterit ovat kiinni. • jos jarrut tai laakerit ovat ylikuumentuneet (osoitin sulaa n.125°C)"

There are twice the copyright symbol and the import for that product cuts there and the first "bullet" starts the next line (see the image).

import-image-of-copyright-symbol-issue.png

Is it possible to use copyright symbol in import? How?

- Anne
Accepted Answer Pending Moderation
Hello Anne,
I don't think using copyright symbol should be a issue. if you use the text enclosure and field delimiter, you can use any characters you want. Do you have text enclosures in your import file? did you try with that? Can you post your import file to check?
Kind regards,

Tharuna

=========================
If you use CSVI, 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
Hi,
we use ; as field delimiter and ¤ as text-enclosure. We cannot use " symbol since that is used in the text (inch).

Attached you'll find bot excel and csv format of the import-files. The issue starts on line 4 where there is the first copyright symbol. The product description cuts the line and part of the product description (of line 4) starts the next line (line 5).

Virtuemart3 rengastarvike sekalaiset 29.01.2018 Perus.csv Virtuemart3 rengastarvike sekalaiset 29.01.2018 Perus.xls

Greetings, Anne
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,

Also make sure that your file is UTF-8 encoded. You can always use the HTML equivalent as well which is
©
or
©
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,

We cannot use " symbol since that is used in the text (inch).
Actually you can but the CSV rules describe that you need to use 2 double quotes in your text and it would look like this
" A 5""inch nail"
Using a different delimiter is not an issue of course as long as the system can read it.
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Anne,

I have tried your file and I get the same preview as you do. Now I do have error reporting on and I found out that your special text enclosure is a multi-byte character, this means it takes 2 spaces instead of 1. This causes PHP not to be able to read it. So you have to use something else. If you don't want to use the " character you can use the ~ (tilde) character. That will work as well.
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hi, we cannot use tilde as a delimiter since we use customfieldsforall plugin and we need to use tilde in that import to separate different custom fields and their values. So tilde is also not possilble. What else can we use if we cannot use " and we cannot use tilde?

- Anne
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello Anne,

Which spreadsheet program are you using? Both Excel and OpenOffice/LibreOffice will save textfields fine using the ; and " as delimiters. They will add the necessary " where needed when saving as CSV file.
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hi,
we use openoffice.
In your example how to use " sign in the text, you wrote the format to be this way:
"text""inch"

But since we do not use the WORD inch, we cannot use that format. We could use this:
"text"""
But I imagine this would not work!

So we are not able to use " sign as the delimiter. What else can we use so that it would not mess with the import?
We cannot use " we cannot use tilde.
- Anne
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello Anne,
The inch text Roland used was just for an example. You can escape your "(symbol used for inch) by putting the text like below. Notice the two " used one is for inch and other is for escape character. This should work for you. And since you are using Openoffice if you use " as text delimiter the escape characters will be taken care by openoffice . did you try it?

"A long big 5"" nail" 
Kind regards,

Tharuna

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

So we are not able to use " sign as the delimiter.
Actually you can because you are using OpenOffice. Please see the Save a CSV file as UTF-8 document. This also concerns the delimiters, when you save the document like that you should have a good CSV file you can import.

Can you give that a try and let us know?
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hi,
I'm testing your method of using double inch signe when using " symbol as delimiter. I also added copyright symbol in the import to both title, short and long description. I can import all but the inch sign is then showing as double-" sign not one " as it should be. Am i missing somethig still?
We do not want so show on frontend the inch in format 21"" but is should be 21".

So how can we use " as delimiter AND use inch sign " (once) in the title/descriptions and use copyright symbol?
Sorry don't get it!

- Anne

testing-double-inch-sign.png
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello Anne,
Can you post your latest import file to check?
Kind regards,

Tharuna

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

com_csvi.log.268.zip

Greetings, Anne

p.s. I also tried using number""inch (so using the word inch, but not change).
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello Anne,
Would also like to see your import file, can you send that too?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hi,
here is my test-file. I use openoffice and save it with delimiters ; and ".
I added copyright to title/descriptions and used "" as inch in the same 3 fields.

- Anne



testi-inch-import.csv
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
Hello Anne,
Your file is UTF-8 encoded and you are using openoffice where the text delimiters and escape characters are taken care. You can simply use the file as attached in the post. Try the import and let me know.

testi-inch-import_modified.csv
Attachments (2)
Kind regards,

Tharuna

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

I added copyright to title/descriptions and used "" as inch in the same 3 fields.
You should not type the double " yourself. OpenOffice will add that when you save it.
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
Hi,
ok, well that is new to me. I understood from your earlier instructions that I specifically need to use double " if I want to use " sign inside one field. B)
NOw I tested with just one " sign and also having copyright sign and it all worked fine. Thank you!

- Anne
  1. more than a month ago
  2. RO CSVI
  3. # 18
Accepted Answer Pending Moderation
Hello Anne,

We had some words lost in translation :) OpenOffice makes life easier by doing the double quotes for you if it finds you are using them.

Glad to hear we all figured it out now.
  1. more than a month ago
  2. RO CSVI
  3. # 19
  • Page :
  • 1


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