On Tue, Jun 19, 2001 at 02:45:54PM -0500, jeffr at odeon.net wrote: > > 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. If you say the current database server is slow, my suggestion is to dump the data in text files and move them over to the linux box. Over there you could use a little bit of perl magick (tm) to put them in the database. florin -- "you have moved your mouse, please reboot to make this change take effect" 41A9 2BDE 8E11 F1C5 87A6 03EE 34B3 E075 3B90 DFE4