@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!

From Adobe support:

“Had shared the case with my seniors. The Console was a developer tool and was there till Version 2024 and have been discontinued for now.”

@1337err I’ve had a similar problem with my replication just stops and keeps crashing/loading until I eventually force quit AE. In my case it was a special character in the “output” filename (a “€” sign) that caused the crash. Replaced it with “eur” and things are running smoothly again. Haven’t read your thread thoroughly, so might not be the case for your project, just thought I’d give a shout.

@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.

@ermalr

If you continue to have issues with speed and performance over time, I’d recommend getting in touch with us directly at support@dataclay.com so we can get some more specific details on how the project is configured.

Outside of enabling the “Remove unused footage after each job” and “Purge all memory caches after each job” in the Templater Preferences panel, as @ariestav mentioned, it might be necessary to take a look at the templater.log file to see if we can narrow down exactly where the issue is occurring.

Let’s start by enabling those options, and if we still run into issues, go ahead and send us a message, and we’ll see if we can’t make some more specific suggestions based on the project’s operating environment.

Thanks,

Jeff

@jeff Thanks for the reply, Jeff.

@eric_dean shoot us an email at support@dataclay, and we’ll send you a build that should work with the new flags. Also, let us know which platform (MacOS or Windows).

@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.

@Jeff Just to close the loop on this. Support informed me that the comment field in each marker needs to be filled in for the Spot Check feature to work. Problem solved.

@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.”

@Jon Sorry for the late reply.
Yes, I got everything working with Jeff’s advice and your tips.
Big thanks for the help.

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?