[Zope] ODBC DSN file

Mon, 14 May 2001 13:13:58 -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_01C0DC99.43497B10
Content-Type: text/plain;
	charset="windows-1252"
Content-Transfer-Encoding: quoted-printable

I found that I can pass the filename of the Excel file I want in the
connection string with the DBQ parameter.

How could I pass this parameter in the Z ODBC connection string?  Have =
I to
modify the Zope source code?  If so, wich file?

 -----Message d'origine-----
De : Menard.Jean-Francois@hydro.qc.ca
[mailto:Menard.Jean-Francois@hydro.qc.ca]
Envoy=E9 : lundi 14 mai 2001 12:03
=C0 : tpassin@mitretek.org; zope@zope.org
Objet : RE: [Zope] ODBC DSN file

Thanks Thomas, good idea.  I will use LocalFS to list all the files in =
my
directory.=20
All I need, is a way to change the DSN parameters on the fly to point =
to the
needed Excel file.  I don't want to create 100 DSN!!!  That's why I =
wonder
if Zope can use File DSN instead of Sytem or User DSN.
Maybe there would be a way to import my Excel sheets without ODBC?  I =
need
them the way they are, not in CSV  format or anything...
But again, thanks for the tip!=20

-----Message d'origine-----=20
De : Thomas B. Passin [mailto:tpassin@mitretek.org]=20
Envoy=E9 : lundi 14 mai 2001 11:45=20
=C0 : zope@zope.org=20
Objet : Re: [Zope] ODBC DSN file=20

[Menard.Jean-Francois@hydro.qc.ca>]=20
I created an ODBC System DSN, and it work fine.  But I have about=20
100 excel files, and I would like to develop an interface with a =
dropdown=20
list with all the excel files in my directory, choose one, and import =
it.=20
Any ideas how I could do that?  I tried to create a File DSN, but=20
Zope doesn't seem to detect it. With such a connection, I could change =
the=20
connection string into the DSN file when needed.=20
[Tom]=20
If you always know where the files are located, you could use the =
LocalFS=20
product.  Or you could write a simple python external method.=20
Cheers,=20
Tom P=20

_______________________________________________=20
Zope maillist  -  Zope@zope.org=20
http://lists.zope.org/mailman/listinfo/zope=20
**   No cross posts or HTML encoding!  **=20
(Related lists -=20
 http://lists.zope.org/mailman/listinfo/zope-announce=20
 http://lists.zope.org/mailman/listinfo/zope-dev )=20

------_=_NextPart_001_01C0DC99.43497B10
Content-Type: text/html;
	charset="windows-1252"
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=3Dwindows-1252">
<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>I found that I can pass the filename of the Excel =
file I want in the connection string with the DBQ parameter.</FONT>
</P>

<P><FONT SIZE=3D2>How could I pass this parameter in the Z ODBC =
connection string?&nbsp; Have I to modify the Zope source code?&nbsp; =
If so, wich file?</FONT></P>
<BR>
<BR>

<P><FONT SIZE=3D2>&nbsp;-----Message d'origine-----</FONT>
<BR><FONT SIZE=3D2>De : Menard.Jean-Francois@hydro.qc.ca [<A =
HREF=3D"mailto:Menard.Jean-Francois@hydro.qc.ca">mailto:Menard.Jean-Fran=
cois@hydro.qc.ca</A>]</FONT>
<BR><FONT SIZE=3D2>Envoy=E9 : lundi 14 mai 2001 12:03</FONT>
<BR><FONT SIZE=3D2>=C0 : tpassin@mitretek.org; zope@zope.org</FONT>
<BR><FONT SIZE=3D2>Objet : RE: [Zope] ODBC DSN file</FONT>
</P>
<BR>

Thanks Thomas, good idea.&nbsp; I will use LocalFS to =
list all the files in my directory. 
 All I need, is a way to change the DSN parameters on =
the fly to point to the needed Excel file.&nbsp; I don't want to create =
100 DSN!!!&nbsp; That's why I wonder if Zope can use File DSN instead =
of Sytem or User DSN.

<P><FONT SIZE=3D2>Maybe there would be a way to import my Excel sheets =
without ODBC?&nbsp; I need them the way they are, not in CSV&nbsp; =
format or anything...</FONT></P>

But again, thanks for the tip!

<P><FONT SIZE=3D2>-----Message d'origine----- </FONT>
<BR><FONT SIZE=3D2>De : Thomas B. Passin [<A =
HREF=3D"mailto:tpassin@mitretek.org">mailto:tpassin@mitretek.org</A>] =
</FONT>
<BR><FONT SIZE=3D2>Envoy=E9 : lundi 14 mai 2001 11:45 </FONT>
<BR><FONT SIZE=3D2>=C0 : zope@zope.org </FONT>
<BR><FONT SIZE=3D2>Objet : Re: [Zope] ODBC DSN file </FONT>
</P>
<BR>

[Menard.Jean-Francois@hydro.qc.ca&gt;] 
 I created an ODBC System DSN, and it work =
fine.&nbsp; 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?&nbsp; 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. =

 [Tom] 
 If you always know where the files are located, you =
could use the LocalFS 
 product.&nbsp; Or you could write a simple python =
external method. 
 Cheers, 
 Tom P

<P><FONT SIZE=3D2>_______________________________________________ =
</FONT>
<BR><FONT SIZE=3D2>Zope maillist&nbsp; -&nbsp; Zope@zope.org </FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://lists.zope.org/mailman/listinfo/zope" =
TARGET=3D"_blank">http://lists.zope.org/mailman/listinfo/zope</A> =
</FONT>
<BR><FONT SIZE=3D2>**&nbsp;&nbsp; No cross posts or HTML =
encoding!&nbsp; ** </FONT>
<BR><FONT SIZE=3D2>(Related lists - </FONT>
<BR><FONT SIZE=3D2>&nbsp;<A =
HREF=3D"http://lists.zope.org/mailman/listinfo/zope-announce" =
TARGET=3D"_blank">http://lists.zope.org/mailman/listinfo/zope-announce</=
A> </FONT>
<BR><FONT SIZE=3D2>&nbsp;<A =
HREF=3D"http://lists.zope.org/mailman/listinfo/zope-dev" =
TARGET=3D"_blank">http://lists.zope.org/mailman/listinfo/zope-dev</A> ) =
</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C0DC99.43497B10--