FORUMS: list search recent posts

Spreadsheet -> AE

COW Forums : Adobe After Effects

<< PREVIOUS   •   FAQ   •   VIEW ALL   •   PRINT   •   NEXT >>
Adam Lewen
Spreadsheet -> AE
on Dec 6, 2018 at 2:14:42 pm

Hi!
I know about a couple of scripts that help with several tedious tasks. I am looking for something that could really cut down some tedious work:
To simplify-
I have a spreadsheet (Excel) with 50 rows (for 50 Comps)
Each row has a name column (Comp name)
and size column (all different resolutions)
Is there a script that I can execute and get an AE Project to help with creating those 50 Comps, each comp having the specific rez?
If anyone knows, any tip will very very much appreciated!
Thank you!
Adam


Return to posts index

Walter Soyka
Re: Spreadsheet -> AE
on Dec 9, 2018 at 11:25:08 am

This sounded useful, so I wrote one:

12936_keenmakemanycomps.zip.zip

You will need a six-column Excel grid with header rows for Comp Name, Width, Height, pixel aspect ratio, time, and frame rate:



The script presents an area for input like this:


Paste your data from Excel into this area, like this:


Click the "Make many comps" button, and many comps will be made.

Walter Soyka
Designer & Mad Scientist at Keen Live [link]
Motion Graphics, Widescreen Events, Presentation Design, and Consulting
@keenlive [twitter]   |   RenderBreak [blog]   |   Profile [LinkedIn]


Return to posts index

Adam Lewen
Re: Spreadsheet -> AE
on Dec 9, 2018 at 7:57:55 pm

Walter, this is not the first time you reply to my quest with a tailor-made useful script. I am speachless. I am sure its useful many purposes and many people. iā€™m going to try it first thing tomorrow morning. Stay tuned šŸ˜‰. Thank you so so so much!


Return to posts index


Adam Lewen
Re: Spreadsheet -> AE
on Dec 10, 2018 at 10:37:09 am

Walter Thanks again! It works like butter! (I needed to tweak the order of the columns a bit, but I think its due to RTL-LTR on my side, and btw, it works with other languages - for the comp names!)

Can I share this with people of interest?

Adam.


Return to posts index

Walter Soyka
Re: Spreadsheet -> AE
on Dec 10, 2018 at 10:44:16 am

You're welcome, Adam. This looked like the sort of thing we could use, too, so hopefully it works well for both of us. Please do feel free to share; I post these publicly so the whole community can benefit.

Walter Soyka
Designer & Mad Scientist at Keen Live [link]
Motion Graphics, Widescreen Events, Presentation Design, and Consulting
@keenlive [twitter]   |   RenderBreak [blog]   |   Profile [LinkedIn]


Return to posts index

Adam Lewen
Re: Spreadsheet -> AE
on Dec 12, 2018 at 1:19:25 pm

Walter, where do you post publicly?


Return to posts index


Walter Soyka
Re: Spreadsheet -> AE
on Dec 12, 2018 at 5:57:44 pm

[Adam Lewen] "Walter, where do you post publicly?"

Here, mainly! But I do have a set of scripts available on my dusty old blog, Render Break:
http://www.renderbreak.com/

Walter Soyka
Designer & Mad Scientist at Keen Live [link]
Motion Graphics, Widescreen Events, Presentation Design, and Consulting
@keenlive [twitter]   |   RenderBreak [blog]   |   Profile [LinkedIn]


Return to posts index

Marko Suto
Re: Spreadsheet -> AE
on Dec 13, 2018 at 9:01:43 am

Hi, this is what I use for daily TV broadcast:

https://aescripts.com/compsfromspreadsheet/


Return to posts index

Walter Soyka
Re: Spreadsheet -> AE
on Dec 13, 2018 at 2:42:56 pm

[Marko Suto] "Hi, this is what I use for daily TV broadcast:
https://aescripts.com/compsfromspreadsheet/"


Absolutely, CompsFromSpreadsheet is a fantastic solution for turning out many data-driven variations on one template. We use it a lot, too.

My script above is not even a little helpful for that scenario! This will set up a set of different, blank comps with different and customizable names, resolutions, PARs, durations, and frame rates.

Walter Soyka
Designer & Mad Scientist at Keen Live [link]
Motion Graphics, Widescreen Events, Presentation Design, and Consulting
@keenlive [twitter]   |   RenderBreak [blog]   |   Profile [LinkedIn]


Return to posts index

<< PREVIOUS   •   VIEW ALL   •   PRINT   •   NEXT >>
© 2020 CreativeCOW.net All Rights Reserved
[TOP]