ARIS - Q&A Session 9:00am CEST
ARIS - Q&A Session 6:00pm CEST

View all

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, tags, liking a post and uploading a profile picture.
Recent Unlocks


Weekly | All-time
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