They don't have to do anything
On their end you do a select into and add a field for their location
Zip it
Sebd it
On your end you drop into sql server
Custom reports for them
Finished
Did a deal like this for childrens hospital in boston
Five them the abilkity tocreate xcel
Pardon typing
On cell phone so can't elaborate on ut
Sent from my BlackBerry® Smartphone by WCW
-----Original Message-----
From: "MB Software Solutions,
LLC" <[email protected]>
Date: Wed, 10 Mar 2010 12:12:33
To: ProFox Email List<[email protected]>
Subject: Re: Web services and VFP9SP1
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.
_______________________________________________
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/198234811-1268242990-cardhu_decombobulator_blackberry.rim.net-17405128...@bda238.bisx.prod.on.blackberry
** 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.
