Generating Office Documents/Mail Merge from Solaris

From: Tony Jenness (Tony.Jenness@nzacu.org.nz)
Date: Thu Mar 31 2005 - 18:39:30 EST


Hi Managers.

I have a rather unique and annoying issue that's causing us some grief. We
currently have an application that runs on Solaris and is terminal based. We
want to generate office documents from the data contained in the database and
I have developed a system using Open Office, Xvfb and a few other bits and
pieces however it is not optimal.

The way it works now is that the database executes my script which reads in
the config file. I use a Perl module, OODoc to parse the file and create a new
OO document with the relavent data, so far so good. The problem comes to
printing, the only way I seem to be able to print these documents is to use an
OO Macro to turn the office document into a PostScript file which I then spool
to the printer. This has a few drawbacks it either requires an OpenOfffice
installation for each user (400+) or using sudo a single installation.

Even then it isn't robust enough as the Macro looks like it hangs every now
and again. I have a rudimentary queueing system as it can't run multiple ones
at once so if a large number of people want to generate the document it queues
and turns into a rather large bit of system load as OO has to start/close
constantly.

The other issue is that, well, Solaris's printing isn't as simple as Windows.
We print to a large amount of printers on our WAN that we don't control/own.
Printers that do not support PostScript will not print the document. I can't
easily convert it into PCL.

I'm considering moving it over to a new server but I don't believe it will
solve the OO Macro issues, nor the PCL/PostScript issue.

What I'm after is a complete robust solution that doesn't specifically have to
be Solaris based, although I'd prefer it.

Any help would be greatly appreciated and I'll summarise.
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers



This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:30:27 EDT