[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.&nbsp; </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>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
I need to transform a lot of data from multiple Excel files and</FONT>
<BR><FONT SIZE=3D2>&gt; export one standard big text file.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
I created an ODBC System DSN, and it work fine.&nbsp; But I have =
about</FONT>
<BR><FONT SIZE=3D2>&gt; 100 excel files, and I would like to develop an =
interface with a dropdown</FONT>
<BR><FONT SIZE=3D2>&gt; list with all the excel files in my directory, =
choose one, and import it.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
Any ideas how I could do that?&nbsp; I tried to create a File DSN, =
but</FONT>
<BR><FONT SIZE=3D2>&gt; Zope doesn't seem to detect it. With such a =
connection, I could change</FONT>
<BR><FONT SIZE=3D2>&gt; the connection string into the DSN file when =
needed.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
So:</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
- Is it possible to connect to a File DSN ODBC from Zope?</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
- Is there a better, cleaner solution I could try?</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Thanks!</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Jean-Fran=E7ois M=E9nard</FONT>
<BR><FONT SIZE=3D2>&gt; Intranet DPAS</FONT>
<BR><FONT SIZE=3D2>&gt; Pratiques d'affaires et orientations</FONT>
<BR><FONT SIZE=3D2>&gt; *&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
(514) 840-3000&nbsp; poste 3939</FONT>
<BR><FONT SIZE=3D2>&gt; *&nbsp; (514) 840-5585</FONT>
<BR><FONT SIZE=3D2>&gt; *&nbsp; menard.jean-francois@hydro.qc.ca</FONT>
<BR><FONT SIZE=3D2>&gt; =
*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 855 Ste-Catherine =
est, 6e =E9tage</FONT>
<BR><FONT =
SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp; Montr=E9al, Qu=E9. H2L 4P5</FONT>
</P>
<BR>
<BR>

</BODY>
</HTML>
------_=_NextPart_001_01C0DC8B.2F5B6EA0--