I've done a number of Worldship integrations using Unidata and ODBC. Earlier it was stated that the integration is limited to an INSERT. That's entirely true. The key is having access to write into a temp table on the U2 side and then having some program that can consume the records that get dropped in that file and post the results to the real data table. Writing anything directly from ODBC - in my opinion - can get ugly.
On Wed, Aug 19, 2009 at 10:10 AM, Glen Batchelor <[email protected]>wrote: > > 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 > -- -Kevin http://www.PrecisOnline.com _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
