Subcategories

• Google Sheets

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

  119 Posts

  undefined

  @chrismeadmore Thanks for reaching out to us. You are 100% correct that we can’t use a /n or /r modifier to insert a line break when using a TSV as a Data Source. Instead, we’ll need to use a special character in conjunction with an After Effects Expression. For this example, we’ll use an asterisk ( * ) in our Data Source to designate where line breaks should be inserted. So, if we wanted text on two lines, the data would look something like this: “Lorem ipsum*dolor sit amet” (with no quotes). Then, we’ll want to add this Expression: thisLayer.text.sourceText.split("*").join("\r"); to the Source Text property of the text layer. This should instruct AE to search the text and replace any asterisks it finds with /r, which should result in a line break. You can change the asterisk to another character if needed, but hopefully, this should get us moving in the right direction. If you have any other questions or if we can help further, please don’t hesitate to reach out here or to our main support at support@dataclay.com. Thanks and Happy Rendering! Jeff
• Local JSON

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

  18 Posts

  undefined

  @eric_dean Great question! Escaping the quotation marks should be as easy as putting a backslash before the quotes in the text block of our JSON file. So, for example, if we wanted something like this: Lorem ipsum "dolor" sit amet we’d write it like this: Lorem ipsum \"dolor\" sit amet The backslashes should be read as an “escape” to keep the quotation marks in the text from interfering with the formatting of the JSON data file. Hopefully, that should be all we need, but if you have any other questions, please feel free to reach out. Thanks, Jeff
• Remote URL Feeds

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

  24 Posts

  undefined

  @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

  undefined

  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. [image: 1469650488015-screen-shot-2016-07-27-at-3.14.17-pm.png]