I’m importing a csv file into Sugar. I get Accounts in and then the associated Contacts with their custom fields without problems. There are several custom fields in the csv used to define mailing lists. I’ve created each mailing list entry as a campaign and target list. While I can import the contacts into a target list, it doesn’t map to the original contact imported.

I probably could do a sql insert of the appropriate contact id into the correct target list in the backend. However I can’t seem to find where the target lists are stored and which tables are used to store the contact, target and account target list references. Is this an appropriate approach or is their a better way? I’m currently using SugarCRM 4.5.1 Open Source.

I have found references to a targets table in some past threads, but this table doesn't exist in the crm tables in my install.