ODBC

Boaz Bezborodko boaz at mirrotek.com
Wed Jul 30 08:09:33 PDT 2008


I avoid having to maintain two databases by simply giving Worldship each 
address every time I ship a package.  I also include freight, 
dimensions, COD and other shipping options, etc. 

To my system Worldship just processes the shipment and gets back 
tracking number and freight charge info.  To Worldship each shipment 
looks like a unique package.  It still automatically puts shipments 
together to generate "Hundredwieght" freight rates, but I want to list a 
"package x of y" then I have to keep track of it myself.  Still, 
Worldship will let you send the "package x of y" information as well. 

Worlship will import a lot of fields including everything that can be 
key-entered in the system and, I believe, a few more.

I only have to maintain my own database and just worry about getting the 
appropriate information back from Worldship to keep it up to date.

GCC Consulting wrote:
> Thanks for the response.
>
> However, we are getting the tracking information in an end of day process
> which spins out a csv which I import and post to the order header file.
>
> The problem is that it is necessary to maintain 2 separate store shipping
> files.  Worldship and my application.  This presents a problem when
> addresses are corrected or changed or new stores added.  It is too time
> consuming to keep these in sync.
>
> Also, they are processing too many orders each day to do this in a batch
> process during the day.  The plan is to have Worldship get the address info
> from the Access file and push back the tracking info.
>
> As I have considered it, I probably will create a shipto file also.
>
> Richard 
>
>   
>> -----Original Message-----
>> From: filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com
>>
>>     
> [mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com]
> On
>   
>> Behalf Of Boaz Bezborodko
>> Sent: Wednesday, July 30, 2008 9:02 AM
>> To: filepro-list at lists.celestial.com; rkreiss at gccconsulting.net
>> Subject: Re: ODBC
>>
>>
>>     
>>> 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
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>     
>
>
>
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20080730/61cd4af8/attachment.html 


More information about the Filepro-list mailing list