@pbretz It can depend quite a bit on how your systems are configured, but I’ll try and outline the basics here. To run Event Scripts, the first thing you’ll need is a copy of Templater Bot. Event Scripts are only available on this version of Templater, so if you’re using Pro or Rig, this won’t be an option. Once you’ve got Bot set up, head to the Templater Preferences window and click on “Setup ExtendScripts”. From there, you should get a box that will allow you to choose which Templater event you’d like to use to trigger the Event Script. When I tested the script outlined above, I registered it on the “After layers update” event under “Layer Processing”. This instructs the script to run after any data versioning and Time Sculpting have been applied to the project. If you’re running Templater via CLI, you’ll want to specify the script you’d like to run in the templater-options.json file on the appropriate Event. In this case, you’d want to add it to the “post_cmd_update” event. Those are the basics, but more information can be found in this article from our support website. Additionally, we have some example scripts on our GitHub Page located here. If you run into any hurdles or if we can answer any questions, just let us know! Thanks!

Yeah, got it to work, had to select one of the jobs first, and then all columns showed :) This is great, I’m really starting to love QUE as much as I do Templater :-)

@pbretz The jobs being left in a state of “processing” in Google Sheets is actually a bug left over from the way the Google API updates when footage is missing. Technically speaking, the render-status should be changed to “done” in the Google Sheets since it completes the Job with the option set in the Templater Preferences dialog. This was a scenario we likely should have envisioned in the past, but our assumption was that customers would use Spot Checks rather than the render-status to check for outputs with missing footage. Either way, we’ll see about implementing some sort of flag to indicate Jobs that complete with missing assets. Thanks, Jeff

@pbretz Hi Pete, I checked in and it looks like we’ve got it fairly high on our list, and we’re eyeing early next year for release. I don’t have an exact timeframe, but hopefully in the first few months.

@rkvalvaa Glad to hear it. If you have any other questions or run into any other issues, please don’t hesitate to get in touch. Thanks!

@motion-jp Glad to hear it! My guess is that something went wrong when the previous project was imported, and an asset was incorrectly reported as a JPEG sequence instead of a static image file. It’s possible that AE then cached that asset state, so every time the file was loaded, AE saw it as a sequence regardless of whether it was previously removed or not. We haven’t seen that particular scenario before, but it’s good to hear that you were able to get it resolved. If you run into any additional problems, please feel free to get in touch. Thanks!

@unclemonty It seems like you’ve already found a solution, but I wanted to chime in and say that it should, theoretically, be possible to map the same value to both a footage and text layer simultaneously. In this case, the footage layer should be swapped out, and the text layer should be replaced with the filename present in the cell. As you noted, you’d need to use an expression to strip out any subfolder information or file extensions, but from a theoretical standpoint, it should work. If you have any other questions or run into any problems, let us know, and we’ll do whatever we can to get you up and running. Thanks!

@joevac Thanks for getting in touch with us. This issue most commonly occurs when a value besides {{off}}, {{on}}, or a valid precomp name is referenced in the Data Source for the project. What typically happens is that Templater tries to reference the value in the Data Source and map it onto the precomp layer as either text or as a footage reference. This is what is causing the pre-comp to turn into an image when cycling through the rows. The first thing I’d try is to check and see if you have anything besides {{off}} or {{on}} in your Google Sheet if you’re primarily using Templater to control layer visibility. Hopefully, that’s all it is, but if that doesn’t change anything or you have any further questions, please feel free to let us know. Thanks, and happy rendering!

@lucarech Templater can absolutely handle all of those sorts of assets! In fact, swapping out text is our plugin’s most common use case. Videos and music can also be swapped in as long as they’re in a format that After Effects can read. I’d recommend taking a look at the tutorial videos on our Youtube channel as well as the documentation on our support website for further details. If you have any other questions, please feel free to let us know. Thanks!

@viriato Unfortunately, due to the way that After Effects is invoked from the CLI when a batch is run, Templater will always spin up an AE instance, render the data that’s been passed over, and then close out. There isn’t a way to force Templater to stay open and await further data without using Templater Bot. I’m assuming that using Bot isn’t an option due to the real-time processing requirement of this project. If that’s the case, and the time that Templater takes to spin up, process, close, and re-open is introducing a delay into the system, the only recommendation that I could make would be to run multiple instances of Templater Bot simultaneously so that new entries in the data source could be passed off to a fresh system while the previous one closes out the last job batch. If those assumptions are incorrect, or if there are some details that I’m missing, please feel free to let us know any additional information about the project that might help us to make a better suggestion. Thanks!

@rkvalvaa Thanks for the update; that’s quite odd. It’s possible that this might be caused by After Effects holding on to some of the legacy preferences from the previous installation of Templater. Could you try clearing the After Effects preferences using the method outlined on this page and see if that makes any difference in what you’re seeing? Another thing you might try would be to create a new project and see if the issue is limited to previously created After Effects files. We’ve seen some problems in the past with project files storing information from previous versions of Templater/After Effects which might account for what you’re seeing here. Thanks!

@viriato Hmmm. That’s quite odd. One thing to check would be to see what the value of post_cmd_output_async is in the templater-options.json file. That key should be set to false to enable synchronous execution, which should keep the post_cmd_job action from setting the render-status to done until the script is completed. If that doesn’t make any difference, we might need to get some additional information on what actions the script is performing. If that ends up being the case and you’d like to provide that information in a less public setting, please feel free to email our support channel directly at support@dataclay.com Thanks!

@seth thanks. That is what the behavior is. It seems to apply to all filters. I get the same limit with filtering output.

@pbretz It’s relatively similar but actually a bit easier with Shape Layers. Since Shape Layers intrinsically have a “Color” property under the “Fill” section, there’s no need to add a Fill Effect to the layer. You can simply add the Expression directly to the “Color” value. Adobe has also added a more streamlined Expression that can convert hex codes to the RGB values needed to determine a layer’s color. This Expression: hexToRgb(""+thisComp.layer("layername").text.sourceText+"") should perform the same function as the Expression referenced in the previous post. The layername value will need to be swapped out for the name of the text layer with the hex information you’d like to use for the fill. Other than that, it should work the same. Let us know if you run into any issues, and we’ll see what we can do to help. Thanks!

@pbretz My understanding was that there shouldn’t be anything else to do aside from assigning the specific AEP to the applicable set of jobs in the campaign (functional parity with Google Sheets). If it’s not functioning that way, that’s something we’ll need to open a ticket on and investigate. I’ll dig into it and try to get more info for you. Seth

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

Thanks @seth! Just to be clear on (2), the issue happens when I’m trying to set a filter - ie select a satellite in it’s filter drop down, or try to set an action like reassign selected jobs to another satellite. When I interact with the dropdown, my selection(s) in the dropdown will be cleared if the render-status changes for any job in the campaign before I apply / submit the selection(s).

@jeff oh, thank you for clarifying

@yansfeld The answer is most likely going to have to do with the way that Templater processes project files. Because of how tangled and dependent AE projects can become, Templater reversions all the layers in all the comps in a project when it runs. This is mainly to ensure that layers aren’t accidentally left out of the process due to an error in dependency logic. That’s just a guess, but we’ve seen issues in the past where Expressions on plugins that aren’t being used can cause an issue since they still need to be reversioned when Templater runs. It sounds like everything is running normally, but if you run into any other issues or have any further questions, please feel free to get in touch. Thanks!