-
Using a CSV with time information to determine layer and comp timings
I’m new to expressions (and coding), but have worked through controlling alignment, parented font styles, linking csv data dynamically using the comp name as the variable, expression controls and a number of other simple things with master controls, but I’m beginning to think I have a fundamental misunderstanding of a couple of key elements, so my apologies if this is super basic.
I’ve set up an excel spreadsheet where my team can enter textual content for ‘text-style’ animations for social media (the simple square videos that are primarily text with some images or video in the background). There are three text boxes in each excel row that are used as three separate text layers in an AE comp. Each row of text is a separate ‘slide’ (a comp in AE). The excel sheet is set up to automatically calculate the timings for the slide in and out points, as well as for each text layer based on standard reading rates as well as generate a caption file for accessibility.
My goal is to create a mogrt for Premiere to simplify my team’s creation process. My team would use the excel file to enter their text, which would generate a csv for the mogrt in Premiere, as well as export a timed caption file. The audio and background video/images would be handled in Premiere (I’ll look into scripting that as my next step).
So, my project is set up so that I can make changes to a single comp (comp 0) and then duplicate it as many times as I need to and place those ‘slide comps’ into a master comp as layers. The csv data is linked using the comp name as a guide so the csv data updates to match. My plan was to have all the slide comps (0,1,2,3…) run the entire length of the mogrt and adjust the “start, in, out, off” timings for each layer in the ‘slide comps’ as well as the start time/opacity for each comp layer in the master comp using the data from the csv. The project is working in all respects with the exception of the timing expressions.
My setup right now doesn’t really use keyframes, but I’ve successfully used a linear expression as a test in controlling keyframes to shift the time, but that seems to be limited to two keyframes and I need to control 4. Start, In, Out, Off. So, I looked at startTime, InPoint, Offset, etc. There seems to be a lot of information about using a controller to adjust keyframes, but I haven’t been able to find anything to just use a new time provided dynamically.
Which is why I think I’m probably experiencing a fundamental misunderstanding of how AE handles time. If anyone has any insight into how I might be able to just override timing using dynamic values, please let me know.