Visokio website     Downloads     Video tutorials     KnowledgeBase  
Idea: Outputs - Dynamic file names - Visokio Forums
Idea: Outputs - Dynamic file names
  • VoteVote Up7Vote Down edtclarke     edtclarke January 9, 2012 5:05AM
    Would it be possible to add some more complexity into the [File Output] block to enable some dynamic file naming, specifically the ability to use the unique value of a specified field as part of the file name.

    For example, if the data contained a field called [Week] which was populated by a value [50] for the current file being processed. In the output block you could then specify the file name to be something like:
    "Weekly data for week(s)" + SUBSET_UNIQUESLIST([Week]) = [Weekly data for week(s) 50.iok]

    When the next file is processed the file produced would then be named [Weekly data for week(s) 51.iok]
    Atheon Analytics Ltd
    w: www.atheonanalytics.com
    e: ed.crawford@atheon.co.uk
    t: +44 8444 145501
    m: +44 7789 393 087
    s: edtclarke
  • 4 Comments
  •     chris January 9, 2012 5:27AM
    Hi Ed,

    Thanks for the question. In the file output block you can add a timestamp to the file name by selecting the "Add file timestamp" button. You can then choose the format of the timestamp.

    For fully customisable dynamic file naming you will need to create a DataManager workflow that generates a batch output configuration file. You can use a formula field for the "File name" batch command field, enabling you to dynamically specify the name.

    The "Field organiser" block provides an easy way to populate all of the fields from the batch configuration file. Simply click the "Tools" button at the bottom and then choose
    "Add batch publisher command file fields.". Please note that you only need to include the fields that you need to use (output type, directory, file name etc.).

    After running this workflow you simply need to run a second workflow that contains a "Batch output" block linked to the newly created batch configuration file.

    The method described above is hugely powerful, as not only can it be used to customise the file name, you can also use it to dynamically customise any other batch configuration data, for example the filters and even the individual output rows themselves.
  • edtclarke     edtclarke January 9, 2012 5:41AM
    Thanks Chris, I'll have a play with it but it would be useful to have the functionality in the single file output block as it would cut down on the steps involved in achieving this.
    Atheon Analytics Ltd
    w: www.atheonanalytics.com
    e: ed.crawford@atheon.co.uk
    t: +44 8444 145501
    m: +44 7789 393 087
    s: edtclarke
  •     steve January 9, 2012 12:30PM
    Ed, this is a good idea - to summarise: allow "Formula" option for output filename (& folder?) generation.
  •     sherriff March 2, 2013 6:57AM
    Just wondering if there is an update as to how to do easy dynamic Output file naming.

    I understand that the Batch Configuration File and Batch Publish is very powerful and flexible but it takes a while to figure out and get it to work well. Whereas many users probably would be happy just to set the Output file name by linking to a Data Field with a unique value.

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership