[GUSDEV] Re: Gusdev-gusdev digest, Vol 1 #587 - 8 msgs

[Eric E. S. <es...@vb...>]

As the original poster, I should say that the XML-based loaders people 
have mentioned (thanks, BTW!) are the ultimate solution I was looking 
for.  While the specific problem I have today came to me as a tab 
delimited file (TIGR annotation from their web site), the data must be 
mapped to the schema somehow; XML seems like the obvious way to do that. 
                If it simultaneously addresses the other issues, then we 
are way ahead of the game.  As Pablo suggests, maybe the real solution 
to the specific problems of tab delimited data as a medium of exchange 
should be addressed by encouraging adoption of XML by more data providers.

 >From: "Pablo N. Mendes" <pa...@pa...>
 >Subject: Re: [GUSDEV] Generic GUS data loader for tab delimited files
 >Date: Fri, 10 Jun 2005 11:05:58 -0300
 >Hi folks,
 >I find working with tab delimited files quite uncomfortable and
 >sometimes dangerous.  We don't have ways to check well formedness or
 >schema compliance (like in XML with XSDs or DTDs). This could cause
 >execution halts after long time running or worse: wrong data loaded
 >into the database.
 >Any thoughts on this?