Thank you for this amazing script. From what I can tell, this script duplicates your template comp and replaces contents from csv. What if after all this is done, I want to update all the comps again but this time with a different csv? (Modify existing duplicated comps, not duplicate template comp x times again)
@MichaelThomas2477Ай бұрын
This was a great tutorial!
@paulv8185Ай бұрын
Hi Emily. Great tutorial...Thanks for making this...need up up the workflow...this should do it! YUP. Working... Anyone have a hint on how to get ',' comma's to translate. I have NAME - HOMETOWN in these graphics...the commas between town and state are causing issues and a " " "quotation is being inserted...
@SportNatural20122 ай бұрын
Works like a charm! The only downside of working with CSVs is that I can't use commas in the texts. The script treats the comma as a new line, and otherwise, it gives an error. Do you have any workaround for that?
@emilyagentile2 ай бұрын
Yes! All you have to do is put double quotes around your text “like, this” and it will work - it’ll omit the double quotes in your comp when you batch.
@SportNatural20122 ай бұрын
@@emilyagentile Thanks for your superquick response! Unfortunately that doesn't work for me. For some reason i get 2 double quotes (two on the left and two on the right). And after the comma the text goes to the other layer.
@emilyagentile2 ай бұрын
@@SportNatural2012 One of the other quirks to using the double quotes is that you can't have a space between data. for example: a,"b,c" will work, but a, "b,c" will not work. Remove the space before the quoted data and let me know if that works, otherwise feel free to email me at [email protected] with your data and we can troubleshoot further!
@salahhammam4384 ай бұрын
👌💯💯💯
@xFlyingSkylark12234 ай бұрын
I am getting a "Could not find the photo file ___" despite putting in the folder name in AE exactly and keeping the names simple. Do you have any advice?
@emilyagentile4 ай бұрын
Update for anyone running into the same issue: Make sure to save photo files on a physical drive instead of cloud storage, as the script has trouble pulling from a cloud drive. Thank you @xFlyingSkylark1223 for your patience! Hello! Do your file names match your csv file exactly? For example if it has .jpg in the csv file it has to have that file extention in the name in your AE folder as well. If you're still running into issues, feel free to send me your project files to my email [email protected] so i can help troubleshoot further.
@boyeliza4 ай бұрын
Thank you! You got a new subscriber! Keep posting!
@andreagdeleon74506 ай бұрын
I love your tutorial, it worked for me, I was able to bring it into chatgpt 4o and modify it a bit succesfully, you will save me ton of time, also, the one thing i was unable to make work was the baller FX code, i wrote it and copy and paste it into the "scale" and with no luck, not sure why, here is the code: maxWidth = 415; w = thisLayer, sourceRectAtTime().width; x = (maxWidth/w)*100; y = value [1]; s = Math.min (x,y); [s,s] is there anything that I am missing?
@broadcastGEMs2506 ай бұрын
Can we put in a request for an Annual Maxon All-In as the Give Away? :-)
@MisterCozyMelodies6 ай бұрын
hey, thanks a lot, works great!! i had some issues because i didn't pay attention to every single detail, but after some adjust i got it!! in 9:46 you important that you select the composition you wanna run the script
@ignaciosagrario7 ай бұрын
Hey Emily very good tutorial. Is there a way to make these bars change alont the timeline according to this data? Lets say I have a demographic chart where bars should be changing along the years. Thanks!
@emilyagentile7 ай бұрын
hmm maybe you could connect to a slider control that controls which row or column your chart is looking at vs using the index? That way you could animate the slider, but it would require some coding to make a smooth transition between values. Just thought of this off the top of my head but I'm sure there are other solutions as well :)
@QO0OD8 ай бұрын
Great video. 👍 I was wondering 11 hours in envato and videohive none of the sellers gave me this kind of great product
@brandhuetv10 ай бұрын
thank you for this video, it was very helpful! but how to edit the points and variables, just by changing the Excel sheet, and it will be updated inside premiere ?
@litaln10 ай бұрын
first thank you for this. i tried your script and i get an error: "unable to excute script at line 46. after effects error: unable to set "name". value is undefined" and i made the csv file exactly as explained i really hope you can help thank u
@emilyagentile10 ай бұрын
Sorry you're getting that error! Can you email me at [email protected] to troubleshoot?
@MrKevinMulder7 ай бұрын
@@emilyagentile I'm getting the same error message...can you share the fix here?
@emilyagentile7 ай бұрын
@@MrKevinMulder Hello, this error usually occurs because the "Name" column is not properly labeled. It needs to read exactly "Name", no other words and with a capital 'N' in Name. If you're still experiencing issues feel free to email me at [email protected] and we can troubleshoot further. Thanks!
@magiettadetko154310 ай бұрын
Excellent content, thank you for posting it. Very well explained.
@mediocreape11 ай бұрын
wow!!! thanks!
@hafidzfihri Жыл бұрын
Do you have tutorial or any links i can check to understands the whole concept of automation using CSV? I want to have better understanding so i can customize with my needed and do some problem fixing. Thanks~
@HandyAnime Жыл бұрын
I Edit The Script Now you can replace more than Photo I cant Believe it I'm Very Happy Thank you
@MichaelAnderson257 ай бұрын
How did you do that? I need that feature as well
@HandyAnime Жыл бұрын
Thank You So Much For That Video 😊
@davidmair3517 Жыл бұрын
@emily@gentile thanks so much for creating this tutorial! It was super helpful. For anyone else that uses this tutorial if you are planning to explore this I found that AE doesn't like the adjustment layer references if you send your motion graphics to Media Encoder. Instead export it to the native AE render queue and export it from there. No errors or broken data chart animation.
@emilyagentile Жыл бұрын
Thanks for sharing!
@andrewoward Жыл бұрын
Nice work Emily.
@Techspin Жыл бұрын
Edit: If you're importing into Premiere, the CSV file MUST be included in the main/imported composition. Otherwise it does not include it, and pulls no values! // This video not only showed me exactly what I needed, it also taught me expressions in After Effects. We now have a fully customizable, resizable bar graph for the future! Thanks so much for this truly excellent and detailed walkthrough!
@craigwall6071 Жыл бұрын
Absolutely outstanding, Emily. A very thoughtful tutorial. Loved your inclusion of the goals at the outset. Attention to detail was also great! My mother's name was Emily, btw.
@doodlve Жыл бұрын
This was so Awesome. Hope I can make it work <3
@treksis Жыл бұрын
Hi, new subscriber here. Thanks for the great content! I have a question. Is there a way to batch edit/swap images that are inside the precompositions? Your script works well when I have all the layers in the main comp, but the project I have has many precompositions. I have a main composition with many precomps called scene[0,24] , and for every [scene i], there are photo[i] and text[i].
@jlagerholm Жыл бұрын
Thank you.
@piyushchouhan709 Жыл бұрын
I have 80 shorts for youtube, All are of exactly 50 seconds, I want to Put a outro of 3 seconds in all the shorts at once, Can you help me plz..
@emilyagentile Жыл бұрын
you can try making a template comp in AE with "placeholder.jpg" as one of your mp4 or mov files of your videos. in the template comp, add the outro to the end. create a csv file with the Name Column, "Photo" column (put your 80 video names here), and any other column you need. import the vids into AE and run your comp. it should work with most file types as long as the layer is labeled "placeholder.jpg" and your Photo column cells match the names of your files. Hope this helps!
@piyushchouhan7099 ай бұрын
thank you soo much@@emilyagentile
@piyushchouhan709 Жыл бұрын
Thank you So Much :) are you a coder?
@piyushchouhan709 Жыл бұрын
amazing
@Netizen56 Жыл бұрын
Thanks for this! Would love more tutorials related to infographics for after effects.
@HarisRehan-f8d Жыл бұрын
I dont understand, it keeps returning the error "couldnt return a numeric value"
@emilyagentile Жыл бұрын
Here's a couple of troubleshooting steps i suggest: first, when you drag your csv file into your timeline, does it show the column headers? If your csv is set up properly and the column headers show up properly, make sure you're referenceing the correct column with the numbers you want the bar graph to represent (perhaps you need to reference column 0 instead of column 1 for example?) Make sure there's no spaces after or in-between any of your numbers in your csv file. Line breaks are fine as you see in my video, but spaces inbetween characters can make things wonky. For example if my csv reads "1920 , 1000" in a row, the space after 1920 might mess with my data (same thing if there was space after the 1000) I hope you're able to figure it out!
@olliegeorge132 Жыл бұрын
I had the same problem, but I found that my CSV had commas in the numerical values which caused the problem (i.e. 1,987 rather than 1987). Removing these commas in my text editor and re-saving the CSV seemed to correct it :) hope this helps!
@shekhkasim2099 Жыл бұрын
I want to replace three photos at once is it possible and CSV file three photos columns Thank you.
@emilyagentile Жыл бұрын
With this script it’s not possible to import multiple photos but i have a version im working on that works with multiple photos. Im still testing it for bugs right now so its not ready for release, but coming soon!
@shekhkasim2099 Жыл бұрын
@@emilyagentile Please, as soon as can you release this script, this script is very important to me. Thank you so much your script tutorial very helpful for my project.
@OhioNPC91110 ай бұрын
@@emilyagentileis the script available
@AbhishekKumar-bx8dj Жыл бұрын
Helpful
@gianluccacolangelo6543 Жыл бұрын
Thank you very much Emily! I often wonder how can I merge science and art and this is definitely one way. There is no turning back, thanks again.
@gianluccacolangelo6543 Жыл бұрын
Can you recommend me where can I go deeper about animating data sets?
@emilyagentile Жыл бұрын
@@gianluccacolangelo6543 Ukramedia and BallerFX on KZbin have a lot of really good tutorials!
@BenjaminCurry Жыл бұрын
Thank you so much for making this!!
@tomaskoeck Жыл бұрын
This is awesome, super informative.
@natureismyjam Жыл бұрын
This is a FANTASTIC tutorial!! THANK YOU! New sub from me!
@ML-vh7nz Жыл бұрын
hello! Congratulations on this great tutorial. Is there a chance to place a link to the after effects file you made? Thank you in advance.
@emilyagentile Жыл бұрын
Thanks for your interest! I'm glad you found the tutorial helpful! I've posted the project files on my Gumroad account: emilyagentile.gumroad.com/l/CSVtoBarGraph
@newsnew4185 Жыл бұрын
Wow so beautiful!!
@pradippokhrel2233 Жыл бұрын
How can we create racing bar graph which sorts according to data provided ? can you please help mam
@emilyagentile Жыл бұрын
Hi there! The data will sort based on your csv file. Whatever changes you make to your file will reflect in the bar graph
@yadavpokhrel3770 Жыл бұрын
kzbin.info/www/bejne/hJ-Xk5x9f7iWqbc
@yadavpokhrel3770 Жыл бұрын
How can we create this kind of animation but this should be data driven ? Can you help please.
@pradippokhrel2233 Жыл бұрын
Hello madam . You been doing great tuitorial hope to see more This comment is to appreciate your work as well as to get in youtube's algorithm .
@SportData_ES Жыл бұрын
Hi ! Very nice tutorial🥰 How can i do to change the data value on a compositions? So i got a text and a shape that are responsive one to other in a comp, and i want to change the text value related with an excell as you show but from this comp not from the layer text , like that i can duplicate the comp with - 1 value everytime . it is possible¿?
@emilyagentile Жыл бұрын
Hi there! It sounds like you might want to utilize "thisComp.split()" to reference your excel sheet columns. For example "Comp Name - 0" would reference column 0. Duplicating this comp would give you "Comp Name - 1" refenceing the next column, etc. I'm making a tutorial about this topic soon!
@SportData_ES Жыл бұрын
@@emilyagentile thank you very much , i will try myself and waiting for your tut too :))
@SportData_ES Жыл бұрын
Would you accept a zoom meeting to explain me the solution? I am a AE beginner... so far i am complete lost on how to make it work (even if you gave me some ideas) ^^
@SportData_ES Жыл бұрын
I pay you 💪
@eldadmarkus Жыл бұрын
Thank you! Great tutorial
@BlackSwanFinancial Жыл бұрын
Very good explanation 👏. Thank you fit the video. The best I've seen on the topic
@alansaga19732 жыл бұрын
best video ever, i was trying to discover how to sync the excel data with After effects,thanks so much 👍👍👍👍👍👍
@aliciajoohee2 жыл бұрын
thankssss
@realcarljhonson2 жыл бұрын
Fantastic tutorial....it seems like i was watching watchmojo type of quality voiceover with great explanation. 🙂