That's what I was going to suggest - something kind of "down & dirty" to just get the job done. Could even be an exported TXT/CSV file of the data that gets export from the external sites - and imported at the Corp. site. For a webpage - it could simply be something that the external sites can access a simple webpage that allows a file to be uploaded to Corporate - and dropped into a specific folder. Once there - the App running on Corp can continuously poll this folder for existing files - and, when it sees one - process the file - pull in the data - then Kill the file or move it for Archiving purposes.
But - again - Corp may have some rules that Mike has to follow... -K- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Virgil Bierschwale Sent: Wednesday, March 10, 2010 10:52 AM If there all the same tables, write a vfp app that will go to the tables, grab the data, zip it and allow them to either email or fed-ex it to you. Quick and dirty. Works because I've used it many times over the years Virgil Bierschwale -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MB Software Solutions,LLC Sent: Wednesday, March 10, 2010 9:46 AM The need: Centers across the nation have data in their local VFP9 database folder (all free tables). We need to send some of that data to corporate. First idea: I had thought I'd just create a simple VFP9SP2 app that uses a MySQL web database (like I've done many times now). The problem: Corporate doesn't want to expose a database on the web. They'd rather I use a web service and have that be the public-facing object. I don't know DotNet but am very good with VFP9, and I need this to come up quick (within 2 months), so please (Stephen) don't say "Make it in DotNet." -- it's a waste of bandwidth at this point. Other: Target/Backend database here at Corporate can be a SQL Server 2005 database or VFP9 (most likely free tables). Suggestions? -- Mike Babcock, MCP _______________________________________________ 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/289ea162f5642645b5cf64d624c66a14071a1...@us-ny-mail-002.waitex.net ** 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.
