manually adding users
Submitted by Anonymous on Sun, 2009-08-09 19:51
is there a prefered method to manually add user accounts when in-band registration is disabled.
i.e. i need to manually add about 100k users from a CSV text file and then in the future add them in batches of 10 to 20
i presume i should write a script to import the CSV directly into the db for 100k users and and ad-hoc commands script fro the smaller batches?
(also has anyone already got such beasts already written?)
- 1170 reads
Printer-friendly version- Send to friend
I used to generate large
I used to generate large user databases for my load tests. From my experience the best (and the fasted way) to do it is via SQL scripts.
However I don't think you can use SQL only script to load users from SCV files. In my cases all users had user names generated by the code which is simple to do.
Therefore your best option would be probably to use any scripting language to read the SCV file, and connect to the database and add user accounts. Just remember that, depending on the authentication connector you use, you should call proper stored procedures to perform such actions.
Using the ad-hoc command is also an option but this is much slower way, and you need a 'bot' or something like this which would call the ad-hoc command.
Post new comment