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 Emp. records. Currently they are maintaining it in Excel. Now they want to make it web based stuff. We have developed a tool for that. Since all that data are there in Excel I wanted some stuff to import that. Hoping your reply. bye yours subrahmanyan.
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.
Actually all those data are the Emp. records. Currently they are maintaining it in Excel. Now they want to make it web based stuff. We have developed a tool for that. Since all that data are there in Excel I wanted some stuff to import that. Hoping your reply.
I seem to recall that once-upon-a-time DC had a tool/product called Tabula for this purpose. Maybe they'll haul it out of storage for a consulting engagement. HTH, Michael Bernstein.
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 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.
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 all the data to zope manually.
Actually all those data are the Emp. records. Currently they are maintaining it in Excel. Now they want to make it web based stuff. We have developed a tool for that. Since all that data are there in Excel I wanted some stuff to import that. Hoping your reply.
Well... firstly, moving from a spreadsheet to a db is probably a very good move, in the case of employment records. As for how to go about it... I would recommend you export the Excell data in a comma or tab delimited text file, then write a Python Method (or Script, whichever you have) to munge each line and store it in the db.
bye yours subrahmanyan.
Have a better one, Curtis Maloney
participants (4)
-
Bill Welch -
Curtis Maloney -
K H Subrahmanyan -
Michael Bernstein