ODBC

[Boaz Bezborodko]

> Message: 1
> Date: Tue, 29 Jul 2008 17:00:32 -0400
> From: "Richard Kreiss" <rkreiss at gccconsulting.net>
> Subject: ODBC
> To: <filepro-list at lists.celestial.com>
> Message-ID: <00ed01c8f1be$24f18f30$6ed4ad90$@net>
> Content-Type: text/plain;	charset="iso-8859-1"
>
> A question for those using fp ODBC.
>
> I need to pass information to and get back from UPS Worldship.
>
> I created an Access file as that is what Worldship is written in.  
>
> ODBC record: 	PO #, store #, name, address, city state and zip - From my
> application
> 		Tracking #, pickup date, number of cartons, weight, cost -
> from Worldship
>
> I am thinking through the procedure and since I have very little ODBC
> experience, would like to know if I am approaching this correctly.
>
> I am plan to use the low level method.
> 	1. When an order is created, an odbc record is created with the po
> #, store #, name, address, city state and zip.  
> 		(This gives my application control of the shipping address
> witch UPS uses)
> 	2. Once shipped, when the order is accessed using @entsel, I want to
> check if the order is a ups shipment and if it is, check to see if there is
> a tracking #.
> 		a. No number - read the Access record and get the shipping
> information
> 				1. no value in record - not been shipped yet
> 				2. tracking # - read into filepro record
> 		b. Number present - do nothing more
>
> Since my client ships a large number of orders each month(about 8,000), I
> would like to run a procedure that deletes records for those orders that are
> 30 days or more old from the odbc database.  This should keep the database
> fairly small and make access fairly quick.
>
> At the current time the tracking #'s are being  update from a csv file
> created when Worldship close at the end of the day.  This procedure will be
> more real time.  Its other advantage is a standardized point for store
> address.  When changed in my application, the correct address will be used
> by UPS.  No, I don?t need to go back and change the address once an order
> has been shipped.
>
> Any suggestions will be greatly appreciate.
>
>
> Richard Kreiss
> GCC Consulting
> rkreiss at gccconsulting.net
> ? 
>
>
>   
I use Worldship, but I avoided using ODBC by using their text/csv 
files.  Since we don't ship a lot my system uploads the data via a batch 
file and gets the tracking and freight charge information at the end of 
the day.  IIRC UPS has the ability to create the export file when it 
processes each label.  Looking for and updating your filepro database 
with this information would allow you to keep the files up to date on a 
regular basis.

Boaz