[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: Exporting ascii files from SQL
Well, I was discussing that very issue with my good friend, Larry Wall.
He said "PERL!" I heartily agreed. You just need to slide down to your
local bookstore and pick up 2 books :
Perl in a Nutshell (just got it, awesome reference, less cryptic than
Programming Perl, the camel book)
Perl Cookbook (lots of examples and things).
Then, just connect to the GDBM database (Perl::DBI interface), make some
SQL queries, then use our beloved perl to spit out the data!
Its really quite easy. The hardest part is the database connectivity and
one thing I will give you the answer to right not. A tab is printed in
perl by ' print "\t"; '.
August Detlefsen wrote:
>
> ****** message to minivend-users from August Detlefsen <augustd@idiom.com> ******
>
> I'd like to build an exporter that would export our SQL DBs to an .asc file as a cron job. The if anything ever happens, it should be a simple matter to re-import the ascii file.
>
> Anyone have an idea what the best way would be? I've tried a couple of things, from a simple script that calls a page with [tag export products], up to a script that calls export_database in Data.pm. Any help would be appreciated.
>
> -August
> --
> August Detlefsen
> mailto:augustd@idiom.com
> -
> To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list
