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 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

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 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

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 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

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 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 )




[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 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 )