Support ISO8859-1 for SAINT imports

Avatar

Avatar
Boost 500
Level 10
adierl
Level 10

Likes

808 likes

Total Posts

188 posts

Correct reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
adierl
Level 10

Likes

808 likes

Total Posts

188 posts

Correct reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
adierl
Level 10

02-11-2010

For all non-english speaking countries you're facing the problem with non-ASCII characters like ü, é, ç, Æ, ...

Using Excel to manage campaign sheets or other SAINT files, you run into the problem that a European Excel per default saves ISO8859-1 and won't save UTF8 at all. Depending on the Excel version you might be able to save a unicode, but this also doubles the file size.

Would be great if ISO8859-1 could be supported by SAINT.

 

Additionally please don't accept ISO8859-1 files that have characters with charcode >127 in SAINT standard import. Those are treated as UTF-8 on the servers, but will produce unreadable characters, since ISO8859-1 != UTF-8.

Please also accept UTF-8 files with a BOM. If you use an other tool to save SAINT sheets that saves UTF with BOM, SAINT won't accept although valid UTF-8.

4 Comments

Avatar

Avatar
Boost 50
Level 5
nic_cm
Level 5

Likes

71 likes

Total Posts

57 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Boost 50
Level 5
nic_cm
Level 5

Likes

71 likes

Total Posts

57 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile
nic_cm
Level 5

02-11-2010

Hi Andreas,

 

just out of curiosity: do you have that issue with both web and ftp upload?

I have successfully uploaded some Russian characters via ftp.

 

so long

nic

Avatar

Avatar
Boost 500
Level 10
adierl
Level 10

Likes

808 likes

Total Posts

188 posts

Correct reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
adierl
Level 10

Likes

808 likes

Total Posts

188 posts

Correct reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
adierl
Level 10

03-11-2010

nic,

 

just tested it. yes, FTP is having the same issues.

Which encoding did the file with the Russian characters have? Sure it was ISO8859-1?

 

//Andreas

Avatar

Avatar
Boost 50
Level 5
nic_cm
Level 5

Likes

71 likes

Total Posts

57 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Boost 50
Level 5
nic_cm
Level 5

Likes

71 likes

Total Posts

57 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile
nic_cm
Level 5

05-11-2010

Hi Andreas,

 

maybe you're right. Of course I deleted the file:-/

 

so long

nic

Avatar

Avatar
Boost 5
Level 2
guthier
Level 2

Likes

20 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 2
guthier
Level 2

Likes

20 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
guthier
Level 2

14-06-2015

When we encountered the issue a few weeks ago, Customer Care instructed us to convert the file to UTF-8 without BOM before uploading. This seems to work but it would be nonetheless an improvement to have ISO8859-1 support - updating our SAINT file is a mostly automated process without that extra manual step.