Any ColdFusion/OpenOffice Gurus?

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

15

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?

5141 Views Send Print Comments (15)

Comments (15)

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

Dan Z's Gravatar I've been using OpenOffice with CF for a few years now.. I use JavaLoader along with artofsolving's guide to setup OO as a service.

You can really do some great stuff with it. I'm using it now to create .swf clickable previews of user uploaded Power Point presentations.

Posted by: Dan Z on: 6/2/10 1:29 PM

Seth Johnson's Gravatar I was finding that if Open Office was not running on the first attempt ColdFusion would throw an error: "Could not determine OpenOffice installation." On the second conversion attempt everyhting would work. I ended up taking your CFEXECUTE code and running that before the CFDOCUMENT in order to make certain OO is up and running. Do you think I should then use CFEXECUTE to exit OO after the conversion? I tried to find a command line option, but soffice doesn't seem to have an "exit" or "quit" switch.

Thanks!

Posted by: Seth Johnson on: 2/18/11 10:35 AM

Andy G's Gravatar OMG, I have been rackin' my brain for about 2 days now on this. finally found this article and it solved my problems. Just had to move my macro over to the "C:\Program Files (x86)\OpenOffice.org 3\Basis\share\basic\" (and pick one folder) to place it.

Thank you all!

Posted by: Andy G on: 12/8/11 2:52 PM
Add Comment

  • Calendar

    << May 2012 >>
    Sun Mon Tue Wed Thu Fri Sat
      12345
    6 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.