Review M-Files on G2 & get a $25 gift card Arrow right Review us!

Options
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Locked Locked
  • Replies 4 replies
  • Subscribers 11 subscribers
  • Views 1658 views
  • Users 0 members are here
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Text analytics - FilePathPattern to a value list

Adrian Crossing

Hi Team,

I've spent a lot longer on this that I'd care to admit.

I have a requirement to extract a specific folder name from the FilePathPattern and have this set the "Quarter Ending" property which is a Value List containing 4 dates:

31 Mar, 30 Jun, 30 Sep, 31 Dec

And the FilePath is in the format \\server\share\31 Dec\scanned_document.pdf

I have my regex that is retrieving the date element from the FilePath correctly (tested by having this add to a standard Text property. But when I configure this to return the value to the "Quarter Ending" property (which is a Value List) nothing happens.

1st Question, is this even possible?

2nd Question, if so should Text Analytics be able to do this, or should I also require Matcher?

3rd Question, why doesn't it work? Slight smile

Any assistance would be appreciated. I've been stuck on this for weeks.

Parents
  • 0

    Have had a similar request a while back. My solution was to save the extracted value in a text property and then in the next step of a workflow to run a script that uses this text value in a search to find the corresponding lookup value and insert that in the lookup property.

    It might be simpler for you to use Matcher if the documents do not contain a lot of dates. If they do, Matcher may provide false suggestions based on dates found in the document.

  • 0 in reply to bright-ideas.dk

    Hi, Thanks for the reply. 

    So basically Text analytics cannot populate a value list property? 

    I'm not sure I can use Matcher, because the date is coming from the file path, using Smart Migration (Sorry I missed this bit) that is why I'm using Text Analytics and regex.

  • 0 in reply to Adrian Crossing

    Yeah, Matcher can only work with the document content so when working with file paths you need to use Text Analytics.

  • +1 in reply to Joonas Linkola

    Thanks Joonas, 

    Our M-Files Sales engineer confirmed the same. And Text Analytics cannot be used to populate a value list based property :(


    We have come up with a dirty work around. I'm using Text Analytics to get the data we need and fill in a temporary text property (hidden from the metadata card) and then use PropertyCalculator to set the correct value in the value list based on the text in the hidden property. 

    Maybe this might help someone else one day :)

Reply
  • +1 in reply to Joonas Linkola

    Thanks Joonas, 

    Our M-Files Sales engineer confirmed the same. And Text Analytics cannot be used to populate a value list based property :(


    We have come up with a dirty work around. I'm using Text Analytics to get the data we need and fill in a temporary text property (hidden from the metadata card) and then use PropertyCalculator to set the correct value in the value list based on the text in the hidden property. 

    Maybe this might help someone else one day :)

Children
No Data
M-Files
M-Files Support


© 2024 M-Files, All Rights Reserved.