[Zope] extract values from zope

[seb bacon]

I've also done a rather convoluted process whereby I wrote a script
which outputs a tab-separated file of records.  I then imported this
into the relevant table.  Something like:

  for item in context.mycatalog(Foo='Bar'):
    print "%s\t%s\%" % (item.id, item.title, item.colour)
  return printed

then 'test' the script, and 'save frame as...' -> /tmp/FooTable.txt

then (for mysql):

  $ mysqlimport --local dat_template FooTable.txt

hth, seb

On Mon, 2002-02-04 at 13:58, Gilles Lenfant wrote:
> I've done such a stuff...
> 
> IMNSHO the "best" solution is to make a small python app (standalone, not
> Zope) that grabs the Zope data through xmlrpc (with the help of a
> server-side script) and records those data to your RDBMS.
> Get mxODBC to connect to an M$ SQL*Server database.
> 
> HTH
> 
> 
> ----- Original Message -----
> From: "Mike Bunyan" <mrbun@bigfoot.com>
> To: <zope@zope.org>
> Sent: Saturday, February 02, 2002 1:05 PM
> Subject: [Zope] extract values from zope
> 
> 
> After many months of accumulating information from users filling in
> forms my intranet zope server has accumulated a large amount of useful
> information I would like to extract into sqlserver for analysis and
> use elsewhere.
> 
> Some pointers as to how to extract the values into a useful format for
> import into a database would be appreciated.
> 
> Mike B
> 
> _______________________________________________
> Zope maillist  -  Zope@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 )
> 
> 
> 
> 
> 
> _______________________________________________
> Zope maillist  -  Zope@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 )