CASE STUDY: generating Microsoft Word Documents on a server

[MMcCarthy]

This problem was proposed to me but not really my area of expertise so I thought I would open it up to the forum to see if anyone had any bright ideas.

The problem is generating Microsoft Word Documents on a server from Word templates and injecting data from a data source. There are a number of solutions to this problem that are less than satisfactory:

1. Use the Microsoft Word Object Model is not good as it requires the installation of a client application on a server and it leaves processes open if you are not really careful.
2. Using WordML is Not great because it's XML and not really word documents.
3. Using HTML is OK but it's HTML not word at the end of the day.
4. Using RTF is same problem.

Requirements:

1. The documents will be generated on a server, no Word application is installed.
2. If at all possible the input should be Word documents or Word Template files, so that business users can create them. I will relax this requirement for good alternatives.
3. The solution should be scalable.
4. I don't care what technology is used, PHP, Java, .NET?
5. The solution should work

[Motoma]

Trying to get someone else to do your job for you, eh Mary?

[MMcCarthy]

Trying to get someone else to do your job for you, eh Mary?

LOL! Naw ...

This is just something one of my clients proposed to their IT staff. They asked for my input as well.

[Motoma]

Open Office is scriptable; I believe you can set it up to to file conversions without invoking a GUI as you do with MS Office's craptools.

[MMcCarthy]

Open Office is scriptable; I believe you can set it up to to file conversions without invoking a GUI as you do with MS Office's craptools.

Thats Sun's version of Office is it?

[Motoma]

Thats Sun's version of Office is it?

More or less.
There is OpenOffice, and there is StarOffice, which is Sun's version.

[MMcCarthy]

More or less.
There is OpenOffice, and there is StarOffice, which is Sun's version.

I remember star office from many years ago but never actually got exposed to open office.

[gits]

hmmm ...

in case you find a solution based on open office you may be interested in the following odf-to-openXML-converter

kind regards

[Motoma]

hmmm ...

in case you find a solution based on open office you may be interested in the following odf-to-openXML-converter

kind regards

Well, Open Office can save directly to MS Word Document format, as Mary requested.

[gits]

yep ... forget about my post ... but i thought it could be an good idea to produce odf at all ... because of its standardization . and only convert it for word in case you need to ...

i know that ms is trying to get the office openXML standardized as well and i think this might happen otherwise i think they have to use odf too? ... and isn't openXML the format of word-docs too? sorry ... but i shouldn't had said something in a domain where i'm not an expert ...

[MMcCarthy]

yep ... forget about my post ... but i thought it could be an good idea to produce odf at all ... because of its standardization . and only convert it for word in case you need to ...

i know that ms is trying to get the office openXML standardized as well and i think this might happen otherwise i think they have to use odf too? ... and isn't openXML the format of word-docs too? sorry ... but i shouldn't had said something in a domain where i'm not an expert ...

This is just a case study gits. All opinions are welcome.

[Motoma]

This is just a case study gits. All opinions are welcome.

As gits stated, there are STANDARDIZED formats which I would strongly urge clients to use. Almost all document editors can utilize these formats, as opposed to proprietary formats. Microsoft is really pushing to get its format to be an ISO standard, however they haven't succeeded with that yet.

[MMcCarthy]

The client who originally put this problem forward has come up with the following solution.

Apache POI - Java API To Access Microsoft Format Files

Its interesting stuff.

[r035198x]

The client who originally put this problem forward has come up with the following solution.

Apache POI - Java API To Access Microsoft Format Files

Its interesting stuff.

The integration of the template and the database data would range from being a trivial exercise to very complex depending on the complexity of the reports required.

Might as well throw away everything and use ireports. It's easy to design reports on it and create .jasper files which are easily convertible to .doc and .pdf files. The sql will be tied to the report itself and you can make some complicated reports on it.
We are using ireports a lot at work.

Using the poi with Java is very easy of course but there is no mechanism that ties sql queries to the .docs themselves. You'd have to couple them yourself.

[Motoma]

Crystal Reports can generate word documents too, I believe.