1st question - are you able to tell your sources to stick with a standard file layout? Say, they also send a CSV - and the fields are all in a specific order. Or - must you change YOUR Program to take in Different formats? If so - that can be More complicated - Especially if they change the formats at any point in time - making Imports fail.
-K- -----Original Message----- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dennis Schuette Sent: Tuesday, April 28, 2015 9:47 AM To: profoxt...@leafe.com Subject: Best way to gather data I manage a VFP database for a customer on my servers and I gather data from a variety of sources, including: files through ftp sites, files in Dropbox and PDF files, text files, and Excel spreadsheets as email attachments, etc. My main tools are VFP 9 SP2 (fully patched) and Outlook 2013 and I have no web programming experience. I now have a need to gather about 10 pieces of data monthly from 50+ customers that may include numbers, dates, and some text fields. Some of these customers have RDP connections, but most do not. I am looking on suggestions as how to best gather this data so that the parsing can be automated through a VFP program. Thanks. Customized Business Services, LLC (928) 580-6352 Dennis Schuette Primary: den...@cbsds.com<mailto:den...@cbsds.com> 49 NW 130th Avenue Alternate: schuette.den...@gmail.com<mailto:schuette.den...@gmail.com> Great Bend, KS 67530 Please notice new address as of 4/1/2015 --- 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: 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/80838f1ca795b14ea1af48659f35166f1b5...@drexch02.corp.globetax.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.