CSV User Import Download 2.1

German ~Z~ Man 4 years ago

CSV User Import


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:

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:

username,email,first_name,last_name,gender,birthdate

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
  • email: a valid email address, since it will be used to send activation keys to your new users
  • 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 ...

tomato,[email protected],rita,red,,

... 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.

sjacobs,[email protected],Susan,Jacobs,f,

... 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.

Good luck!

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.
Referring to Adam03 from above that means: He will be able to log in with the password: [email protected]

Please instruct your new members to change their password once after logging in for the first time.


Changes

V 2.1

  • changed function names according to Ossn component conventions
  • added missing language files
  • license update
Comments
German ~Z~ Man Replied 4 years ago

There's a nice guide on how to use the Facebook Api at
http://www.json-xls.com/how-to-export-facebook-group-members-to-excel

and a graphical Interface based on the above developed at
http://www.ls1.ifkw.uni-muenchen.de/personen/wiss_ma/keyling_till/software.html

see accompanying video tutorial
facepager:

German Martin Korn Replied 4 years ago

i will import gruops from facebook in ossn

Component

Developer: ~Z~
License ossnv4
Type: Tools
Minimum Requirement: 5.2
Latest Version: 2.1
Last Updated 4 months ago
Repository Url View Repository

Versions