OK, I am totally lost after 4 days trying to import customer data in version 7. I have a simple file with 2 rows and 6 columns. This is how the data looks like. Company,Address Type,City,State,Zip,Phone Health Basket of Mount Dora,18834 US HWY 441,Mount Dora,FL,32757,352-735-1166 Health Basket of Clermont,1050 Florida 50,Clermont,FL,34711,352 242-4499
If I try to import this I get this message after I press <validate>
No matching record found for name 'Health Basket of Mount Dora' in field 'Company' at row 2
Get all possible values
Found multiple matches for field 'State' (2 matches) at row 2 (1 more)
Value '18834 US HWY 441' not found in selection field 'Address Type' at row 2
Here are the possible values:
Default
Invoice
Shipping
Contact
Other
Missing required value for the field 'name'. This might be 'Name' in the current model, or a field of the same name in an o2m. at row 2 (1 more)
No matching record found for name 'Health Basket of Clermont' in field 'Company' at row 3
Get all possible values
Value '1050 Florida 50' not found in selection field 'Address Type' at row 3
Here are the possible values:
Default
Invoice
Shipping
Contact
Other
Can someone please help. Thank you