Subcategories

• Google Sheets

  Questions, answers, and discussions about using Google Sheets as a Templater data source.

  26
  Topics
  94
  Posts

  

  @dwalters

  The most common cause for the error shown in the screenshot is, more often than not, attempting to authenticate using an older version of Templater. Google made a change to the authentication method that their API uses to grant apps access to Google Sheets last year. Due to this change, previous versions of Templater will no longer be able to sign in to Google Sheets.

  The first thing I’d try is updating to the latest version of Templater. You can download the installer for Templater Standard (for AE 2022 and above) from this link:

  https://assets.dataclay.com/Templater3.zip

  and Templater Legacy (For AE 2021 and below) here:

  https://assets.dataclay.com/Templater3-Legacy.zip

  Hopefully, that’s all we should need to get things up and running, but if you run into further issues, just let us know, and we’ll see where we need to go from there.

  Thanks!

• Local JSON

  Questions, answers, and discussions about using a local JSON object array as a Templater data source.

  5
  Topics
  16
  Posts

  

  @Neil-González

  It’s definitely going to depend on how the data is collected and what you’re trying to achieve. You could certainly render each worksheet individually and then combine them into a final master project, but you could also merge all of the data into one large sheet to create a ‘flat’ JSON file. That may allow you to combine the scenes without having to render or replicate the project multiple times. Instead, you could theoretically create sub-comps and then use the Time Sculpting features of Templater to resize the individual sections as necessary.

  After looking at the data in your JSON example, you might consider a setup where you create a series of blank videos or comps of variable durations and then load them with the ‘duration’ data point. You could then use Time Sculpting to trim the image and text to that blank placeholder’s duration as needed. Again, a lot of this will depend on your setup, so if you have any specific questions, please just let us know.

  As for your question about what version you need, it sounds like your setup will be best served by either the Pro or Bot version of Templater. If your final goal is full automation, Bot will probably be the way to go, but if you’re mainly looking to replicate and iterate large numbers of videos, Pro should be fine.

• Remote URL Feeds

  Questions, answers, and discussions about using URL feeds as Templater data sources.

  5
  Topics
  24
  Posts

  

  @oms The structure of the data returned is not readable by Templater. You need to have it respond to your request as an array of objects. Inside the objects, you cannot have nested objects either. You actually can, but Templater will ignore it.

  So for example your structure now is this:

  { "data": { "id":2, "name":"fuchsia rose", "year":2001, "color":"#C74375", "pantone_value":"17-2031" }, "support": { "url":"https://reqres.in/#support-heading", "text":"To keep ReqRes free, contributions towards server costs are appreciated!" } }

  But really it needs to be an array, and it needs to be “flat” objects inside that array. So it would be best to do:

  [ { "id" : 2, "name" : "fuchsia rose", "year" : 2001, "color" : "#C74375", "pantone_value" : "17-2031", "url" : "https://reqres.in/#support-heading", "text" : "To keep ReqRes free, contributions towards server costs are appreciated!" } ]

  Note how the singular object is still within an array [ ]. Also note that there are no nested objects in that singular object in the array.

  Does this help?

• Tabbed Separated Values

  Questions, answers, and discussions about using Tabbed Separated Value files as a Templater data source.

  1
  Topics
  1
  Posts

  

  If your data is stored in Microsoft Excel, you will need to export it as a Tabbed Separated Value file—known as a TSV file.

  With all the various Microsoft Excel releases, the steps to convert a worksheet to a TSV file vary between versions and operating systems.

  Also, don’t forget that you may need to enable the “Tab delimited file exported from Excel or Numbers” checkbox within the Templater Preferences dialog to work with TSV data exported or saved from Microsoft Excel.

  0_1469650487624_Screen Shot 2016-07-27 at 3.14.17 PM.png