getting data to the internet

[fp at casabellagallery.com]

Scott posted:

> 
> I have a client that is looking to be able to supply his clients with real
> time (or close to) access to their data.
> There are a couple different filepro data files involved - client master
> file, each clients data and a few others.
> 
> My concern is mainly from a security standpoint.
> He is in the middle of having a web site designed that he would like his
> clients to be able to log in to in order to access this data -- so he wants
> to setup individual usernames/passwords for clients to be able to get a
> 'snapshot' of activity and a few reports.
> 
> With all the 'new' products available for filePro - what is the easiest way
> to get this accomplished?
> 
> My thought was orginally to do a 'data dump' each night to his web host
> provider and upload this data into a MySQL table or something -- but I'm
> pretty sure there is an easier way to do this - without endangering security
> on his filePro server.
> 
> Currently he is running filePro 64-user license on a SCO OpenServer 5.0.5system.
> 
> Does anyone have a 'blueprint' for accomplishing this?
> Thanks
> 

Scott,

There are many ways to skin this cat and you will hear of many here in the
coming days  :)

Here are some suggestions:

1) fpSQL or whatever the name is (sorry, being away for awhile ...)
2) Periodic updates via XML + ftp + cron + stored procedures ...
3) Write filePro code to write mySQL queries and execute them as filePro records
   are added, edited, deleted ... then access mySQL from site (not filePro)
4) Write CGI or PERL code to connect to your server and run live inquiries
5) Write PHP code to connect to your server and run live inquiries (which can also run 
   in CGI mode but not a good idea as it gets very slow)
6) Hire a guy like me to get it done  ;)

Not exactly a map to a definite solution but a start.

Regards,



---
Jose Lerebours
954  559  7186
http://www.fpgroups.com