CF

I will show you a very simple script to update data from Word files. Sometimes you may need update an object atribute (e.g., Description) from a Word document previously generated, this works for me:

Import POI library

    var importer = JavaImporter(

    Packages.java.io.File,

    Packages.java.io.FileInputStream,

    Packages.org.apache.poi.hwpf,

    Packages.org.apache.poi.hwpf.HWPFDocument,

    Packages.org.apache.poi.hwpf.extractor.WordExtractor,

    Packages.org.apache.poi.hwpf.usermodel.TableIterator

    );



Open Word file

    var docFile = new java.io.File([Word Document]);

    var fis = new java.io.FileInputStream(docFile);

    var doc = new importer.HWPFDocument(fis);

Iterate tables and rows in document

    var range = doc.getRange();  

    var ti = new importer.TableIterator(range);

    ArisData.getActiveDatabase().setAutoTouch(false);

    //Iterate tables in document

    while(ti.hasNext()) {

        var table = ti.next();

       

        //Iterate rows in table

        for (var rowIdx=0; rowIdx<table.numRows(); rowIdx++) {  

            var row = table.getRow(rowIdx);  

            var cell = row.getCell(0);

            var sid = cell.getParagraph(0).text();

           

Search and update the attribute



            //Search item in EPC model

            bitemisvalid = __toBool(getitembyid(ocurritem, sid));

           

            if (bitemisvalid) {

                //Get description attribute

                ocurrattr = ocurritem.value.Attribute(Constants.AT_DESC, g_nloc);

               

                if (ocurrattr.IsValid()) {

                   

                    var svalue = getCellText(row.getCell(1));

                   

                    changeAutoTouch(ocurritem.value);

                   

                    //Update attribute value

                    if (ocurrattr.setValue(svalue) == false) {

                   ...

 

    ArisData.getActiveDatabase().setAutoTouch(true);

 

Best regards,

by nicolas cofre
Posted on Fri, 10/22/2010 - 04:44

Hi, hola

Esta parte de ARIS, lo que es scripting resulta ser muy emocionante y util. Me gustarìa aprender mas. Gusta.. me habló de ti y veo que dominas el tema.

Saludos y un abrazo.

 

 

nico

0
by Cristian Franzin Author
Posted on Wed, 10/27/2010 - 23:21

Hola, si es interesante lo que se puede hacer con el modulo de scripting, hay buenos articulos aca para aprender, saludos a Gustavo

Saludos!!! 

0
by Ilya Seletkov
Posted on Tue, 07/23/2013 - 04:41

Hello! 

Just for info.

I'm using ARIS release 7.2.0.554169. When I tryed to use appache POI for *.doc (HWPFDocument or XWPFDocument) I faced issue:

"method <init>()V not found".

I've resolved this by updating POI-*.jar libraries in ARIS server's lib directory. Newest version of POI libraries could be found here.

Hope, this helps smbd.

0
by Cristian Franzin Author
Posted on Mon, 07/29/2013 - 17:53

Hi Ilya, thanks for the info!

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

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