Page 1 of 1

Any idea on how to create...?

Posted: Wed Aug 30, 2017 1:51 am
by Zoranj
Does anyone have an idea on how to create flow when file is passing through, it picks up number from list (csv, xml, etc..) than it gets renamed by appending that number.
Perhaps it might be simple thing I am overlooking.

I want to have list that csr can manually update, e.g. in csv or xml file.
List would be 12 entries for a year, 12 monthly docket numbers.
This could be weekly thing.

When file passes through the flow, it should check the present date for a month, than look up the list and see what docket number is for that month.
File than gets renamed by appending docket number to file and it gets processed accordingly.

Any ideas?

Thanks

Re: Any idea on how to create...?

Posted: Wed Aug 30, 2017 10:35 am
by loicaigon
Hi

You can manage this using many methods

Using Metadata module with xml file
Then you can capture XML and associate ticket with job. Later rename the job accordingly

Using scripting module
A script can then check for current date, parse txt or xml file and rename the job accordingly

Using database module
You store the specific string in some table and get it through a sql request

Using configurator module
With command line tool, you can call a bash script that will do same as scripting.

It's all I can think of so far.

Re: Any idea on how to create...?

Posted: Wed Aug 30, 2017 9:13 pm
by Zoranj
I am not good with scripting and I don't have database module.
That leaves me with metadata.
I'll play around, thanks

Re: Any idea on how to create...?

Posted: Wed Aug 30, 2017 9:27 pm
by gabrielp
Sounds like this is exactly what CSV Lookup was designed for: https://www.enfocus.com/en/appstore/product/csv-lookup

Re: Any idea on how to create...?

Posted: Thu Aug 31, 2017 9:17 am
by loicaigon
Yes Gabriel, I had the feeling it existed but couldn't find it on the appstore. So I didn't mention it :P