Content Management and Capture

 View Only
  • 1.  Updating custom column

    Posted Wed March 30, 2022 07:07 AM

    Hi

    From tech note: https://www.ibm.com/docs/en/datacap/9.1.9?topic=administration-creating-custom-column-in-job-monitor

    We can use pilot.XtraBatchFieldValue action to update custom column.

    Can I have a sample custom action that could call this action to update datacap custom column?

    Any kind of assistance is very much appreciated



    #IBMDatacap
    #Support
    #SupportMigration


  • 2.  RE: Updating custom column

    Posted Wed March 30, 2022 08:48 PM

    No because batch pilot code are all gone. I believed starting from Dcap 8.x release?

    Use the technote.



    #IBMDatacap
    #Support
    #SupportMigration


  • 3.  RE: Updating custom column

    Posted Thu March 31, 2022 08:07 AM

    Tank you for the reply

    We are migrating from 9.1.1 to 9.1.9

    We are using db2 as our database

    In 9.1.1, our rrx script did do the job to update the custom column, but the same rrx script did not update. Here are the script:

    <f name="InsertCustomColumn" access="public" bInter="bInter" bDebug="bDebug" strParam="StrParam" qi="Saves demo line item data to demo database">

    <p name="ColumnName"/>

    <p name="ColumnValue"/>

    <ap>

    None<br/>

    </ap>

    <h>

    Saves records to demo database. Do not use for production.<br/>

    <e>

    </e>

    </h>

    <lvl>

    Lineitem field only.

    </lvl>

    <ret>

    True. <br/>

    </ret>

    <see>

    </see>

    <g>

    <![CDATA[

    Pilot.XtraBatchFieldValue(ColumnName) = Metaword(ColumnValue)

    ]]>

    </g>

    </f>

    In the logs, the function returns true (which I assume run correctly) for both datacap version but only the old 9.1.1 updates the custom column.

    I also tried to add custom action in our existing custom library (.dll) :

    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;

    }

    This action also return true for the 9.1.9 version without updating the custom column. Is there somewhere I missed which can help me troubleshoot the current situation?

    TQ



    #IBMDatacap
    #Support
    #SupportMigration


  • 4.  RE: Updating custom column

    Posted Thu March 31, 2022 03:24 PM

    You must be using the verify panel or scan panel to update the custom column?

    There are DDK and custom panel you must use when creating custom action or custom panel. Have you looked into the ddk and there are example to creating custom action.

    https://github.com/ibm-ecm/datacap-developer-kit

    Make sure you use the right version and review the custom action guide.



    #IBMDatacap
    #Support
    #SupportMigration


  • 5.  RE: Updating custom column

    Posted Fri April 01, 2022 04:03 AM

    Thank you for the reply


    This custom action to update custom column runs as a backend task (rulerunner). As it is working custom action, and we are only migrating from 9.1.1 to 9.1.9, do we need to create custom action from scratch? We do have a COM custom action library which we recompile to the target .NET framework 4.7.2 (9.1.9 requirement). We just add the UpdateJobMonitor action into the pre-existing custom action library.


    Aside from the custom action, we use db2 as our database. We created the custom columns as well added it to the repository in ICN (which allow us to see the custom column in the job monitor in desktop). As to our prior experience with db2, the database is case sensitive. Just wondering if this fact could be the reason data could not be updated to the database?


    Your assistance is very much appreciated


    Your kind assistance



    #IBMDatacap
    #Support
    #SupportMigration