• Replies 6 replies
  • Subscribers 337 subscribers
  • Views 92 views
  • Users 0 members are here
Related

Import Order Utility issues

Jeffrey Fauver
$organization

Hello out there -


We at Goodman Theatre in Chicago are trying to start using the Import Order Utility after seeing some great examples of how it can work at the Conference. However, when we tried to test it, it wouldn't import anything. Our IT staff filed a help ticket several weeks ago and has yet to hear anything, despite a few follow-up attempts.

Anyone out there using this successfully? Thoughts or suggestions?

Jeffrey Fauver
Publicity Manager
Goodman Theatre

Parents
  • $organization

    What's the error you're getting?  I just got it to work for us and I'm pretty sure I hit all of them at one point or another!  ;-)

    Common problems are the location of the file being inaccessable to the database, incorrect formatting of the data, or a problem with your performance set-up so that's where I'd start looking.  The error message should point you to which of these things is causing the issue.

  • $organization in reply to Kjersten Schladetzky

    Here's what our IT department passed along:

     

    The error message was:  50000 The file The system cannot find the file specified. does not have a valid
    extention() and will be skipped.

     

    Entered on 08/31/2010 at 12:05:06 by Chris Hipschen:
    I am currently testing the Ticket Order Import Report to discern if it could be used to seat our "opening night" performances. I've
    placed the test import file in multiple locations but the same error is returned for all of them.

     


    Attempted locations:

    \\file-server\imports\order (files residing on a file server)
    \\file-server\imports\order\ <file:///\\file-server\imports\order\> (files residing on a file server)
    T:\imports\orders (files residing on a file server)
    T:\imports\orders\ (files residing on a file server)

    C:\imports\orders (files residing on the SQL server)
    C:\imports\orders\ (files residing on the SQL server)
    C:\imports\ (files residing on the SQL server)
    C:\imports (files residing on the SQL server)

     

    The test file is simply an Ticket Order Export file, saved to excel, edited, and saved as txt.

    From the SQL server the file could be manually opened from all of the above locations.

Reply
  • $organization in reply to Kjersten Schladetzky

    Here's what our IT department passed along:

     

    The error message was:  50000 The file The system cannot find the file specified. does not have a valid
    extention() and will be skipped.

     

    Entered on 08/31/2010 at 12:05:06 by Chris Hipschen:
    I am currently testing the Ticket Order Import Report to discern if it could be used to seat our "opening night" performances. I've
    placed the test import file in multiple locations but the same error is returned for all of them.

     


    Attempted locations:

    \\file-server\imports\order (files residing on a file server)
    \\file-server\imports\order\ <file:///\\file-server\imports\order\> (files residing on a file server)
    T:\imports\orders (files residing on a file server)
    T:\imports\orders\ (files residing on a file server)

    C:\imports\orders (files residing on the SQL server)
    C:\imports\orders\ (files residing on the SQL server)
    C:\imports\ (files residing on the SQL server)
    C:\imports (files residing on the SQL server)

     

    The test file is simply an Ticket Order Export file, saved to excel, edited, and saved as txt.

    From the SQL server the file could be manually opened from all of the above locations.

Children
No Data