Content Management and Capture

 View Only
  • 1.  Content Collector Settings

    Posted Fri September 18, 2020 11:11 AM
    Edited by David Powell Fri September 18, 2020 11:29 AM
    We are in the process of migrating from one ECM Solution to FileNet.  One of the options we used in our old system was for a folder to sweep a file and assign properties based on the name of the file.  My question is this, can ICC do this same function where it will assign Metadata/property info based on the file name.  For example the file name could be Grey^House^47^IBM Drive.pdf  where I am looking to have the ^ be the separator for each property.  so it would read the file like <Color>^<Building>^<AddressNumber>^<AddressStreet> as assign those metadata fields to property templates within the Document Class when creating the file inside FileNet

    I believe I found where I need to do this at under the FSC Associate Metadata task and in the Metadata File Name>Regular expression applied to document name for Match Pattern.  Not sure the context to use here and I am not finding much documentation on it.


    ------------------------------
    David Powell
    ------------------------------


  • 2.  RE: Content Collector Settings

    Posted Tue September 22, 2020 01:37 AM

    This is possible with regular expressions.. 

    Check Section "Replacement regular expressions" in this link 

    https://www.ibm.com/support/knowledgecenter/en/SSAE9L_4.0.0/com.ibm.content.collector.doc/expression_editor/r_afu_regular_expression_samples.htm

    For your case it would be like this 

    Regex: (\w*)\^(\w*)\^(\w*)\^(\w*)(.pdf)
    Sample filename: Grey^House^47^IBMDrive.pdf

    Replacement String:

    $1 => Grey 

    $2 => House

    $3 => 47 

    $4 => IBMDrive



    ------------------------------
    DHANANJAYA MADIRAJU
    ------------------------------



  • 3.  RE: Content Collector Settings

    Posted Tue September 22, 2020 07:59 AM
    Thank you! this was a huge help

    ------------------------------
    David Powell
    ------------------------------