Import/Add accounts in bulk?

[anthonyv]

Hi there,

i will be using snippetmaster to allow a large number of cients to edit a single page withi their own folders.

My problem is that with 383 clients, setting up an account for each one is going to be a tedious task.
Is there a way i could create account in bulk? - generally i'd use a CSV import option, but Snippet Master does not seem to have anything like this.

How/where could i find an SQL entry/example that would allow me to do this in bulk?

I could provide the details for each client as follows;

username|password|firstname|lastname|email|language|enabled|privilages|starting_folder|starting_url|allow_uploads|quota|can_manage_files|upload_grp|list_grp|editor_grp|notes

anthony|testpass|anthony|verma|anthonyv@officeclub.co.uk|english|yes|user|/home/mydomain.co.uk/anthony/|http://www.mydomain.co.uk/anthony/|no|-1|no|uploadgroup1|listgroup1|editorgroup1|no notes

james|james0000|James|Todd|james.t@somedomain.co.uk|english|yes|user|/home/mydomain.co.uk/james/|http://www.mydomain.co.uk/james/|no|-1|no|uploadgroup1|listgroup1|editorgroup1|no notes

How could i import this data into the SQL database so that effectively i'm bulk importing users?

Please advise.

Much appreciated.

Anthony.

[anthonyv]

Ok, i found that in the file: /mailclub/editor/snippet-db/68ab106xxx/users.php, the kind of values i was looking for... eg:

id#username#password#first_name#last_name#email#enabled#start_root#start_url#language#allow_uploads#user_type#list_group#upload_group#edit_group#description#manage_files#disk_quota


however, when i look a few lines down at the entry for a user already setup, i found that the password was encrypted?

so if i wanted to add additional lines to this file, how would i encrypt the passwords?

Please advise.

Thank you.

[admin]

Hello,

At the moment, there is no way to do an import of users into the database file... There is also no way for you to use the encryption system outside of SnippetMaster.

However... what I can do is take a look at maybe creating an "external encryption engine" or something so that you can do this.  For example, you would give it a list of your users and details you want added to the database, and it will take the "plain-text" password you provided and then spit out an encrypted version.

Let me know what kind of timeline you have for this, as I'm pretty swamped with other work at the moment.  (I have a full-time job, and paying my bills comes first..)

Let me know..

[anthonyv]

Hey there,

thanks for the prompt reply.

something along those lines would be great, just any method of me speeding up the process of adding nearly 400 accounts.

In terms of time scale, ideally something by friday would be great.

Please provide a quote for this work and i will consult my manager.

Thanks.

[admin]

I'll send you a PM with details...