Hello,
I have an extraction that I generated and am trying to extract the constituents to an excel file for light cleaning and de duping for a brochure mail file. When I extract to a file, the view log posted this in the final line: Comment: Error: BCP failed. Not sure what that comment refers to. Can anyone shed light? I then extracted to a list. But Tess won't let me export a list generated from extraction to an excel document. Is there a way to do this that I am missing?
Please help,
Doug
PlayMakers Repertory Company
Are you using “Execute an Output Set” in Reports and Utilities?
From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Doug Coon Sent: Friday, April 25, 2014 12:56 PM To: Nicole Keating Subject: [Tessitura Marketing Forum] Exporting an extraction to an excel
Eric Gerdts
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
No, I was using Generate a List in Reports and Utilities. I have not created an Output Set for this List. Is that a step I need to take?
The easiest way I’ve found to export a list into Excel is to use “User Defined Format from a List” under Labels and Letters in Report/Utility. I choose Standard Mailing Labels as the Output Format. Once the labels are generated I save that document as an Excel spreadsheet. It also gives you header columns as well should you need to do a mail merge.
Christopher Cuhel I Software Application Project Manager
John Michael Kohler Arts Center
ccuhel@jmkac.org
Direct 920-694-4551
From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Doug Coon Sent: Friday, April 25, 2014 12:30 PM To: Chris Cuhel Subject: RE: [Tessitura Marketing Forum] Exporting an extraction to an excel
From: Nicole Keating <bounce-nicolekeating9176@tessituranetwork.com> Sent: 4/25/2014 12:04:39 PM
I believe that BCP error you're seeing is a technical issue having to do with the server configuration. We've experienced something similar. It's something you would probably need your IT people to resolve, possibly with help from Tessitura support.
"Generate a List" only works on lists that have criteria. What you want is definitely "Execute an Output Set," or "User Defined Format from a List." Output sets offer you much more flexibility in terms of which data you want to pull, so I always tend to use those.
Of course, when you extract to a list you lose the ability to track which segments which people were in, (unless you save the segments individually as separate lists,) but that is definitely a useful workaround if/while your extractions aren't working.