Malcolm Greene wrote: > Micheal, > > I agree with Virgil - make a copy of your tables - zip them - and FTP or > HTTP/HTTPS upload them to a central folder. > > You should be able to all of this very easily with VFP. Craig Boyd has a > free zip encryption FLL. There are some very good free VFP FTP libraries > or use WestWind IP-Tools(?) ($200) which would also allow you to upload > your files via an HTTP/HTTPS interface. > > This gives your Finance team a bunch of zipped tables. They should be > able to take it from there. > > Or you could write a simple VFP utility that your Finance team would run > that would unzip and load tables into a master database. > > I also agree with Stephen's comment that you really might want to look > at new technology. In this case you might want to look at Python's > excellent *built-in* zip file and web modules. I don't see any reason > why you can't implement your solution as 2 small, standalone Python > apps. > > Good luck! > Malcolm
I don't like the idea of Finance having to unzip and process files, especially since there's 1000 centers, so no freakin' way is someone expected to process 1000 zip files every month. Absolutely not if I'm associated with the project. Perhaps you meant use the zip feature on the center side to post it in the web area, then have another program on the corporate side poll the web folder for files to process and handle the transfer that way? That I could see as an option. I could secure the zip with 128-bit encryption using Craig Boyd's FLL. Hey, I wonder if I could have a simple table that puts the zip file in a text/blob field in the MySQL table? That way, I could perhaps use my original idea without having to look bad for security reasons. Just want to make sure I don't get "dinged" for security...because if I expose customer data, that could obviously bring my time here to a quick close. Tell me more about Python's web module...what's that about? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
