Mon, 17 Mar 2003 09:04:08 +0400
Perhaps off-topic, but I have similar considerations as Rick...
I believe OpenOffice can read in the CSV files, much like Excel. Is there
any way to get the information out of OpenOffice into Zope? I'm thinking
along the lines of how, on Win32 systems, one can set up a ODBC connection
to Excel files. Since OpenOffice stores all content in XML files, perhaps
there's a better way?
From: M.-A. Lemburg [mailto:firstname.lastname@example.org]
Sent: Wednesday, March 12, 2003 14:33
To: D. Rick Anderson
Subject: Re: [Zope-DB] result
D. Rick Anderson wrote:
> CSV file ODBC driver? I'm not on Windows, but is there something similar
> for Linux? that sounds promising.
unixODBC ships with a txt driver that can handle CSV files. It
takes a bit of tweaking though to set it up and only knows the
varchar column type, so all you get back is strings.
> On Wed, 2003-03-12 at 01:07, M.-A. Lemburg wrote:
>>D. Rick Anderson wrote:
>>>well .. unfortunately we dont' have access to the actual db server yet,
>>>and won't for another year. My boss wants me to parse this site, that
>>>will be composed of some 50-60 different reports, based on the CSV files
>>>that we get daily. I just don't want to have to rewrite those 50 reports
>>>to read the info from a DB connection once we get it.
>>Why not import the CSV tables into a database and then use one of
>>the available DAs to access it ?
>>If you're on Windows you can also use the CSV file ODBC driver from
>>MS to access the CSV files directly.
>>Professional Python Software directly from the Source (#1, Mar 12 2003)
>> >>> Python/Zope Products & Consulting ... http://www.egenix.com/
>> >>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
>>Python UK 2003, Oxford: 20 days left
>>EuroPython 2003, Charleroi, Belgium: 104 days left
>>Zope-DB mailing list
> Zope-DB mailing list
Professional Python Software directly from the Source (#1, Mar 12 2003)
>>> Python/Zope Products & Consulting ... http://www.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
Python UK 2003, Oxford: 20 days left
EuroPython 2003, Charleroi, Belgium: 104 days left
Zope-DB mailing list