• Jon Jon

    @Roberto-Mardini You can add your comp to the render queue normally via AE’s menus, and it will render just the currently-previewing individual job data. The render-status column is only used by Templater Bot. If you still want to output a range of rows, you’d still need to adjust the start and end values in the Transport controls section.

    posted in Templates read more
  • Jon Jon

    @Steve I’m not clear on the question you are asking. Could you explain more in depth what is and isn’t happening, and what you are trying to make happen?

    posted in Templates read more
  • Jon Jon

    In case anyone comes across this topic later, it appears that jotform changed something about the way that they serve media files, and they no longer appear to be offering directly hosted files that work with Templater. There is a paid plugin called Uploadcare that I believe still works for file uploads that Templater can import.

    posted in Data Sources read more
  • Jon Jon

    @simon_t apologies for the long delay. We haven’t been receiving notices for new posts, but I believe we corrected that issue. It looks like the video at the loom link isn’t active anymore. If you set a scale factor on the text layer, and make sure that it is within it’s own precomp that is the size of the text box you want, it should fit the text to the dimensions of the precomp.

    posted in Templates read more
  • Jon Jon

    @vjn86 (and for anyone else reading this later)

    Yes, you can do this, but you will need to use expressions to accomplish it. You can set numerical values in your data, then map that data to a dynamic text layer in your project. Then, you can use a parseInt() expression to parse the value of the sourceText of the layer into a number that can be used in any numerical value such as position, scale, rotation, etc. See referencing dynamic text layers section.

    posted in Google Sheets read more
  • Jon Jon

    @Tasnadi-Otto Just to clarify, are you talking about pixel dimensions (length and width) or time/duration? If you’re talking about time, you can do what Arie suggested, or, as a workaround, you could set up your text layer(s) and have it mapped in multiple comps, each comp having a different duration, then use comp switching feature to swap between different precomps using the method shown in this demonstration.

    posted in Templates read more
  • Jon Jon

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

    posted in Google Sheets read more
  • Jon Jon

    @dwalters You can select individual comps within a project to re-version with the target property, or you can switch between projects with the aep property (and you can combine the two). Templater will parse through the entire project, not just the target comp, so you can set up really complex, modular systems that all update at once. You can use data from your data source to drive you controller/checkbox layouts.

    posted in Google Sheets read more
  • Jon Jon

    @dwalters You can use spreadsheet formulas to access data in other worksheets within a “master” worksheet. Just be aware that if you are using the Bot to process your jobs, a quirk of the Google Sheets API makes it so that Templater must “flatten” the formulas in any row that it processes. If you are using the Render/Replicate to process jobs, you don’t need to worry about that particular issue.

    posted in Google Sheets read more
  • Jon Jon

    @eliasnilsson19 How are you locally accessing the files uploaded to the Google Form? Are they being synced back to your computer via Google Drive (File Stream or Backup and Sync)? You would need to build a formula in your Sheet that transposes and concatenates a local file path based on the original file name of the file being uploaded-- the generated URLs for Google Drive are not absolute links, so Templater will fail to download them correctly (Templater can download URLs that are absolute links to the files, ending with a file extension). I’m not certain whether it is possible to get just the filename of the uploaded file via Google Forms, but if it is, that is how you would have to approach it. Outside of that, you’d have to look at a different form builder that can handle the requirement of uploading the file and pushing the absolute URL back into your Sheet. I know that it is possible to do with JotForm, if configured correctly.

    posted in Google Sheets read more
  • Jon Jon

    @darrencase There are several ways to set text color. We’ve got a sample project on our GitHub repo that demonstrates one of the ways, but there are others as well.

    posted in Data Sources read more
  • Jon Jon

    @darrencase I’m not familiar with how that script works. Are you using the same data for both that script and Templater?

    I think Arie linked you to our using data in expressions support page. Long and short, you can bring in values to your project as text in a text layer, then parseInt() (for numerical data) the sourceText of that text layer to use in numerical expressions on other layers. You can also do this directly with JSON data imported into AE, but be aware that AE’s JSON import support is actually finicky and prone to breaking in one particular way that makes it problematic for Templater (though I’m not sure that what you’re dealing with is the same issue).

    posted in Data Sources read more
  • Jon Jon

    @darrencase also, it might be helpful to watch this video to see a demonstration of how comp swapping works, to hopefully make it clearer.

    posted in Batch Output read more
  • Jon Jon

    @darrencase You could actually skip about 4 or 5 steps. Each JSON object is one “job” of data for your project. The formatted data should contain all of the variable data from your raw data, as well as data about the After Effects project-- namely which comps you are using to swap into your master “target” comp using the slideshow method I linked. Steps 3-7 should be just one step for Templater. The data swap inside the comps, swapping and re-timing comps (if necessary), and rendering all happen in one step.

    posted in Batch Output read more
  • Jon Jon

    @darrencase on your tweet we mentioned using comp swapping for your precomps. You can follow the “variable slideshow” instructions on this post, but instead of swapping video clips, you can swap your city precomps in and out.

    We do have a Templater Bot NodeJS stitching script on our GitHub repo, but I don’t know that that would be exactly what you are looking for, and would likely overcomplicate the workflow.

    posted in Batch Output read more
  • Jon Jon

    @darrencase Yes, you can use JSON as a data source, though the JSON needs to be “flat” with no nested object arrays. You can take a look at our JSON documentation. JSON has some significant advantages over Sheets/TSV data when it comes to being able to adapt data points being passed to Templater on a per-job basis, but it can be not as user-friendly for a lot of people who are already extremely familiar with Sheets. JSON can effectively act as if each object array is a unique worksheet with values that are only relevant to that particular job. If it were a Sheet, it would be like having different columns on a per-job basis. If you still want to use a Sheet, did you take a look at the sample Sheet that I made for Keith’s case?

    posted in Templates read more
  • Jon Jon

    @pbretz Are you able to share a screen recording illustrating the issue? If you want it to be private, you can create a support ticket.

    posted in Templater Bot Deployment read more
  • Jon Jon

    @shaileshom Can you submit a support ticket and include the full templater.log file as well as your templater-options.json file?

    posted in Templater Bot Deployment read more
  • Jon Jon

    @pbretz I believe that all you would need to do is add an exit command to the end of your script, so that it closes once it is complete. Are you on MacOS or Windows? I would suggest looking into the syntax for your OS.

    posted in Templater Event Scripts read more
  • Jon Jon

    @alip as another idea, to add to what @ariestav suggested, if you know the duration, you can also us “dummy” video clips that are the correct duration, then use the Time properties of the Templater Settings effect to match the duration of the images to the duration of the videos. Similarly, you could also have each image precomped, and use the duration of the precomp pre-set to the duration you want, then set the duration of the clip to fill the full duration of the precomp. These two solutions don’t require using ExtendScript, but they would be limited syncing to one song, rather than songs with different durations/transitions on a per-job basis. If you need per-song flexibility, with different timings, you would need to look into using ExtendScript events as previously mentioned.

    posted in Templates read more