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
> 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
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 val
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 g
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 gadf
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
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