<cfsilence>

Any ColdFusion/OpenOffice Gurus?

Posted At : June 21, 2008 9:52 AM | Posted By : todd sharp
Related Categories: ColdFusion

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?

Comments (10) |

Print |

Send |

del.icio.us |

Linking Blogs | 1330 Views

Comments

[Add Comment]

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 | 6/21/08 10:46 AM

Todd - not sure but you might look at this:

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

# Posted By Scott P | 6/21/08 8:23 PM

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

# Posted By todd sharp | 6/22/08 1:48 AM

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

# Posted By Scott P | 6/22/08 2:41 AM

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 | 6/22/08 1:13 PM

@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 | 6/24/08 3:55 PM

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 | 6/24/08 4:37 PM

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 | 6/24/08 5:58 PM

<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 | 6/24/08 6:20 PM

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 | 6/24/08 9:04 PM

[Add Comment]