RE: Bulk Import of User Accounts

This message was sent from: Features
http://forums.oscommerce.com/viewtopic.php?p=164686#164686
----------------------------------------------------------------

I tried creating a User by directly inputing the User Information into the MySQL table, which is basically what uploading will do. But when I tried to login as that User, it didn't recognize the User/Password combination. I even tried to leave the password blank, but that didn't work either.

So I have determined that the only way to get this to work is to upload the User Account data and run it through the osCommerce Account creation process. 

This means coming up with a script that will upload and read a comma or tab deliniated file and push the data through to the osC Account Creation process and mass create the Accounts.

*********************

I've found that the osC Account Creation process is made up of a few different pieces...

/catalog/CREATE_ACCOUNT.PHP
/catalog/includes/modules/ACCOUNT_DETAILS.PHP
/catalog/CREATE_ACCOUNT_PROCESS.php
/catalog/includes/functions/PASSWORD_FUNCS.PHP
/catalog/CREATE_ACCOUNT_SUCCESS.PHP

1.  The first page is CREATE_ACCOUNT.PHP which calls /MODULES/ACCOUNT_DETAILS.PHP from within it. ACCOUNT_DETAILS.PHP is responsible for creating the Input Fields that are used and to bundling the data that has been input.

2.  Once the required info is correctly input in the CREATE ACCOUNT form, CREATE_ACCOUNT_PROCESS is called. This file will process the information that has been input and send it to the MySQL DB.

Its in the above process (Step#2) that also calls /GENERAL/PASSWORD_FUNCS.PHP, which handles the encryption and decryption of the Password.

3.  The CREATE_ACCOUNT_SUCCESS.PHP page appears when all of the previous steps are completed succesfully.

[i]FYI... The User Account info is stored in 2 different osC MySQL Tables, the CUSTOMERS and the ADDRESS BOOK Tables. [/i]

*****************

Another thought will be the time involved with this process. Will it be able to stream the uploaded data and create the accounts immediately? Or, will there be a sight delay in between each Account creation as it gets processed? Then I wonder how long it will take to process and create 3000+ accounts.

With all of this said, lets get a few of us to work together as a Team to create a Utility that will allow us bulk upload, process and create User Accounts.

Any thoughts? Who wants in on the Team?

Let me know! 

-R