[Zope] ODBC DSN file
Menard.Jean-Francois@hydro.qc.ca
Menard.Jean-Francois@hydro.qc.ca
Mon, 14 May 2001 11:33:11 -0400
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C0DC8B.2F5B6EA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thanks for your response!
Yes, I could do that, but I would like to skip this step if possible, =
cause
I will keep receiving data form Excel sheets for a while. =20
What I would like to do is create a web interface to let users put the =
exel
files in a directory on the server, import the data themselves, create =
some
transfer directives, end export the result.
So, would it be possible?
-----Message d'origine-----
De : Tino Wildenhain [mailto:tino@wildenhain.de]
Envoy=E9 : lundi 14 mai 2001 11:22
=C0 : Menard.Jean-Francois@hydro.qc.ca; zope@zope.org
Objet : Re: [Zope] ODBC DSN file
Hi Jean-Francois,
I would import the Excel-Sheets into an RDBMS first
and then use this to access your data.
Regards
Tino Wildenhain
--On Montag, 14. Mai 2001 11:09 -0400 Menard.Jean-Francois@hydro.qc.ca=20
wrote:
>
> I need to transform a lot of data from multiple Excel files =
and
> export one standard big text file.
>
> I created an ODBC System DSN, and it work fine. But I have =
about
> 100 excel files, and I would like to develop an interface with a =
dropdown
> list with all the excel files in my directory, choose one, and import =
it.
>
> Any ideas how I could do that? I tried to create a File DSN, =
but
> Zope doesn't seem to detect it. With such a connection, I could =
change
> the connection string into the DSN file when needed.
>
> So:
>
> - Is it possible to connect to a File DSN ODBC from Zope?
>
> - Is there a better, cleaner solution I could try?
>
> Thanks!
>
> Jean-Fran=E7ois M=E9nard
> Intranet DPAS
> Pratiques d'affaires et orientations
> * (514) 840-3000 poste 3939
> * (514) 840-5585
> * menard.jean-francois@hydro.qc.ca
> * 855 Ste-Catherine est, 6e =E9tage
> Montr=E9al, Qu=E9. H2L 4P5
------_=_NextPart_001_01C0DC8B.2F5B6EA0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>RE: [Zope] ODBC DSN file</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Thanks for your response!</FONT>
</P>
<P><FONT SIZE=3D2>Yes, I could do that, but I would like to skip this =
step if possible, cause I will keep receiving data form Excel sheets =
for a while. </FONT></P>
<P><FONT SIZE=3D2>What I would like to do is create a web interface to =
let users put the exel files in a directory on the server, import the =
data themselves, create some transfer directives, end export the =
result.</FONT></P>
<P><FONT SIZE=3D2>So, would it be possible?</FONT>
</P>
<P><FONT SIZE=3D2>-----Message d'origine-----</FONT>
<BR><FONT SIZE=3D2>De : Tino Wildenhain [<A =
HREF=3D"mailto:tino@wildenhain.de">mailto:tino@wildenhain.de</A>]</FONT>=
<BR><FONT SIZE=3D2>Envoy=E9 : lundi 14 mai 2001 11:22</FONT>
<BR><FONT SIZE=3D2>=C0 : Menard.Jean-Francois@hydro.qc.ca; =
zope@zope.org</FONT>
<BR><FONT SIZE=3D2>Objet : Re: [Zope] ODBC DSN file</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Hi Jean-Francois,</FONT>
</P>
<P><FONT SIZE=3D2>I would import the Excel-Sheets into an RDBMS =
first</FONT>
<BR><FONT SIZE=3D2>and then use this to access your data.</FONT>
</P>
<P><FONT SIZE=3D2>Regards</FONT>
<BR><FONT SIZE=3D2>Tino Wildenhain</FONT>
</P>
<P><FONT SIZE=3D2>--On Montag, 14. Mai 2001 11:09 -0400 =
Menard.Jean-Francois@hydro.qc.ca </FONT>
<BR><FONT SIZE=3D2>wrote:</FONT>
</P>
<P><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> =
I need to transform a lot of data from multiple Excel files and</FONT>
<BR><FONT SIZE=3D2>> export one standard big text file.</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> =
I created an ODBC System DSN, and it work fine. But I have =
about</FONT>
<BR><FONT SIZE=3D2>> 100 excel files, and I would like to develop an =
interface with a dropdown</FONT>
<BR><FONT SIZE=3D2>> list with all the excel files in my directory, =
choose one, and import it.</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> =
Any ideas how I could do that? I tried to create a File DSN, =
but</FONT>
<BR><FONT SIZE=3D2>> Zope doesn't seem to detect it. With such a =
connection, I could change</FONT>
<BR><FONT SIZE=3D2>> the connection string into the DSN file when =
needed.</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> =
So:</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> =
- Is it possible to connect to a File DSN ODBC from Zope?</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> =
- Is there a better, cleaner solution I could try?</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> Thanks!</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> Jean-Fran=E7ois M=E9nard</FONT>
<BR><FONT SIZE=3D2>> Intranet DPAS</FONT>
<BR><FONT SIZE=3D2>> Pratiques d'affaires et orientations</FONT>
<BR><FONT SIZE=3D2>> * =
(514) 840-3000 poste 3939</FONT>
<BR><FONT SIZE=3D2>> * (514) 840-5585</FONT>
<BR><FONT SIZE=3D2>> * menard.jean-francois@hydro.qc.ca</FONT>
<BR><FONT SIZE=3D2>> =
* 855 Ste-Catherine =
est, 6e =E9tage</FONT>
<BR><FONT =
SIZE=3D2>>  =
; Montr=E9al, Qu=E9. H2L 4P5</FONT>
</P>
<BR>
<BR>
</BODY>
</HTML>
------_=_NextPart_001_01C0DC8B.2F5B6EA0--