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 )