POSSIBLE ERROR ON CSV USER LIST IMPORT

[Arturo DSI]

Hi to all, first, thank you for your marvellous tool for elearning. Im a ex moodle, ex docebo admin, and Chamilo is the best of all!.

Second, when importing CSV file with user list, and the "username" column is populated of emails, it seems to work ok, and my users can log with their emails and passwords, but when they want to modify their profile, form validator throws an error: invalid characters on username (@ or _ or -).

Is there any solution? maybe disabling username validation... Thank you.

[Coursenligne]

Hi,

It could depend on how the CSV file was created...
To have a clue, you can, on the platform, edit a name (where you know there is the issue), and check the fields Name, First Name and email address. There is possibly a space charatcer in one of these fields (I said a clue )

If so, please open th eCSV document and check if the space exists... It may!

To create a CSV, we usually use Copy/Past (or Ctrl C, Ctrl V) from a software such as email (Outlook adn so on), this copy can add a space in the fields, you therefore have the issue.

I hope this helps.

[Arturo DSI]

Well, after some checks, the problem is with @ character.

Is there any way of rid this comprobation on user form? my campus actually hosts 500 users with an email as username!.

I Dont want to change all usernames and resend new credentials. Thank you for your time!

[Arturo DSI]

Found a possible workaround:

1º - main/admin/user_add.php -> comment "$form->addRule('username', get_lang('OnlyLettersAndNumbersAllowed'), 'username');"

2º - main/admin/user_edit.php -> comment "$form->addRule('username', get_lang('OnlyLettersAndNumbersAllowed'), 'username');"

3º - main/auth/profile -> comment "$form->addRule('username', get_lang('UsernameWrong'), 'username');"


Need some feedback! thanks!

[Coursenligne]

Well, this is what could happen when not giving enough information

I'm kidding but it's indeed a part of my answer...
If you have given all this info + the platform version, I would have said that you are lucky, because 1.9.x version of the platform (very soon released in 1.9.2) integrates directly the "Using email address as login".

This said, I'm glad you didn't mention too much precisely, as you shared a very good tip to do it using 1.8.x

Thanks very much.

[Arturo DSI]

!! I forgot that basic info, my platform is 1.8.8.4 !!

Well, Im currently hosting 2 campus with 1500 users each, full of users questions every day!... hope some post on next 12 months!

Again, thanks for your time!

[Coursenligne]

No problem...

And if you need some tips to come to 1.9, I'm sure you'll get them here

[Arturo DSI]

Hi to all, first, thank you for your marvellous tool for elearning. Im a ex moodle, ex docebo admin, and Chamilo is the best of all!.

Second, when importing CSV file with user list, and the "username" column is populated of emails, it seems to work ok, and my users can log with their emails and passwords, but when they want to modify their profile, form validator throws an error: invalid characters on username (@ or _ or -).

Is there any solution? maybe disabling username validation... Thank you.

[Coursenligne]

Hi,

It could depend on how the CSV file was created...
To have a clue, you can, on the platform, edit a name (where you know there is the issue), and check the fields Name, First Name and email address. There is possibly a space charatcer in one of these fields (I said a clue )

If so, please open th eCSV document and check if the space exists... It may!

To create a CSV, we usually use Copy/Past (or Ctrl C, Ctrl V) from a software such as email (Outlook adn so on), this copy can add a space in the fields, you therefore have the issue.

I hope this helps.

[Arturo DSI]

Well, after some checks, the problem is with @ character.

Is there any way of rid this comprobation on user form? my campus actually hosts 500 users with an email as username!.

I Dont want to change all usernames and resend new credentials. Thank you for your time!

[Arturo DSI]

Found a possible workaround:

1º - main/admin/user_add.php -> comment "$form->addRule('username', get_lang('OnlyLettersAndNumbersAllowed'), 'username');"

2º - main/admin/user_edit.php -> comment "$form->addRule('username', get_lang('OnlyLettersAndNumbersAllowed'), 'username');"

3º - main/auth/profile -> comment "$form->addRule('username', get_lang('UsernameWrong'), 'username');"


Need some feedback! thanks!

[Coursenligne]

Well, this is what could happen when not giving enough information

I'm kidding but it's indeed a part of my answer...
If you have given all this info + the platform version, I would have said that you are lucky, because 1.9.x version of the platform (very soon released in 1.9.2) integrates directly the "Using email address as login".

This said, I'm glad you didn't mention too much precisely, as you shared a very good tip to do it using 1.8.x

Thanks very much.

[Arturo DSI]

!! I forgot that basic info, my platform is 1.8.8.4 !!

Well, Im currently hosting 2 campus with 1500 users each, full of users questions every day!... hope some post on next 12 months!

Again, thanks for your time!

[Coursenligne]

No problem...

And if you need some tips to come to 1.9, I'm sure you'll get them here