I started to comment on that yesterday, but i've been sick with the flu. But today I'm feeling a tad bit better and wanted to state that many times I've done data conversions using text files for various reasons.
for instance, if you look at any printed report, you will begin to notice that the fields always start in a certain positions and your lines will have header, detail, summary, blank lines, etc.. So it is a fairly simple transfer of data to send the report to a text file and then process the file using substrings and after a few passes, you can capture the data and insert it into your new tables.. Don't remember the reasons I did it this way, but I think it was from systems that didn't play well together or team a didn't want to work with team b.. But of course my experiences have been like Kurt and I was typically playing firefighter.. Don't get me wrong, i prefer the "Plan your work and work your plan" philosophy, but there are times and companies where that is not an option. On 4/28/2010 8:30 AM, Kurt Wendt wrote: > Hey Paul - don't get too offended by Stephen's comments - as its just > his style of Quirky Humour! > > I believe he is referring to the older style of coding (which, many I > suspect still do - even myself - as the place where I work has no time > to properly plan - I get new tasks thrown at me every day - and I just > need to turn them around as fast as possible - or continue to be > buried!) - where people create code on the fly without making lots of > plans and documenting the flow of a system. And, I think his comment > about passing a Text file - was just his way to come up with an extreme > issue. > > :-) > -K- > > -----Original Message----- > From: [email protected] [mailto:[email protected]] > On Behalf Of Paul McNett > Sent: Tuesday, April 27, 2010 6:12 PM > To: [email protected] > Subject: Re: Open source updates cost TIME instead of $$$ > > On 4/27/10 12:38 PM, Stephen Russell wrote: > >> On Tue, Apr 27, 2010 at 1:40 PM, Paul McNett<[email protected]> wrote: >> >>> On 4/27/10 11:19 AM, Stephen Russell wrote: >>> This work turns out to make your code much more portable, secure, >>> > reliable, and stable. > >> ------------------------- >> Untill you take straight text and pass that back to the db, then you >> > Well, that would be pretty stupid. You'd have to trust the network you > are on, but > that's no different than transferring any file over that network. > > >> get a whole new set of people scared. Or you just craft your >> statements on the fly, that builds DBA confidence real quick! >> > Not sure what you mean by "craft statements on the fly" and how that > would pertain. > > Paul > [excessive quoting removed by server] _______________________________________________ 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.
