Hi Community,

   Can someone give me a sample on how to fill the Excel import template to import an excel to ARIS for BPMN models.



by Ed Swiatkowski
Posted on Thu, 12/21/2017 - 17:10

Hi Subash,

Were you ever able to find a sample or additional information regarding how to fill the Excel import template to create objects in ARIS? I am also trying to figure out how to use this functionality but I haven't been successful with finding anything useful to guide me with this task.




by Nicholas Tan
Posted on Fri, 12/22/2017 - 04:07

i've got something working just recently,

you can look at this sample code:

var locale = Context.getSelectedLanguage();

var models = ArisData.getSelectedModels([Constants.MT_EERM])[0];

var db = ArisData.getActiveDatabase();

var template = Context.getFile("Template.xls",Constants.LOCATION_COMMON_FILES);

var xlsBook = Context.createExcelWorkbook(models.Name(locale)+".xls",template);

var setting = xlsBook.getSheets()[0];

var row=1;

var oEntityOccs = models.ObjOccListFilter(Constants.OT_ENT_TYPE);

for(var m = 0; m < oEntityOccs.length; m++) { 

    var pEntityName = oEntityOccs[m].ObjDef().Name(locale);


    var oCxnOccs = oEntityOccs[m].CxnOccList();

    for (var n = 0; n < oCxnOccs.length; n++)


        var oSourceObjOcc = oCxnOccs[n].SourceObjOcc();

        setting.cell(row, 1).setCellValue(pEntityName);

        setting.cell(row, 2).setCellValue(oSourceObjOcc.ObjDef().Name(locale));

        setting.cell(row, 3).setCellValue(oSourceObjOcc.SymbolName());

        setting.cell(row, 5).setCellValue(oSourceObjOcc.ObjDef().Attribute(Constants.AT_LEN_1,locale).getValue());

        setting.cell(row, 6).setCellValue(oSourceObjOcc.ObjDef().Attribute(Constants.AT_DATA_TYPE,locale).getValue());

        setting.cell(row, 7).setCellValue(oSourceObjOcc.ObjDef().Attribute(Constants.AT_DESC,locale).getValue());


        row = row + 1;





Featured achievement

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


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