July 14, 2010 | 
Author Two years back, I have blogged catalog importer, which will help us to import catalog data into commerce server. I have used this tool in many projects and business users like this tool as it uses excel as input parameter. Recently I see in communities asking for user profile import. User profile has some sensitive information (like password, secret question and answer, etc) and we can’t directly insert these data into database as these data should be encrypted using few algorithms (SHA1, SHA256, MD5, etc) before saving into database.
If your requirement is to import all existing user profiles then the good option is to insert data using commerce server API. I created a tool (simple and robust) which will help you to insert user profile (can extend to save address and other profiles) information in commerce server. The tool is very flexible and extensible without touching the code. Input to this tool is the excel file (sample file in data folder) and couple of constraints with this template are.
- The work sheet name should be “UserData”.
- Currently only 5 columns are there but you can extend the list – the column name should be same as commerce server column name. For example, if you want to import telephone number then the column name should be “GeneralInfo.tel_number”.
The code is pretty simple and self explanatory. When you run the tool, you will be prompted for excel file location. After providing the information, the tool loads data into data table and starts inserted data one by one into commerce server. The output of the tool looks like this (I have imported the sample data in the sample template file). Any wrong information in excel will lead to exception.
On successful import, if you query “UserObject” table (or other profile tables), you can find imported data.
Click here to download the tool.
If you like this post, please click on our sponsor advertisement.
Posted in 
Tags: 
