Inputing mass customer details

[Mr_Gareth]

Hi.
Is it possible to recreate a database in a new store containing upto 9000 customers details from a previous (non actinic store)?

I have been asked to build a new store, but the client wants to keep all the existing customer account details - name, address, login details, email address, etc from the current store.

I really wouldn't want to enter every piece of data in manually. Is there a quicker method?

Thanks

[leehack]

Actinic information is held within an Access database, after some manipulation you shoudl be able to recreate the existing structure. It will be a case of cross-referencing your current fields to the ones actinic needs.

You could always download the free 30 day trial and see the format it takes.

[Jan]

You should build a hierarchical import file for import into Actinic from the information that you have, to check the format, enter one set of details manually and then export the details, then use the detail in the file produced as your template (the format is also in the help).

I wouldn't recommend trying to enter this information straight into the database as the structure of the accounts information is a little tricky.

Regards,

[NormanRouxel]

You can import customer data into Actinic via a structured text file. Actinic calls this a Hierarchical Import.

Look in the Actinic help for Importing Content into Actinic.

There's also a sample import file in C:\Program Files\Actinic v8\Sites\Site1\Common\SampleCustomerImportFile.txt. Example below.

Header:Customer,Name,External Reference,Price Schedule,Status,Payment Method,Email On Order,Email Address,Telephone,Fax,Contact Name,Salutation,Title,Comments,Invoice Address,Invoice Address Rule,Purge
Header:CustomerAddress,Name,Line 1,Line 2,Line 3,Line 4,Post/Zip Code,Country ID,Valid Invoice Address,Valid Delivery Address,State ID,Exempt Tax 1,Exempt Tax 1 Data,Exempt Tax 2,Exempt Tax 2 Data,Purge,Residential/Commercial
Header:CustomerBuyer,Username,Password,Status,Invoice Address Rule,Invoice Address,Delivery Address Rule,Delivery Address,Email On Order,Email Address,Maximum Order Value,Name,Salutation,Title,Phone,Fax,Limit Order Value,Hide Retail Prices,Purge
Header:PriceSchedule,Schedule Name,Base schedule,Calculation Method,Calculation Factor

Customer,"Example Customer 1","100001",Retail,0,10002,0,"name@mail.address","0123 456 7898","0123 456 789","Contact name","","","",Invoice Address,1,0
CustomerAddress,"Buyer Address","Buyer street address","","Buyer Town/City","Buyer State/Province/County","Postcode",UK,1,1,,0,"",0,"",0,0
CustomerAddress,"Invoice Address","Invoice street address","","Invoice Town/City","Invoice State/Province/County","Post code",UK,1,0,,0,"",0,"",0,0
CustomerBuyer,"Buyer 1","password",0,2,Buyer Address,0,Buyer Address,0,"buyername@buyer.com",0.000000,"Buyer name","","","0123 465 789","",0,0,0
Customer,"Example Customer 2","100002",Retail,0,10002,0,"name@mail.address","0123 456 7898","0123 456 789","Contact name","","","",Invoice Address,0,0
CustomerAddress,"Buyer Address","Buyer street address","","Buyer Town/City","Buyer State/Province/County","Postcode",UK,1,1,,0,"",0,"",0,0
CustomerAddress,"Invoice Address","Invoice street address","","Invoice Town/City","Invoice State/Province/County","Post code",UK,1,0,,0,"",0,"",0,0
CustomerBuyer,"Buyer 3","password",0,0,Invoice Address,0,Buyer Address,0,"buyername@buyer.com",0.000000,"Buyer name","","","0123 465 789","",0,0,0
CustomerBuyer,"Buyer 2","password",0,0,Invoice Address,0,Buyer Address,0,"buyername@buyer.com",0.000000,"Buyer name","","","0123 465 789","",0,0,0

I've also attached a copy here.