Use New output

Hi Ciska,

to use the new output object paste the following command into your script code:

Context.setProperty("use-new-output", true); 

Greetings,

Jens

Hi Jens,

Thank you but I know this command, the problem is when using this command or even when changing it in the config file to true, there is no TOC and commands like begintable does not work. I want to know what else needs to be done and also how can I utilize OutputXLSX and OutputDOCX.

Just for interest sake, I have added this command to the standard script Create Process Manual and it actually breaks at a begintable statement.....

Ciska

Hi

Does someone have any feedback on this, or at least got it working?

Ciska

Hi 

I tried using new output to extract external file from the 'Documentation' attribute but the formatting of the whole report was ruined. I would appreciate if someone can give an advice on how to fix it.

Nikolai

Hi,

Can someone share some light on how to succesfully use the use-new-output and also how to use OutputXLSX and OutputDOCX?

Thank you

Ciska

Hi,

I suppose output to xlsx in ARIS is not working, although claimed to be. I have tried everything possible acording to my knowledge as no working solution is available or made available.

By changing the setting in the config file (<report use-new-output="true" />) will enable the new office formats but only for docx, which is available as selection when creating reports, xlsx is not.

Changing the output format in the script by using Context.setSelectedFormat(Constants.OutputXLSX) - not working. Used the workbookobject by writing directly to excel (Context.createExcelWorkbook) - not working as well. Using a pre-defined xlsx template for each script in order to output to xlsx, haven't tried that, but is that really the way to go in order to get an output to xlsx for each script? I don't think so.

Surely if claimed that ARIS can ouput to xlsx why is it so difficult to do so? Is there a missing jar file, or wrong version of a jar file installed in the ARIS directory?

Ciska

Hi Ciska,

Did you get any resolution on this problem? I am having the same issues (and more).

Kind regards,

Brooke

Hi Brooke,

No, nothing at all, and also no response since my last post. I also experience problems when using the new word formats (docx) so I've reverted back by setting the (<report use-new-output="false" />).

All of our clients are using either Office 2007 or Office 2010, and by using the old office formats are causing issues (like colours for example).

It would be nice if we could get some answers regarding this - for both xlsx and docx! Not sure if the latest version of Aris 7.2 addresses these issues, maybe Aris 9.....

Ciska

I've got this to work.

for docx, "Context.setSelectedFormat" does not work, but createOutputObject does. So I use this.

Context.setProperty("use-new-output", true);
oldname = Context.getSelectedFile()
newname = oldname + "x"
var oOutput = Context.createOutputObject( Constants.OutputDOCX, newname)

I've also tried this with Output XLSX format. It works perfectly.

However, this means that the stock code needs to be rewritten. For example, the global header and footer text we so often take from WYSIWYG reports becomes very ugly and needs to be rewritten. 

Hi Galvin,

Thanks, will give your suggestion a try. What version of ARIS do you use?

Ciska

I'm using 7.2.2.589499 ( 2011_02), so pretty old. 

Hi Galvin,

Had a quick test, a xlsx output is generated the only thing, the colours are missing. For example the heading columns background is yellow, it turns out to be black when outputting to xlsx. This is for all formatting, text, background and so forth.

Unless I'm missing something?

Ciska

The fix for me was that I used the rgb function that is saved in every WYSIWYG report. Using that to directly define the background colour seems to work.

function RGB(r, g, b) {
	return (new java.awt.Color(r/255.0,g/255.0,b/255.0,1)).getRGB() & 0xFFFFFF
}

Strange.... I have tried the RGB as well without any success. Is that to Excel or to Word?

Not that I think that this might be relevant, I'm using Office 2010.

Ciska

The Colours are working when output to Word, not to Excel it seems......

Hi Ciska,

You're right, I tested it on docx successfully. It doesn't seem to work for excel. the table is set to a background of black, although the rest of the sheet is set to no background)

The only background "colour" that works is "Constants.C_TRANSPARENT"

Also tried

1. outexcel (doesn't work at all) 
2. outxlsm (doesn't work at all)