RE: [Zope] version 2.2.4 just blew up!

2000-12-07 Thread michael angelo ruberto


Chris,



The Dr. Watson log won't help us at this stage.  Can you turn on debug
logging by inserting the following to the beginning of your Zope's start.bat
file:

set STUPID_FILE_LOG=var\debug.log

did it.

Then report back what comes up in the var\debug.log file when you click on
the link that crashes Zope, if anything.

nothing. debug.log is never created.

Python is dying?  That's a little rude even given your frustration, dontcha
think?

what the hell is so rude about that? my problem is caused by Python going
tits up each time i hit the link. a bit oversensitive dontcha
think?

- Original Message -
From: "michael angelo ruberto" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 05, 2000 5:16 PM
Subject: [Zope] version 2.2.4 just blew up!


 hi,

 i just performed the upgrade from 2.2.2 to 2.2.4 and it blew up after
 running for a few minutes. it happened as i clicked the link to Debug
 Information from the control panel. Zope does start up again and the same
 thing occurs each time i click this link. i can send you the Dr. Watson
 error log if you think it will help you but i prefer not to send it to a
 public list. please send me a personal email address for this. i can also
 send a screen shot of the error message.

 Python is dying.

 -mike-


 ___
 Zope maillist  -  [EMAIL PROTECTED]
 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 )




___
Zope maillist  -  [EMAIL PROTECTED]
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 )




RE: [Zope] just curious

2000-12-07 Thread michael angelo ruberto

what i meant was, is there a way to remove my files in Zope back to the
filesystem? i'm having serious concerns about the stability of this product
and need to know if i can gracefully revert back.



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chris
McDonough
Sent: Wednesday, December 06, 2000 12:05 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [Zope] just curious


What?

- Original Message -
From: "michael angelo ruberto" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 05, 2000 7:33 PM
Subject: [Zope] just curious


 hi,

 how do i remove all of the 7000 + company documents from Zope?

 -mike-

 ___
 Zope maillist  -  [EMAIL PROTECTED]
 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 )




___
Zope maillist  -  [EMAIL PROTECTED]
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 )


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




RE: [Zope] the day of zope headaches

2000-12-07 Thread michael angelo ruberto

thanks Kevin,

that seems to have did the trick. the deal on my server is that tmp,
/var/tmp, and /usr/tmp are all linked to one directory. this required me to
create /home/httpd/tmp and point tempfile.py to it because the disk for all
the other tmp stuff is quite full. time for bigger drives.

-mike-

ps: in the process of following your suggestion i found another problem and
fixed it, so thanks again!

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 05, 2000 11:00 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [Zope] the day of zope headaches



 Zope has encountered an error while publishing this resource.

 IOError

 Sorry, a Zope error occurred.

 such a very helpful message. this happened while reindexing the ZCatalog

View the HTML source for the error page - the Python traceback contained
in there will be more helpful. However, the last time I had an IOError
while re-indexing a ZCatalog was when Python was ran out of space in the
/tmp dir (4600 objects, 100 MB /tmp partition). What I did was edit
Python's tempfile.py file (contained at /usr/lib/python1.5/tempfile.py
on Debian systems) from:

attempdirs = ['/usr/tmp', '/tmp', pwd]

To:

attempdirs = ['/var/tmp', '/usr/tmp', '/tmp', pwd]

--
  Kevin Teague, Zopista
  http://www.stormix.com


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] mod_fastcgi

2000-12-05 Thread michael angelo ruberto

hi,

i was wondering what if any difference there is for zope if i install it to
access mod_fastcgi through a port as opposed to a socket. which is the
recommended/safest approach?

thanks

-mike-


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] version 2.2.4 just blew up!

2000-12-05 Thread michael angelo ruberto

hi,

i just performed the upgrade from 2.2.2 to 2.2.4 and it blew up after
running for a few minutes. it happened as i clicked the link to Debug
Information from the control panel. Zope does start up again and the same
thing occurs each time i click this link. i can send you the Dr. Watson
error log if you think it will help you but i prefer not to send it to a
public list. please send me a personal email address for this. i can also
send a screen shot of the error message.

Python is dying.

-mike-


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




RE: [Zope] mod_fastcgi

2000-12-05 Thread michael angelo ruberto

Ron,


 i was wondering what if any difference there is for zope if i
 install it to
 access mod_fastcgi through a port as opposed to a socket. which is the
 recommended/safest approach?

In theory (and maybe in practice) the socket should be faster since it does
not go through the networking process.  However, since it uses a local file,
Zope and Apache must be one the same system.  Using a TCP port would be
slower, but it allows you to run Zope and Apache on different machines.  As
to how much faster or slower, I have no idea if anyone has done any testing.

As for safest/recommended, avoiding the network is probably always safer
(although with the loopback, I'm not sure it makes any difference).  But if
you need to run them on different servers, you don't have a choice.

I've found mod_fastcgi very easy to configure in Apache and have had no
problems using it through a port.
___

thanks for the info! my co-worker just informed me that he thinks it is
faster to use the port when dealing with a firewall. since it seems easier
this way i guess i'll go with the port.

much appreciated!

-mike-


___
Zope maillist  -  [EMAIL PROTECTED]
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 )


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] the day of zope headaches

2000-12-05 Thread michael angelo ruberto

ok,

i'm not that superstitious but today must be Zopes equivalent of friday the
13th. i've nothing but headaches with it all day today. maybe the warranty
expired ;)

here we go the new problem is this:

Zope has encountered an error while publishing this resource.

IOError

Sorry, a Zope error occurred.


such a very helpful message. this happened while reindexing the ZCatalog
used for the main site search. i do this every week without problems. it
takes a bit longer each week but never got this error before. have i maxed
it out or something? has anyone else come across this?

as always, help greatly appreciated!

thanks

-mike-

ps: the catalog is now empty.


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] just curious

2000-12-05 Thread michael angelo ruberto

hi,

how do i remove all of the 7000 + company documents from Zope?

-mike-

___
Zope maillist  -  [EMAIL PROTECTED]
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 )




RE: [Zope] version 2.2.4 just blew up

2000-12-05 Thread michael angelo ruberto

i was thinking of doing just that.

thanks Jimbo!

-mike-

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of jimbo
Sent: Tuesday, December 05, 2000 7:57 PM
To: [EMAIL PROTECTED]
Subject: [Zope] version 2.2.4 just blew up


Same thing happened to me on upgrading from 2.2.2.  I just reinstalled the
full version over the hosed upgrade and it worked again.
-Jimbo

___
Zope maillist  -  [EMAIL PROTECTED]
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 )


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] opinions please

2000-11-13 Thread michael angelo ruberto

hello,

i am searching for opinions on a project i am considering. the project is to
create a product or script to allow users to email documents into Zope as
attachments. then the documents are to be placed in the proper folder
according to information in the subject line of the email they rode in on.
what i would like to know is, is this possible? if it is, how hard will this
be to implement?

the other idea was to create a client app where users can drop the document
onto a desktop icon and the app uses webDAV to put it into Zope. would this
be easier or harder?



___
Zope maillist  -  [EMAIL PROTECTED]
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 )




RE: [Zope] FW: [Zope] adding properties to all existing docs

2000-11-09 Thread michael angelo ruberto


However, I would not make such changes asynchronously.
I would use "ZopeFind" to locate all objects that need to
be updated and then do it.
Maybe, its a matter of personal taste ...


Dieter

this is an interesting idea. another thing i might try is running the script
from Xron and ZopeFinding the objects. in this way the task is completely
automated and will free me from having to run it whenever new objects are
added.

-mike-


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] FW: [Zope] adding properties to all existing docs

2000-11-08 Thread michael angelo ruberto



hi Dieter,

thanks for the advice. i have written a small DTML script which i plan to
call from the standard html header so that the intranet users will
unknowingly populate the docs as they browse. saves me from doing it
manually unless there are file objects in the folder. here is the script:

dtml-in "PARENTS[0].objectItems(['File','DTML Document'])" sort=title
dtml-unless "_.string.find(_['id'],'index_html')==0"

dtml-comment
properties are added in the unless below.
to add additional properties to this script repeat the unless block
for each new property and change the id and type to what you
want to add.
/dtml-comment

dtml-unless "hasProperty('rev')"
dtml-call "manage_addProperty('rev','none','string')"
/dtml-unless


/dtml-unless
/dtml-in

to run the script give it manager role and call the method in the URL or
with a dtml-var tag. you can select the types of objects it "sees" in the
first line. please let me know if there is some flaw in doing it this way.

take care

-mike-

ps: i tried to make a python method for this but couldn't figure out how to
handle the objects properly.

-Original Message-
From: Dieter Maurer [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 05, 2000 12:49 PM
To: michael angelo ruberto
Cc: [EMAIL PROTECTED]
Subject: Re: [Zope] adding properties to all existing docs


michael angelo ruberto writes:
  i have a Zope containing 4700+ files and documents. i want to add new
  properties to all of them, how can i do this programmatically? is it
  possible to change the base classes? if so, how?
It is possible to change the base class but I would not do it
(as it affects all Zope objects and your change is likely
to disappear when you upgrade).

You can automate Zope either internally or externally.

  Internally (via a method (DTML or Python)) you would
  use ZopeFind to list all objects that need to be
  updated and then iterate (dtml-in) over the objects
  to update.

  Externally, you would use "ZPublisher.ZClient".


I would go for the internal solution.


Dieter


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] error in Zope book

2000-11-03 Thread michael angelo ruberto

in chapter 5 the example Creating a File Library has an error in the sorting
method.



  dtml-var standard_html_header

  h1File Library/h1

  table
tr
  tha href="dtml-URL0;?sort=name"File/a/th
  tha href="dtml-URL0;?sort=date"Last Modified/a/th
 /tr

  dtml-if expr="_.has_key('sort') and sort=='date'"

---ERROR
---

dtml-in expr="objectValues('File')"

~this should be dtml-in expr="PARENTS[0].objectValues(['File'])"
~it doesn't work otherwise.

---ERROR
---
 sort="bobobase_modification_time" reverse
  tr
 tda href="dtml-absolute_url;"dtml-var
title_or_id/a/td
 tddtml-var bobobase_modification_time fmt="aCommon"td
  /tr
/dtml-in
  dtml-else

---ERROR
---

dtml-in expr="objectValues('File')" sort="id"
~same as above.

---ERROR
---

  tr
 tda href="dtml-absolute_url;"dtml-var
title_or_id/a/td
 tddtml-var bobobase_modification_time fmt="aCommon"td
  /tr
/dtml-in
  /dtml-if

  /table

  dtml-var standard_html_footer

-mike-


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




RE: [Zope] date comparison

2000-10-13 Thread michael angelo ruberto

hi,

i had tried something similar already without success. here is the error
your script caused:

DOH!


Zope Error
Zope has encountered an error while publishing this resource.

Error Type: TypeError
Error Value: unsubscriptable object

for some reason Zope just doesn't want to compare ZopeTime with
bobobase_modification_time. i started reading the readme i found for the
python DateTime method but it hasn't shed any light on the situation yet. i
will try doing it with javascript. i can write the modification dates of the
objects into arrays and do the comparisons using a scripting language that
works.

thanks

-mike-

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kapil
Thangavelu
Sent: Wednesday, October 11, 2000 2:53 PM
To: michael angelo ruberto
Cc: [EMAIL PROTECTED]
Subject: Re: [Zope] date comparison


michael angelo ruberto wrote:

 i want to create an index page that displays whether or not a page has
been
 updated in the past 7 days or the past 20 days. however, i can't figure
out
 how to get the bobobase_modification_date to compare with ZopeTime. can
 someone give me a clue before i rush blindly down Zope's undocumented dark
 alleys.

 mike

untested

ul
dtml-in "objectValues['DTMLDocument']"
dtml-if "ZopeTime()-7  bobo_base_modifcation_time"
libNew/bdtml-var absolute_url/li
dtml-elif "ZopeTime()-20  bobo_base_modifcation_time"
libSomewhat New/bdtml-var absolute_url/li
dtml-else
libOld/bdtml-var absolute_url/li
/dtml-if
/dtml-in
/ul

kapil

___
Zope maillist  -  [EMAIL PROTECTED]
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 )


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] date comparison

2000-10-11 Thread michael angelo ruberto

i want to create an index page that displays whether or not a page has been
updated in the past 7 days or the past 20 days. however, i can't figure out
how to get the bobobase_modification_date to compare with ZopeTime. can
someone give me a clue before i rush blindly down Zope's undocumented dark
alleys.

mike


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




RE: [Zope] sort_order???

2000-06-08 Thread michael angelo ruberto

hey that worked perfectly! thanks! most of my problems always seem to have
solutions right under my nose.  ;)

-mike-

-Original Message-
From: Charlie Derr [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 07, 2000 11:25 PM
To: [EMAIL PROTECTED]
Subject: FW: [Zope] sort_order???


You saw this one, right?

~c

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Phil
Harris
Sent: Tuesday, June 06, 2000 6:35 PM
To: michael angelo ruberto; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [Zope] sort_order???


Try:

dtml-in table-1 sort=date reverse

hth

phil
[EMAIL PROTECTED]


- Original Message -
From: "michael angelo ruberto" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: 06 June 2000 23:18
Subject: [Zope] sort_order???


 hello,

 ok, here is my code:

 dtml-in table-1 sort=date

 a href="dtml-var URL"dtml-var name/a | dtml-var value |
dtml-var
 URL | dtml-var attendee | dtml-var datebr
 /dtml-in

 what's wrong - nothing, it works fine. however, the result is sorted by
date
 ascending and i need it to be reversed. i found a reference to an
attribute
 "sort_order" which can be given an arg such as "sort_order=reverse". the
 problem here is that it won't work and i can't find any usage info on
 "sort_order". it isn't mentioned in the DTML Reference and after hours of
 searching the Zope website i am empty handed. does anyone know how to use
 this? thanks in advance.

 -mike-


 ___
 Zope maillist  -  [EMAIL PROTECTED]
 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 )


___
Zope maillist  -  [EMAIL PROTECTED]
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 )


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] sort_order???

2000-06-06 Thread michael angelo ruberto

hello,

ok, here is my code:

dtml-in table-1 sort=date

a href="dtml-var URL"dtml-var name/a | dtml-var value | dtml-var
URL | dtml-var attendee | dtml-var datebr
/dtml-in

what's wrong - nothing, it works fine. however, the result is sorted by date
ascending and i need it to be reversed. i found a reference to an attribute
"sort_order" which can be given an arg such as "sort_order=reverse". the
problem here is that it won't work and i can't find any usage info on
"sort_order". it isn't mentioned in the DTML Reference and after hours of
searching the Zope website i am empty handed. does anyone know how to use
this? thanks in advance.

-mike-


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] secure area?

2000-06-02 Thread michael angelo ruberto

hi,

i need some help with permissions again. is there a way to make a subfolder
secure from people with manager roles in the parent folder? i've tried
different settings but nothing locks them out. thanks.

-mike-


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




RE: [Zope] product installation voodoo

2000-05-30 Thread michael angelo ruberto


From: Kevin Dangoor [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 30, 2000 4:48 PM
To: michael angelo ruberto; [EMAIL PROTECTED]
Subject: Re: [Zope] product installation voodoo


- Original Message -
From: "michael angelo ruberto" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 30, 2000 4:11 PM
Subject: [Zope] product installation voodoo


 why do some products install fine on their own and others require voodoo
 incantations and sacrificial goats?

Usually, products written completely in Python can be installed just by
untarring the file. Products built through the web (ZClasses) usually comes
as a .zexp file, which is essentially the pickled objects that make up the
ZClasses, DTML Methods, etc. These need to be imported from the Products
Control Panel. Is that the voodoo you're talking about?

The difference is basically whether the product is just distributed as files
that go in your file system, or as objects that need to live somewhere in
your ZODB.

 can somebody tell me what the
 permissions for products should look like?

I'm not sure that it really matters as long as your webserver process can
read the files.

Kevin

i've had situations where trying to import a .zexp does not work until the
file's permissions are set to nobody:nobody ?


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




RE: [Zope] Newbie: MS Access ODBC connection strings

2000-05-18 Thread michael angelo ruberto

i had a similar problem recently. my access DB was not showing up in the
data sources list until i deleted the ODBC connection from windows control
panel and recreated it - i guess i messed up the first time. make sure your
DB shows up in the "User Data Sources" list in the ODBC Data Source
Administrator in Windows and in the ODBC Data Source list in the "Add Z ODBC
Database Connection" screen in ZOpe. my connection string is simply the
database name. now that i have a working connection all of my tests fail.
does anyone know why?

-mike-

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 18, 2000 5:19 AM
To: [EMAIL PROTECTED]
Subject: [Zope] Newbie: MS Access ODBC connection strings


Before you all start, I know, MS Access is pants and I should be using
a "real" database.  And I shall, once the "proof of concept" stage is
passed and I can migrate the existing data over to one.  But for now
I'm stuck with it.

Right, that over, here's my plea: I'm trying to create a connection
object to a MS Access 97 database.  I've installed the ODBC DA product
but I cannot get my connection to actually connect.  The error I get is,
"invalid connection string: project,"  (project is the DSN name).

According to the docs that come with the ODBC-DA, there's usually no
need for a connection string and accordingly I have left it blank; I
presume that the DA is defaulting to connecting using the DSN name as
its string.  The database has no security settings that might limit
access.

What's going wrong?  Help!
--
Andy Gates, Learning and Research Technology
[EMAIL PROTECTED] - ICQ#74362415


___
Zope maillist  -  [EMAIL PROTECTED]
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 )


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




RE: [Zope] listmate + CSV problem

2000-05-18 Thread michael angelo ruberto

hi, Heiko

it works! i had to replace all whitespaces in column names with
under_scores. it's the whitespace that created a problem. now i have to
enter "NULL" in all the empty cells to make the table line up properly
-( but this is not your fault, it's mine. i think many people in my company
are going to be happy now! thank you for all the help you have provided.

-mike-

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Heiko Stoermer
Sent: Thursday, May 18, 2000 3:46 AM
To: michael angelo ruberto
Subject: Re: [Zope] listmate + CSV problem


michael angelo ruberto wrote:


 Error Type: Bad Request
 Error Value: Invalid or duplicate property id


yes, I see. the first line of the csv will be split up into words and
for each word a table column is created.
these column names are actually properties of some internal object, so
they MUST be unique. So if you have the same word appear twice in the
first line of the file, you will get this error.

the file size or column number should not be a problem. duplicate column
names are.

hope this helps,
Heiko

--
[EMAIL PROTECTED]
innominate AG
 networkingpeople
fon: +49.30.308806-0 fax: -77   web: http://innominate.de


___
Zope maillist  -  [EMAIL PROTECTED]
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 )