VFP - web app interchange format?

Author: Ted Roche

Posted: 2014-02-23 at 10:25:09

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

---

_______________________________________________

Post Messages to: ProFox@leafe.com

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/CACW6n4sAYkVVb8UN5PNwBHRRqizAnt0xmQpxJn7=m8Ssq_XmrA@mail.gmail.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.

©2014 Ted Roche