[Zope] a whole lot of db related Q's

[Jim Sanford]

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 )