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
On Sat, 2 Feb 2002, Mike Bunyan wrote:
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.
Hmm well if you have the data stored in zope it seems like a better solution would be to use a db adapter and connect zope to the other database. Then use python script to copy the data you need from zope into the sql database. Not sure what you mean by sqlserver though since I don't of any sql db called that. Oracle? Postgresql? Mysql? DB2? Sap? etc
kosh@aesaeion.com wrote:
On Sat, 2 Feb 2002, Mike Bunyan wrote:
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.
Hmm well if you have the data stored in zope it seems like a better solution would be to use a db adapter and connect zope to the other database. Then use python script to copy the data you need from zope into the sql database. Not sure what you mean by sqlserver though since I don't of any sql db called that. Oracle? Postgresql? Mysql? DB2? Sap? etc
SQLServer is what Sybase became after Microsoft bought it, if I've got my geneaology straight. Cheers, -- Joe "I should like to close this book by sticking out any part of my neck which is not yet exposed, and making a few predictions about how the problem of quantum gravity will in the end be solved." --- Physicist Lee Smolin, "Three Roads to Quantum Gravity"
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 )
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 )
participants (5)
-
Gilles Lenfant -
Joseph A Knapka -
kosh＠aesaeion.com -
Mike Bunyan -
seb bacon