Parsing out a file name for import into DocuWare-1534430724

I have a customer that has information in the file name that fills out the only two indexes they need, but i can't parse out the info through document processing. They currently drop these files into a folder and it indexes the documents. Any ideas?

Example File Name:

"Cigna - 10/20/17"

 

Indexes:

Carrier: Cigna

Posted Date: 10/20/17

Hey Jay,

is it a cloud or an on premise system?

You can split the document name with workflow manager or with autoindex.

Best Regards

Martin

HI,

Other idea, you write a Powershell script to get the file name, split it in two values which are used to generate a .dwcontrol file.

Then you just have to push orginal file + dwcontrol file in a folder used by a DW Deskstop Import task

If the volume is high, the other idea is to write a program using DW SDK, that's more efficient and easier to monitor in case of error during upload.

Best regards

Gilles

This is a cloud account. Any direction on how to do this through AutoIndex or Workflow would be greatly appreciated.

Not a high volume so trying to find an easy way. Great ideas.

Jay,
Here is a link to a document I did recently to use a simple workflow to filter an index value. You will use the same principal to extract the parts of the index field containing the file name. You just need to extract the string parts either side of the hyphen.
The workflow is triggered on storage of a document with a specific field empty, in your case, I would trigger it on the filename field containing a hyphen, and the 2 target field being empty.
If your date field, is a true date field then you need to convert the extracted field to a date otherwise the assignment may fail.

https://drive.google.com/open?id=1UhGW59Gerav6P96Q4M3G4cOHdFNZBqZa

Check out the document, and if you need any guidance, just post here.

 

Phil Robson
Senior Director Support Americas

That worked perfectly! The only issue i am having now is getting it from a text field to a date field. They are using this format for thier date now.

09-02-18

Ok, so the date is in standard European format. Are they in Europe? Dates are formatted based on the user region. Can you clarify why the date in the file is in standard US format?
In any event, you need a data assignment step after you extract the string date to a variable.
Create a Date variable, and then assign the string date variable to it with a conversion like this:

GV_Date_Var = CDate(GV_String_Date_Var)

Phil Robson
Senior Director Support Americas

HI looking to do something similar to Jay's original post,  the google doc Phil mentioned is no longer available. 

https://drive.google.com/open?id=1UhGW59Gerav6P96Q4M3G4cOHdFNZBqZa

 any help would be appreciated 

Tony