You can insert a new record into a temp MV file via ODBC or you can dump text data to a file on a net share. When we were solely integrated with WorldShip (and we still use it for hazmat), we utilized an RF terminal to scan the package tracking barcode, prompt for weight and shipping charges, and then perform billing, credit card charging, etc in a WaveLink/Pick application from MV. Contact JMO Business Systems if you are interested in building a simple MV app for industrial RF terminals like the Symbol PDT6800 series. The whole export/import deal was too disconnected for my liking.
---------------------------------------- Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: [email protected] Web: http://www.all-spec.com Blog: http://blog.all-spec.com ---------------------------------------- > -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Brutzman, Bill > Sent: Wednesday, August 19, 2009 10:37 AM > To: U2 Users List > Subject: [U2] U2 and UPS WorldShip > > > The main thing we need with United Parcel Service is to get the 1Z... > tracking number back into UniVerse. > > I found that, via ODBC, WorldShip can read a packslip file from UniVerse > and import all of the packslip data but WorldShip stalls when trying to > write the data back to UniVerse via the same ODBC connection. > > Thus, it appears that we have to export the UPS data to Microsoft SQL > Server and then use another ODBC (JDBC or .Net) connection to read the > 1Z from SQL Server and then write the 1Z to UniVerse. > > Insights or alternative approaches would be appreciated. > > --Bill > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
