Csv users import

[lverdier]

There is a bug when we import csv file of users with classes.
Here is my file :

LastName;FirstName;UserName;Password;AuthSource;Email;OfficialCode;PhoneNumber;Status;Courses;ClassName
nomtest;prenomtest;identTest;pwd;;identtest@msn.com;;;user;;1TSEL

Its works on dokeos 1.8.6.1 but on chamilo 1.8.8.4 I've got this error message :
"Ce nom de classe n'est pas disponible: identTest (prenomtest nomtest)"

The 1TSEL classe really exist in the classe list.

How can I do to import students withs their classes ?

[ywarnier]

Hi Laurent,

Wow, you found a good one! This is due to the fact that we have changed the classes system so it works with the sessions. The CSV import feature is still linked to the old classes tables, while the classes management interface you've used created the class in the new tables.

I've reported the bug here so we can solve it in Chamilo 1.9: http://support.chamilo.org/issues/4071

Thanks! I think we're going to give you the eagle-eye rank for bug spotter

[lverdier]

Thanks for the title lol.
On the 1.9 version, could you do an update wich wont destroy the old method I'm using (classes and not group) but adapt it ?
Thanks.

[Tamela]

It might be nice if this bug was listed somewhere on the download or in the admin panel.
I just spent 2 hours switching a large file of students from a csv to your xml, because I though that it was a problem with my csv file.

Or maybe a suggestion on how to fix the problem without waiting for a new version?
Some of us have lists of students to import and don't want to put each of them in by hand.

Thank you.

[ywarnier]

Hi Tamela,

Sorry about that. This is our way of doing things:

• Users *report* the bug (or alternatively they come afterwards to rant on having spent 2 hours to fix it )
• We check it, register it
• When we have time (or budget) we fix it
• We first publish a report on how we fixed it (in this case we would put it later on in http://support.chamilo.org/issues/4071)
• We then include it in the code for the next version of Chamilo, which is generally out within 6 months, sometimes much less

Obviously for this model to work we need a little bit of compromise and helping hands so we can (1) find the bug early, (2) fix it early (with good hints on how to fix it), (3) publish it early so users can fix their own platform if they can't wait for the next release.

This all being said in an excellent disposition, I'm sure you'll appreciate that we respect the fact that it caused you some time loss. I'd just like to tell you how much time we spent developing Chamilo (which is *much* more than 1000 times the time you lost) and that we're happy to help, and it would really help your cause to be participative (like so many people on the forum have understood).

[joke.vanammel]

Hi

I work with Chamilo 1.8.8.4.
I would like to enroll a list of new users immediately in a course by using a CSV file.

The manual says that the CSV file should look like this (Fields in bold are required.)

LastName;FirstName;Email;UserName;Password;AuthSource;OfficialCode;PhoneNumber;Status;legal_accept;tags;rssfeeds;dashboard;timezone;mail_notify_invitation;mail_notify_message;mail_notify_group_message;Courses;
xxx;xxx;xxx;xxx;xxx;platform;xxx;xxx;user/teacher/drh;xxx;xxx;xxx;xxx;xxx;xxx;xxx;xxx;xxx1|xxx2|xxx3;

How should I fill in "course" fill? Where can I find the course name that I should use? Do I have to use the course title or course code? And do I have to type in lowercase or uppercase?

[Coursenligne]

Never tried so far to enrol directly, as I'm using more likely session...
I would have a try using course code and if it doesn't work, I would give a go to course name...
My feeling is course code will be my first choice for testing.

I don't have much tim to perform the test now, but I may give a go soon if you can't perform it

For lower/upper case, I would use the same as for code/course name.

Why mainly code first ? Usually spaces are not allowed, which only is the case for code.. Name can contain spaces.

[adeschenes]

Hi,

I've already did it and it's worked fine.

To do it, you could use the course's code exactly as it exist (upper or lower case).

Regards,

Alain

[joke.vanammel]

I'm sorry. I tried everything, but it doesn't work...

[Coursenligne]

Hi,

Do you have any error message?
Does the platform registers the student OK (it doesn't work is meaning nothing works or part works?)

n the meantime, note that is for registering new users only and not modify any, this is to say that the users you try to register musn't exist in the platform.

[lverdier]

There is a bug when we import csv file of users with classes.
Here is my file :

LastName;FirstName;UserName;Password;AuthSource;Email;OfficialCode;PhoneNumber;Status;Courses;ClassName
nomtest;prenomtest;identTest;pwd;;identtest@msn.com;;;user;;1TSEL

Its works on dokeos 1.8.6.1 but on chamilo 1.8.8.4 I've got this error message :
"Ce nom de classe n'est pas disponible: identTest (prenomtest nomtest)"

The 1TSEL classe really exist in the classe list.

How can I do to import students withs their classes ?

[ywarnier]

Hi Laurent,

Wow, you found a good one! This is due to the fact that we have changed the classes system so it works with the sessions. The CSV import feature is still linked to the old classes tables, while the classes management interface you've used created the class in the new tables.

I've reported the bug here so we can solve it in Chamilo 1.9: http://support.chamilo.org/issues/4071

Thanks! I think we're going to give you the eagle-eye rank for bug spotter

[lverdier]

Thanks for the title lol.
On the 1.9 version, could you do an update wich wont destroy the old method I'm using (classes and not group) but adapt it ?
Thanks.

[Tamela]

It might be nice if this bug was listed somewhere on the download or in the admin panel.
I just spent 2 hours switching a large file of students from a csv to your xml, because I though that it was a problem with my csv file.

Or maybe a suggestion on how to fix the problem without waiting for a new version?
Some of us have lists of students to import and don't want to put each of them in by hand.

Thank you.

[ywarnier]

Hi Tamela,

Sorry about that. This is our way of doing things:

• Users *report* the bug (or alternatively they come afterwards to rant on having spent 2 hours to fix it )
• We check it, register it
• When we have time (or budget) we fix it
• We first publish a report on how we fixed it (in this case we would put it later on in http://support.chamilo.org/issues/4071)
• We then include it in the code for the next version of Chamilo, which is generally out within 6 months, sometimes much less

Obviously for this model to work we need a little bit of compromise and helping hands so we can (1) find the bug early, (2) fix it early (with good hints on how to fix it), (3) publish it early so users can fix their own platform if they can't wait for the next release.

This all being said in an excellent disposition, I'm sure you'll appreciate that we respect the fact that it caused you some time loss. I'd just like to tell you how much time we spent developing Chamilo (which is *much* more than 1000 times the time you lost) and that we're happy to help, and it would really help your cause to be participative (like so many people on the forum have understood).

[joke.vanammel]

Hi

I work with Chamilo 1.8.8.4.
I would like to enroll a list of new users immediately in a course by using a CSV file.

The manual says that the CSV file should look like this (Fields in bold are required.)

LastName;FirstName;Email;UserName;Password;AuthSource;OfficialCode;PhoneNumber;Status;legal_accept;tags;rssfeeds;dashboard;timezone;mail_notify_invitation;mail_notify_message;mail_notify_group_message;Courses;
xxx;xxx;xxx;xxx;xxx;platform;xxx;xxx;user/teacher/drh;xxx;xxx;xxx;xxx;xxx;xxx;xxx;xxx;xxx1|xxx2|xxx3;

How should I fill in "course" fill? Where can I find the course name that I should use? Do I have to use the course title or course code? And do I have to type in lowercase or uppercase?

[Coursenligne]

Never tried so far to enrol directly, as I'm using more likely session...
I would have a try using course code and if it doesn't work, I would give a go to course name...
My feeling is course code will be my first choice for testing.

I don't have much tim to perform the test now, but I may give a go soon if you can't perform it

For lower/upper case, I would use the same as for code/course name.

Why mainly code first ? Usually spaces are not allowed, which only is the case for code.. Name can contain spaces.

[adeschenes]

Hi,

I've already did it and it's worked fine.

To do it, you could use the course's code exactly as it exist (upper or lower case).

Regards,

Alain

[joke.vanammel]

I'm sorry. I tried everything, but it doesn't work...

[Coursenligne]

Hi,

Do you have any error message?
Does the platform registers the student OK (it doesn't work is meaning nothing works or part works?)

n the meantime, note that is for registering new users only and not modify any, this is to say that the users you try to register musn't exist in the platform.