I found that using ActiveVFP on the server and VFP on the client was pretty slick using the CURSORTO XML and XMLTOCURSOR. Basically VFP web services awesome!
-----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Ted Roche Sent: Sunday, February 23, 2014 11:25 AM To: [email protected] Subject: VFP - web app interchange format? How 'bout that? An on-topic question! I need to upload/download small (10-100 records) batches of data between a web application (likely Ruby, maybe PHP) and a VFP application. Data is straight-forward, 3 simple tables of data: customers names and addresses, order details and some numeric constant-ishes. The idea is that the web app assigns a batch of customers, the sales guy downloads the data to their portable VFP apps, load it up, and visit the customer sites, where internet of any form (cellular, wireless, wired, modem) is not available. Data is gathered/updated, and later (when internet available) tabular data loaded back up to the mothership, overwriting existing records. VFP is a bridging technology; I want the import/export to be generic enough that other devices (iPad, Android, WinTab) might be used in future versions with minimal recoding. My thoughts are that the two compatible formats these days are JSON and XML. Questions: 1. Anyone doing something like this? What techniques/technologies are you using? I see Sweet Potato (yay, Craig!) and Google Code both have JSON translators. Experiences? VFP can do CursorToXML() and the reverse. Problems? 2. Problems with translating character data between web app (typically UTF-8) and FoxPro (ASCII/ANSI Windows code pages)? Customer data will likely be Euro-American English (accents, tildes, umlauts, etc.) suitable for US Postal delivery, so not Persian, Cyrilic or Asian character sets. I'm pretty sure CursorToXML should handle encoding back-and-forth pretty well. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/41fa58bff3534218bedad32550740...@blupr05mb007.namprd05.prod.outlook.com ** 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.
