OpenOffice.org

[Louis Suarez-Potts]

[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

[Darren Oh-2]

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

[Nancy Wichmann]

I'm interested in helping with this; I doubt I can do it all myself.

Nancy Wichmann, PMP


-----Original Message-----
From: development-bounces@...
[mailto:development-bounces@...]On Behalf Of Louis Suarez-Potts
Sent: Wednesday, May 14, 2008 9:35 PM
To: development@...
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

[Tony Yarusso-2]

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/

[FGM]

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@...>
To: <development@...>
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

[Simon Lindsay]

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

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

[Louis Suarez-Potts]

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:
>
> http://drupal.org/project/inline_odt/

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

[Louis Suarez-Potts]

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.
>
> http://groups.drupal.org/node/10890

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

[Balazs Dianiska]

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@...> 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.
>>
>> http://groups.drupal.org/node/10890
>
> 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@...          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
>
>

[Victor Kane-2]

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@...> 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@...>
To: <development@...>
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

[Victor Kane-2]

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@...> 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@...> 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.
>>
>> http://groups.drupal.org/node/10890
>
> 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@...          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
>
>

[FGM]

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@...>
To: <development@...>
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@...> 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@...>
> To: <development@...>
> 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
>
>

[Louis Suarez-Potts]

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@...>
> To: <development@...>
> 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@...>  
> 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@...>
>> To: <development@...>
>> 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
>>
>>
>

[Victor Kane-2]

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@...> 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@...>
To: <development@...>
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@...> 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@...>
To: <development@...>
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

[Khalid Baheyeldin-2]

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.

[Piermaria Maraziti]

At 17.07 15/05/2008, you wrote:

>We have a winner here...

<delurk>
May the Gods listen to you!

I also envision a good role of this in an e-commerce suite made for
web-ignorant store owners...
</delurk>

--8<-----------------------------------fnord-----
Piermaria Maraziti piermaria@... KALLISTI
ICQ744473  MSN:kallisti@...  +3934735GILDA
www.gilda.it   www.eridia.it   www.hovistocose.it

[Nedjo Rogers-2]

> 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

[Bill Fitzgerald]

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

[Syscrusher-2]

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