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
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.