Last release (1.9): having problems with uploading user

Last release (1.9): having problems with uploading user

by Leticia Maimann-Roland -
Number of replies: 7
Hi people!

I've just upgraded to 1.9 but i'm having problems in uploading users from a txt file.

The following erros is shown: Invalid CSV file format - number of columns is not constant!

The CVS file I tried worked in another instalation of Moodle 1.84, so i know it doesn't have invalid format.

Is there some new settings regarding required fields? My file has just username, firstname, lastname, password and email.

Even if you try to copy and taste the example in the help file for upload users, it doesn't work, so i imagine something must be wrong.

Hugs from Letícia.
Average of ratings: -
In reply to Leticia Maimann-Roland

Re: Last release (1.9): having problems with uploading user

by Petr Skoda -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
Hello,

Eloy created new issue for this in tracker MDL-13840, I tested it and it works fine for me. Please attach a sample import file there, so that we can try to reproduce it.

Petr
Average of ratings: -
In reply to Petr Skoda

Re: Last release (1.9): having problems with uploading user

by Alex Jal -
The Idea is simple
Moodle recognizes columns by commas " , " so find if there is an extra comma in a name or an email
I had the same problem and found out that there is an extra , in an email field

you can open the file in excel and search for ,

please tell me if it works
Average of ratings: -
In reply to Leticia Maimann-Roland

Re: Last release (1.9): having problems with uploading user

by arturo ruvalcaba -
So I ran into the same problem, and figured it out.

  1. Explanation: (skip if uninterested haha)
    1. So i had all the columns lined up perfectly and keep getting that error message "number is not constant!" .. so if you open up your CSV from excel in something like text or wordpad, you'll see something peculiar.

      What happens is that if for some reason, the last column has ANY empty values, then it is ignored when being converted to CSV and the comma is left out. CSV does not recognize multiple commas at the end of the row as the last entries.
  2. Solution
    1. Make sure that the last column when creating your CSV contains all entries filled in. I set mine with a user's first name as the last column, as it is the simplest one to use since everyone should have one.
      The order of columns in the CSV is irrelevant, as they are routed to the profile fields anyway, so you can manipulate it that way.

Hope that works! if not, then i apologize for the long explanation!
Average of ratings: -
In reply to arturo ruvalcaba

Re: Last release (1.9): having problems with uploading user

by Leticia Maimann-Roland -

Sorry for didn't give any more feedback on this, but in the time I updated to the latest released and thought it was what solved the problem.

However, now with the explanation given by Arturo it is pretty clear that it happened to me too!

Before I was entering just some data and left some columns empty (and I probably had the last one as empty!), but since it took me some time to solve it, when I managed to have the users uploaded I decided to put all the data I had... without knowing it, I was solving the problem!

Thanks for the information, arturo!

Hugs from Leticia.

Average of ratings: -
In reply to arturo ruvalcaba

This forum post has been removed

The content of this forum post has been removed and can no longer be accessed.