Problems with Swedes: Uploading users via text/csv

Problems with Swedes: Uploading users via text/csv

Josep M. Fontana - келді
Number of replies: 8
OK, the problem are not the Swedes but the special characters they use in their names. I made the title as catchy as possible to get more people to read it and hopefully get some help smile

We have a course with more than 200 Swedish users. The problem with Swedish users is that they have names with characters like å or ö (or also é which doesn't look as strange because we have these as well). When I try to upload users via a text/csv file, all the names that contain a "special" character don't get added and I get an error message that doesn't make much sense:

User "x" not added - already registered

What I have seen is that sometimes the user does get added but with his/her name cut just where the special character would come. So a user called "Eva Bergström" would get added as "Eva Bergstr"

Is there a way to do this? Am I doing something wrong or is it not possible to upload users via csv files if they contain special characters?

Should I post a bug in the bug tracker?

Josep M.
In reply to Josep M. Fontana

Re: Problems with Swedes: Uploading users via text/csv

Iñaki Arenaza - келді
Core developers қатысушының суреті Documentation writers қатысушының суреті Peer reviewers қатысушының суреті Plugin developers қатысушының суреті

Hi Josep,

as long as the text/csv file is saved with UTF-8 encoding (and doesn't contain the BOM at the beginning of the file -notepad on Windows is known to add it-), you should be able to use any special characters you want.

Saludos. Iñaki.

In reply to Iñaki Arenaza

Re: Problems with Swedes: Uploading users via text/csv

Josep M. Fontana - келді
Eskerrik asko Iñaki!

I was actually saving it with UTF-8 (I use a text editor called UltraEdit which can do that). I realize there is the option 'Save as UTF-8 NO BOM' which I wasn't using. So I'll try that.

JM

PS. Too bad I didn't get to see you in Caceres. News is that the MoodleMoot was a lot of fun. I hope to see you in Barcelona next year.
In reply to Josep M. Fontana

Re: Problems with Swedes: Uploading users via text/csv

Iñaki Arenaza - келді
Core developers қатысушының суреті Documentation writers қатысушының суреті Peer reviewers қатысушының суреті Plugin developers қатысушының суреті

You can meet us in the Basque Country next spring (around May) for the MoodleMoot Euskadi '08 too Көзін қысқан

Saludos. Iñaki.

In reply to Iñaki Arenaza

Re: Problems with Swedes: Uploading users via text/csv

Josep M. Fontana - келді
Euskadi in Spring. That's a thought. I've experimented it in Summer and in Winter and I loved it, so in Spring it must be la leche Күлкі

Or, if that fails, I hope to see you in Barcelona where I have found out they are having the next Spanish MoodleMoot.

Josep M.
In reply to Iñaki Arenaza

Re: Problems with Swedes: Uploading users via text/csv

Josep M. Fontana - келді
Good! It worked perfectly with UTF-8 no BOM.

JM
In reply to Josep M. Fontana

Re: Problems with Swedes: Uploading users via text/csv

Joseph Rézeau - келді
Core developers қатысушының суреті Particularly helpful Moodlers қатысушының суреті Plugin developers қатысушының суреті Testers қатысушының суреті Translators қатысушының суреті
Josep,
Be aware that BOM encoding is a real nuisance and can cause all kind of problems.angry
Display problems caused by the UTF-8 BOM
Joseph
In reply to Joseph Rézeau

Re: Problems with Swedes: Uploading users via text/csv

Josep M. Fontana - келді
Thanks Josep[h]. I know now that the BOM is a bummer Күлкі In fact, I'm starting to think that an earlier upload of users from a csv file which had been saved as UTF-8 BOM was the source of all kinds of strange problems we've had in our installation.

Josep no BOM-h