I've seen this question posted before with no answer - but is there a way to get column headings on an extraction when you save it to file? It would make things easy when passing data to a mailing house.
Also, the files always come out with no extension, so no program knows how to open them by default. Why is there no .txt extension on the file?
Matthew -
I'm not aware of any way of including column headers in extractions unfortunately. I'd be happy to be proven wrong! As for the files - we try to train our users when creating extractions to name them 'blah.txt' or 'blah.xls'. That will create a file that has a usable extension.
Heather
Ditto on the extension.
Sounds like an enhancement request to me. I mean, I'm not going to submit it myself, but I'd probably consider voting for it :)
Thanks for replying guys. That suitably irritated me enough about the column headings that I went and logged it as an enhancement request.
Hi Matt,Sorry, I've only just seen this (and I know that you've already pulled your subscription mailing) but thought I'd respond anyway.There isn't a way to include the column headings in the output but we have found a work-a-round. Full credit should be given to Lesley Diskin at Opera Australia for this solution.You can create a row in T_LIST_DECOY_NAMES, which has the name of the column in each column (eg. 'Prefix' in the prefix column). When you pull the extraction, select 'include decoys' and use the segment number that you have assigned to the decoy column row.Obviously, this only works if you don't use decoys (we don't).Cheers,Adriana Normal 0 false false false false EN-AU X-NONE X-NONE MicrosoftInternetExplorer4
Adriana Law CRM Marketing Specialist
T 02 9250 7297
Sydney Opera House Bennelong Point
GPO Box 4274 Sydney NSW 2001 AUSTRALIA
I just realised that my Friday brain meant 'this only works if you don't specify a decoy segment within the extraction', not' this only works if you don't use decoys'.
What a genius that Lesley is - I'm totally giving this a try next time.
Thanks!