Creative Communities of the World Forums

The peer to peer support community for media production professionals.

Activity Forums Square Box CatDV Auto incrementing a number to a file in CATDV Worker

  • Auto incrementing a number to a file in CATDV Worker

    Posted by Gene Bauer on May 20, 2014 at 1:29 pm

    In Worker we’re trying to catalog a file, create a proxy and have a unique sequential number added to both the full res and proxy. I’m not seeing a way to do this with the choices available in the preprocessing tab. We have a CATDV 10 Pro running on a MAC with MYSQL…Thanks in advance for any help.

    Dougal Matthews replied 11 years, 12 months ago 3 Members · 2 Replies
  • 2 Replies
  • Matthew Stamos

    May 20, 2014 at 10:30 pm

    The new worker has more bulk edit feature but not this one yet. Of course you could do this with the bulk edit tool in CatDV Pro Client. One thought I would toss in is using a couple date and time stamp variables as those would be unique numbers. $T for time and $D for date come to mind there are other variables that maybe useful that I am less familiar with in $u and $U. Maybe SqaureBox could chime in here and add some detail or alternative approaches.

  • Dougal Matthews

    May 21, 2014 at 5:16 pm

    hi Gene

    Firstly every file brought into catdv gets a unique id called a clip Id and the proxy is tide to this file by pathing so you already have a unique identifier set up in catdv and this can be set to be visilbe in your user views

    you don’t say if you want to add the number as metadata or as a file name, either way you can use variables, as matt says there are a few options creating a custom string using date – time and you own characters or using unix style

    eg
    $u A long Unix timestamp that could be used to create a ‘unique’ filename

    $U A unique name dervived from the current timestamp, shown as letters and digits

    $D Current date as yyyymmdd, eg. 20081231

    $M Current year and month as yyyy mm, eg. 2009 01

    $T Current time as hhmmss, eg. 235959

    see here for more details https://www.squarebox.com/using-variables/

    to either append or replace the file name ( choose rename – expand variables on the conversion tab ) see image

    or to add variables to metadata see this tutorial for a guide

    https://www.squarebox.com/using-metadata-from-paths/

    If you really do want to use a external sequential number you could create a text file called counter.txt read a value from this file, append this to a filename /metadata field using worker and then increment the counter by one ready for the next file, using shell scripting on a mac or batch scripting on a pc.

    a good sysadmin should be able to knock this up for you fairly easily

    i hope this helps you achieve your aims

    good luck

    dougal

    Improvise Adapt and Overcome

We use anonymous cookies to give you the best experience we can.
Our Privacy policy | GDPR Policy