Exporting Campaign Target List

[stoomey66]

I am using Sugar Community Edition Version 5.0 on Windows XP.

I have created a campaign and a campaign targeted list from my contacts. I have down loaded the MS Word trial and am having difficulties with it. When I click the merge file within Sugar nothing happens. Now on to the 2nd idea, I would like to export this campaign mailing list to a comma separated file.

I pull up the campaign list and there is no export button for it. Is there an easy way to do this or do I need to go through each individual contact and reselect the names of the campaign and export that way.

Any help would be great.

Thanks
Scott

[maxmix]

I know its Boring, but "ME TOO"

I wanted to do export from an elder 4.5 Version a finetuned Target list to an up to date new but (still empty) 5.1.

Usually - with contacts i have the Xport option available - with targets it looks much different.
Any ideas - to help us ?

Txs

[roblaus]

Unfortunately you have to do the export directly from the database. Check in "prospect_lists" for the id (e.g. f150ace4-c45d-0bdd-f874-48cdf951e6da) of the list you want to export.

Then create the following query:

SELECT *
FROM `prospect_lists_prospects`
WHERE `prospect_list_id` = 'f150ace4-c45d-0bdd-f874-48cdf951e6da'

If you use OpenOffice this is very easy - use oo base, create a query, open oo calc and open the saved query with F4. You can then drag and drop it into your spreadsheet and fiddle with it.
But since the result is a relation make sure that you have the related base data (leads, contacts) available in your new db with the SAME IDs, otherwise the list won't show anything.

Hope that saves your Sunday!
rgds

[sebek]

I would also like to export (edit in spreadsheet) and import target lists.
Could you write me how to do that...more in detail....please

Thank you