ADOBE AFTER EFFECTS: Forum Expressions Tutorials Creative Cloud

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

Dave LaRonde
Re: Spreadsheet -> AE
on Dec 6, 2018 at 6:14:19 pm

Are you on a tight deadline? If you are, I'd just get busy making 50 comps by hand. If it takes you more than 45 seconds to make each one, you're doing something wrong.

Or you can wait around for someone with encyclopedic knowledge of all the scrips available to make a suggestion (that's not me!) and then figure out how to use it.

Dave LaRonde
Promotion Producer
KGAN (CBS) & KFXA (Fox) Cedar Rapids, IA


Return to posts index

Adam Lewen
Re: Spreadsheet -> AE
on Dec 6, 2018 at 8:44:01 pm

Hey Dave, thanks for the reply.
Sure making 50 comps is easy, but since it’s a pretty automatic task, and my situation might happen a couple times a week, not a one time project, where 50 can turn to 80 or even more... An automated way of starting a project, which is dealing with the content of these comps, will help tremendously. I thought asking here might be helpful.
This forum helped me numerous times with knowledgeable scripting suggestions or direction ☺

Adam


Return to posts index


Dave LaRonde
Re: Spreadsheet -> AE
on Dec 7, 2018 at 3:28:57 am

Well, I hope someone has the script that meets your needs. In the meantime, persevere!

Dave LaRonde
Promotion Producer
KGAN (CBS) & KFXA (Fox) Cedar Rapids, IA


Return to posts index

Adam Lewen
Re: Spreadsheet -> AE
on Dec 8, 2018 at 8:29:14 pm

I will.
Thanks Dave.


Return to posts index

Mark Doctor
Re: Spreadsheet -> AE
on Dec 8, 2018 at 10:31:00 pm

Yes there is a script! I haven't seen it for ten years, but its out there. Sorry to be of no help now, but maybe I can find it.

Greets Mark


Return to posts index


Adam Lewen
Re: Spreadsheet -> AE
on Dec 9, 2018 at 7:30:12 am

Mark, thanks for the reply. If there is one I'll be very thankful!


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

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