How to have "account" field in imported contacts?

[arrowmark]

Hi, I have recently installed 5.5.0 and am about to start importing my contacts. Is there a way to have my contacts' workplaces be imported as account names? Or would I first need to import those workplaces as accounts and then import the contacts separately?

Also, I have lots of different Excel worksheets to import. They are for groups such as Loyalty Club, Front Line, Hotels, etc. Some contacts fall within several groups. I was planning to merge all worksheets into one and assign a lead source to each. Would that be the most efficient way to do this?

Thanks in advance for advice,
Jo

[arrowmark]

Surely someone knows the answer to theese queries. Or should I have posted this in another forum?

[jmertic]

You should be able to map your "workspace" field to the "Account Name" field, and it will link to existing Accounts or create new ones if a match doesn't exist.

[sugarcane]

Hello,

Check out the following Sugar University and KB links on instructions for importing data:

http://kb.sugarcrm.com/featured/importing-made-easy
http://www.sugarcrm.com/university/s...=1&sid=3&id=15
http://www.sugarcrm.com/university/s...=1&sid=3&id=16
http://www.sugarcrm.com/university/s...=1&sid=3&id=57

[arrowmark]

Hi guys, thanks for suggestions.
Jo

[arrowmark]

Hi guys, thanks for suggestions.Mapping the workplace field to account worked perfectly.

I would still be keen to hear suggestions on how to handle contacts who fall within several groups. Lead source only lets me allocate one type per person.
I've tried setting up check boxes for each group and will see if that does what I need but I'd be interested to know what others do in this situation.

Jo