You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Web site displays the following
1-9 units cost �0.55 each, 10-19 cost �0.51, 20 or more �0.46
Why the � instead of the £ sign after importing products from a csv file?
On the csv file the field reads
1-9 units cost £0.55 each, 10-19 cost £0.51, 20 or more £0.46
Anyone found this error and is there a simple solution.
Using ClickCart Pro level 6.0.6 GB version
Thanks
Eric
Offline
Most likely reason is that Excel, or whatever program you're using to modify the CSV, is saving it in such a way that it's getting lost or converted. If you look at the CSV with a plain text editor is the pound sign displayed correctly?
Offline
Hi Dave.
Using Notepad to open the csv file, the £ sign shows OK and the field is encompassedin the " sign (text field identifier), but you are right, there is a different character being displayed when I look at the file using the Dos editor.
I am using Excel 2007 to save/create the csv file. Is there a specific way of doing this that I am unaware of?
Thanks so far.
Eric
Offline
As you were Dave.
I saved the file from excel in CSV (MS-DOS) (*.csv) format and £ sign displayed correctly.
Thanks for pointer.
All the best,
Eric
Offline
Ooops. When I import the csv file with the '£' sign correct to the web site, once again the '£' sign has been converted to '�' When I then export the prod file and open the csv with the DOS editor, where there was a '�' on the web, there is now 'œ' in its place. It looks like the CCP conversion software is changing things around.
Any further thoughts.
Thanks,
Eric
Offline
CCP doesn't convert anything Eric. For the pound sign the safest way is to use the HTML entity for it which is & pound; (without the space).
Offline
Hi Dave. I understand the principal of using the HTML entity, but am unsure where (and how) to include it in the csv file for uploading. Sorry to be a pest, but can you direct me?
Thanks,
Eric
Offline
Any place you have an actual pound sign replace it with what I posted minus the space between the & and the word pound (I can't show it exactly correct here or it will show up as a pound sign).
Offline