This component allows you to import a long list of new members to your Ossn community from a so-called 'csv' file in just one step.
As an option you may make them a member of a group of your choice.
Before using this tool, a few pre-requisites must be definitely met:
- you have made a backup of your Ossn database AND you know how to restore it
- you have a basic knowledge of csv files and how to create one ( http://www.computerhope.com/issues/ch001356.htm )
As for the last topic, a ready-to-use CSV file named
example.csv is included. Just open that file from a local directory with a simple text editor like notepad and have a look at the first line now:
This line we call "header", it is
mandantory, and it defines the order of all following user records. Do not change.
All 6 fields have to be compliant with Ossn's internal data structures, thus it makes sense to have a closer look at each of them.
username: has to be at least 5 characters long, no spaces, no special characters, just a-z, A-Z, and numbers are allowed
first_name: has to be at least 2 characters long, spaces and special characters and numbers are allowed
last_name: same as first_name
gender: must be '
f' for female users, or '
m' for males. Any other invalid or empty entries will be replaced by 'male'
birthdate: the only accepted notation is
dd/mm/yyyy. Any other format or leaving this field blank will result in a replacement of the user's birthdate by the current date
All following lines must be user records - one user per line
Adam03,[email protected],Adam D.,Schießbörger,m,19/03/1993
... this is a perfectly complete record, gender and birthdate are explicitely set and correctly formatted, some special chars are used with the first and the last name ...
... the most incomplete record, and although a woman most obviously, Rita will be set to 'male' since no gender has been set ...
Note, that the commas must be left in place, though. Otherwise the
number of fields wouldn't match with the 6 columns of the header.
... Susan will be set to 'female' correctly, but again her birthdate will be set to the day of insertion because the last column has been left empty ...
So if you don't want to stress your members too much with correcting their profiles later on, it's a good idea to make sure all records are as complete as possible.
And once again: The first 4 columns can't be empty - if so, CSV User Import will throw out an error and exit.
Actually, this component comes with a lot of built-in error checking already, as Ossn won't work with duplicate usernames or email addresses for example.
Okay, let's go ahead. After installing and enabling this component, please navigate to Configure->CSV User Import.
Next, you have to decide whether you want to
send an activation key to every newly imported user. This option is checked by default, but it may really stress your server with larger csv files. And especially on shared hosts it can't be wrong to ask your provider first, whether these kind of mass mailings are allowed at all.
If you uncheck this option, no mail will be sent and all users will be switched to 'active' automatically. Still playing around with the example.csv, this may be the preferred option in the beginning. Thus, uncheck
 Mail activation key to imported users for now, and click the [Browse...] button to select the example.csv file. Finally click the [Import] button.
One last important thing to note:
Since your member's old passwords are long encrypted strings nobody would love to remember, and dealing with clear text passwords is no good idea either, the members's
new password has been saved as a
copy of his email address.
Adam03 from above that means: He will be able to log in with the password:
Please instruct your new members to change their password once after logging in for the first time.
There's a nice guide on how to use the Facebook Api at
and a graphical Interface based on the above developed at
see accompanying video tutorial