- Zope - Zope lists

zope sql_delimiter windows
by garry saddington 27 Dec '06

27 Dec '06

I have a Zope application that runs perfectly on Linux. However, my target audience is likely to use Windows so I am trying to port my app. to that platform. Whenever I use a multiple insert Zsql method that includes sql_delimiter, python.exe crashes. eg. <dtml-in att> <dtml-var sql_delimiter> <dtml-if absent> insert into attendance (absent,timeperiod,studentid ) values ( <dtml-sqlvar absent type="string">, <dtml-sqlvar timeperiod type="string">, <dtml-sqlvar studentid type="int"> ) </dtml-if> </dtml-in> The above ZSQL method works on Linux any Zope version but causes the crash on Windows, Zope versions - 2.8, 2.9, 2.10 have been tested and all fail, is there an issue with this? Regards Garry

3 5

Re: [Zope] usering module problem on zope 2.8.8
by Allen Huang 27 Dec '06

27 Dec '06

I know I'm not suppose to use Z Class anymore but I really aren't familiar with make Products yet and I just want to do some quick result before I translate it into a product but it seem that something is different with Z Class in Zope 2.9 and I couldn't make a Z Class like I use to do when I'm was using Zope 2.8. Why is that? ----- Original Message ---- From: Andreas Jung <lists(a)zopyx.com> To: Allen Huang <swapp0(a)yahoo.com>; Zope <zope(a)zope.org> Sent: Wednesday, December 27, 2006 3:03:52 PM Subject: Re: [Zope] usering module problem on zope 2.8.8 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 - --On 26. Dezember 2006 20:05:41 -0800 Allen Huang <swapp0(a)yahoo.com> wrote: > zope 2.8.8 uses python 2.3.5 > but I want to use modules that will only work with python 2.4 > > I've being adviced not to change runzope.bat file since it might disrupt > functionalities of zope 2.8.8 designed for python 2.3.5. what should I do? Use Zope 2.9 or Zope 2.10 that will require Python 2.4. - -aj -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (Darwin) iD8DBQFFkhrYCJIWIbr9KYwRAgtlAJ0a2fcP15hkbO6FX0yD9zrUSGGKyQCcCiPE b1BfidjHojTfIXVdsx1Ui9c= =khQQ -----END PGP SIGNATURE----- __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

3 2

Re: [Zope] processing data problem
by Allen Huang 27 Dec '06

27 Dec '06

Thanks for replying Maciej Wisniowski As I have mention some of the problem due to both methods I proposed, I wish to aim to build a system that could keep everything web-based and at the same time process the source data on the user's computer instead of send large source file(such as the dbf) back to the server for process. I feel that this way it would be faster since the processing the source data isn't very complicated with the python modules I have on-hand to do the processing. The problem is how to get the module to the users at the same time work for them. Just as you said, I could make an application for windows users, but I really want to keep everything web based and be multi-plateform. I want to make a zope site where you can deliver modules to the user computer, process the data, send back to the server, create zope objects and store it in zodb. This is what I wants to do. Please feel free to provide me with any suggestion.. Thanks. ----- Original Message ---- From: Maciej Wisniowski <maciej.wisniowski(a)coig.katowice.pl> To: Allen Huang <swapp0(a)yahoo.com> Cc: Zope <zope(a)zope.org> Sent: Wednesday, December 27, 2006 7:18:37 AM Subject: Re: [Zope] processing data problem > I already have the tools to do it but I just don't know where to do it. > Is it to bring the program to the user and process it on the user's > computer or bring the data to my server and do it. > If its on the user's computer, I could save the time from transfering > files, which could be a really problem if the file is over 500mb, > let alone 1GB. but the user's computer might not have the libraries > needed to translate the set data. This is very inprecise use case description. Do you have to transfer these files for every user and every time he has to do something? How many users (and concurrent users) you will have? What is your network admin opinion about such a big transfers for estimated amount of users? > I would really like to work on the first case, since I think it is the > most effeicient way, Efficient for you or for your users? > but I don't know how to do it (bring the program to a computer > that probably won't have python or the required libraries). > Do you know how to accomplish this? Could you help me? What do you mean by 'bring the program to a computer'? Just few hints: 1. Write INSTALL.txt :-) 2. Use python 'eggs'. 3. In Windows you may use py2exe (or things like that) to create typical Windows executable app. and there are other possibilities like installers etc. but you first need to define your target platform and then ask about this (possibly on python mailing list). -- Maciej Wisniowski __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

2 1

how to modify floder's attribute by script
by nienfeng 27 Dec '06

27 Dec '06

I create a folder in ZMI, and add several attributes in it. In the folder, I add a Script that modify the folder's attribute. How should I do?

2 2

usering module problem on zope 2.8.8
by Allen Huang 27 Dec '06

27 Dec '06

zope 2.8.8 uses python 2.3.5 but I want to use modules that will only work with python 2.4 I've being adviced not to change runzope.bat file since it might disrupt functionalities of zope 2.8.8 designed for python 2.3.5. what should I do? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

2 1

Re: [Zope] processing data problem
by Allen Huang 26 Dec '06

26 Dec '06

Hi Andreas Jung I'm sure you have seen my earlier post about shapefiles. the files that i'm working with are .shp, .shx, .dbf and I'm aware that zodb is not the place to store big files. I just need to translate individual entries in the data set into individual object in zodb. I already have the tools to do it but I just don't know where to do it. Is it to bring the program to the user and process it on the user's computer or bring the data to my server and do it. If its on the user's computer, I could save the time from transfering files, which could be a really problem if the file is over 500mb, let alone 1GB. but the user's computer might not have the libraries needed to translate the set data. If I where to bring the file over to my computer I have to wait for the file to transfers to my computer but I wouldn't have to worry about the program not working. I would really like to work on the first case, since I think it is the most effeicient way, but I don't know how to do it (bring the program to a computer that probably won't have python or the required libraries). Do you know how to accomplish this? Could you help me? ----- Original Message ---- From: Andreas Jung <lists(a)zopyx.com> To: Andreas Jung <lists(a)zopyx.com>; Allen Huang <swapp0(a)yahoo.com>; Zope <zope(a)zope.org> Sent: Sunday, December 24, 2006 11:31:09 PM Subject: Re: [Zope] processing data problem -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > - --On 24. Dezember 2006 07:10:21 -0800 Allen Huang <swapp0(a)yahoo.com> > wrote: >> >> Anyways, since I have encounter some initial problem, I was wondering if >> I should do this 1. have the user upload the set data or transfer the >> set data to my computer 2. process and record the data into zodb >> 3. delete the set data(since I really don't need a copy of it, but I >> don't see how I could do that) >> or is there any way that I could just process the data right on the >> user's computer without transfer it to my computer, like bring the >> programming to them instead of bring the set data to us since set data's >> could be quite large (over 1GB). In addition: what is an "online system"? Keep in mind that the ZODB not a data bog for temporary or large files. There are possibly better solutions for your purpose but you did not tell us exactly what you are trying to do and what kind of data you have and how often you update them. - -aj -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (Darwin) iD8DBQFFjp09CJIWIbr9KYwRAvQfAKCRnqdIrVxizT829VSJxdXwBhtpHQCgiZ0p uw11mrYAk6y/czpZKKnr7i8= =tI7S -----END PGP SIGNATURE----- __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

2 1

Re: [Zope] zope sql_delimiter windows
by garry saddington 24 Dec '06

24 Dec '06

Andreas Jung wrote: > Please read this: > > <http://opensource.zopyx.com/helpcenter/misc/writing-smart-and-reasonable-po…> If there had been anything else to send I would have. I thought the question was quite clear: Is there an issue with sql_delimiter on windows? There is nothing in the error log. There is nothing in the Event log. There is nothing in the Z2 log. Windows event log just says that Python.exe exited abnormally. I was quite clear on which versions of Zope had been tested. I gave the code which caused the crash. I have searched Google and I have searched the mailing list. My last resort is always to ask on this list simply because of the sort of answer you have just given. Regards Garry

4 4

Fw: [Zope] problem with the shapelib module.. help
by Allen Huang 24 Dec '06

24 Dec '06

shapelib still didn't work for me.. help I've being trying different things for the pass day 1. I put the shapefile directly in the Extensions with the external method and it work fine import shapelib, dbflib def readshp(): shp = shapelib.ShapeFile('taiwan1.shp') return shp.info() and in zope <dtml-var expr="readshp()> 2. but when I save the shapefiles (taiwan1.shp, taiwan1.shx, taiwan1.dbf) into zope and call it using dtml it return the same error message. import shapelib, dbflib def readshp(filename): shp = shapelib.ShapeFile(filename) return shp.info() and in zope <dtml-var expr="readshp(taiwan1.shp)"> or <dtml-var expr="readshp('http://localhost/pytest/taiwan1.shp')"> The error message are 1. in "Run Zope in Console" Exception exceptions.AttributeError:"ShapeFile instance has no attribute 'thisown'" in ignored 2. in web browser Site Error An error was encountered while publishing this resource. Error Type: IOError Error Value: new_ShapeFile failed is there something wrong with how I constructed it? Do I need to do something before hand? 3. in error_log Traceback (innermost last): Module ZPublisher.Publish, line 115, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 41, in call_object Module OFS.DTMLMethod, line 143, in __call__ - <DTMLMethod at /testPython/test> - URL: http://localhost/testPython/test/manage_main - Physical Path: /testPython/test Module DocumentTemplate.DT_String, line 476, in __call__ Module DocumentTemplate.DT_Util, line 196, in eval - __traceback_info__: readshp Module <string>, line 1, in <expression> Module Products.ExternalMethod.ExternalMethod, line 231, in __call__ - __traceback_info__: (('http://localhost/testPython/taiwan1.shp',), {}, None) Module C:\web\ZopeInstance\Extensions\shapetools.py, line 4, in readshp Module shapelib, line 44, in __init__ IOError: new_ShapeFile failed ----- Forwarded Message ---- From: Dieter Maurer <dieter(a)handshake.de> To: Allen Huang <swapp0(a)yahoo.com> Cc: Zope <zope(a)zope.org> Sent: Saturday, December 23, 2006 3:52:53 AM Subject: Re: [Zope] problem with the shapelib module.. help Allen Huang wrote at 2006-12-21 23:23 -0800: >I want to do some mapping application with zope.. but I have run into this problem over and over.. > >in "Run Zope in Console" >Exception exceptions.AttributeError:"ShapeFile instance has no attribute 'thisown'" in ignored Hmm. I doubt that you have really seen this text. There should be something in between the "in" and the "ignored". It is *vital* that you are as precise as possible in your problem reports... Python emits messages of the kind above in some (rare) situations, e.g. when exceptions occur in destructors. The exception above seems to have been raised in such a situation. The missing thing betwenn "in" and "ignored" should tell us which situation this was. It tells you that something tries to access the attribute "thisown" on a "ShapeFile" instance but this does not have the attribute. > >in web browser >Site Error >An error was encountered while publishing this resource. >Error Type: IOError >Error Value: new_ShapeFile failed Another tip for the future. When you report problems, you need to include full error information. Beside the "Error Type" and "Error Value" above, this also includes the traceback. You find all this information in the "error_log" object in Zope's "Root Folder" (Management Interface). -- Dieter __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

3 2

processing data problem
by Allen Huang 24 Dec '06

24 Dec '06

I'm new at data processing using zope and I could need some advice I want to make a online system that can processing a set data of three files and record them info zodb. I have running into some problem where I could process the set data if it was on my computer in the same extension directory as my python program but couldn't when I store the set data into some directory on zodb. I heard from some mail-list users telling me that it is not the same even though in concept it is similar but I still don't understand why it doesn't work even though I direct my program into the same directory. Anyways, since I have encounter some initial problem, I was wondering if I should do this 1. have the user upload the set data or transfer the set data to my computer 2. process and record the data into zodb 3. delete the set data(since I really don't need a copy of it, but I don't see how I could do that) or is there any way that I could just process the data right on the user's computer without transfer it to my computer, like bring the programming to them instead of bring the set data to us since set data's could be quite large (over 1GB). I appreciate any input... as soon as possible. Thanks __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

2 2

Re: Fw: [Zope] problem with the shapelib module.. help
by Allen Huang 24 Dec '06

24 Dec '06

Thanks a lot for replying... I still a newbie at this ... in order for shapelib to read shapefile, you need a set of three files(.shp, .shx, .dbf). so, if I have to download this to a temp location into my computer filesystem, could you show me how this is done? ----- Original Message ---- From: Andreas Jung <lists(a)zopyx.com> To: Allen Huang <swapp0(a)yahoo.com>; Zope <zope(a)zope.org> Sent: Sunday, December 24, 2006 2:47:52 PM Subject: Re: Fw: [Zope] problem with the shapelib module.. help -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 - --On 23. Dezember 2006 22:27:29 -0800 Allen Huang <swapp0(a)yahoo.com> wrote: > > 2. but when I save the shapefiles (taiwan1.shp, taiwan1.shx, taiwan1.dbf) > into zope and call it using dtml it return the same error message. > import shapelib, dbflib > def readshp(filename): > shp = shapelib.ShapeFile(filename) > return shp.info() > > and in zope > <dtml-var expr="readshp(taiwan1.shp)"> > or > <dtml-var expr="readshp('http://localhost/pytest/taiwan1.shp')";> No idea what shapelib is doing but reading a file from the locale filesystem as it seems to work from an external method is *different* from a accessing content that is stored within the ZODB. I really wonder why you think it would work the same way? The hierarchical object storage of Zope looks similar to a filesystem but it is not a filesystem and the Python APIs for accessing filesystems don't apply. We have no idea what the ShapeFile constructors expects as data. If it expects a filename of a file within the filesystem then you must obtain the content of your data stored within the ZODB, create a temporary file and call the constructor as you did within your external method. Possibly the constructor accepts the data directly as *string*..in this case this would make things a bit easier. But it is up to *you* to check the Shapelib API and take appropriate action. - -aj -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (Darwin) iD8DBQFFjiKYCJIWIbr9KYwRAk0oAKCSyEo5ykswElgi9jFGWf89NthzmwCfRvEM nSMyeIu/cK7NpecUlof2BR8= =B0Mw -----END PGP SIGNATURE----- __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

1 0