NR

Hi All,

We have received a new request from an user which was about changing the existing reports in ARIS. Currently we are using ARIS 9.6 and the output for all the reports are generated in excel format with the help of JavaScript language . 

The user needs 3 new reports in csv format.

We require an immediate solution to create reports in csv format. Could you please look into this ASAP and please provide us a sample script or any kind of effective guidance.

Thanks in Advance.

 

by Robert Goldenbaum
Badge for 'Question Solver' achievement
Posted on Thu, 02/04/2016 - 12:13

Hi,

you could try to generate a txt file and then just rename it to csv (or change the extension in ARIS to csv) - this should work.

BR Robert

0
by Diego Labrador
Posted on Thu, 02/04/2016 - 21:06

Hi

When you create the report, change the constant values for the type of file and, as Robert said, change the name to FILE.csv. This is an example:

// Create a CSV file
var csv = Context.createOutputObject(Constants.OutputTXT,"AplicacionesPorDBMS.csv");
// Write a line, in this case, the split char is ";"
// XX, YY and ZZ are the values you want to write in the report
csv.OutputLn("XXXX;YYYYY;ZZZZZ","Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 0);

Hope this help

Regards

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks
  • Profile picture for user frankweise
  • Profile picture for user Henrik Buckler
  • Profile picture for user UffeK
  • SS
  • MZ
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock