Conversion of File Types Problem

[blesnyder]

I'm working on using OO to generate documents which may be saved in whatever format the client needs, Word, Wordperfect, OO, etc. In my initial testing, I've been loading .odt and .sxw and saving .doc or .rtf formats. When I attempt to open the newly saved files in Word, it can't read them. The newly saved documents can be opened fine in OO, however. Here's my code, can anyone point me in the right direction?

String fileName = "c:/Test.sxw";
java.io.File sourceFile = new java.io.File(fileName);
StringBuffer sLoadFileUrl = new StringBuffer("file:///");
sLoadFileUrl.append(sourceFile.getCanonicalPath().replace('\\', '/'));
PropertyValue[] loadProps = new PropertyValue[2];
loadProps[0] = new PropertyValue();
loadProps[0].Name = "Hidden";
loadProps[0].Value = new Boolean(false);
loadProps[1] = new PropertyValue();
loadProps[1].Name = "DocumentTitle";
loadProps[1].Value = "Testing.odt";
XComponent xDoc = xComponentLoader.loadComponentFromURL(sLoadFileUrl.toString(), "_blank",
0, loadProps );
//..lots of processing goes here...

String sURL = "file:///c:/done.rtf";
com.sun.star.beans.PropertyValue[] lProperties =
new com.sun.star.beans.PropertyValue[2];
lProperties[0] = new com.sun.star.beans.PropertyValue();
lProperties[0].Name = "FilterName ";
lProperties[0].Value = "Rich Text Format";
lProperties[1] = new com.sun.star.beans.PropertyValue();
lProperties[1].Name = "Overwrite";
lProperties[1].Value = new Boolean(true);

com.sun.star.frame.XStorable xStore = (com.sun.star.frame.XStorable)UnoRuntime.queryInterface (
com.sun.star.frame.XStorable .class, xDoc);

xStore.storeAsURL (sURL, lProperties);

[JohnV]

DannyB has written a file conversion macro. You can find it here:
http://sourceforge.net/project/showfiles.php?group_id=87718&package_id=95532
To go to the general web site where this is use www.ooomacros.org

[blesnyder]

The macro works great, but what I need to do is do the filtering from my java application. The code I'm using is based upon the documentation, so I'm puzzled as to why it isn't readable by Word. I've manually done a Save As to Word 97 and RTF formats from inside OO, and those are readable by Word as well, which leaves me to conclude that I've done something wrong in my code.

[DannyB]

It looks like your program does exactly as you describe. I see nothing wrong.

The problem is that Word doesn't like the RTF that OOo is generating.
(Have you actually opened the RTF file in a text editor to make sure it really looks like RTF?)

One other minor note, it should not be necessary to specify the property Hidden=False when loading the document. I would expect that you only need the Hidden property if you want to set it to True.
_________________
Want to make OOo Drawings like the colored flower design to the left?

[blesnyder]

You are correct, Word doesn't like the file. I've looked at it, and it looks to me like an RTF, but I'm no expert on what an RTF is supposed to look like. What I find interesting is that if I manually "Save as" to RTF or DOC out of OpenOffice, Word reads that fine. I've been reviewing example code, and have begun to wonder if I'm not doing enough set-up in my code? For example, the code in the example FunctionHelper reads in part:

com.sun.star.lang.XServiceInfo xInfo = (com.sun.star.lang.XServiceInfo)UnoRuntime.queryInterface(
com.sun.star.lang.XServiceInfo.class,
xDocument);

if(xInfo!=null)
{
// Find out possible filter name.
String sFilter = null;
if(xInfo.supportsService("com.sun.star.text.TextDocument")==true)
sFilter = new String("HTML (StarWriter)");
else
if(xInfo.supportsService("com.sun.star.text.WebDocument")==true)
sFilter = new String("HTML");
else
if(xInfo.supportsService("com.sun.star.sheet.SpreadsheetDocument")==true)
sFilter = new String("HTML (StarCalc)");

// Check for existing state of this filter.
if(sFilter!=null)
{
com.sun.star.lang.XMultiServiceFactory xSMGR = OfficeConnect.getSMGR();

com.sun.star.container.XNameAccess xFilterContainer = (com.sun.star.container.XNameAccess)UnoRuntime.queryInterface(
com.sun.star.container.XNameAccess.class,
xSMGR.createInstance("com.sun.star.document.FilterFactory"));

if(xFilterContainer.hasByName(sFilter)==false)
sFilter=null;
}

What I'm wondering is if I need to explicitly make sure that the filter exists? I've tried implementing this code, but the line:

com.sun.star.lang.XMultiServiceFactory xSMGR = OfficeConnect.getSMGR();

won't compile, I don't have the OfficeConnect method. I've searched the example, and haven't found where OfficeConnect is created, and I'm not having any luck finding it.

Could this theory be correct, that I need to ensure that I have the filter before using it? Oh, I have the hidden property in there to remind me to set it to true when I eventually put this code into production.

[DannyB]

[blesnyder]

I added the following code:

String sFilter = null;
if(xInfo.supportsService("com.sun.star.text.TextDocument")==true)
sFilter = new String("MS Word 97");

com.sun.star.container.XNameAccess xFilterContainer = (com.sun.star.container.XNameAccess)UnoRuntime.queryInterface(
com.sun.star.container.XNameAccess.class,
xMSF.createInstance("com.sun.star.document.FilterFactory"));

if(xFilterContainer.hasByName(sFilter)==false)
sFilter=null;

sFilter gets populated, but the document still isn't Word readable. Argh!

[blesnyder]

I figured it out. The line:

lProperties[0].Value = "MS Word 97";

had been:

lProperties[0].Value = "MS Word 97 "; //Note there's a trailing space

The trailing space didn't raise any errors, but it sure did hose up the output file!

Thanks for all your help.