Thanks, Stephen. Another nuance missed here; the import routines are part of the application. I can do all and any of these things myself very easily in my dev environment. The quest for ideas was around programmatic approaches that could be integrated into my application workflows. I want the computer to do the work. 😊
Yes, there are plenty of options for handling json in VFP. That's been part of the Westwind framework/toolkits for years. There are also some open source classes available from the VFPx Github repo.
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Stephen Russell Sent: Saturday, April 17, 2021 2:38 PM To: profoxtech@leafe.com Subject: Re: Variations in CSV settings by region
I'd take the CSV file and save it as XML. Then rip from there.
Not sure if there is a json reader/writer for VFP yet.
if you look to sql server you could import the data through the IMPORT wizard as well. You tell it the delimiters etc per file.
On Fri, Apr 16, 2021 at 8:42 AM Richard Kaye rkaye@invaluable.com wrote:
Throwing this one out to the collective wisdom. We're doing a lot with CSV import/experts these days with our web-based WWC application and are running into issues with regionalization. Here in the US, a "standard" CSV means commas between data elements and double quotes around text elements. But in Belgium, the delimiter is the semi-colon and text elements are not wrapped in double quotes. As best I can tell, Excel determines what format to use by the OS settings and not its own application settings. This makes importing from a CSV a bit of a dance for our Belgian clients as they have to change their regional settings, import the file that was received in US format, and then change their settings back. And, of course, changing region affects date and currency formats. For those of you working with clients from multiple locations where the standards may be different, what strategies do you use to deal with this?
TIA
--
rk
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
_______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CAJidMYJGvsup_znY_zeQTb=RAkEgeRQ2kBqg8zvrL=... ** 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.
Report [OT] Abuse: http://leafe.com/reportAbuse/CAJidMYJGvsup_znY_zeQTb=RAkEgeRQ2kBqg8zvrL=i_Hw...