Any ColdFusion/OpenOffice Gurus?

Posted By : todd sharp Posted At : June 21, 2008 8:52 AM Posted In: ColdFusion

12

I'm abusing the blog a bit here by asking a question, but are there any folks with experience integrating OpenOffice with CF out there? I'm really looking for a basic quick start guide for getting started. What do I need installed on the server?

I did some quick tests last night but couldn't even get past creating the bootstrap object to connect to OO. In my first attempt tried using JavaLoader to load up the OO jars, but got an 'no office executable found' exception. I then figured I'd try adding OpenOffice to my class path, but the connection just timed out.

Can anyone point me in the right direction?

3050 Views Send Print Comments (12)

Comments (12)

Subscribe to Comments Add Comment

Mike Kelp's Gravatar While I have no experience with this, I was interested by your idea and did some assitive googling :-)

Checkout this link:
http://www.javaworld.com/javaworld/jw-05-2008/jw-0...

It seems to show how to manipulate a spreadsheet using Java and explains a bit more about how OO.org can run in a server mode and manipulate many documents via network communication (regardless of language). Though, since many of them are written in Java, and CF has the capability, using the jar straight up might be preferred.

Anyway, hope that helps and good luck.

Posted by: Mike Kelp on: 6/21/08 10:46 AM

Scott P's Gravatar Todd - not sure but you might look at this:

http://www.artofsolving.com/opensource/jodconverte...

Posted by: Scott P on: 6/21/08 8:23 PM

todd sharp's Gravatar @Scott - yeah dude, that is what I'm talking about....perfect!! And it works too ;)

Posted by: todd sharp on: 6/22/08 1:48 AM

Scott P's Gravatar Yeah - I've been playing with it also. I'll try to ping you tomorrow.

Posted by: Scott P on: 6/22/08 2:41 AM

Mike Kelp's Gravatar Good find Todd!

If you get a chance, I'd love to see a sample of what you do with it.

Posted by: Mike Kelp on: 6/22/08 1:13 PM

todd sharp's Gravatar @Mike: I'll probably post something once I get things polished.

@Scott: Did you have any luck getting CF to start OpenOffice as a service? I'm trying to use cfexecute with no luck whatsoever...

Posted by: todd sharp on: 6/24/08 3:55 PM

Scott P's Gravatar yeah - try cmd.exe with /k and the cmdline as argument.

<cfexecute
name="cmd.exe"
arguments="/k c:/pathto/soffice -headless -accept=""socket,host=127.0.0.1,port=8100;urp;"" -nofirststartwizard" />

Posted by: Scott P on: 6/24/08 4:37 PM

todd sharp's Gravatar Still no luck :(

I think it's choking because my pathto/soffice has spaces in it - and wrapping in quotes doesn't work...

Posted by: todd sharp on: 6/24/08 5:58 PM

Scott P's Gravatar <cfexecute
arguments="-headless -accept=""socket,host=127.0.0.1,port=8100;urp;"" -nofirststartwizard"
name="C:\Progra~1\OpenOf~1.0\program\soffice"/>


dir /x from the cmdline should tell you the 8.3 directory name if the one above is wrong.

Posted by: Scott P on: 6/24/08 6:20 PM

todd sharp's Gravatar You are my hero :)

When dealing with me, always remember, if it ain't GUI, I don't have a clue :)

Posted by: todd sharp on: 6/24/08 9:04 PM

Juan Escalada's Gravatar I´ve been asked to extract every single footnote on a word document and its related paragraph one by one. After the pair (the particular footnote and the related paragraph) is extracted they want to send it via e-mail to a person. Does anyone know if I could do this with JOD Converter?

Thanks in advance, Juan.

Posted by: Juan Escalada on: 9/24/09 12:33 PM

todd sharp's Gravatar I haven't messed with JOD+Word at all - but I'd be willing to bet you could do that with Apache POI Juan.

Posted by: todd sharp on: 9/24/09 3:01 PM
Add Comment

  • Calendar

    << March 2010 >>
    Sun Mon Tue Wed Thu Fri Sat
     123456
    7 8 9 10 11 12 13
    14 15 16 17 18 19 20
    21 22 23 24 25 26 27
    28 29 30 31    

  • Subscribe

    • Enter your email address to subscribe to this blog.