On 8/9/2011 4:28 PM, Malcolm Greene wrote: > Michael, > > This might be an excellent opportunity to experiment with Python. You > could create a simple command line script to process your data and > create a CSV like file that your VFP app could import. > > Python has excellent support for strings, files, and XML. Python doesn't > have any size restrictions beyond what fits in memory and if you're > running a 64 bit version of Python, your memory space can be as large as > your budget for memory.
Alas, this is not a python project for now, because it was a program already written and working. I've confirmed with the mgmt that the file sizes we're getting now are much higher than they used to be. And it's a production issue now, so I can't go recreating in Python from scratch. I'm sure you understand. The LLFF commands I've used seem to work good now, however. Now I have to go and retool the export to Excel 2007 portion, because it was going to Excel 2003 before, and now that we've upsized to 2007, the Excel code isn't working the same, so now the focus is shifting to that. Ugh...what a day! Thankfully, Craig Boyd's code is just what I need. I've used it once successfully, so I have confidence in it to deliver yet again. Just a pain in the ass that I have to write in code the labels for columns A through GZ. (It's currently in an Excel template.) FUUUUDDDGGGEEEE! Hey, on 2nd thought, I should be able to export that shitty row to a text file and just grab that! AAaaahhhh! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
