Datacap132 Comments on Creating a custom column in Job Monitor for IBM Datacap

If you want to show custom columns in your applications job monitor there are several things to do.

  • At first you need to add the required coulmn to you applications engine database table TMBATCH. Please keep in mind that only STRING or INTEGER columns are supported. As a prefix PB_ for the coloumn name is required. E.g. PB_VENDORNAME. Please create the column name also in upper case letters.
  • After you added the new column(s) you also need to update the database views JMView and JobMonitor.
  • Now you can select the new column in the repository settings in content navigator. Iin my case the columns are called PB_NL and PB_KASSENTAG
Datacap Application configuration in Content Navigator repositories

Now comes the more difficult part. Because you cannot use existing SQL action from datacap to update these columns. If a task completes the batchpilot will overwrite the update columns with empty fields. The solution is to write a custom action to update the batchpilot information so that the information persists in the engine database.

I wrote a custom action in .NET. The following code function is used to update the Batchpilot

public bool UpdateJobMonitor(string column, string value)
        {

            dcSmart.SmartNav localSmartObj = new dcSmart.SmartNav(this);
            string input = localSmartObj.MetaWord(value);
            /// BatchPilot.set_XtraBatchFieldValue(column, input); ///
            DatacapRRBatchPilot.set_XtraBatchFieldValue(column, input);
            WriteLog("SmartNav: " + this);            
            WriteLog("TIMETOACT Setting Column: " + column + " To Value: " + input);
            
            return true;
        }

In the TheRRX.rrx file I added the following

<method name="UpdateJobMonitor">
      <p name="Spaltenname" type="string" qi="Der Name des Feldes aus dem gelesen wird.  Smart parameters are supported."/>
      <p name="Feldname" type="string" qi="Der name der Spalte die im JobMonitor geschrieben wird.  Smart parameters are supported."/>

      <ap>
        Updates the TMBATCH table with custom values for BatchPilot.
      </ap>
      <h>
        Eingabe von Spaltenname und Feldname<br/><br/>

        <e>
          <b>UpdateJobMonitor("PB_NIEDERLASSUNG,@P\Niederlassung")</b><br/>
          Smart Parameter erlaubt.
        </e>
      </h>
      <lvl>All levels.</lvl>
      <ret>
        <b>True,</b> if the action succeeds.  Otherwise, <b>False.</b>
      </ret>
    </method>

Here I read a fileds value and pass this as “input” variable to the action to update the batchpilot.

132 thoughts on “Creating a custom column in Job Monitor for IBM Datacap”

  15. Just a smiling visitor here to share the love (:, btw great style. “Competition is a painful thing, but it produces great results.” by Jerry Flint.

  16. Turniket – Tuniket sistemləri hər yerdə giriş çıxışı nəzarətini təmin etməkməqsədi ilə istifadə edilməkdədir.Stadionlarda,Otellərdə,iş yerlərində,idman zallarında,qisacası izlənmə təmin edilmək istənən bütün yerlərdə istifadə edilməktədir

  41. Hello There. I discovered your blog the usage of msn. That is a very neatly written article.I will be sure to bookmark it and come back toread more of your helpful info. Thanks for the post.I’ll definitely comeback.

  56. I haven’t checked in here for soe time because I thought it was getting boring, but the last srveral posts are good qualiryso I guess I will add you back to my daily bloglist.Youdeserve it my friend

  58. Amazing! This blog looks exactly like my old one!It’s on a totally different subject but it has prettymuch the same layout and design. Outstanding choice ofcolors!

  75. Hey There. I discovered your blog the usage of msn. This is an extremely well written article. I will be sure to bookmark it and come back to read extra of your helpful information. Thank you for the post. I will certainly return.

  86. What’s Happening i am new to this, I stumbled upon this I’ve found It absolutely helpful and it has helped me out loads. I hope to contribute & assist other users like its helped me. Great job.

  91. Great post however , I was wondering if you could write a litte more on this topic?I’d be very grateful if you could elaborate a little bit further.Kudos!

  98. IOCL Recruitment 2019 1574 vacancies Apprentice Posts – JOB DESK INDIA ivermectin for humans amazon stromectol ivermectin tablets for humans uk stromectol vloeistof

  100. We are searching for some people that are interested in from working their home on a full-time basis. If you want to earn $100 a day, and you don’t mind creating some short opinions up, this might be perfect opportunity for you!

  101. We are looking for some people that are interested in from working their home on a full-time basis. If you want to earn $200 a day, and you don’t mind creating some short opinions up, this might be perfect opportunity for you!

  105. When some one searches for his required thing, thus he/she wishes to be available that in detail, thus that thing is maintained over here.

  107. It’s going to be ending of mine day, except before ending I am readingthis great piece of writing to improve my knowledge.

  116. Describe in well mannered language, if as an example your accountsimply cannot log in for causes such as a person over.mobile legends account free 2021 Lvl 30 Accountmobile legends account free

  117. Don’t just upload 1, sometimes 2 videos, upload a multitude of videos. The shorter the recording the better of the opportunity you have of much less watching. Having a watermark in your video works wonders.

  119. I needed to thank you for this excellent read!! I absolutely loved every littlebit of it. I have you book marked to look at newthings you post?Here is my blog … Hyper XXL Pills

  122. This is a really good tip particularly to those new to the blogosphere.Short but very accurate information

  130. Hi, I do believe this is an excellent blog. I stumbledupon it 😉 I’m going to come back once again since I book-marked it.Money and freedom is the greatest way to change, may you be rich and continue to guide other people.

  131. Hi my friend! I want to say that this post is amazing, nice written and include almost all significant infos. I¦d like to look extra posts like this .

Leave a Reply

Your email address will not be published. Required fields are marked *