marvi has asked for the wisdom of the Perl Monks concerning the following question:

Where can I find a good programming pattern for importing textfiles into RDMS tables? Dealing with missing files, keeping track of imports etc.

Replies are listed 'Best First'.
Re: Pattern for recurring database imports
by perrin (Chancellor) on Nov 28, 2001 at 20:23 UTC
    I've always found it pretty easy to write these on an ad hoc basis. They vary so much depending on your needs that its hard to offer much in the way of generally useful advice. However, the AnyData module might be useful to you.
Re: Pattern for recurring database imports
by Biker (Priest) on Nov 28, 2001 at 20:10 UTC

    If you have a heavy duty UNIX box to spare, I would recommend PowerMart from Informatica.

    Size and price tag indicates it's made for enterprise clients. :-)

    f--k the world!!!!
    /dev/world has reached maximal mount count, check forced.

Re: Pattern for recurring database imports
by Rhose (Priest) on Nov 28, 2001 at 19:58 UTC
    May I ask what database you are using? Many database vendors supply utilities to do these sorts of operations -- Oracle supplies SQL*Loader.