Is there any way to adjust the start time of a pre-comp with in the min comp?? I have a :30 second main camp, using a pre-comp that 2:00 minutes. I would like to have the pre-comp start at different times. Possible to do?? or do I need to create several different pre-comps that have different start times from the original pre-comp??
I purchased the script and have a question regarding setting render setting/output module. I would like to rendering png/jpg but both format are not in the output module list. There are only two for rendering image, photoshop and tiff image sequence. Is there a way to set the script so it render in png/jpg?
I purchased the script and have a question regarding setting render setting/output module. I would like to rendering png/jpg but both format are not in the output module list. There are only two for rendering image, photoshop and tiff image sequence. Is there a way to set the script so it render in png/jpg?
If you go to edit_>templates->output module; then create a png output module.
Next, in comprFromSpreadsheet, go to settings->processing, click on change render settings and select your newly created png output module.
I finally got this for my project and works great. However I have a question about parenting using this script and wonder if anyone could help. What I am trying to do is get a persons name from the spreadsheet in two locations; which works fine; but one is in the middle of a sentence and I am not sure how to do that.
The work around I am using is to break the sentence up so the dynamic linking works.
The second part is I want to give possession to a text field, a name, that is brought in dynamically. Is there a way to parent a text object ['s] to the end of a dynamic text field?
Hello Michael! I didn't see anyone asking this question, am I the only one? So let's say we have two comps, comp 1 has image 1 to replace from spreadsheet, and comp 2 has text 1. Do you have to do each comp in a separate run? because when I leave the image 1 column empty because comp 2 only have text and no image, the script shows me an error. I hope this is clear. Is there a workaround?
Hello Michael! I didn't see anyone asking this question, am I the only one? So let's say we have two comps, comp 1 has image 1 to replace from spreadsheet, and comp 2 has text 1. Do you have to do each comp in a separate run? because when I leave the image 1 column empty because comp 2 only have text and no image, the script shows me an error. I hope this is clear. Is there a workaround?
Hi Nader,
is comp 2 a precomp inside of comp 1? or are these two completely separate comps you want to update?
I finally got this for my project and works great. However I have a question about parenting using this script and wonder if anyone could help. What I am trying to do is get a persons name from the spreadsheet in two locations; which works fine; but one is in the middle of a sentence and I am not sure how to do that.
The work around I am using is to break the sentence up so the dynamic linking works.
The second part is I want to give possession to a text field, a name, that is brought in dynamically. Is there a way to parent a text object ['s] to the end of a dynamic text field?
In AE add a text fields (TEXT1) link it to the spreadsheet but make sure it is hidden (Disable eyeball) Now add another text field which is not connected to the spreadsheet, add an expression to the text: text.sourceText="Type here the text you want from the left " + thisComp.layer("TEXT1").text.sourceText + text.sourceText=" Type here the text you want from the Right" This will combine your text with the name in the middle of it.
Upon clicking on it in the Window drop down. I just get the error message and a blank panel. I tried it on a few different versions of AE and it was doing the same thing. Wondering if perhaps I need to dump my preferences or something?
Update: Uninstalled all of AE, re-installed and it still does the same thing unfortunately.
This looks awesome. Is there a way to name the new copy compositions from the spreadsheet rather than just 1,2,3??? This might already exist but I have not tried the plug in yet so was curious.
Two days ago I created 61 lower thirds, each with two text boxes in dissent different colors, and different text in each lower third. Previously that would have taken me at least 90 minutes. Using CompsFromSpreadsheet it took 17 seconds.
you need the layer name of your subcomp to begin with a ! then jany layer in that subcomp will be updated be updated.
so in your main comp there is a precomp named !precomp, the layer in !precomp named #image will recive the image from your image column of your spreadsheet
Ok, so one issue I have had is that every now and then it throws up the error "Pick a Template. line x has an error. there is no template named x". Sometimes the x is part of the text from the text file, sometimes it's just blank.
Is there a way to use media encoder for the exports?
I'm trying to render a batch of H.264 files and now that there is no H.264 option in the output module of After Effects it makes this a bit of a pain. Current workaround is to render as ProRes files then batch these to H264, but this feels like it's adding time to my workflow when the whole point of the script is to save time!
Is there a way to use media encoder for the exports?
I'm trying to render a batch of H.264 files and now that there is no H.264 option in the output module of After Effects it makes this a bit of a pain. Current workaround is to render as ProRes files then batch these to H264, but this feels like it's adding time to my workflow when the whole point of the script is to save time!
Any pointers would be appreciated!
if you go into compsFromSpreadsheet settings and make sure "auto render comps" is deselected in the processing tab. run the script. go to the render queue. click the "queue in media encoder" button.
You just have to make sure before you do this, you render something in the in encoder with the settings you want the batch to be rendered with, when your render que items get added to encoder, they will be set to be rendered the way the last item in encoder was rendered.
I'm using the trial of compsfromspreadsheet, and running into a
couple issues. When I run the script, it works - but only sends 3 comps
to the render queue. Is this a limitation built into the trial, or am I
possibly doing something wrong? It is pulling from a spreadsheet of 500
comps.
Another issue is that checking "Auto
Render Comps" doesn't automatically render them - it sends them to the
queue, but I still have to click "Render." Is this also a limitation in
the trial?
I'm using the trial of compsfromspreadsheet, and running into a
couple issues. When I run the script, it works - but only sends 3 comps
to the render queue. Is this a limitation built into the trial, or am I
possibly doing something wrong? It is pulling from a spreadsheet of 500
comps.
Another issue is that checking "Auto
Render Comps" doesn't automatically render them - it sends them to the
queue, but I still have to click "Render." Is this also a limitation in
the trial?
Thank you
the trial is limited but you will always have to click render. for a fully automated solution check out Templater Bot, pt_OpenSesame Server or MoDeck.
I'm using the trial of compsfromspreadsheet, and running into a
couple issues. When I run the script, it works - but only sends 3 comps
to the render queue. Is this a limitation built into the trial, or am I
possibly doing something wrong? It is pulling from a spreadsheet of 500
comps.
Another issue is that checking "Auto
Render Comps" doesn't automatically render them - it sends them to the
queue, but I still have to click "Render." Is this also a limitation in
the trial?
Thank you
There is no limit to how many comps you can create while in demo mode. My gut instinct is that you have a field in your spreadsheet with a carriage return in it (a newline maybe in a text field). This breaks the tab delimited text format (you need to replace any newline in your data with <br> the script will replace it when it runs).
Open a ticket on aescripts and I can take a look and help you get it working.
I'm not able to get a Nested Comp to update its instances in the RenderComp.
When running the script, I get this error dialog -
Update - It looks like if the Nested Comp has its Layer Shied, the script will not update the instance. Un-shying helps. BUT, my Expressions in the sourceText is not updating to reflect the new instance of the Nested Comp.
I have this line in the sourceText of a few layers in the RenderComp -
After running the script, the comp should be renamed to comp("bGEMs-RDMG-Minimalist-CLN-U_001 TextsInput n").layer("^1st - Line").text.sourceText; where n is the number of instances/comps.
Something is either preventing the Expression from updating or there is no avenue for the Expression to update, to reflect the different RenderComp instances and its respective Nested Comps.
The Text Layers in the Precomp instances are updated correctly but the Expressions in the Render Comps do not update and hence, they are all pointing to the Original Render Comp's source; the Nested Comp with Text Layers.
Got things to work - most likely I had erroneous data in one of the cells.
However, there is still an error message that points to a comp that's present in the Project Panel but isn't involved in the versioning process.
Most importantly, there should be a feature to pick the output folder. Current constructs place the rendered files into the newly created folder. However, I'd prefer placing them into a pre-created AME Watchfolder, where I've set up optimized MP4 render settings.
Using the pre-built script, Change Render Locations, is a PITA since it asks for confirmation for the changed location for each comp - not ideal to be used for a workflow promising automation. I'm hopeful this can be implemented easily/quickly or perhaps there is a better option available now?
Great script but I think I've found a missing feature - it'll be great to be able to include a prefix to define a comp that ONLY NEEDS UPDATING of text/visuals without having to create a new comp.
Current workflows include the possibility of a client changing texts and other parameters. So, it'll be great to be able to run the script AFTER already creating the comps, to update certain Text Layers/Visual Layers.
The script, as is, is designed to be used at the end of a workflow and the beginning of an automation stage. But I'm also trying to use the script at the start of a workflow where I begin with one Comp and then create versions with the script.
hi! is there a way to auto-change a layer's hex code with this tool? i have a spreadsheet full of hex codes and when I try to link up that column with the layer in ae, nothing happens. Is this something that this program is capable of doing?
Can someone explain this to me like I'm a 2 year old? I've tried the most basic name swapping and I can't get it to to work. It makes a "compsfromspreadsheet" folder and a subfolder called "imports" and a subfolder called "preComps" and nothing else, including nothing in the render queue
I've seen the 7 & 12 year old videos on YouTube and another guy that kind of goes through it, but I would like to see something where it starts a project from scratch...even the most basic.
hi! is there a way to auto-change a layer's hex code with this tool? i have a spreadsheet full of hex codes and when I try to link up that column with the layer in ae, nothing happens. Is this something that this program is capable of doing?
Probably using a text layer and hexToRgb() expression
Can someone explain this to me like I'm a 2 year old? I've tried the most basic name swapping and I can't get it to to work. It makes a "compsfromspreadsheet" folder and a subfolder called "imports" and a subfolder called "preComps" and nothing else, including nothing in the render queue
I've seen the 7 & 12 year old videos on YouTube and another guy that kind of goes through it, but I would like to see something where it starts a project from scratch...even the most basic.
Alright, turns out it was that particular machine... I have no idea why it wouldn't work, I actually just got a new machine and it worked without a hitch, so that is sort of solved
FEATURE REQUEST: What if you use the "create text object"/"create layer object" etc etc buttons and it made a .tsv file from that? Is that even something that's possible?
I love this script, worth every penny! After struggling with Photoshop's native spreadsheet import tool, I thought I was going to be in for a big hassle with this one but it just worked and it made sense. Thanks Michael!
Thanks for making this. Really love what it does. Every time I run it, I get a "warning: Undo group mismatch, will attempt to fix." and then I have to close and reopen to render the next file in the queue. Any idea what I might be doing wrong? Or is this a bug? Using AE 23.2.1 on a MacBook Pro.
Thanks for making this. Really love what it does. Every time I run it, I get a "warning: Undo group mismatch, will attempt to fix." and then I have to close and reopen to render the next file in the queue. Any idea what I might be doing wrong? Or is this a bug? Using AE 23.2.1 on a MacBook Pro.
If you have any questions or need help please open a support ticket and we will be happy to assist you: https://aescripts.com/contact/
Hello, I have a question about using the compsfromspreadsheet.
When you load a script through the compsfromspreadsheet and work on it, there is a phenomenon that one letter of the work is unspecified once or twice a month. (ex. Only E is broken during LOVE) Why is this happening and is there a solution?
Hello, I have a question about using the compsfromspreadsheet.
When you load a script through the compsfromspreadsheet and work on it, there is a phenomenon that one letter of the work is unspecified once or twice a month. (ex. Only E is broken during LOVE) Why is this happening and is there a solution?
I use this script to make the LED Wall graphics for a World Championship with over 300 crews and 5000 participants. You are a life saver!
I would like to enhance this script with a new update that adds a basic spreadsheet editor inside of After Effects, with the ability to view, create, edit, export and import tab delimited spreadsheet files, so as to remove the need to use external software like Excel. This is also very useful for QUICKLY running CompsFromSpreadsheet on the fly without creating a new .txt file in an outside folder directory.
I will commission you for this update, including additional features, if you would like to partner on this idea.
The 2023 World Championship is coming up next week, and I would like to have the new version ready for Q1 of 2024.
Are you interested? Thanks!!!
You can reach me by email at 710 [dot] avfx [at] gmail [dot] com
I will need a script like this one for an upcoming gig. Can your script work with other languages than english i.e. french with all the accents and punctuations/symbols?
Purchased the full version. I have a list of numbers ranging from double digits to six figures. Is there a way for the script to auto resize the text to match the text box depending on how big or small the number is?
Currently, if the number is too big, only the first few digits appear.
Thank you for the excellent script. I've tested the trial version and believe it's exactly what I need for my work. However, I need to verify if the script can handle specific requirements.
When using the script in After Effects, it duplicates comps, precomps, and files. For instance, if the quiz has 10 questions, each with its own comp, precomp, and files, editing comp 1 results in the same changes being applied to all other comps. I suspect this issue stems from the duplication process.
The project is a trivia quiz with different correct answer variations, animations, sliders, etc. I'm interested in knowing if it's possible to customize the script so that changes can be automatically applied using a spreadsheet.
I didn't see anyone asking this question, am I the only one?
So let's say we have two comps, comp 1 has image 1 to replace from spreadsheet, and comp 2 has text 1.
Do you have to do each comp in a separate run?
because when I leave the image 1 column empty because comp 2 only have text and no image, the script shows me an error.
I hope this is clear. Is there a workaround?
Now add another text field which is not connected to the spreadsheet, add an expression to the text:
text.sourceText="Type here the text you want from the left " + thisComp.layer("TEXT1").text.sourceText + text.sourceText=" Type here the text you want from the Right"
This will combine your text with the name in the middle of it.
You can use expressions
Thanks!
checker boxes or sliders ?
the trial is limited but you will always have to click render. for a fully automated solution check out Templater Bot, pt_OpenSesame Server or MoDeck.
When running the script, I get this error dialog -
I have this line in the sourceText of a few layers in the RenderComp -
const sauceText=comp("bGEMs-RDMG-Minimalist-CLN-U_001 TextsInput").layer("^1st - Line").text.sourceText;
After running the script, the comp should be renamed to
comp("bGEMs-RDMG-Minimalist-CLN-U_001 TextsInput n").layer("^1st - Line").text.sourceText;
where n is the number of instances/comps.
The Text Layers in the Precomp instances are updated correctly but the Expressions in the Render Comps do not update and hence, they are all pointing to the Original Render Comp's source; the Nested Comp with Text Layers.
Any ideas? TIA
However, there is still an error message that points to a comp that's present in the Project Panel but isn't involved in the versioning process.
Most importantly, there should be a feature to pick the output folder. Current constructs place the rendered files into the newly created folder. However, I'd prefer placing them into a pre-created AME Watchfolder, where I've set up optimized MP4 render settings.
Using the pre-built script, Change Render Locations, is a PITA since it asks for confirmation for the changed location for each comp - not ideal to be used for a workflow promising automation. I'm hopeful this can be implemented easily/quickly or perhaps there is a better option available now?
Current workflows include the possibility of a client changing texts and other parameters. So, it'll be great to be able to run the script AFTER already creating the comps, to update certain Text Layers/Visual Layers.
The script, as is, is designed to be used at the end of a workflow and the beginning of an automation stage. But I'm also trying to use the script at the start of a workflow where I begin with one Comp and then create versions with the script.
I've tried the most basic name swapping and I can't get it to to work.
It makes a "compsfromspreadsheet" folder and a subfolder called "imports" and a subfolder called "preComps" and nothing else, including nothing in the render queue
I've seen the 7 & 12 year old videos on YouTube and another guy that kind of goes through it, but I would like to see something where it starts a project from scratch...even the most basic.
FEATURE REQUEST: What if you use the "create text object"/"create layer object" etc etc buttons and it made a .tsv file from that? Is that even something that's possible?
If you have any questions or need help please open a support ticket and we will be happy to assist you: https://aescripts.com/contact/
I use this script to make the LED Wall graphics for a World Championship with over 300 crews and 5000 participants. You are a life saver!
I would like to enhance this script with a new update that adds a basic spreadsheet editor inside of After Effects, with the ability to view, create, edit, export and import tab delimited spreadsheet files, so as to remove the need to use external software like Excel. This is also very useful for QUICKLY running CompsFromSpreadsheet on the fly without creating a new .txt file in an outside folder directory.
I will commission you for this update, including additional features, if you would like to partner on this idea.
The 2023 World Championship is coming up next week, and I would like to have the new version ready for Q1 of 2024.
Are you interested? Thanks!!!
You can reach me by email at 710 [dot] avfx [at] gmail [dot] com
Thank you for the excellent script. I've tested the trial version and believe it's exactly what I need for my work. However, I need to verify if the script can handle specific requirements.
When using the script in After Effects, it duplicates comps, precomps, and files. For instance, if the quiz has 10 questions, each with its own comp, precomp, and files, editing comp 1 results in the same changes being applied to all other comps. I suspect this issue stems from the duplication process.
The project is a trivia quiz with different correct answer variations, animations, sliders, etc. I'm interested in knowing if it's possible to customize the script so that changes can be automatically applied using a spreadsheet.
Thank you.