I have had some minor issues with importing special characters from some of my CSV files. It seems like they are not recognized when they are imported. So they are replaced with the "?" sign instead.
The characters I'm thinking about are of course the danish "æøå" and then characters like '. I just thought I would mention it. It is not something that has been a big issue, because there have not been used that many of the characters in the data I have been importing. But on a larger scale it might could get a bit frustrating.
I've just downloaded your package and it's very helpfull. Just got the same problem as Jan. It won't take danish "æøå" and then characters like '. The characters looks strange. Have you found a way to get around it?
Should be fixed in the current version online. Where did you download it and also make sure that the csv file is saved with UTF8 encoding. Please let me know if it helped you.
I think the package repository isn't updated yet. Please try the version from our.umbraco.org... To check if the file is saved correctly is to open it in wordpad and then select save as. The encoding should be set to UTF-8
I was looking into using this to import members, but the problem is that it is an old installation of Umbraco; 4.0.2.1 and the version of CmsImport that I have is 1.2.
Will it work to save the excel file with utf-8 and import or do i have to use another version of CmsImport?
I dont eant to install the latest version as it isnt compatible with the old version of Umbraco..
Can I find the right version of CmsImport somewhere?
Sorry didn;t see this comment before. I think version 1.2 can import csv with special characters if you store the file as UTF-8 indeed. Excel will not work since that adapter is introduced in 2.0 and the DataAdapter class has changed a bit.
Email me richard[at]soetemansoftware[.]nl for a package file.
It worked nice now :) I have the 1.2 version installed.
Except one thing: I have a column that is sometimes empty, sometimes contains info.
If I try to import that column I get an error saying that the field can not be empty. Is this the way it should be according to the code or is it a bug?
Thta might be a bug in older versions indeed since that can handle null values very well but have some issues with empty values. Also depends on which underlying datatype you assign an empty value. Text values will work, assigning an empty value to an integer, or datedatatype will propably cause some issues indeed.
Danish and special characters
Hi Richard
I have had some minor issues with importing special characters from some of my CSV files. It seems like they are not recognized when they are imported. So they are replaced with the "?" sign instead.
The characters I'm thinking about are of course the danish "æøå" and then characters like '. I just thought I would mention it. It is not something that has been a big issue, because there have not been used that many of the characters in the data I have been importing. But on a larger scale it might could get a bit frustrating.
Cheers
/Jan
Hi Jan,
Thanks for reporting this. It's on my bug/todolist.
Cheers,
Richard
Hi Richard,
I've just downloaded your package and it's very helpfull. Just got the same problem as Jan. It won't take danish "æøå" and then characters like '.
The characters looks strange.
Have you found a way to get around it?
Cheers
Palle
Hi Palle,
Should be fixed in the current version online. Where did you download it and also make sure that the csv file is saved with UTF8 encoding. Please let me know if it helped you.
Cheers,
Richard
Hi,
I have faced the samed problems, but when saved with UTF-8, the files imported nicely and preserved danish characters,, ;)
/ulrich ebsen
Hi Richard,
I got the package from the Umbraco package Repository.
How do you save with UFT8 encoding. I'm using office 2007
Cheers
Palle
Hi Palle,
I think the package repository isn't updated yet. Please try the version from our.umbraco.org... To check if the file is saved correctly is to open it in wordpad and then select save as. The encoding should be set to UTF-8
Cheers,
Richard
Great !!, now it works.
Thanks for quick reply.
Cheers
Palle
Hi!
I was looking into using this to import members, but the problem is that it is an old installation of Umbraco; 4.0.2.1 and the version of CmsImport that I have is 1.2.
Will it work to save the excel file with utf-8 and import or do i have to use another version of CmsImport?
I dont eant to install the latest version as it isnt compatible with the old version of Umbraco..
Can I find the right version of CmsImport somewhere?
Hi,
Sorry didn;t see this comment before. I think version 1.2 can import csv with special characters if you store the file as UTF-8 indeed. Excel will not work since that adapter is introduced in 2.0 and the DataAdapter class has changed a bit.
Email me richard[at]soetemansoftware[.]nl for a package file.
Cheers,
Richard
It worked nice now :) I have the 1.2 version installed.
Except one thing: I have a column that is sometimes empty, sometimes contains info.
If I try to import that column I get an error saying that the field can not be empty. Is this the way it should be according to the code or is it a bug?
Thta might be a bug in older versions indeed since that can handle null values very well but have some issues with empty values. Also depends on which underlying datatype you assign an empty value. Text values will work, assigning an empty value to an integer, or datedatatype will propably cause some issues indeed.
No, it wasnt a bug. I forgot to add headers to the column so I suppose that was the reason :)
Thx for support!
is working on a reply...