[Zope] from excel to zclasses...

[ender]

On Thursday 12 July 2001 11:52, bonnyk wrote:
>>hi all,
>>
>>i have a lot of excel data (poor man's database) and would love to somehow
>>transform them into zclasses (yes, it has to be zlasses) automagically.
>>
>>what would be the best approach to look at ?

write a python script to get the data out of the xcel spread sheet via com, 
have that do any filtering/processing  you might want, connect to zope via 
xml-rpc to an external method that handles the creation of the zclass. you 
want to connect to external method so you don't have to deal with the return 
types.

i believe there is a howto on xml-rpc

http://www.zope.org/Members/teyc

ZSyncer comes with a copy of xmlrpc that supports basic authentication as 
well if you need to continue to use xcel and sync to zope periodically. else 
you can just delete the external method when your done.

you can get zsyncer at

http://www.zope.org/Members/andym

hth

kapil


>>thx
>>
>>T.
>>
>>
>>_______________________________________________
>>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 )