|
|
|
[SOLVED] Import users
|
|
Date: 2006/11/28 23:35
|
By: brendonhatcher
|
Status: User
|
|
|
Karma: 2
|
|
Fresh Joomlapolitan
| Posts: 16 |   |
|
|
Hi
I have created a fairly simple, well-documented method of importing a large user list into Community Builder.
The process requires phpMyAdmin access, an Excel spreadsheet (attached), and a careful reading of my documentation (attached).
I'd appreciate feedback from users, as well as suggestions on how to streamline the process.
Regards
Brendon
- word doc and excel file
|
|
The administrator has disabled public write access. |
|
|
|
|
Re:[SOLVED] Import users
|
|
Date: 2007/01/11 22:29
|
By: royce
|
Status: 
|
|
|
Karma: 0
|
|
Senior Joomlapolitan
| Posts: 52 | |
|
|
|
Ok, so to import users I use Brendon spreadsheet and for bulk edits I use Juice?
|
|
|
The administrator has disabled public write access. |
|
|
|
|
Re:[SOLVED] Import users
|
|
Date: 2007/01/14 03:28
|
By: martinschm
|
Status: User
|
|
|
Karma: 0
|
|
Senior Joomlapolitan
| Posts: 51 | |
|
|
hi,
the instructions of your spreadsheet say that the light blue fields have excel equations that would bring in data. if i however click on the fields there is no equation show. if i enter data in the white fields nothing happens.
also, the columns B & C for name and username are marked as light blue (so according to the instructions i shouldn't edit them) but don't i need to enter this data?
cheers
martin
|
|
|
The administrator has disabled public write access. |
|
|
|
|
Re:[SOLVED] Import users
|
|
Date: 2007/03/15 19:18
|
By: brendonhatcher
|
Status: User
|
|
|
Karma: 2
|
|
Fresh Joomlapolitan
| Posts: 16 | |
|
|
Apologies for the delay in responding. I wasn't subscribed to this thread.
The blue columns do contain equations. I just haven't copied the equations to the rest of the rows because I don't know how many users you have. If you click on cell B4 or C4, for example, you'll see the equations. Just AutoFill these for subsequent rows.
The userfields in columns B and C get their data from columns further to the right. To enter the user's first name, for example, go to column Y.
Hope that clears it all up.
Regards
Brendon
|
|
|
The administrator has disabled public write access. |
|
|
|
|
Re:[SOLVED] Import users
|
|
Date: 2007/06/01 04:02
|
By: revkang
|
Status: User
|
|
|
Karma: 0
|
|
Fresh Joomlapolitan
| Posts: 2 | |
|
|
can you email me revkang@mail.com
if you are able or interested in running a transfer for our school? (about 2-3 hundred folks)
for a fee?
thanks so much
|
|
|
The administrator has disabled public write access. |
|
|
