Export or convert Target List

[racassel]

Hi, I want to move all my target list, to contacts or leads. Can this be done? I see an option to do it 1 at a time...... Otherwise, I can export the list, but it does not include the company name. Is there a way I can get the export function to export the company name? Which file would I edit..... Thanks so much.
Rick

[salesagility]

What version of sugar? In 5.5 when targets are exported then account_name is exported.... but you need to export the target list ... not the target.

So, add your targets to a target list and export the target list ... this will create a .csv with account_name.

[racassel]

Where can I find the version info? I looked around and it is not apparant. I believe it is 5.0x.

I was able to extract the data I needed using the script below found in the forum:

================================================== ===========================

/// this one gets all prospects in a prospect list but doesn't extract email addresses
SELECT *
FROM prospects as p
INNER JOIN prospect_lists_prospects as plp
ON plp.related_id = p.id
LEFT JOIN email_addresses as ea
ON p.id = ea.id
WHERE
plp.prospect_list_id = "3bbc3834-9d28-dc77-440b-4851544f7454"


/// this one gets all targets from all prospect lists and their emaill addresses
SELECT prospects. * , email_addresses.email_address
FROM prospects
LEFT JOIN email_addr_bean_rel ON prospects.id = email_addr_bean_rel.bean_id
AND email_addr_bean_rel.bean_module = 'Prospects'
AND email_addr_bean_rel.primary_address =1
LEFT JOIN email_addresses ON email_addresses.id = email_addr_bean_rel.email_address_id
LIMIT 0 , 30

/// get all the prospects with email addresses for a certain prospect list only
SELECT prospects. * , email_addresses.email_address
FROM prospects
INNER JOIN prospect_lists_prospects as plp
ON plp.related_id = prospects.id
LEFT JOIN email_addr_bean_rel ON prospects.id = email_addr_bean_rel.bean_id
AND email_addr_bean_rel.bean_module = 'Prospects'
AND email_addr_bean_rel.primary_address =1
LEFT JOIN email_addresses ON email_addresses.id = email_addr_bean_rel.email_address_id
WHERE
plp.prospect_list_id = "3bbc3834-9d28-dc77-440b-4851544f7454"