• Replies 9 replies
  • Subscribers 341 subscribers
  • Views 99 views
  • Users 0 members are here
Options
Related

Order Import File issue

Donna Wiser
$organization

Hi,

Looking for some guidance. We play in 3 venues but none are "home" to the Florida Orchestra. I have been trying to import the venue sales for the first time. They have not done this in the past. I am working towards streamlining this process for reporting. 

I have been working with Tessitura for a few weeks troubleshooting the errors. We seem to have things mostly sorted out. I have an XML Format file as well as a txt Import order file. There is a TERMINATOR "\r\n" on the last import row.

The latest error is  - Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)". The import file data may be out of sync with the specified format file. 

Has anyone encountered this issue and how did you resolve it?

I've researched the help guide, Troubleshoot section and a pop-up skill builder for Importing Orders. From there I looked at the T_DEFAULTS table and found 2 entries relating to OLE. See below screenshot. I'm not sure if I need to add any, one for xml and txt?

Thank you in advance!

Donna

Parents
  • $organization

    Hi Donna,

    I have also fought many of these import batttles, and definitely came up against the issues Kanani has described with extra spaces etc throwing it off. I always select the cells for import and paste them to a new document then save as .txt for import, as even a click into an empty cell outside the range has been known to break it! 

    I expect you have found this in the documentation already but make sure the upload file is the only one in the folder, make sure any dates are in the correct format, your columns are in the same order.

    Good luck!

    Katie

Reply
  • $organization

    Hi Donna,

    I have also fought many of these import batttles, and definitely came up against the issues Kanani has described with extra spaces etc throwing it off. I always select the cells for import and paste them to a new document then save as .txt for import, as even a click into an empty cell outside the range has been known to break it! 

    I expect you have found this in the documentation already but make sure the upload file is the only one in the folder, make sure any dates are in the correct format, your columns are in the same order.

    Good luck!

    Katie

Children
  • $organization in reply to Katie Sewell

    Hi Katie,

    Glad to hear I'm not the only one, lol.

    I do have to manipulate 3 venues data so I can see where something may throw it off.

    I do have only one file in each of the folders. Columns are in same order. What format should the dates be? I tested it with 10/10/2022 as well as 2022-10-10 for the order date. I didn't see anywhere that said what it should be unless I totally overlooked that info.

    I'm so glad I posted this question. Everyone on this forum is great and so helpful.

    Thank you!

    Donna