CSV User Import Download 2.0

This component/theme works with latest OSSN version.
German Zet Man 4 months ago

CSV User Import

V2.0
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 making use of the 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,adam@z-mans.net,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,tomato@z-mans.net,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,tomato@z-mans.net,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: adam@z-mans.net

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

Comments
German Zet Man Replied 2 months ago

No.
This component doesn't come with its own mail agent, and thus it will not have any mailer settings. It is relying on Ossns built-in mailer, and if your site's mail doesn't work, you're having a problem in general, and new users never will be able to register the normal way. Please verify your site's email settings and in doubt consult your provider regarding php mail issues.

German Martin Korn Replied 2 months ago

You can make the mailoption as in the picture because i have a problem with phpmailer
enter image description here

German Martin Korn Replied 2 months ago

okay

German Zet Man Replied 2 months ago

Yes, but you would silently losing members afterwards that way. And since the basic idea is to KEEP your old members, making use of your personal intelligence at this stage to track down what's wrong with 2 identical emails combined with 2 different users is a much more efficient solution than to leave decisions like that to a hardcoded mechanism.

German Martin Korn Replied 2 months ago

You can write the componente so the double contacts are ignored and the rest is imported

German Zet Man Replied 3 months ago

Aha.
So: what's your idea of solving your problem with a message like that?
You didn't mention WHAT error you're getting, and I don't know what kind of CSV file you are using.

German Martin Korn Replied 3 months ago

With me goes with the user import not always comes error. Got the 4.2 as demo version

German Zet Man Replied 3 months 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: https://www.youtube.com/watch?v=S9kYApoR8U4

German Martin Korn Replied 3 months ago

i will import gruops from facebook in ossn

German Zet Man Replied 4 months ago

Anyway, there's an option like that available now with V.2.0

Component

Developer: Zet
License GPL v2
Type: Tools
Ossn Version: 4.x
Latest Version: 2.0
Last Updated 4 months ago
Repository Url View Repository

Versions