@pbretz Yes, that would be an option. I’m pretty confident that it’s an issue specific to Google Sheets and not a “bot” value, generally.

@ben-forman said in Best Way to Template Subtitle Track:

@jon said in Best Way to Template Subtitle Track:

So the line endings on Mac might work best as CR (rather than CRLF or LF). Sublime should let you change the line endings, too.

Can you clarify what this means? Am I changing characters? Changing encodings?

LF, CR, and CRLF are platform-specific “line-endings”—they tell the OS where a given line of text or code ends and a new one starts. The behavior where it was displaying all of the subtitle text at once is because AE and the OS aren’t correctly interpreting where each line ends.

UTF-8 is a text character encoding—numerical representations of a graphical character/shape. There are also others like ASCII, UTF-16.

The files in the GitHub repo are already UTF-8. When I created them on Windows, the files had CRLF line endings, but git automatically converted them to LF line endings upon uploading.

I am on Windows and an older version of Sublime, but this is what it looks like on my menu. Save after changing.

16d599cd-5194-4739-9b26-e6bd1e38e708-image.png

@RobAranter Do you have any special characters in the title of your Google Sheet?

It could also be something to do with your Google Account, or with the authorization that Templater had previously retrieved. Can you try signing back into the problematic account in the Google Sheets Setup?

@ariestav Any update on the bug?

EDIT: It’s now becoming a bigger and bigger issue. It now hangs for about 2 minutes when pulling in data from the JSON source. It is getting to the point where we are looking at no longer using templater bot, as we haven’t had any indication this will be fixed.

@ben-forman-0

Sure! You can use a few different Expressions, but the basics are relatively similar.

For solids, the mapping is automatic, so you can apply Templater to a solid and then directly input the hex code you’d like to use in the data source. For other layers, the process is a bit more complex. First, you’ll want to create a text layer with the Templater Effect applied and map it to your data source. For the purposes of this example, we’ll call that layer “color” (with no quotes).

Next, you’ll want to add the “Fill” effect to the layer whose color you want to change. Finally, you’ll want alt/option click the “Color” value of the “Fill” effect and add this expression:

hexToRgb(""+thisComp.layer("color").text.sourceText+"")

This should change the value of the “Fill” effect to the hex code brought into the “color” text layer.

Hopefully, that’s enough to get you started, but if you have any issues or additional questions, feel free to let us know.

Thanks!

@cristian

Thanks for the update. Are the new comps being created when you preview the next row in your data set? Or is this happening when you hit the “replicate” button in Templater? Templater won’t typically create new precomps when swapping between assets, so we need to narrow down how exactly this project is laid out.

Could you outline the steps one by one that led to the behavior that you’re seeing? Hopefully, that’ll give us a better picture of what exactly is happening. You can also get in touch with us directly at support@dataclay.com if you’d like to share these details in a more direct message.

Let us know what you can, and we’ll take it from there. Thanks!

@jeff Yes! This is it! Thanks, everyone.

Pete,

I’m thinking that you’re correct in assuming that this probably has to do with After Effects getting tripped up by the file getting swapped but AE using a cached version of the old file. Unfortunately, this isn’t a super common issue, so we’ll probably need to dive deeper into the specifics. I’d like to know a bit more about where the audio files are stored. Is this local footage, or are they being downloaded from a URL? If the source is remote, could you check and see if the “Allow unique downloads for cloud-based assets” box is checked in the Templater Preferences? If the assets are local, I think that getting access to the templater.log file would probably be the best next step so we can see if there’s something obvious happening behind the scenes.

Thanks,

Jeff

@Junior The JSON files that Templater generates in that folder can be ignored. They aren’t relevant to what you’re doing. You will want to still remove any that got imported into the Project panel in your AEP file, as those can cause errors.

You can have the project file and the replicated AEP files or videos in separate locations. The two are independent. In addition, you can also have the AME watch folder be in a completely different location from AME’s output folder. AME defaults to sorting the files it is processing into a source and an output folder within the main destination that you are watching, but you can set those to be separated.

@jeff Thanks for the reply, Jeff.

@veteos Glad to hear that’s resolved, and that it was an easy fix!

@surabhiv

At the moment, Templater Bot can only be set up to automate either video production or Spot Checking, so if you’d like to have both actions automated, you’ll need to look into running two separate versions of Templater. There is a Reserved Column that Templater recognizes named bot that will allow you to designate which Bot should process each line of data in your data source. Using this feature, you should be able to route preview actions to one Bot to perform Spot Checks and render actions to another that can do render/replication actions.

@cmoyer

Testing the collapse transformations issue, it looks like any effect (not limited to the Templater Settings effect) that you apply to that precomp will break or change your collapse transformation in unexpected ways. There is something weird happening in the way that AE applies effects to collapsed precomps. I’m not entirely sure of a way around this issue.

From Adobe’s help (with my highlights):

“When a closed mask (with mask mode other than None), a layer style, or an effect is applied to a nested composition with collapsed transformations, the layers in the nested composition are first rendered on their own, then masks and effects are applied, and then the result is composited into the main composition. This rendering order means that the blending modes of the nested layers are not applied to any underlying layers in the main composition, and that 3D layers above and below the collapsed layer cannot intersect or cast shadows on each other.”

hi there

Did anyone work this out?

We have 10 comps with the same information in. Name, Date, Venue.

Is there a way not to have to name each layer Name1, Name2, Name3? S0 the excel spreadsheet only looks at row 1 so you end up having a massive long line on row 1

I just want to have:

Column 1 - Driver
Column 2 - Date
Column 3 - Venue

Does that make sense?

@pbretz It’s probably difficult to do without some kind of math if your timeline is moving around a lot, but since you can pass data values to be arguments in an event script incantation, you could pass a time/timecode value into a script to extract key frames as stills using the above mentioned methods.

@videohoney did Jeff’s suggestion help? From the screenshot, the expression is likely working, but you have to shorten the length of the audio track (or extend the length of the comp) for the fade to work correctly. Also, the audio.audioLevels on the first line of your expression shouldn’t be included.

@dwalters There are videos demonstrating setting a target as well as switching between project files. For data in expressions, see the link in my previous post under the section “referencing dynamic text layers.”

@Neil-González Have you added those to the process exceptions list? Is there a separate file blocking area that you can add them to a permanent whitelist? I’m not directly familiar with Trend Micro’s interface.

Thanks Jon!

Thanks Jeff!