[This is a re-send of a message I sent originally to the infrastructure list.] Hello all! Allow me to introduce myself: I'm the community manager of OpenOffice.org, a role I've held for the last 7.5 years. My interest here is to see if there is interest in developing an OpenDocument Format filter for Drupal or (better yet) some ways of integrating or at least linking OOo to Drupal. The reason? Lots, including both public and private enterprises, want a CMS + productivity suite (such as OOo) combo. Drupal has huge market share and is flourishing; so does and is OOo. How is integration imagined? It could be close or it could be even something as simple as an extension. We have now many extensions, and there is no reason why everything has to be a single package--this is the Internet age, not the isolated desktop age. If people are interested, let's talk. My guess is that an obstacle to good intentions is reality: shortage of resources. But I also am relentlessly optimistic and hopeful, and believe if we can present a good case then companies may want to allocate those resources, which is to say, people and money. Ciao, Louis -- Louis Suarez-Potts, PhD Community Manager, Sun Microsystems, Inc. OpenOffice.org
Being able to publish directly to Drupal from OOo would be great for usability. Drupal implements an XLMRPC interface that as I understand it allows blog publishing software to edit and save posts. On May 14, 2008, at 9:35 PM, Louis Suarez-Potts wrote:
Hello all!
Allow me to introduce myself: I'm the community manager of OpenOffice.org, a role I've held for the last 7.5 years. My interest here is to see if there is interest in developing an OpenDocument Format filter for Drupal or (better yet) some ways of integrating or at least linking OOo to Drupal. The reason? Lots, including both public and private enterprises, want a CMS + productivity suite (such as OOo) combo. Drupal has huge market share and is flourishing; so does and is OOo.
How is integration imagined? It could be close or it could be even something as simple as an extension. We have now many extensions, and there is no reason why everything has to be a single package-- this is the Internet age, not the isolated desktop age.
If people are interested, let's talk. My guess is that an obstacle to good intentions is reality: shortage of resources. But I also am relentlessly optimistic and hopeful, and believe if we can present a good case then companies may want to allocate those resources, which is to say, people and money.
Ciao,
Louis
-- Louis Suarez-Potts, PhD Community Manager, Sun Microsystems, Inc. OpenOffice.org
I'm afraid I'd be useless for actual development, but I would like to say that I too am very interested in seeing this sort of thing happen. Some things I've seen / heard of that would be cool: Be able to upload an ODF document and have it transformed to XHTML and made into a Drupal node. Be able to write posts in Drupal and have them automatically made available for download as ODF formats, similar to modules that do this for PDF. I can confirm for Darren that Drupal accepts posts from desktop software through XML-RPC. I've used Drivel for that before, and tools like that likely have some code that would be useful, although I'm not sure about license compatibility (leave that for someone else too). -- Tony Yarusso http://tonyyarusso.com/
I'm interested in helping with this; I doubt I can do it all myself. Nancy Wichmann, PMP -----Original Message----- From: development-bounces@drupal.org [mailto:development-bounces@drupal.org]On Behalf Of Louis Suarez-Potts Sent: Wednesday, May 14, 2008 9:35 PM To: development@drupal.org Subject: [development] OpenOffice.org [This is a re-send of a message I sent originally to the infrastructure list.] Hello all! Allow me to introduce myself: I'm the community manager of OpenOffice.org, a role I've held for the last 7.5 years. My interest here is to see if there is interest in developing an OpenDocument Format filter for Drupal or (better yet) some ways of integrating or at least linking OOo to Drupal. The reason? Lots, including both public and private enterprises, want a CMS + productivity suite (such as OOo) combo. Drupal has huge market share and is flourishing; so does and is OOo. How is integration imagined? It could be close or it could be even something as simple as an extension. We have now many extensions, and there is no reason why everything has to be a single package--this is the Internet age, not the isolated desktop age. If people are interested, let's talk. My guess is that an obstacle to good intentions is reality: shortage of resources. But I also am relentlessly optimistic and hopeful, and believe if we can present a good case then companies may want to allocate those resources, which is to say, people and money. Ciao, Louis -- Louis Suarez-Potts, PhD Community Manager, Sun Microsystems, Inc. OpenOffice.org
Hello, Thanks for your message. I have currently unpublished PHP code I've been using for a few years to access OOo spreadsheets and load them into Drupal. However, it was developed "ad hoc" to import product data, and is currently not fit for general use since it is limited to spreadsheets and only goes from OOo to Drupal, not the other way round. Maybe if others are interested in working on this we could turn it into a general use module. This being saind, while it could obviously be extended to other formats if someone took time to create something more general, a limitation remains due to the time it takes to load an OOo document in PHP vs the maximum time/memory per PHP script on low-end intallations. A file-system-like approach based on plain XML RPC or BlogAPI would probably be easier on users and work in more cases. But it looks like this would have to be done from within OOo, not in PHP but in Python, Basic, JS or Beanshell. Frederic G. MARAND http://blog.riff.org/ ----- Original Message ----- From: "Louis Suarez-Potts" <Louis.Suarez-Potts@Sun.COM> To: <development@drupal.org> Sent: Thursday, May 15, 2008 3:35 AM Subject: [development] OpenOffice.org
[This is a re-send of a message I sent originally to the infrastructure list.]
Hello all!
Allow me to introduce myself: I'm the community manager of OpenOffice.org, a role I've held for the last 7.5 years. My interest here is to see if there is interest in developing an OpenDocument Format filter for Drupal or (better yet) some ways of integrating or at least linking OOo to Drupal. The reason? Lots, including both public and private enterprises, want a CMS + productivity suite (such as OOo) combo. Drupal has huge market share and is flourishing; so does and is OOo.
How is integration imagined? It could be close or it could be even something as simple as an extension. We have now many extensions, and there is no reason why everything has to be a single package--this is the Internet age, not the isolated desktop age.
If people are interested, let's talk. My guess is that an obstacle to good intentions is reality: shortage of resources. But I also am relentlessly optimistic and hopeful, and believe if we can present a good case then companies may want to allocate those resources, which is to say, people and money.
Ciao,
Louis
-- Louis Suarez-Potts, PhD Community Manager, Sun Microsystems, Inc. OpenOffice.org
-------------------------------------------------------------------------------- No virus found in this incoming message. Checked by AVG. Version: 8.0.100 / Virus Database: 269.23.16/1432 - Release Date: 14/05/2008 07:49
Ok, taking into account what both Dario and Federic are saying (OpenOffice as the user interface for publishing directly to a Drupal site via XMLRPC), the best fit here in my opinion would be to use the services module. It offers a rich API for node creation based on custom written services. Here, I am not talking about importing a Document, but rather using the OpenOffice as a client for Drupal, much as Word can be used as a client for a Blog, including Drupal. I am using this now for Drupal to Drupal speak (actually an editorial workflow system sends articles to a publishing system). See http://awebfactory.com.ar/node/297 That would be a quick and sure path, leaving to OpenOffice the client work and to Drupal the services server work, we'd be all set. I actually did hunt around in the Open Office forums recently with an eye to something like this, and saw something implemented ... but opted in the end for Drupal 2 Drupal for the architecture of the system I was developing. But imagine reporters in the field sending in their articles with a Drupal plugin! Victor Kane http://awebfactory.com.ar On Wed, May 14, 2008 at 11:49 PM, Frédéric G. MARAND <fgm@osinet.fr> wrote:
Hello,
Thanks for your message.
I have currently unpublished PHP code I've been using for a few years to access OOo spreadsheets and load them into Drupal. However, it was developed "ad hoc" to import product data, and is currently not fit for general use since it is limited to spreadsheets and only goes from OOo to Drupal, not the other way round. Maybe if others are interested in working on this we could turn it into a general use module.
This being saind, while it could obviously be extended to other formats if someone took time to create something more general, a limitation remains due to the time it takes to load an OOo document in PHP vs the maximum time/memory per PHP script on low-end intallations.
A file-system-like approach based on plain XML RPC or BlogAPI would probably be easier on users and work in more cases. But it looks like this would have to be done from within OOo, not in PHP but in Python, Basic, JS or Beanshell.
Frederic G. MARAND http://blog.riff.org/
----- Original Message ----- From: "Louis Suarez-Potts" <Louis.Suarez-Potts@Sun.COM> To: <development@drupal.org> Sent: Thursday, May 15, 2008 3:35 AM Subject: [development] OpenOffice.org
[This is a re-send of a message I sent originally to the infrastructure list.]
Hello all!
Allow me to introduce myself: I'm the community manager of OpenOffice.org, a role I've held for the last 7.5 years. My interest here is to see if there is interest in developing an OpenDocument Format filter for Drupal or (better yet) some ways of integrating or at least linking OOo to Drupal. The reason? Lots, including both public and private enterprises, want a CMS + productivity suite (such as OOo) combo. Drupal has huge market share and is flourishing; so does and is OOo.
How is integration imagined? It could be close or it could be even something as simple as an extension. We have now many extensions, and there is no reason why everything has to be a single package--this is the Internet age, not the isolated desktop age.
If people are interested, let's talk. My guess is that an obstacle to good intentions is reality: shortage of resources. But I also am relentlessly optimistic and hopeful, and believe if we can present a good case then companies may want to allocate those resources, which is to say, people and money.
Ciao,
Louis
-- Louis Suarez-Potts, PhD Community Manager, Sun Microsystems, Inc. OpenOffice.org
--------------------------------------------------------------------------------
No virus found in this incoming message. Checked by AVG. Version: 8.0.100 / Virus Database: 269.23.16/1432 - Release Date: 14/05/2008 07:49
Actually, I think this approach may give a solution with very little work on the drupal side. Now, if someone with OOo programming knowledge could provide the required info to start on the OOo side of things, I'd gladly set up the whole thing. I've always wanted to improve my OOo integration skills, and stopped in front of the OOo SDK documentation, and this seems a good occasion to do so. ----- Original Message ----- From: "Victor Kane" <victorkane@gmail.com> To: <development@drupal.org> Sent: Thursday, May 15, 2008 12:42 PM Subject: Re: [development] OpenOffice.org Ok, taking into account what both Dario and Federic are saying (OpenOffice as the user interface for publishing directly to a Drupal site via XMLRPC), the best fit here in my opinion would be to use the services module. It offers a rich API for node creation based on custom written services. Here, I am not talking about importing a Document, but rather using the OpenOffice as a client for Drupal, much as Word can be used as a client for a Blog, including Drupal. I am using this now for Drupal to Drupal speak (actually an editorial workflow system sends articles to a publishing system). See http://awebfactory.com.ar/node/297 That would be a quick and sure path, leaving to OpenOffice the client work and to Drupal the services server work, we'd be all set. I actually did hunt around in the Open Office forums recently with an eye to something like this, and saw something implemented ... but opted in the end for Drupal 2 Drupal for the architecture of the system I was developing. But imagine reporters in the field sending in their articles with a Drupal plugin! Victor Kane http://awebfactory.com.ar On Wed, May 14, 2008 at 11:49 PM, Frédéric G. MARAND <fgm@osinet.fr> wrote:
Hello,
Thanks for your message.
I have currently unpublished PHP code I've been using for a few years to access OOo spreadsheets and load them into Drupal. However, it was developed "ad hoc" to import product data, and is currently not fit for general use since it is limited to spreadsheets and only goes from OOo to Drupal, not the other way round. Maybe if others are interested in working on this we could turn it into a general use module.
This being saind, while it could obviously be extended to other formats if someone took time to create something more general, a limitation remains due to the time it takes to load an OOo document in PHP vs the maximum time/memory per PHP script on low-end intallations.
A file-system-like approach based on plain XML RPC or BlogAPI would probably be easier on users and work in more cases. But it looks like this would have to be done from within OOo, not in PHP but in Python, Basic, JS or Beanshell.
Frederic G. MARAND http://blog.riff.org/
----- Original Message ----- From: "Louis Suarez-Potts" <Louis.Suarez-Potts@Sun.COM> To: <development@drupal.org> Sent: Thursday, May 15, 2008 3:35 AM Subject: [development] OpenOffice.org
[This is a re-send of a message I sent originally to the infrastructure list.]
Hello all!
Allow me to introduce myself: I'm the community manager of OpenOffice.org, a role I've held for the last 7.5 years. My interest here is to see if there is interest in developing an OpenDocument Format filter for Drupal or (better yet) some ways of integrating or at least linking OOo to Drupal. The reason? Lots, including both public and private enterprises, want a CMS + productivity suite (such as OOo) combo. Drupal has huge market share and is flourishing; so does and is OOo.
How is integration imagined? It could be close or it could be even something as simple as an extension. We have now many extensions, and there is no reason why everything has to be a single package--this is the Internet age, not the isolated desktop age.
If people are interested, let's talk. My guess is that an obstacle to good intentions is reality: shortage of resources. But I also am relentlessly optimistic and hopeful, and believe if we can present a good case then companies may want to allocate those resources, which is to say, people and money.
Ciao,
Louis
-- Louis Suarez-Potts, PhD Community Manager, Sun Microsystems, Inc. OpenOffice.org
--------------------------------------------------------------------------------
No virus found in this incoming message. Checked by AVG. Version: 8.0.100 / Virus Database: 269.23.16/1432 - Release Date: 14/05/2008 07:49
Hi, On 2008-05-15, at 08:06 , FGM wrote:
Actually, I think this approach may give a solution with very little work on the drupal side.
Now, if someone with OOo programming knowledge could provide the required info to start on the OOo side of things, I'd gladly set up the whole thing. I've always wanted to improve my OOo integration skills, and stopped in front of the OOo SDK documentation, and this seems a good occasion to do so.
I'll ping some developers on this and cc you. They may be resistant to joining yet another list but let's see. Thanks! Louis
----- Original Message ----- From: "Victor Kane" <victorkane@gmail.com> To: <development@drupal.org> Sent: Thursday, May 15, 2008 12:42 PM Subject: Re: [development] OpenOffice.org
Ok, taking into account what both Dario and Federic are saying (OpenOffice as the user interface for publishing directly to a Drupal site via XMLRPC), the best fit here in my opinion would be to use the services module.
It offers a rich API for node creation based on custom written services.
Here, I am not talking about importing a Document, but rather using the OpenOffice as a client for Drupal, much as Word can be used as a client for a Blog, including Drupal.
I am using this now for Drupal to Drupal speak (actually an editorial workflow system sends articles to a publishing system). See http://awebfactory.com.ar/node/297
That would be a quick and sure path, leaving to OpenOffice the client work and to Drupal the services server work, we'd be all set.
I actually did hunt around in the Open Office forums recently with an eye to something like this, and saw something implemented ... but opted in the end for Drupal 2 Drupal for the architecture of the system I was developing.
But imagine reporters in the field sending in their articles with a Drupal plugin!
Victor Kane http://awebfactory.com.ar
On Wed, May 14, 2008 at 11:49 PM, Frédéric G. MARAND <fgm@osinet.fr> wrote:
Hello,
Thanks for your message.
I have currently unpublished PHP code I've been using for a few years to access OOo spreadsheets and load them into Drupal. However, it was developed "ad hoc" to import product data, and is currently not fit for general use since it is limited to spreadsheets and only goes from OOo to Drupal, not the other way round. Maybe if others are interested in working on this we could turn it into a general use module.
This being saind, while it could obviously be extended to other formats if someone took time to create something more general, a limitation remains due to the time it takes to load an OOo document in PHP vs the maximum time/memory per PHP script on low-end intallations.
A file-system-like approach based on plain XML RPC or BlogAPI would probably be easier on users and work in more cases. But it looks like this would have to be done from within OOo, not in PHP but in Python, Basic, JS or Beanshell.
Frederic G. MARAND http://blog.riff.org/
----- Original Message ----- From: "Louis Suarez-Potts" <Louis.Suarez-Potts@Sun.COM> To: <development@drupal.org> Sent: Thursday, May 15, 2008 3:35 AM Subject: [development] OpenOffice.org
[This is a re-send of a message I sent originally to the infrastructure list.]
Hello all!
Allow me to introduce myself: I'm the community manager of OpenOffice.org, a role I've held for the last 7.5 years. My interest here is to see if there is interest in developing an OpenDocument Format filter for Drupal or (better yet) some ways of integrating or at least linking OOo to Drupal. The reason? Lots, including both public and private enterprises, want a CMS + productivity suite (such as OOo) combo. Drupal has huge market share and is flourishing; so does and is OOo.
How is integration imagined? It could be close or it could be even something as simple as an extension. We have now many extensions, and there is no reason why everything has to be a single package--this is the Internet age, not the isolated desktop age.
If people are interested, let's talk. My guess is that an obstacle to good intentions is reality: shortage of resources. But I also am relentlessly optimistic and hopeful, and believe if we can present a good case then companies may want to allocate those resources, which is to say, people and money.
Ciao,
Louis
-- Louis Suarez-Potts, PhD Community Manager, Sun Microsystems, Inc. OpenOffice.org
--------------------------------------------------------------------------------
No virus found in this incoming message. Checked by AVG. Version: 8.0.100 / Virus Database: 269.23.16/1432 - Release Date: 14/05/2008 07:49
Basically, the most important info would be on the XMLRPC API on the OpenOffice side, and various client examples/development environments in which this has been done before, if possible. But the more communication the better! Victor Kane On Thu, May 15, 2008 at 9:26 AM, Louis Suarez-Potts < Louis.Suarez-Potts@sun.com> wrote:
Hi, On 2008-05-15, at 08:06 , FGM wrote:
Actually, I think this approach may give a solution with very little work
on the drupal side.
Now, if someone with OOo programming knowledge could provide the required info to start on the OOo side of things, I'd gladly set up the whole thing. I've always wanted to improve my OOo integration skills, and stopped in front of the OOo SDK documentation, and this seems a good occasion to do so.
I'll ping some developers on this and cc you. They may be resistant to joining yet another list but let's see.
Thanks! Louis
----- Original Message ----- From: "Victor Kane" <victorkane@gmail.com> To: <development@drupal.org> Sent: Thursday, May 15, 2008 12:42 PM Subject: Re: [development] OpenOffice.org
Ok, taking into account what both Dario and Federic are saying (OpenOffice as the user interface for publishing directly to a Drupal site via XMLRPC), the best fit here in my opinion would be to use the services module.
It offers a rich API for node creation based on custom written services.
Here, I am not talking about importing a Document, but rather using the OpenOffice as a client for Drupal, much as Word can be used as a client for a Blog, including Drupal.
I am using this now for Drupal to Drupal speak (actually an editorial workflow system sends articles to a publishing system). See http://awebfactory.com.ar/node/297
That would be a quick and sure path, leaving to OpenOffice the client work and to Drupal the services server work, we'd be all set.
I actually did hunt around in the Open Office forums recently with an eye to something like this, and saw something implemented ... but opted in the end for Drupal 2 Drupal for the architecture of the system I was developing.
But imagine reporters in the field sending in their articles with a Drupal plugin!
Victor Kane http://awebfactory.com.ar
On Wed, May 14, 2008 at 11:49 PM, Frédéric G. MARAND <fgm@osinet.fr> wrote:
Hello,
Thanks for your message.
I have currently unpublished PHP code I've been using for a few years to access OOo spreadsheets and load them into Drupal. However, it was developed "ad hoc" to import product data, and is currently not fit for general use since it is limited to spreadsheets and only goes from OOo to Drupal, not the other way round. Maybe if others are interested in working on this we could turn it into a general use module.
This being saind, while it could obviously be extended to other formats if someone took time to create something more general, a limitation remains due to the time it takes to load an OOo document in PHP vs the maximum time/memory per PHP script on low-end intallations.
A file-system-like approach based on plain XML RPC or BlogAPI would probably be easier on users and work in more cases. But it looks like this would have to be done from within OOo, not in PHP but in Python, Basic, JS or Beanshell.
Frederic G. MARAND http://blog.riff.org/
----- Original Message ----- From: "Louis Suarez-Potts" <Louis.Suarez-Potts@Sun.COM> To: <development@drupal.org> Sent: Thursday, May 15, 2008 3:35 AM Subject: [development] OpenOffice.org
[This is a re-send of a message I sent originally to the
infrastructure list.]
Hello all!
Allow me to introduce myself: I'm the community manager of OpenOffice.org, a role I've held for the last 7.5 years. My interest here is to see if there is interest in developing an OpenDocument Format filter for Drupal or (better yet) some ways of integrating or at least linking OOo to Drupal. The reason? Lots, including both public and private enterprises, want a CMS + productivity suite (such as OOo) combo. Drupal has huge market share and is flourishing; so does and is OOo.
How is integration imagined? It could be close or it could be even something as simple as an extension. We have now many extensions, and there is no reason why everything has to be a single package--this is the Internet age, not the isolated desktop age.
If people are interested, let's talk. My guess is that an obstacle to good intentions is reality: shortage of resources. But I also am relentlessly optimistic and hopeful, and believe if we can present a good case then companies may want to allocate those resources, which is to say, people and money.
Ciao,
Louis
-- Louis Suarez-Potts, PhD Community Manager, Sun Microsystems, Inc. OpenOffice.org
--------------------------------------------------------------------------------
No virus found in this incoming message. Checked by AVG. Version: 8.0.100 / Virus Database: 269.23.16/1432 - Release Date: 14/05/2008 07:49
I see where this is going. If this fleshes out in to a good usable product, then it can be a Microsoft Sharepoint killer. Sharepoint's strong selling point is the ability to create documents in Word, Excel, ...etc. and publish them directly to the web. If what we are discussing materializes, then the same could be done with OpenOffice and Drupal. You get a powerful and usable front end that only requires word processing skills, and a powerful back end for web publishing, and both are open. We have a winner here... -- Khalid M. Baheyeldin 2bits.com, Inc. http://2bits.com Drupal optimization, development, customization and consulting.
On Thursday 15 May 2008 11:07:59 Khalid Baheyeldin wrote:
Sharepoint's strong selling point is the ability to create documents in Word, Excel, ...etc. and publish them directly to the web.
In my experience, HTML generated by MS Office is absolutely horrid, full of inline style declarations and other bad behavior. I suggest that one goal of the OO/Drupal integration should be to take advantage of OO's much cleaner HTML generating capabilities, or to do the conversion in a well-behaved way at the Drupal end. "We make better HTML" won't sell to the end user, but it will play well with the web services administrators. I'm already committed on two other Open Source projects this summer, but I wanted to lend my voice to those who agree that this is a Way Cool Idea, and to thank Louis for contacting the Drupal community! Kind regards, Scott -- ------------------------------------------------------------------------------ Scott Courtney (Drupal user "Syscrusher") syscrusher@4th.com
On 2008-05-15, at 11:07 , Khalid Baheyeldin wrote:
I see where this is going.
If this fleshes out in to a good usable product, then it can be a Microsoft Sharepoint killer.
bingo. :-)
Sharepoint's strong selling point is the ability to create documents in Word, Excel, ...etc. and publish them directly to the web.
yep, though I'd modulo it with, "supposed"
If what we are discussing materializes, then the same could be done with OpenOffice and Drupal. You get a powerful and usable front end that only requires word processing skills, and a powerful back end for web publishing, and both are open.
We have a winner here...
that's what I have been thinking. Ideally, a filter could also work with other compatible and free/open CMSs, just as it could also work with other ODF implementations, eg, KOffice. My goal is really to make the product a flexible one. (Alfresco has gone some distance, I believe, along these lines, but lacks Drupal's presence and plugin ease.)
-- Khalid M. Baheyeldin 2bits.com, Inc. http://2bits.com Drupal optimization, development, customization and consulting.
best, Louis
Louis Suarez-Potts wrote:
Allow me to introduce myself: I'm the community manager of OpenOffice.org, a role I've held for the last 7.5 years. My interest here is to see if there is interest in developing an OpenDocument Format filter for Drupal or (better yet) some ways of integrating or at least linking OOo to Drupal. The reason? Lots, including both public and private enterprises, want a CMS + productivity suite (such as OOo) combo. Drupal has huge market share and is flourishing; so does and is OOo.
We built an odt filter for Drupal some time ago: http://drupal.org/project/inline_odt/ Is this the sort of thing you are referring to? It would be great to be able to do similar things with spreadsheets and presentations. Simon
Hi Simon, et al., On 2008-05-14, at 23:22 , Simon Lindsay wrote:
Louis Suarez-Potts wrote:
Allow me to introduce myself: I'm the community manager of OpenOffice.org, a role I've held for the last 7.5 years. My interest here is to see if there is interest in developing an OpenDocument Format filter for Drupal or (better yet) some ways of integrating or at least linking OOo to Drupal. The reason? Lots, including both public and private enterprises, want a CMS + productivity suite (such as OOo) combo. Drupal has huge market share and is flourishing; so does and is OOo.
We built an odt filter for Drupal some time ago:
Cool. I had not known of it.
Is this the sort of thing you are referring to?
Perhaps. Certainly, it's a good step. The overall idea I have is vague but among other things, I envision, say, a Drupal user being able, b/c of a filter, to create an environment where ODF documents (texts, presentations, spreadsheets, etc.) can be collaborated on, exchanged, and of course imported and exported. Alfresco's ODF Virtual File System is an instance, but I'm sure one could be creative here :-)
It would be great to be able to do similar things with spreadsheets and presentations.
Oh yes.
Simon
best louis
There is a Google Summer of Code project to build a document importer module for Drupal that can handle, among other formats, ODT. http://groups.drupal.org/node/10890 While the student is not allowed to accept additional money beyond what Google offers (I think), having access to ODT experts is something I can only think is a good thing. On Wednesday 14 May 2008, Louis Suarez-Potts wrote:
[This is a re-send of a message I sent originally to the infrastructure list.]
Hello all!
Allow me to introduce myself: I'm the community manager of OpenOffice.org, a role I've held for the last 7.5 years. My interest here is to see if there is interest in developing an OpenDocument Format filter for Drupal or (better yet) some ways of integrating or at least linking OOo to Drupal. The reason? Lots, including both public and private enterprises, want a CMS + productivity suite (such as OOo) combo. Drupal has huge market share and is flourishing; so does and is OOo.
How is integration imagined? It could be close or it could be even something as simple as an extension. We have now many extensions, and there is no reason why everything has to be a single package--this is the Internet age, not the isolated desktop age.
If people are interested, let's talk. My guess is that an obstacle to good intentions is reality: shortage of resources. But I also am relentlessly optimistic and hopeful, and believe if we can present a good case then companies may want to allocate those resources, which is to say, people and money.
Ciao,
Louis
-- Louis Suarez-Potts, PhD Community Manager, Sun Microsystems, Inc. OpenOffice.org
-- Larry Garfield AIM: LOLG42 larry@garfieldtech.com ICQ: 6817012 "If nature has made any one thing less susceptible than all others of exclusive property, it is the action of the thinking power called an idea, which an individual may exclusively possess as long as he keeps it to himself; but the moment it is divulged, it forces itself into the possession of every one, and the receiver cannot dispossess himself of it." -- Thomas Jefferson
Hi, On 2008-05-14, at 23:27 , Larry Garfield wrote:
There is a Google Summer of Code project to build a document importer module for Drupal that can handle, among other formats, ODT.
Nifty.
While the student is not allowed to accept additional money beyond what Google offers (I think), having access to ODT experts is something I can only think is a good thing.
Quite. And certainly a supporting community can help. I cannot allocate resources at OOo but can certainly invite students and others to the relevant lists and introduce people; and can also see if there is sufficiently strong interest within Sun (my employer and OOo's primary contributor and sponsor) to act on a Drupal integration. But much of the effort would really have to come from our communities, no? best Louis
On Wednesday 14 May 2008, Louis Suarez-Potts wrote:
[This is a re-send of a message I sent originally to the infrastructure list.]
Hello all!
Allow me to introduce myself: I'm the community manager of OpenOffice.org, a role I've held for the last 7.5 years. My interest here is to see if there is interest in developing an OpenDocument Format filter for Drupal or (better yet) some ways of integrating or at least linking OOo to Drupal. The reason? Lots, including both public and private enterprises, want a CMS + productivity suite (such as OOo) combo. Drupal has huge market share and is flourishing; so does and is OOo.
How is integration imagined? It could be close or it could be even something as simple as an extension. We have now many extensions, and there is no reason why everything has to be a single package--this is the Internet age, not the isolated desktop age.
If people are interested, let's talk. My guess is that an obstacle to good intentions is reality: shortage of resources. But I also am relentlessly optimistic and hopeful, and believe if we can present a good case then companies may want to allocate those resources, which is to say, people and money.
Ciao,
Louis
-- Louis Suarez-Potts, PhD Community Manager, Sun Microsystems, Inc. OpenOffice.org
-- Larry Garfield AIM: LOLG42 larry@garfieldtech.com ICQ: 6817012
"If nature has made any one thing less susceptible than all others of exclusive property, it is the action of the thinking power called an idea, which an individual may exclusively possess as long as he keeps it to himself; but the moment it is divulged, it forces itself into the possession of every one, and the receiver cannot dispossess himself of it." -- Thomas Jefferson
If you imagined this interaction between OOo and Drupal over a protocol like XML-RPC, SOAP etc, then I would recommend taking a look at the services module (drupal.org/project/services), writing an ooffice service (containing the methods for Drupal) in my opinion would be an elegant way to go. b On Thu, May 15, 2008 at 4:38 AM, Louis Suarez-Potts <Louis.Suarez-Potts@sun.com> wrote:
Hi,
On 2008-05-14, at 23:27 , Larry Garfield wrote:
There is a Google Summer of Code project to build a document importer module for Drupal that can handle, among other formats, ODT.
Nifty.
While the student is not allowed to accept additional money beyond what Google offers (I think), having access to ODT experts is something I can only think is a good thing.
Quite. And certainly a supporting community can help. I cannot allocate resources at OOo but can certainly invite students and others to the relevant lists and introduce people; and can also see if there is sufficiently strong interest within Sun (my employer and OOo's primary contributor and sponsor) to act on a Drupal integration. But much of the effort would really have to come from our communities, no?
best Louis
On Wednesday 14 May 2008, Louis Suarez-Potts wrote:
[This is a re-send of a message I sent originally to the infrastructure list.]
Hello all!
Allow me to introduce myself: I'm the community manager of OpenOffice.org, a role I've held for the last 7.5 years. My interest here is to see if there is interest in developing an OpenDocument Format filter for Drupal or (better yet) some ways of integrating or at least linking OOo to Drupal. The reason? Lots, including both public and private enterprises, want a CMS + productivity suite (such as OOo) combo. Drupal has huge market share and is flourishing; so does and is OOo.
How is integration imagined? It could be close or it could be even something as simple as an extension. We have now many extensions, and there is no reason why everything has to be a single package--this is the Internet age, not the isolated desktop age.
If people are interested, let's talk. My guess is that an obstacle to good intentions is reality: shortage of resources. But I also am relentlessly optimistic and hopeful, and believe if we can present a good case then companies may want to allocate those resources, which is to say, people and money.
Ciao,
Louis
-- Louis Suarez-Potts, PhD Community Manager, Sun Microsystems, Inc. OpenOffice.org
-- Larry Garfield AIM: LOLG42 larry@garfieldtech.com ICQ: 6817012
"If nature has made any one thing less susceptible than all others of exclusive property, it is the action of the thinking power called an idea, which an individual may exclusively possess as long as he keeps it to himself; but the moment it is divulged, it forces itself into the possession of every one, and the receiver cannot dispossess himself of it." -- Thomas Jefferson
Actually, if you think about it, it is not an ooffice service you need. All you need is an OpenOffice client!!! That can talk to the services module. The Drupal Services module already has a node service. The only need for customization may be with certain complex node types... Here the medium is not in the messge. Victor On Thu, May 15, 2008 at 7:37 AM, Balazs Dianiska <csillagasz@gmail.com> wrote:
If you imagined this interaction between OOo and Drupal over a protocol like XML-RPC, SOAP etc, then I would recommend taking a look at the services module (drupal.org/project/services), writing an ooffice service (containing the methods for Drupal) in my opinion would be an elegant way to go.
b
On Thu, May 15, 2008 at 4:38 AM, Louis Suarez-Potts <Louis.Suarez-Potts@sun.com> wrote:
Hi,
On 2008-05-14, at 23:27 , Larry Garfield wrote:
There is a Google Summer of Code project to build a document importer module for Drupal that can handle, among other formats, ODT.
Nifty.
While the student is not allowed to accept additional money beyond what Google offers (I think), having access to ODT experts is something I can only think is a good thing.
Quite. And certainly a supporting community can help. I cannot allocate resources at OOo but can certainly invite students and others to the relevant lists and introduce people; and can also see if there is sufficiently strong interest within Sun (my employer and OOo's primary contributor and sponsor) to act on a Drupal integration. But much of the effort would really have to come from our communities, no?
best Louis
On Wednesday 14 May 2008, Louis Suarez-Potts wrote:
[This is a re-send of a message I sent originally to the infrastructure list.]
Hello all!
Allow me to introduce myself: I'm the community manager of OpenOffice.org, a role I've held for the last 7.5 years. My interest here is to see if there is interest in developing an OpenDocument Format filter for Drupal or (better yet) some ways of integrating or at least linking OOo to Drupal. The reason? Lots, including both public and private enterprises, want a CMS + productivity suite (such as OOo) combo. Drupal has huge market share and is flourishing; so does and is OOo.
How is integration imagined? It could be close or it could be even something as simple as an extension. We have now many extensions, and there is no reason why everything has to be a single package--this is the Internet age, not the isolated desktop age.
If people are interested, let's talk. My guess is that an obstacle to good intentions is reality: shortage of resources. But I also am relentlessly optimistic and hopeful, and believe if we can present a good case then companies may want to allocate those resources, which is to say, people and money.
Ciao,
Louis
-- Louis Suarez-Potts, PhD Community Manager, Sun Microsystems, Inc. OpenOffice.org
-- Larry Garfield AIM: LOLG42 larry@garfieldtech.com ICQ: 6817012
"If nature has made any one thing less susceptible than all others of exclusive property, it is the action of the thinking power called an
idea,
which an individual may exclusively possess as long as he keeps it to himself; but the moment it is divulged, it forces itself into the possession of every one, and the receiver cannot dispossess himself of it." -- Thomas Jefferson
My interest here is to see if there is interest in developing an OpenDocument Format filter for Drupal or (better yet) some ways of integrating or at least linking OOo to Drupal
These look like two distinct issues: A. Importing OpenDocument to Drupal. See this relevant discussion: http://groups.drupal.org/node/9929 B. Publishing directly from OOo to Drupal. Here we have on the Drupal side two potential starting places I think. 1. The existing Blog API module in Drupal core. This would involve writing a Blog API client extension in OpenOffice. 2. As suggested by others, the Services module (not part of Drupal core). This would involve writing a Drupal Services client extension for OpenOffice. Here there would be more potential for customization, but the development would be tied to a contrib Drupal module's APIs. Of the two, the Blog API seems to me the first option to look at. A key advantage is that the extension would not need to be Drupal-specific. Nedjo Rogers
Nedjo Rogers wrote:
My interest here is to see if there is interest in developing an OpenDocument Format filter for Drupal or (better yet) some ways of integrating or at least linking OOo to Drupal <snip>good stuff removed<snip> Of the two, the Blog API seems to me the first option to look at. A key advantage is that the extension would not need to be Drupal-specific. Agreed on this. Targeting the Blog API first is an easier target, and something that would be more accessible to a broader range of users.
Cheers, Bill
On Thu, May 15, 2008 at 12:38 PM, Nedjo Rogers <nedjo@islandnet.com> wrote:
My interest here is to see if there is interest in developing an
OpenDocument Format filter for Drupal or (better yet) some ways of integrating or at least linking OOo to Drupal
These look like two distinct issues:
A. Importing OpenDocument to Drupal. See this relevant discussion: http://groups.drupal.org/node/9929
B. Publishing directly from OOo to Drupal. Here we have on the Drupal side two potential starting places I think.
1. The existing Blog API module in Drupal core. This would involve writing a Blog API client extension in OpenOffice.
Right, this would not involve adding anything to off the shelf Drupal: see John VanDyck's post: Using Word 2007 Blog functionality to post to Drupal via the MetaWeblog API<http://www.sysarchitects.com/node/64> http://www.sysarchitects.com/node/64
2. As suggested by others, the Services module (not part of Drupal core). This would involve writing a Drupal Services client extension for OpenOffice. Here there would be more potential for customization, but the development would be tied to a contrib Drupal module's APIs.
Let's assume that the existing server alternatives (XMLRPC, etc.) suffice. Then the question remains about implementing a special service. This has much more to do with the content of the message rather than the fact that it is coming from OpenOffice. Well, some needs could be met off the shlef by using the existing node services perfectly well. Title and Body would be all you would need to upload an article, it could be the client's job to opt for HTML output directly. Of course, more sophisticated _services_ could be written whose job it would be to map metadata or some structure transmitted by the client to complex cck defined fields of a given content type. That's where the use cases will have to find their implementation. I think it would be best to have an open set of tools (services for Services module and clients for OpenOffice) pointing in that direction, for example, the Drupal community's familiarity with how to construct a client using an OpenOffice plugin that thinks it's talking to an OpenOffice server. Victor
Of the two, the Blog API seems to me the first option to look at. A key advantage is that the extension would not need to be Drupal-specific.
Nedjo Rogers
It's about time I replied to this, as have been planning something similar, just haven't had the time to implement it. I'm worried by the lockin Sharepoint gives Microsoft, and am seeing first hand how people, corporations and institutions are jumping on it. They truly think it's a great thing. From Drupal's perspective Sharepoint is not only gaining traction as a document portal, but as a platform for building Web sites. This worries me. Louis Suarez-Potts wrote:
How is integration imagined? It could be close or it could be even something as simple as an extension.
I've got a battle plan. :)
If people are interested, let's talk. My guess is that an obstacle to good intentions is reality: shortage of resources.
Well, here's what I dreamed up a while ago: * Firstly, create a CCK field that transforms an ODF file attachment into HTML, using the ODF2html stylesheet (or whatever it's being called these days). http://xml.openoffice.org/sx2ml/ and stores it in the Drupal database. I did think of doing this as a content type, but attaching to a node, using CCK and file attachments, allows the author to add metadata about the document and store multiple documents on the same node. It also keeps the document separate from the node, so users don't get confused when they can't edit it online. Initially I do not expect users to be able to edit documents online, they will need a thick-client editor like OOo, or KOffice. * Next, make our ODF CCK field store 'revisions' (in Drupal-speak), according to ODF 'versions' (ODF-speak, I'll call revisions and versions this from now on) stored in the document. I've investigated how the versions are stored in ODF, splitting them out doesn't seem too difficult. CCK information is not stored in node_revisions, so we'll need our own revisions table for this field. * Add GUI elements allowing users to view the versions stored in the file. * Use the diff module ( http://drupal.org/project/diff ) as a basis for a version viewer, that allows people to see the differences between files online. * In order to get write-access to files stored in the document portal, we'll need to point people to other FLOSS technologies, instead of re-inventing the wheel (in my opinion). WebDAV is the most likely candidate I've seen, even Windows supports it (not sure about Vista though). * Add an edit link on the CCK field that points OOo to the file stored in WebDAV. An edit should 'lock' the file for editing, in both Drupal and in the file system. * Add an 'update' or 'check in' link that re-imports the file: splitting out the versions, converting them to HTML and saving the versions to the CCK database. This is kludgy, but fixes two problems: 1. stopping multiple users editing the same file; 2. knowing when a file has been updated in the repo. * Write tutorials on how to turn your Drupal into a document portal. Include instructions on WebDAV (maybe including WebDAV and SVN with autoversioning) and useful Drupal modules, such as Workflow ( http://drupal.org/project/workflow ). For bonus points, create packages for popular GNU+Linux distros: 'apt-get odf-portal' being the aim. * For more than just bonus points, create a business selling servers: Document-portal-in-a-box, or rental services. For bonus marketing points, create a budget Document Portal Server that ships complete for less than the price of a Windows 2008 + Sharepoint *license*. I already asked Slashdot about an ODF Document Portal last year, didn't receive much feedback, but here's the thread: http://ask.slashdot.org/article.pl?sid=07/03/09/0036216 Already had Drupal in my mind as the best way to implement this, but wanted to see if anyone could come up with a better plan. The best was Alfresco, I tried and found it lacking compared to Drupal. Further research, know your enemy: http://office.microsoft.com/en-us/products/HA101687261033.aspx I'm on GNU+Linux, but that ran fine in a VM running Windows XP. Last time I looked Sharepoint was in that demo. It would take precious little time to get this project going, most of what's required is already in place IMO. This is the biggest advantage we have over Microsoft: cannibalising code and services from other projects. I would be very happy to take this idea further, but can't afford to work for free at the moment. If this plan makes any sense, feel free to use it. Otherwise, if nothing happens and I do get some free time, I might try this myself. Feel free to contact me with questions or what not. Kind Regards, Liam McDermott.
On Fri, May 16, 2008 00:53, Liam McDermott wrote:
From Drupal's perspective Sharepoint is not only gaining traction as a document portal, but as a platform for building Web sites. This worries me.
Yep - a document portal would be useful for various business (or not) sites. However I suppose that a real interest would be in creating a website using OOo and Drupal as an "integrated system". Suppose to be able to publish a "book" (drupal term) using a single document that will split in chapters and the like. Or similarly organzing a structured knowledge base or an ecommerce listing and then publish (and manage!) a whole set of nodes with a "single click" (ok, it will never be "one" but I suppose the concept is clear). This should be the target, IMNSHO. Something like this could "sell" - I mean: obviously not the product itself (free to dowload and use and the like) but support to it, courses on best practices and the like. I might have customers interested in it, I will investigate. Ciao! --8<-----------------------------------fnord----- Piermaria Maraziti piermaria@maraziti.it KALLISTI ICQ744473 MSN:kallisti@hotmail.it +3934735GILDA www.gilda.it www.eridia.it www.hovistocose.it
On the topic of using the Blog API, which is an idea I like, I came across a non-free product developed by SUN that seems to do something like this already... Sun Weblog Publisher: http://www.sun.com/software/star/staroffice/extensions.jsp#weblog I am uncertain about its details since I have had no reason to buy it and try it... but it seems that since you work at SUN you may be able to dig deeper into it. It says it works with MetaWeblog which I believe is the same way Office 2007 can talk to Drupal. Might it be possible to look at the Sun Weblog Publisher as a start on your side? Just something I remember coming across that might be worth looking at... Hope this helps. Best, Matt On Wed, 2008-05-14 at 21:35 -0400, Louis Suarez-Potts wrote:
[This is a re-send of a message I sent originally to the infrastructure list.]
Hello all!
Allow me to introduce myself: I'm the community manager of OpenOffice.org, a role I've held for the last 7.5 years. My interest here is to see if there is interest in developing an OpenDocument Format filter for Drupal or (better yet) some ways of integrating or at least linking OOo to Drupal. The reason? Lots, including both public and private enterprises, want a CMS + productivity suite (such as OOo) combo. Drupal has huge market share and is flourishing; so does and is OOo.
How is integration imagined? It could be close or it could be even something as simple as an extension. We have now many extensions, and there is no reason why everything has to be a single package--this is the Internet age, not the isolated desktop age.
If people are interested, let's talk. My guess is that an obstacle to good intentions is reality: shortage of resources. But I also am relentlessly optimistic and hopeful, and believe if we can present a good case then companies may want to allocate those resources, which is to say, people and money.
Ciao,
Louis
-- Louis Suarez-Potts, PhD Community Manager, Sun Microsystems, Inc. OpenOffice.org
participants (17)
-
Balazs Dianiska -
Bill Fitzgerald -
Darren Oh -
FGM -
Frédéric G. MARAND -
Khalid Baheyeldin -
Larry Garfield -
Liam McDermott -
Louis Suarez-Potts -
Matt Galvin -
Nancy Wichmann -
Nedjo Rogers -
Piermaria Maraziti -
Simon Lindsay -
Syscrusher -
Tony Yarusso -
Victor Kane