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 )