[Zope] zodb queries, importing and exporting

[J Cameron Cooper]

Jonathan wrote:
> Not a zope question, but... why don't you create a mutually agreed upon 
> XML DTD (document type definition) that represents the content of a 
> database record.  Then each party can implement the XML data 
> extraction/upload to their own db technology as they please.
> 
> Each db operator will send/receive data in the agreed upon XML format 
> (that's what its for!).

If you use ATXML (see the Marshall product) you can even 
marshall/demarshall the files directly to/from your objects via 
FTP/WebDAV. No intermediate representation.

		--jcc

> ----- Original Message ----- From: "Cliff Williams" 
> <gcw-python at rezidew.net>
> To: <zope at zope.org>
> Sent: Wednesday, January 25, 2006 11:23 AM
> Subject: [Zope] zodb queries, importing and exporting
> 
> 
>>
>>
>> LEAD UP:
>> I've got a site that I need to develop and it's a natural and obvious 
>> decision that I use zope and plone as they are what I'm familiar with 
>> and what I prefer to other CMS/Portal-wares out there. The site will 
>> have several counter parts around the globe being administered by 
>> various individuals, not all of whom are enlightened enough to realize 
>> the folly of using anything other than zope.
>>
>> MEAT OF THE ISSUE:
>> The sites will be tracking dance clubs. We'll be building Types in 
>> plone (Using Archetypes) to track information about clubs locally. 
>> Each site will potentially have different database technology from the 
>> other sites. I know of 3 admins who are planning on using PHP-* + 
>> MySQL and a few others who want to use Postgress and some other front 
>> end.
>>
>> We want to be able to integrate the information from any one site into 
>> any other site with respect to the "club objects" in the disparate 
>> databases. I'd like to leverage the simplicity of zope's 
>> application/database model and not use SQL storage if possible but 
>> don't know how I can be able to "share" with my counterparts who are 
>> bent on using relational databases.
>>
>> We do not intend to leave open connections to each other's database 
>> servers. The consensus is to do scheduled dumps and push the files to 
>> the other admins who would have their own routines for integrating the 
>> data into their site. I really don't want to have to set up an SQL 
>> server.
>>
>> Any help/suggestions would be greatly appreciated.
>>
>> --Cliff
>>
>> _______________________________________________
>> Zope maillist  -  Zope at zope.org
>> http://mail.zope.org/mailman/listinfo/zope
>> **   No cross posts or HTML encoding!  **
>> (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce
>> http://mail.zope.org/mailman/listinfo/zope-dev )
>>
> 
> _______________________________________________
> Zope maillist  -  Zope at zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce
> http://mail.zope.org/mailman/listinfo/zope-dev )
> 
> 


-- 
"Building Websites with Plone"
http://plonebook.packtpub.com/

Enfold Systems, LLC
http://www.enfoldsystems.com