Need assistance with fpODBC

[Rick Hane]

Hi Rich,

I think I was not clear in my email.  Of course fp reads Excel files via
import.  That is the step I want to remove.

I want to set up the fpODBC to read the data directly from the SQL data
base.  I know this is possible.  The problem is how.


Thank you,
Rick Hane
Controller
Deluxe Stitcher Company Inc
ISP Stitching Products
www.deluxestitcher.com
773-777-6500



-----Original Message-----
From: Richard Kreiss [mailto:rkreiss at verizon.net] 
Sent: Tuesday, October 23, 2012 9:10 AM
To: Richard Hane
Cc: file Pro Mailing List; Rick Hane
Subject: Re: Need assistance with fpODBC

Top post:

Fp does not read Excel files. 

What I would suggest is creating Access files linked to your Excel file.
Then connect Fp to the that access file for the import. 

I used Access as a way to link a client's fp application and UPS World
Ship.   it is using their shipto file so this info only needs to be
entered once and is maintained centrally.



By doing this, I don't gave to account for changes in the WorldShip data
structure. UPS Handles the mapping. 

The other import from WorlsShip is at the end of the day. We import from
a csv file created with the end of day reports, the daily tracking
information.

Richard Kreiss
Sent from my iPhone

On Oct 23, 2012, at 9:04 AM, Richard Hane <yoresoft at sbcglobal.net>
wrote:

> We need help setting up our fpODBC.  I have over 30 yrs with fp. I
also do a lot of transferring of data between our MRP software (written
in Microsoft SQL Server)  and fp via the ODBC link in Excel.  I even
took the class in Indy on the ODBC.  That all being said I don't have
the time to play with this and need it setup PDQ.
>  
> A short description of what we do.
> There are about 15 Excel
> spreadsheets I import every day, from MRP then read in to filePro.  
> All I am looking for the fpODBC to do is eliminate the need for the 
> spreadsheets and read the data directly.  It does not need to be live 
> data as a record is called up during the day, rather just a daily 
> update process that I would set as a scheduled task.Before someone 
> asks; we do not allow external access to our systems.  No exceptions.

> So this might have to be an on site help. I can provide a copy of each
of the spread sheets with data and field names.  Obviously also include
the table name.  What I would need from you is how to set up the link (
I had a problem when I tried to do this 3 years ago) and write the
process to do the importing.  Probably Only need you to show 1 of the
processes.  The rest I can write.
>  
> I am assuming (insert joke here) 3 - 5 hours.  We would like to hire
someone for that time.  It would have to be someone local or who comes
to the Chicago area on occasion.
> Email me at either address listed below or call me at the number
listed.
>  
> Thank you in advance,
> Rick Hane
> Controller
> Deluxe Stitcher Company Inc
> ISP Stitching Products
> rhane at deluxestitcher.com
> yoresoft at sbcglobal.net
> 773-777-6500
> -------------- next part -------------- An HTML attachment was 
> scrubbed...
> URL: 
> http://mailman.celestial.com/pipermail/filepro-list/attachments/201210
> 23/cd05becb/attachment.html 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes 
> http://mailman.celestial.com/mailman/listinfo/filepro-list