upload a csv file and no confirmation email

I know that this is not a joomdle question, but more of a moodle question. I been look at all forums in moodle and cannot find an answer. I am running moodle 2.0.3 and I have hidden courses that I do not charge for and will be enrolling students into the class via a csv file. (private courses). I would like a confirmation email sent to the enrolled students with user name and password. RIght now I cannot get to the email to send even when I do not even put a password in the in the "password" field in the cvs file.

Can you assist?

I think there are a few issues here:
1) Registering the users
2) Enrolling the users
3) Sending the confirmation email

The first thing I would like at is the quantity of users. If you are talking about 10-100 users, it might take less time to do it manually compared to the effort you may spend working it out However, if you are talking about thousands of users, the effort may be worth it.

1) Registering users
Are you planning to update the csv into Moodle or Joomla? And is Joomla or Moodle your "master". Most use Joomla as the "master" therefore the password is managed by Joomla. If you register through Moodle (and the password is assigned through moodle) than there is no way for Joomla to know the password due to Moodle's encryption algorithm. If you are loading into Joomla and Joomla is the master than this problem does not exist. So the next question is what tool are you using to bring the file into Joomla - there are a few

2) Enrolling. Again this largely depends on the quantity of students. It may be possible to develop a simple routine to enroll the students into the course. We would need to know the tools used to import the csv. Alternatively, you may do this through Moodle directly if not many students or through the database. I am not sure if Moodle will upload a csv for enrolling only. You could also send a link to the course and provide each student with an enrollment key that they would need to enter. This has security issues of course as they could share / forward the key around.

3) Sending a confirmation email.
This largely depends on the approach of managing the CSV file. If none is used and it's done manually than similar. If you have a tool to upload into Moodle - mmmm not sure. If you have a tool and upload into Joomla than, you may want to auto subscribe them to a list management extension like acymailing. You could create an auto email which is sent to users whenever they are adding to the list. I do this today when a new user is registered (through any method) or when they buy certain products. Once added to the list, they are sent an auto "welcome" message.

Thank you for responding let me be a little more specific.

You are right as far as the three issues, I am able to register the user and enroll them into the correct course. I am attaching the csv file that I am using. In moodle I am going to administrator-->users--> accounts-->upload users.

Like I stated, then upload is working for the fact it is uploading the users and enrolling them into the correct course. But I cannot figure out how to send the confirmation email with the user username and password.

Where things get a little confusing, that these are hidden courses and not being offered in the shopping cart and only want the people uploaded in hte csv file to have access to the hidden courses. If there is a way to do it through joomla, I am more then happy to do it.

The users will prob range between 20-1000 in the csv file.



for some reason it would not upload the csv file, so here the xls file of the file.


Once again thank you for the help

Now is there a way to upload the csv file into joomla with the course I want the student enrolled to? I am just am new to joomla and I am ok with moodle. I would just like the most efficient way to upload a csv file to register and enroll the "student" then send them a confirmation email.

It might be helpful why I want this. We are an education school for restaurants, but we also have private online training course the we work with third party to hold their own courses. These courses are to be free but only want the people the third party wants to enter and know about the course.

I hope this makes sense, look forward to your response

Hi again,

As said, there are a few tools that will allow you to upload into Joomla. You can find these on the JED - extensions.joomla.org/extensions/migrati...sers-import-a-export

Which ones are working good - you're guess is as good as mine as I have never used any of these tools.

But this is really the second question. The first and most important is what platform is going to be your master. If Joomla, then importing into Moodle will not help you. If Moodle than importing into Joomla will not help you. Perhaps you may want to think of it like this - what is your homepage, Joomla or Moodle. Where do you want your users to be most of the time? What is the purpose of Joomla or you and Moodle for you? For most people, Moodle is just the course and Joomla is the content the holder of the course. If this is your case, than importing into Moodle will not help due to the encryption as explained above.

Once you have decided this, the rest of your issues will follow as your plan of action.

If you are using Joomdle, then Joomla is the master.

So, what I would do:
- Batch upload users to Joomla with any component you like
- Use joomdle backend to sync all users to Moodle (as usually, at least the ones I used, the batch uploads don't trigger plugins, so Moodle user won't be created)
- Once users are synced, use a batch action in Moodle admin to upload a file with course enrolments (look at moodle docs as to how to do that)

It is a 2 step process, needing access to both platforms, but I think it is the pnly way to go for now.