Re. migrating from xbase databases to postgresql -- while not a Zope/Python solution, I know PHP has functionality to read xbase files, and I'm sure Perl has a similar module. They can both interface with PostgreSQL too, of course, so you could write your conversion utility in that. -- ._-+$=%##########%=$+-_. |# Matthew R. Scott #| |# gldnspud@lab.net #| `~-+$=%##########%=$+-~'
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Raymund Ramos Sent: Thursday, February 24, 2000 1:24 PM To: zope@zope.org Subject: [Zope] a whole lot of db related Q's
I installed python 1.5.2 with RPMs and installed a Zope 2.1.2 source package.
However, I get this with databases I've done using External Methods and shelve [which seems to make bsd dbm files]:
Zope Error Zope has encountered an error while publishing this resource.
Error Type: error Error Value: db type could not be determined ----- How do I fix this without recompiling whole packages?
So since that stuff doesn't work, I've moved to trying to use ZSQL methods.
Given a ZSQL method viewbytitle, args: title (subject is a property) with a query: select * from metadb where title = <dtml-sqlvar title type=string> and subj like '%<dtml-var subject>%'
Can I do something like <dtml-let x=viewbytitle(title='WorldCat')> <dtml-var "x.url"> </dtml-let> ?
Is this possible using DTML/ZSQLMethods or do I need to do an External Method?
Last Q, does anyone know of good tools that will move PC databases (FM Pro, dBase) into PostgreSQL easily? I've been saving the databases in tab-delim format and then using python scripts to import them into pgsql, with all of the quoting problems.
thanks.
-ray
_______________________________________________ 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 )