Greetings,
I am trying to get this utility to do something, anything, for me at this point. I have been trying to get a simple test import to work (I exported 2 orders from one performance via the export utility and am using that same tab delimited .txt file to import into another performance... same MOS, same price type, customer_no already exists in our db. Payment method is cash and accessible). The permissions on the folder are good, I am running it under an administrator user group, I have verified permissions on everything (famous last words). What I get is a barely 2 page review report, and the error message just stops in the Import Process Log portion with 'Error 0, Severity 0, State 0, Procedure, Line 0'.... and no other error message. I've traced the procedure and I see that there are tons of meaningful error messages in the code. I've re-watched the webinar. I've even said 'pretty, please!'.
Anyone ever seen this type of non-error with Order Import? I've opened a help ticket, but was hoping there might be someone out here who had a quicker answer.
Thank you, thank you!
Nancy
I've seen something similar with suffixes and prefixes, but if it is data from your own database then this shouldn't be a problem. If you open the export in Excel are the order dates formatted correctly? If not you will want to format them.Check that you have an extension on your 'Bcp Error File' path in tr_import_order_set, I seem to recall having issues until I added a .txt to the end.Also make sure that you do not have the export file open at the time you try to import or it will fail.
I'll let you know if I think of anything else to check.
Hi Nancy-
We just went through this process, are you running on version 10.0. If so there is a bug in it with unseated orders not getting into the system. Tessitura sent me a hot fix for that.
I also remember when I was doing this set up we hit that same error and we did not have everything set-up correctly in our system table. I think it was the solicitor was missing, but can't remember exactly. Good luck.
Jeanette
2 thoughts since we obviously spent way too much time playing with this:
1) Is the name of your .txt file displayed on the review report?
If not, then I think the utility isn't even getting there. It could be a permissions issue or a naming issue.
2) If the name is there the next thing I would do is go in and try to manually sell a seat under the same User Group, MOS, Price Type, etc... to be sure permissions look good.
Hope you figure it out soon!