You could use a ZSQL method using the ODBC DA to query the xbase tables and then use a ZSQL query using the PostGreSQL DA to reformat and insert into PostGreSQL. Of course, you would need to be on a Windows machine to do this. __________________________________________________________________ Jim Sanford . Database/Web Engineer / \ / Accelerated Technology, Inc. / / 720 Oak Circle Drive East / / \ Mobile, AL 36609 / / \ Voice: 334-661-5770 fax: 334-661-5788 / \ E-Mail: jsanford@atinucleus.com Web: http://www.atinucleus.com Source Code, No Royalties, Any CPU...It just make sense ! __________________________________________________________________ ----- Original Message ----- From: Matthew Scott <gldnspud@lab.net> To: <rayr@cats.ucsc.edu>; <zope@zope.org> Sent: Thursday, February 24, 2000 2:02 PM Subject: RE: [Zope] a whole lot of db related Q's 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 )

_______________________________________________ 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 )