Re: [Zope] is it possible to import from Excel

2000-12-28 Thread Johan Carlsson
When on a windows platform, I prefer to define an ODBC datasource on the excel spreadsheet, write ZSQL method that selects the fields to be imported, write a DTML method that iterates on returned records and call another ZSQL method that writes into Gadfly. You may need to handle

Re: [Zope] is it possible to import from Excel

2000-12-27 Thread Michael Bernstein
K H Subrahmanyan wrote: Hello, Now we have developed some database using gadfly in zope. Actually there are some datum which are there in Excel. I would like to know is it possible to import all that datum from Excel to zope database, instead of giving all the data to zope manually.

Re: [Zope] is it possible to import from Excel

2000-12-27 Thread Bill Welch
Gadfly is a distinct product, www.chordate.com/gadfly.html, so you can, at least, write python to insert data directly into gadfly. You can get the data out of Excel through COM or export to csv. Bill. On Wed, 27 Dec 2000, K H Subrahmanyan wrote: Now we have developed some database using

Re: [Zope] is it possible to import from Excel

2000-12-27 Thread Curtis Maloney
On Wednesday 27 December 2000 17:30, K H Subrahmanyan wrote: Hello, Now we have developed some database using gadfly in zope. Actually there are some datum which are there in Excel. I would like to know is it possible to import all that datum from Excel to zope database, instead of giving

Re: [Zope] is it possible to import from Excel

2000-12-27 Thread Ayhan Ergul
When on a windows platform, I prefer to define an ODBC datasource on the excel spreadsheet, write ZSQL method that selects the fields to be imported, write a DTML method that iterates on returned records and call another ZSQL method that writes into Gadfly. You may need to handle None/Missing

[Zope] is it possible to import from Excel

2000-12-26 Thread K H Subrahmanyan
Hello, Now we have developed some database using gadfly in zope. Actually there are some datum which are there in Excel. I would like to know is it possible to import all that datum from Excel to zope database, instead of giving all the data to zope manually. Actually all those data are the