IBM Content Platform Engine (CPE)

IBM FileNet Bulk Search and Update in Existing Document Class

December 9, 2019

Sometimes to meet the users requirements, we have to perform bulk operations such as; FileNet P8 bulk search and update existing document class(es) property value(s). Users want to add a new property to particular document class and want to update the existing records to populate this into new property.

There are three mechanisms to achieve this requirements;

  1. FileNet Bulk Search and Update using FileNet vbscript.
  2. Sweep jobs in FileNet or FileNet custom sweep job.
  3. Set document property using JavaScript.

Here we are illustrating FileNet Bulk Search and Update using FileNet vbscript. You can configure as followed to add the new property template to the existing class and documents:

  • Add a new property template via FileNet Enterprise Manager (FEM) or FileNet ACCE.
  • Go to your document class – Property Definition tab and add the new property template to it then refresh the object store.
  • The new property template will be added to the existing document but contains no value.
  • To update the property value of several objects at the same time for the existing documents, you can use the Content Engine Enterprise Manager’s Search feature. First, using the Enterprise Manager, you will need to determine the Symbolic Name of the property that you want to modify. To do this, select the property under the “Property Templates” node and look for the value for the “Symbolic Name” property on the Properties tab.
  • Perform the new search and define the criteria for the new search.
ibm filenet object store search
filenet content engine query builder
ibm filenet sql

Once search completed with results, do the following step by step.

filenet enterprise manager multi select operations

Select all the results values and perform multiselect operations option as mentioned above.

Bulk Operations window will be prompted, go the the script tab and paste the following script in the FileNet vbscript window (Please change the symbolic name of the property value according to yours):

 Public Sub OnCustomProcess (CEObject) 
CEObject.DHA_Br_Ingestion = "BC"
CEObject.Save
End Sub
filenet vbscript
filenet bulk search and update

To confirm the FileNet bulk search and update results, try to search again you will see new property value is updated accordingly.

filenet bulk search and update

Query:

For further confirmation, you can also query from filenet docversion table. Here is the query:

select COUNT(docversion.u0398_dha_br_ingestion) AS TOTAL, classdefinition.symbolic_name 
from docversion, classdefinition
where docversion.u0398_dha_br_ingestion IN ('BC','Tfr')
and docversion.object_class_id = classdefinition.object_id
group by classdefinition.symbolic_name
UNION ALL
SELECT SUM(TOTAL), 'SUM of All' from (
select COUNT(docversion.u0398_dha_br_ingestion) AS TOTAL, classdefinition.symbolic_name
from docversion, classdefinition
where docversion.u0398_dha_br_ingestion IN ('BC','Tfr')
and docversion.object_class_id = classdefinition.object_id
group by classdefinition.symbolic_name
)
a
docversion table filenet p8

In next post, I’ll share other two options; custom sweep job and set document property using JavaScript. For information about FileNet bulk search and update please refer to following Tech notes:

You Might Also Like

1 Comment

  • Reply lintex Jones September 25, 2020 at 9:17 am

    Appreciate the recommendation. Will try it out.

  • Leave a Reply

    error

    Subscribe