Import Customers/Members

[lukefreemam]

Hi,

I have seen several options for exporting members, but is there any way of importing them?

 

I am building a website for a rowing club (mosmanrowing.com / members.mosmanrowing.com) and I am trying to incorporate membership fees with club kit and race entries. We already have a database and I need to upload that information to save people having to all type it in themselves.

 

Cheers,

Luke

[newtech]

I have tried to import customers using a csv database. I have partial success.

 

Here is what I have done, the results, and what is not working.

 

Done

1. I have imported data into three tables:

a. address_book

b. customers

c. customers_info

 

I have made sure the customer info id is the same for all three tables.

I entered todays format for the date_account_created field using the format that was on the original field.

 

Results

I show all the data has imported into the database properly. Cannot find any problems.

 

Not Working

a. In OSC admin there is a list of all customers.

b. However, there is no arrow on any of the customers and fi I click any of teh customers, no arrow shows up.

c. When I go to edit a customer, there is no data in their name in admin even though there is data in database.

 

Help!