Save
Saving
  • Jon Jon

    @pbretz thanks for the update. That’s interesting that it could be related to formulas or Google app scripts. That gives us a potential direction to investigate.

    posted in Templater Bot Deployment read more
  • Jon Jon

    @pbretz I don’t think G Suite vs. personal Google account should matter, but I can’t totally rule it out, either. I’ve never run into an issue, myself, in using both types of accounts. My hunch is that there might be an unreported timeout happening when the API tries to grab the data. Technically, if you set your queue-at-once value to 5 or 10 or even fewer, it shouldn’t matter if you have 20,000 records in your Sheet.

    The timestamp on the files being so off is very strange, and possibly separate behavior. I’m not even sure how that could happen, since that is an operating system function, and I don’t believe that Templater should have any ability to affect that.

    posted in Templater Bot Deployment read more
  • Jon Jon

    @Jorge-Santana If you are using “the Bot” by clicking “Enable Bot” you will need to have a “render-status” column in your Sheet with values set as “ready” for the rows that you want to render. That ScriptError appears when you enable the Bot without a “render-status” column-- the Bot doesn’t know which rows to render. The error can also occur when you do have a “render-status” column without a corresponding “bot” column and value when you have set a Bot Name in Templater’s Preferences. If you’re not using multiple Bots to render, then leave that option blank in the Preferences, and don’t worry about adding a “bot” column into your data.

    posted in Google Sheets read more
  • Jon Jon

    @pbretz Is the earlier version of AE running Templater 2.9.5, too?

    posted in Templater Bot Deployment read more
  • Jon Jon

    @Kikupj glad to hear that solved the issue!

    posted in Google Sheets read more
  • Jon Jon

    @Kikupj I am going to make an assumption that you might be using Windows? Do you have any antivirus or similar tools running on your machine? If you do, can you disable it, then run the Templater installer again? We’ve discovered that some anti-virus will quarantine and delete a legitimate file that Templater requires in order to operate. If that works, you will need to whitelist a file in your anti-virus software: D_curl.exe located in C:\ProgramData\Dataclay (this is a hidden folder).

    posted in Google Sheets read more
  • Jon Jon

    @Kikupj do you have a bot column set in your data? If so, have you set the Bot name in Templater’s preferences on both machines?

    posted in Google Sheets read more
  • Jon Jon

    @Jorge-Santana Do you have a render-status column in your Sheet? Do you have a bot column (optional)? If you have a bot column, do you also have an identical name set in Templater’s preferences? Is there an empty column at last column in your Sheet?

    posted in Google Sheets read more
  • Jon Jon

    @pbretz Yeah, that seems like the best next step. It can help direct us where to look for any problems in the code. If it can do 1,500 with the Bot column (only one bot), vs. if it can do 8,000 with no bot column. It’s difficult for us to nail down these types of issues sometimes because each dataset is going to be different in the number of rows and columns, and also the volume of data that each cell contains.

    posted in Templater Bot Deployment read more
  • Jon Jon

    @pbretz Ok, that’s good to know. The last things to test would be whether it’s the bot column itself, or the number of records that seem to be causing the issue. If you test with the full number of 8000 records but no bot column, does it process correctly? If you do the reduced number of records, but have a bot column and Bot name in Templater’s Preferences, does that still work?

    posted in Templater Bot Deployment read more