Re: [Zope] is it possible to import from Excel
For whatever it is worth, I do imports from an excel spreadsheet to a PostgreSQL table using Applixware. I do it by hand (cut from spreadsheet, paste into data query), but it could probably be automated. So if you then had Zope and one of the two PostgreSQL DA's you could get the data. Drop me a line if you want the gory details. -- cary ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] is it possible to import from Excel
> 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 values to prevent from ending up in > gadfly as 'None' etc. > If your not want to be tied to ODBC and Excel on the deployment platform, you can always try saving the content of the Excel sheet in a text format, if that is possible for your kind of data? The text file could then be parsed by at external method or even imported to the TinyTable product. On lage amounts of data this could be quite time consuming. So it would probably be more efficient to write a seperate import program. There might even be one for Gadfly. In that way you don't have to use a "unreliable" HTTP connection when importing data. That's my 25 öre (which is approximatly 5 cents) Regards, Johan Carlsson "How about Office 2000? Can it export data as XML? And in that case, can it describe more things than just values in a text export?" ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] is it possible to import from Excel
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 values to prevent from ending up in gadfly as 'None' etc. Ayhan ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] is it possible to import from Excel
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 ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] is it possible to import from Excel
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. ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] is it possible to import from Excel
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. ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] is it possible to import from Excel
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. ___ Zope maillist - [EMAIL PROTECTED] 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 )