To not answer your question- You might also consider giving them (read-only) access to the MySQL database via ODBC, that way Excel could pull data for processing as a database client. Saves a few steps in downloading and importing delimited text files. I've only done this a bit with Excel, but it works well for using Access as a front end to MySQL. I assume PostgreSQL also has an ODBC driver. Quoting jeffr at odeon.net: > > Heya folks, > > I'm looking for a way to grab all the data from a database (running on > an > ACD call center) into a mysql or postgres database running on a linux > system. The call center system is network attached, and it can be > accessed via ODBC. > > Here's the scenario... > > The call center system is slow. It stores all of its logs/call-detail > stuff in an SQL database, and it takes about 20 seconds to do a pretty > simple query, hence the desire to pull all the data into a different > database running on a dedicated system. > > The goal is to grab the data files every night and import them into > mysql > or postgres, and then build a web interface with Zope so that the PHBs > can > view their reports via the intranet. Some of them like to grab the > report > and import it into excel so they can further customize their reports > themselves for their records. To support that, I'm thinking about > generating a tab delimited text file for each report every night that > they > can download. The formating will be atrocious, but they will be able to > get their raw numbers without trying to cut/paste an html document into > excel. > > The web interface also lets us build some predefined queries with some > variables that some of the PHBs have been asking us for, giving them a > little more control over the reports that they get. Hopefully if I can > make this work the way I want it to we won't need to spend our time > doing > custom reports whenever they want to see something specific that the > generic reports don't show very well. > > Anyway, I know how to do everything except sucking the data out of the > call center in one big chunk and importing it into mysql or postgres. > I'm thinking I could write something in python to do a query on the call > center (select everything from each table) and import the results of the > query into the appropriate table in mysql, but my python skills aren't > stellar just yet so I'm hoping there's an easier and more direct way > that > I've overlooked. > > The data files total about 750 megs on the call center, so I want to > grab > all the data once, and then every night grab the previous days data. > > Thanks, > > Jeff > > _______________________________________________ > tclug-list mailing list > tclug-list at mn-linux.org > https://mailman.mn-linux.org/mailman/listinfo/tclug-list > >