Enabling ControlPoint Insert Configuration

2 Likes

ISSUE:

ControlPoint allows mapping fields with the target repositories of information. With that, you can send metadata captured by ControlPoint to the target application. For example, you collect social security numbers from documents with entity extraction function; Insert Configuration will allow you to send this value to Content Manager when you do an action to create a record in CM. Insert Configurations are defined in ADMINISTRATION.

Insert Configuration is disabled by default on a new installation.

HOW TO STEPS:

Go to the scheduler install folder, by default: C:\Program Files\Micro Focus\ControlPoint\Engine\Scheduler.

Edit the configuration file ControlPointTimer.exe.config.

Look for…

<add key=”InsertConfigEnabled” value=”false” />

Change it to…

<add key=”InsertConfigEnabled” value=”true” />

A restart of the ControlPoint Engine service is needed to pick up the change.

Note: To map field with Content Manager you can have a look at this post.

Labels:

How To-Best Practice
Comment List
Parents
  • Hi Erik,

    You need to map from a MetaStore field into CM. As AU_DOCUMENT_KEYWORDS_STRING  is an IDOL field it will not work. There is a process to add additional MetaStore fields (during ingestion) by mapping from IDOL fields. Please see the steps in the following Knowledge Doc 

    As an example, for the AU_DOCUMENT_KEYWORDS_STRING field, you would need to perform the following:

    1 - Add a new column to the ControlPointMetadata.Additional table to support the capture of the AU_DOCUMENT_KEYWORDS_STRING string value by running the following SQL:

    USE ControlPointMetaStore
    GO
    ALTER TABLE ControlPointMetadata.Additional
    ADD DocumentKeywords NVARCHAR(255) NULL ---you can call the MetaStore field whatever you like. Can match the source IDOL field if it suits
    GO


    2. Configure AU_DOCUMENT_KEYWORDS_STRING data mapping using the MetaStore.MapField stored procedure by running the following SQL:

    USE ControlPointMetaStore
    GO
    EXEC MetaStore.MapField
    @SourceName = 'AU_DOCUMENT_KEYWORDS_STRING',
    @TargetTable = 'ControlPointMetadata.Additional',
    @TargetColumn = 'DocumentKeywords ',
    @TargetTransform = 'ToString'
    GO


    3. Refresh document ingest, import and update sequences to support the newly captured AU_DOCUMENT_EDITOR_STRING field in MetaStore by running the following SQL:

    USE ControlPointMetaStore
    GO
    EXEC MetaStore.ConfigureAddDocument
    EXEC MetaStore.ConfigureUpdateDocument
    EXEC ControlPointMetadata.ConfigureImportDocument
    GO


    4. Restart the "ControlPoint Metastore" service to utilize the refreshed sequences.

    Note: The steps above will ensure that the new MetaStore field will be captured for new document files being ingested. Existing data however will need to be re-ingested in order to capture values for this field.
    I have found that an IIS restart is required before I can see the new field in the Advanced Properties list. Once you are happy the MetaStore field has been created successfully and the values are mapped over to it, then use this MetaStore field to Map to CM.

    Regards,
    Keith

     

     

Comment
  • Hi Erik,

    You need to map from a MetaStore field into CM. As AU_DOCUMENT_KEYWORDS_STRING  is an IDOL field it will not work. There is a process to add additional MetaStore fields (during ingestion) by mapping from IDOL fields. Please see the steps in the following Knowledge Doc 

    As an example, for the AU_DOCUMENT_KEYWORDS_STRING field, you would need to perform the following:

    1 - Add a new column to the ControlPointMetadata.Additional table to support the capture of the AU_DOCUMENT_KEYWORDS_STRING string value by running the following SQL:

    USE ControlPointMetaStore
    GO
    ALTER TABLE ControlPointMetadata.Additional
    ADD DocumentKeywords NVARCHAR(255) NULL ---you can call the MetaStore field whatever you like. Can match the source IDOL field if it suits
    GO


    2. Configure AU_DOCUMENT_KEYWORDS_STRING data mapping using the MetaStore.MapField stored procedure by running the following SQL:

    USE ControlPointMetaStore
    GO
    EXEC MetaStore.MapField
    @SourceName = 'AU_DOCUMENT_KEYWORDS_STRING',
    @TargetTable = 'ControlPointMetadata.Additional',
    @TargetColumn = 'DocumentKeywords ',
    @TargetTransform = 'ToString'
    GO


    3. Refresh document ingest, import and update sequences to support the newly captured AU_DOCUMENT_EDITOR_STRING field in MetaStore by running the following SQL:

    USE ControlPointMetaStore
    GO
    EXEC MetaStore.ConfigureAddDocument
    EXEC MetaStore.ConfigureUpdateDocument
    EXEC ControlPointMetadata.ConfigureImportDocument
    GO


    4. Restart the "ControlPoint Metastore" service to utilize the refreshed sequences.

    Note: The steps above will ensure that the new MetaStore field will be captured for new document files being ingested. Existing data however will need to be re-ingested in order to capture values for this field.
    I have found that an IIS restart is required before I can see the new field in the Advanced Properties list. Once you are happy the MetaStore field has been created successfully and the values are mapped over to it, then use this MetaStore field to Map to CM.

    Regards,
    Keith

     

     

Children
No Data
Related
Recommended