[Zope-DB] result

[Samir Mishra]

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?

TIA.

Samir.

-----Original Message-----
From: M.-A. Lemburg [mailto:mal@lemburg.com]
Sent: Wednesday, March 12, 2003 14:33
To: D. Rick Anderson
Cc: zope-db@zope.org
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.

> Thanks,
> 
> Rick
> 
> 
> 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.
>>
>>-- 
>>Marc-Andre Lemburg
>>eGenix.com
>>
>>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@zope.org
>>http://mail.zope.org/mailman/listinfo/zope-db
> 
> 
> 
> 
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://mail.zope.org/mailman/listinfo/zope-db

-- 
Marc-Andre Lemburg
eGenix.com

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@zope.org
http://mail.zope.org/mailman/listinfo/zope-db