Import customer accounts functionality

[pkirbyau]

I have an existing business with several thousand registered customers on my distribution list. Is there an equivalent to easy populate for customer details.

 

If not, does anyone have pointers as how to play with the SQL code otherwise?

 

I have the information in Access or Excel at the moment but would understand it may need to be ported into another format

 

Im running RC2.2 if it makes any difference...

 

Many thanks.

[cybercon]

I went through a similar issue with vendors here is what I came up with. I created a csv in excel that provided me with this

 

INSERT INTO vendors VALUES ('1364', 'B And K Cycles', 'CA', 'B AndK Cycles', '1200 Grandview', '90278', 'Redondo Beach', 'CA', '0', '0', '5632632324', '', '', '', '1');

 

Each field is enclosed in apostrophes and coma separated. Blank fields are ",

 

Then just run SQL import

[pkirbyau]

I went through a similar issue with vendors here is what I came up with. I created a csv in excel that provided me with this

 

INSERT INTO vendors VALUES ('1364', 'B And K Cycles', 'CA', 'B AndK Cycles', '1200 Grandview', '90278', 'Redondo Beach', 'CA', '0', '0', '5632632324', '', '', '', '1');

 

Each field is enclosed in apostrophes and coma separated. Blank fields are ",

 

Then just run SQL import

 

Thank you Cybercon. Ill see how I go.

 

I think I need a little more investigation into the various customer tables so will put on the snorkel and dive in this weekend.

[cybercon]

Try going to the customer tables and exporting it, that should give you the table layout.