On Wednesday 27 December 2000 17:30, 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.
> 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.
Have a better one,
Zope maillist - [EMAIL PROTECTED]
** No cross posts or HTML encoding! **
(Related lists -