Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. adriangarford

    Visual Integrator Import Query

    Cracked it, I think the batch number anomaly must have been a red herring (hope this is not an English only phrase?). Problem was that I included the [H.ShipperID] and [H.CommentText] in the data definition with Replace operators and refereces to columns that were the wrong format / didn't...
  2. adriangarford

    Visual Integrator Import Query

    Thanks, I'll have a look at that. Any idea what could be causing my error message?
  3. adriangarford

    Visual Integrator Import Query

    D'oh - didn't know that! Yes I have it set up currently so that a user can assign a batch number if they like but it's not essential functionality. Is there is a way of automatically assigning the next batch number to the whole import?
  4. adriangarford

    Visual Integrator Import Query

    Hi All Here's a quick update on this - I decided to try using MS access as a intermediary vehicle to make this work. The database sits on the server & I import my shipping data text file. Sage's live order info is then exported via a VI export. A simple query brings the two together & is the...
  5. adriangarford

    Visual Integrator Import Query

    MASGuy - sorry, I should have mentioned this earlier! I have two chained imports running that pickup the same text file for their import. The first is importing into SO_InvoiceHeader and the second is importing into SO_InvoiceTracking. It's only the one importing into SO_InvoiceHeader that's...
  6. adriangarford

    Visual Integrator Import Query

    Hi All Not sure if anyone can help here? I'm trying to finalise a visual integrator import in MAS 200 (version 4.30). This VI job will import shipping information from our 3rd party fulfilment operation via a simple delimited text file the pass to us. The aim is to automatically populate...

Part and Inventory Search

Back
Top