• 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

    Hi Jeffrey,

    good day.

    a few things need to be awared.

    1, full file name has no space, also not too long.

    There is limitation of full file name too, we had run into these two troubles before. In the import script, the full command line length is 250? charaters. 

    2, You cannot import the file when the file is openning.

    3, two tables should check if you want to.

    T_ORDER_IMPORT_SESSION

    T_ORDER_IMPORT_LOG

    if you want to run an imported file again, you can delete the file in T_ORDER_IMPORT_SESSION, then you can import it again.

     

    have fun

    Ben

     

     

Reply
  • $organization

    Hi Jeffrey,

    good day.

    a few things need to be awared.

    1, full file name has no space, also not too long.

    There is limitation of full file name too, we had run into these two troubles before. In the import script, the full command line length is 250? charaters. 

    2, You cannot import the file when the file is openning.

    3, two tables should check if you want to.

    T_ORDER_IMPORT_SESSION

    T_ORDER_IMPORT_LOG

    if you want to run an imported file again, you can delete the file in T_ORDER_IMPORT_SESSION, then you can import it again.

     

    have fun

    Ben

     

     

Children
No Data