Framework for import plain text files into databases

Thread view:

german.largo@gmail.com - 31 Aug 2006 02:47 GMT

Hi everybody.

I'm looking for a framework that allow me to map text files into
tables.

I need to load files with different structures into one or many tables
under some customer-specific rules. I was searching for a while but it
looks like there isn't anything like that, so if any of you knows a
framework or plugin that allow me to do that, please let me know.

Thanks in advance.

Reply to this Message

Chris Smith - 31 Aug 2006 04:53 GMT

> I'm looking for a framework that allow me to map text files into
> tables.

What do you mean by a framework? There's no obvious reason to desire a
"framework" for this task in most common senses of the term. Perhaps
you can be clearer about what you're looking for?

> I need to load files with different structures into one or many tables
> under some customer-specific rules. I was searching for a while but it
> looks like there isn't anything like that, so if any of you knows a
> framework or plugin that allow me to do that, please let me know.

Are the files in some well-known format? If not, then you will
unavoidably need to write your own code to read them. Once you've read
the files, and if you understand the database schema, it shouldn't be
too difficult to write the SQL statements to import them into a
database.

Signature

Chris Smith

Reply to this Message

Framework for import plain text files into databases

Free Magazines