- Zope - Zope lists

Widening the ODBC test window in IE?
by Schmidt, Allen J. 13 Jul '01

13 Jul '01

Is there anyway to do this? Code to change somewhere? I use it a lot and am finally frustrated enough to ask. Sorry to bother everyone... Allen

1 0

Re: [Zope] Export to Excel format??
by Mark Langkau 13 Jul '01

13 Jul '01

Hi Oliver, Looks like the right stuff. Thanks for the thread-link! Cheers, Mark Oliver Bleutgen wrote: > > I've searched the mailing list, but only found discussions on importing > >>from Excel to Zope. I need to go the other way. > > Take a look at the thread beginning at > http://zope.nipltd.com/public/lists/zope-archive.nsf/ByKey/ADBCE79BD296A2C9 > > it should answer your question. > > cheers, > oliver

1 0

Export to Excel format??
by Mark Langkau 13 Jul '01

13 Jul '01

Hi, I have a need to have data returned from a query to be displayed in either html, ascii, or MS-Excel formats. Before submitting a query, the user chooses if they want the result returned as a rendered html page to view, an ASCII file to download and import into something else, or as an Excel spreadsheet to download. (From the customers request. They haven't defined what "ascii' means yet - fixed length or csv). Any ideas on how to do this (export to Excel)? I don't think I'll need anything fancy, such as formulas, cell formatting, etc. Probably just a conversion of the html table into something that will be recognized and loaded by Excel. (Would a csv file named "something.xls" or even "something.csv" work??) I've searched the mailing list, but only found discussions on importing from Excel to Zope. I need to go the other way. Thanks, Mark

2 2

Re: [Zope] Export to Excel format??
by Oliver Bleutgen 13 Jul '01

13 Jul '01

> Hi, > I have a need to have data returned from a query to be displayed in > either html, ascii, or MS-Excel formats. Before submitting a query, the > user chooses if they want the result returned as a rendered html page to > view, an ASCII file to download and import into something else, or as an > Excel spreadsheet to download. (From the customers request. They haven't > defined what "ascii' means yet - fixed length or csv). > Any ideas on how to do this (export to Excel)? I don't think I'll need > anything fancy, such as formulas, cell formatting, etc. Probably just a > conversion of the html table into something that will be recognized and > loaded by Excel. (Would a csv file named "something.xls" or even > "something.csv" work??) > I've searched the mailing list, but only found discussions on importing >>from Excel to Zope. I need to go the other way. Take a look at the thread beginning at http://zope.nipltd.com/public/lists/zope-archive.nsf/ByKey/ADBCE79BD296A2C9 it should answer your question. cheers, oliver

1 0

Re: [Zope] Choice of the sorting key of a dtml-in tag
by Oliver Bleutgen 13 Jul '01

13 Jul '01

> Hi again, > I'd like to make a page with a list of my Zclass instances and to be able > to > sort them by different key. I tryed with this code : > <dtml-if "REQUEST.has_key('skey')"> > <dtml-else> > <dtml-call "REQUEST.set('skey', 'bobobase_modification_time reverse')"> > </dtml-if> > <dtml-in "objectValues(['article'])" size=3 sort=skey start=query_start> Take a look at lib/python/OFS/dtml/main.dtml This is the management form for a folders contents view and it contains every trick you need here. IIRC they use <dtml-in "objectValues(['article'])" size=3 sort_expr="skey" start=query_start> i.e. sort_expr instead of sort. Unfortunately I can't find any documentation besides the src of DT_in.py about it's functionality. cheers, oliver

1 0

Form Based Login
by Bruce, Chris 13 Jul '01

13 Jul '01

What is the best approach to use form based login? -------------------------------------------------------------------------- Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. --------------------------------------------------------------------------

2 1

Re: [Zope-CMF] Java WYSIWYG editor
by Ausum 13 Jul '01

13 Jul '01

An alternative for windows IE only: http://www.aspalliance.com/Yusuf/Article10a.asp Free to use, AFAIK :) Ausum Shane Hathaway wrote: > > seb bacon wrote: > > A quick note: a problem with Java in applets is that really needs to > > be 1.1 to ensure browser compatibility, AFAIK > > In fact the Ekit applet requires Swing, which hasn't been integrated > into Netscape's Java. (Not sure about MSIE.) > > However, the Ekit demo contains Javascript for using the Java plug-in... > and I must say, this applet looks very, very nice! I suppose it just > uses Swing to do the fancy work (I haven't checked yet). I'm running it > on Linux and there appears to be a problem with the control characters > like arrows and the "enter" key, but that can be dealt with. > > I used to do Java (and Windows) exclusively. Applets were fun except > when they crashed (and how they crashed!), so I didn't make many > applets. But now that Java works on a more stable platform, there could > be some opportunity here! > > Another thing I looked at yesterday is the possibility of using Plugger, > a Netscape plugin that lets you use shell commands as plugins. > > Shane > > > * Jon Edwards <jon(a)pcgs.freeserve.co.uk> [010712 14:27]: > > > via another list - http://www.hexidec.com/ekit.html > > > > > > "Ekit is a program & applet that uses the Java 2 libraries to create an HTML > > > editor. The Ekit standalone also allows for HTML to be loaded and saved, as > > > well as serialized and saved as an RTF. It is currently a beta, though many > > > features work fine." > > > > > > Any java gurus out there? :-) > > _______________________________________________ > Zope-CMF maillist - Zope-CMF(a)zope.org > http://lists.zope.org/mailman/listinfo/zope-cmf > > See http://www.zope.org/Products/PTK/Tracker for bug reports and feature requests

1 0

Re: [Zope] authentication probelm (take two)
by Bob Shelton 13 Jul '01

13 Jul '01

> Bob Shelton writes: > > File /usr/local/src/Zope-2.3.3-src/lib/python/DocumentTemplate/DT_In.py, line 710, in renderwob > > (Object: getParentForums) > > Unauthorized: 0 > It appears, there is something strange in your list. > I thinks the "0" what you try to access and are not allowed > to, probably because your container has no permission. > I suggest, you install Shane's wonderful "ZDebug". > Often, it is able to generate excellent diagnostics for > permission problems. I think, you need an intermediate > DTML object to see the diagnostics. the problem may lie in discrepencies beween my interfaces and the classes themselves. i will find out for sure when i have time this weekend. thanks, though. i got ZDebug. -bob

1 0

RE: [Zope] DTML-IN not using SIZE parameter in HDML coding.
by Schmidt, Allen J. 13 Jul '01

13 Jul '01

Been to the archives several times and have run across this, too. But, if there are 20 records and I say size=4, I don't get just 4. If I know there are 8 records and I say size=2 I get all 8. I have tried several combinations but each comes back with too much data as it is ignoring the SIZE. -----Original Message----- From: Paul Zwarts [mailto:paz@oratrix.com] Sent: Friday, July 13, 2001 10:25 AM To: Schmidt, Allen J.; zope(a)zope.org Subject: RE: [Zope] DTML-IN not using SIZE parameter in HDML coding. I think I can regurgitate words from Chris to me: Bit by the orphan bug! <dtml-in .... size=10 orphan=0> If you have size=10, but there are 13 records, you get 13 unless you specify the orphan=0. Check the DTML ref guide on <DTML-IN> for more info. Paz (I love to sound smart at someone else's expense) -----Original Message----- From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of Schmidt, Allen J. Sent: Friday, July 13, 2001 4:11 PM To: zope(a)zope.org Subject: [Zope] DTML-IN not using SIZE parameter in HDML coding. I'm working on an HDML page to displayed on a WAP-enabled phone. Its all done in Zope. The application works great. It asks you for part of a company name to search for, submits and queries a database and returns a list of company names that match. However, it seems to be ignoring the size parameter of the dtml-in tag. So long at the list is fewer than 10 it works fine. If over that, the phone can't handle the display of the page and throws an error. Not a Zope error but one from the phone. Any idea why size would not work with HDML? Thanks Allen _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

2 1

RE: [Zope] DTML-IN not using SIZE parameter in HDML coding.
by Schmidt, Allen J. 13 Jul '01

13 Jul '01

Number of bytes... If there is only a small line returned for each of 20 rows...this will be less than the 1400 (should be much less...) Could if have anything to do with the number of rows ZSQL 'grabs' for the query? I'm referring to the Advanced tab now. Anything to do with this there? The size of the page should be determined by the number characters I present to the 'browser' right? If I have just two words for each line times, say, 20 lines, that should not overload it. Aside from this small thing, Zope makes it so nice to write pages for the phone. Several major things are planned and the list keeps growing as we discover new things we can do. Thanks -----Original Message----- From: Ausum [mailto:augusto@artlover.com] Sent: Friday, July 13, 2001 10:44 AM To: Schmidt, Allen J.; zope(a)zope.org Subject: Re: [Zope] DTML-IN not using SIZE parameter in HDML coding. Mobile pages like HDML/WML has page size limits, which use to be the problem. The size attribute of the dtml-in tag doesn't ensure you a target page size, which depends on the number of all the characters within the page, including WML/HDML tags. For WML the page size limit is 1400 bytes. Ausum "Schmidt, Allen J." wrote: > > I'm working on an HDML page to displayed on a WAP-enabled phone. Its all > done in Zope. > The application works great. It asks you for part of a company name to > search for, submits and queries a database and returns a list of company > names that match. > However, it seems to be ignoring the size parameter of the dtml-in tag. So > long at the list is fewer than 10 it works fine. If over that, the phone > can't handle the display of the page and throws an error. Not a Zope error > but one from the phone. > > Any idea why size would not work with HDML? > > Thanks > > Allen > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev )

2 1