[SOLVED] Possibility to import user data using CSV or excel table?

Hey guys,
My co-developper has insisted on collecting user data and putting them in an excel table. Is it possible to import that data into community builder or do we need to hire some monkey that does the Ctrl + C, Ctrl + V step?

CB Juice can export user data as CSV. You could also use a direct database query in phpmyadmin and export the results as CSV. CB it self does not have any import/export features at this time (planned in a later release). There's also reporting extensions that accept a database query and export it as a table of data that can be exported (check JED as think there's a few such extensions).

:woohoo: I have found this paliative first solution to import CSV to Community Builder Users.

First go to www.lightleaves.com/8-ll-users-migrate-export-import.html and download this extension. You will be asked to register to do it.

Secondly install it in your Joomla Backend. After install you will need to set the component "LL User Migrate Import Export" options database access parameters. Also in " User ID's:" option select "New Id" and in "Joomla Version:" the proper Joomla version you have installed.

Before trying an import I recommend that you export users and check the CSV file created. Note that it is a text file but in your system could be linked directly to open with Excel. The first line have the fields names. Note that some fields maybe have no sense in Excel. In particular dates could have other regional settings than yours locale settings, and passwords are coded.

Then create a text csv file, or if you like, in Excel but be careful and save it AS a CSV file.

In text the file must be look as below:

Name,Username,Email,UserGroup,Password,Block,SendEmail,RegisterDate,LastvisitDate,Activation,Params,LastResetTime,ResetCount,OTPKey,OTEP,RequireReset
Taco,taco,taco@ooo.com,Dealer,12345,0,0,,,,,,,,,
Tico,tico,tico@ooo.com,SalesConsultant,12345,0,0,,,,,,,,,
Teco,teco,teco@ooo.com,Client,54321,0,0,,,,,,,,,

BUT !! take into account that the first line, the one with the fields name, MUST NOT be present in the actual file to import. It is posted here only to clarify fields order detail.

Note that the ID first field that exists in the exported file do not exist. Also note that Password is in plain text, not coded, and after Password the other fields could be blank, but the ,,, are needed.

The final step is to go to menu Community Builder / Tools and click on Synchronize Users.

And that's all !. But you still have to manually enter some CB fields for all imported users...

Well, this is a first solution. If you know or will have another more "CB like" solution, please contact me at octaviobh@gmail.com

Thanks in advance.

Octavio.

octaviobh wrote: :woohoo: I have found this paliative first solution to import CSV to Community Builder Users.

First go to www.lightleaves.com/8-ll-users-migrate-export-import.html and download this extension. You will be asked to register to do it.

Secondly install it in your Joomla Backend. After install you will need to set the component "LL User Migrate Import Export" options database access parameters. Also in " User ID's:" option select "New Id" and in "Joomla Version:" the proper Joomla version you have installed.

Before trying an import I recommend that you export users and check the CSV file created. Note that it is a text file but in your system could be linked directly to open with Excel. The first line have the fields names. Note that some fields maybe have no sense in Excel. In particular dates could have other regional settings than yours locale settings, and passwords are coded.

Then create a text csv file, or if you like, in Excel but be careful and save it AS a CSV file.

In text the file must be look as below:

Name,Username,Email,UserGroup,Password,Block,SendEmail,RegisterDate,LastvisitDate,Activation,Params,LastResetTime,ResetCount,OTPKey,OTEP,RequireReset
Taco,taco,taco@ooo.com,Dealer,12345,0,0,,,,,,,,,
Tico,tico,tico@ooo.com,SalesConsultant,12345,0,0,,,,,,,,,
Teco,teco,teco@ooo.com,Client,54321,0,0,,,,,,,,,

BUT !! take into account that the first line, the one with the fields name, MUST NOT be present in the actual file to import. It is posted here only to clarify fields order detail.

Note that the ID first field that exists in the exported file do not exist. Also note that Password is in plain text, not coded, and after Password the other fields could be blank, but the ,,, are needed.

The final step is to go to menu Community Builder / Tools and click on Synchronize Users.

And that's all !. But you still have to manually enter some CB fields for all imported users...

Well, this is a first solution. If you know or will have another more "CB like" solution, please contact me at octaviobh@gmail.com

Thanks in advance.

Octavio.

No idea what extention that is (the link you gave leads to an internal server error).

If process works for you that is great - thanks for sharing experience.