In your scenario above, for example, you’ll need to do a substitute function on the = character to get the different parts of your shot. I don’t normally split out the different parts of my shot ID into separate fields, I’d leave ST0020 all in one field in the database. That way the shot ID is nice and short, it’s easy to type since there are no special characters to deal with, and it’s easy to search and to script, too. For example, ST0020 could be the second shot in a sequence I’d describe as Shooting Things.
For that reason, and because I don’t like typing or saying more than I have to, I usually used the shot ID convention of 2 letters for a sequence ID followed by 4 numbers for the shot in that sequence. It’s been a while since I’ve been a VFX editor, but I generally entered shots into my database by hand, and then exported a bin containing shot elements as a tab-delimited file so I could automate that import and let Filemaker link the elements to the shots automatically. I would check out string splitting functions (, e.g.), so you can import your VFX list directly without doing any find/replace first and let Filemaker handle sorting your VFX naming scheme into separate fields. For this reason, we created our own subtitles/captions converter. A lot of our clients need to have their SRT caption or subtitle files converted into other formats so that they could be used with various types of software. In terms of your database, I can only make some educated guesses about the system you have in place, but I am sure that there is a more efficient way to import into Filemaker. Convert Captions or Subtitle Files to Different Formats Online. If you want just the VFX number and not “ADD”, then the space needs to be before “ADD”. The site parses words by spaces, as you’ve figured out, so the reason you can’t use 0 words from the title is because then there would be no text at all in the subcap. Input Fill Sample | Clear Correct for bug in Avid MC 8.3.1+ If for some reason your EDL doesn't produce the expected results, please e-mail me a copy so I can take a look at it. Remember to Commit Multicam Edits before making your EDL! There is an explanatory post for this called Automating VFX Sequence Titles, and that as with this owes its origination to George McCarthy. Once you paste your EDL into the input field, you'll be presented with options to exclude certain locator colors, or to add a prefix or suffix to the title text for any given locator color. For example, if you wanted to add " - NEW" at the end of every green locator, you could do that. This tool takes an EDL as input (paste it in), and converts it to Avid DS Subtitle format, which is one of the two formats you can supply to Avid's SubCap effect. This site will remain online, but all future development will happen on the new site. Please start to use that, and let me know if you run into any problems. I've released a new version of this tool at /tools.
0 kommentar(er)
