• Replies 4 replies
  • Subscribers 414 subscribers
  • Views 121 views
  • Users 0 members are here
Related

Order Import Utility Issues

Naomi Satake
$organization

Hey everyone!
 
We're trying to use the order import utility for the first time (working in Test for now).  I set everything up according to the utility documentation on the TessituraNetwork site (XML file, txt file, TR_IMPORT_ORDER_SET), but the utility still won't work.  

I went through to the Reports and Utilities, ran the Order Import Utility, and the report ran -- but aside from a list of all the selections in the TR_IMPORT_ORDER_SET (nothing in red), nothing! -- no notice of failure or count of failed rows. It's as if it ignored all of the data.  

Any idea of how why this might be happening?



[edited by: Naomi Satake at 9:36 PM (GMT -6) on 27 Apr 2015]
Parents
  • $organization
    The other thing that some times causes problems is the account running SQL server needs to be able to both read and write to location where you are putting files.

    It may be time for a support ticket with the network support team.

    --Tom

    On Mon, Apr 27, 2015 at 9:57 PM, Tessitura Ticketing Forum wrote:

    Hi Tom,

    There is no second page, but I did set the parameters to Run Mode: "Import" -- no dice! Thanks though
    From: Tom Brown
    Sent: 4/28/2015 1:44:37 AM
    If I remember the parameters correctly.

    Did you set review parameter to No.

    It may be on a second screen of parameters.



    --Tom

    On Mon, Apr 27, 2015 at 9:30 PM, Tessitura Ticketing Forum wrote:

    Hey everyone!

    We're trying to use the order import utility for the first time (working in Test for now). I set everything up according to the utility documentation on the TessituraNetwork site (XML file, txt file, TR_IMPORT_ORDER_SET), but the utility still won't work.

    I went through to the Reports and Utilities, ran the Order Import Utility, and the report ran -- but aside from a list of all the rows in my txt file (nothing in red), nothing! -- no notice of failure or count of failed rows. It's as if it ignored all of the data.

    Any idea of how why this might be happening?



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!


    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!
Reply
  • $organization
    The other thing that some times causes problems is the account running SQL server needs to be able to both read and write to location where you are putting files.

    It may be time for a support ticket with the network support team.

    --Tom

    On Mon, Apr 27, 2015 at 9:57 PM, Tessitura Ticketing Forum wrote:

    Hi Tom,

    There is no second page, but I did set the parameters to Run Mode: "Import" -- no dice! Thanks though
    From: Tom Brown
    Sent: 4/28/2015 1:44:37 AM
    If I remember the parameters correctly.

    Did you set review parameter to No.

    It may be on a second screen of parameters.



    --Tom

    On Mon, Apr 27, 2015 at 9:30 PM, Tessitura Ticketing Forum wrote:

    Hey everyone!

    We're trying to use the order import utility for the first time (working in Test for now). I set everything up according to the utility documentation on the TessituraNetwork site (XML file, txt file, TR_IMPORT_ORDER_SET), but the utility still won't work.

    I went through to the Reports and Utilities, ran the Order Import Utility, and the report ran -- but aside from a list of all the rows in my txt file (nothing in red), nothing! -- no notice of failure or count of failed rows. It's as if it ignored all of the data.

    Any idea of how why this might be happening?



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!


    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!
Children
  • $organization in reply to Tom Brown (Past Member)

    Thanks Tom for your thought!

    After some fiddling, I figured out that despite the documentation, "Import Ref No Location" in TR_IMPORT_ORDER_SET could not be listed as "(none)."  I was able to override the issue by adjusting the TR_REFERENCE_COLUMN table to let "Import Ref No Location" accept "-1."

    It's a little misleading to have a few columns allow "(none)" as a field entry in TR_IMPORT_ORDER_SET, anyway, when it's stated that "all columns are required except when noted as optional." Once I got that out of the way though, the ball started rolling!