Tom and Alan: Thanks for the replies. Good answers.
The web side with definitely be a Linux machine, likely Postgres, and probably Ruby on Rails. An app like that speaks JSON and XML just fine, and can even do the encoding/decoding if it makes more sense to do that server-side. So, if we pick XML for the VFP interface, it's fairly simple to support a second JSON interface later on. The VFP client will be the first pass, first-years budget, but the client would really like to get into smaller smart devices (tablets, phones) if that makes sense (cost reliability, ease of development on native platform, etc.) So, the VFP app is really a single-function app: collect specific order data. (and the auxilliary functions of up- and down-load.) It collects some specific metrics, runs a custom pricing module, spits out an estimate and closes the sale. I'm tempted by the simplicity of CursorToXML() and XMLToCursor() since their built-in, know about encoding, and can produce valid XML. The VFP can read the files in, and generate them out with no 3rd party dependency. The web app would provide a secure up-and down-load. It will be wordier than JSON since attributes or properties will be repeated for each row, but the quantity of data is limited to to a day's work, so that's likely never more than 40 or 50 rows, so I don't think the bandwidth consumed should be a big concern. On Sun, Feb 23, 2014 at 3:33 PM, Alan Bourke <[email protected]>wrote: > I would advocate using JSON over XML. -- 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: [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/cacw6n4vamh3nk3d8pzx1tx-q08ueohcjorynredicbysqu4...@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.
