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?
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.
@@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.
@@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 emilyagentile@gmail.com with your data and we can troubleshoot further!
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?
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 emilyagentile@gmail.com so i can help troubleshoot further.
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?
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
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!
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 :)
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 ?
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
@@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 emilyagentile@gmail.com and we can troubleshoot further. Thanks!
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~
@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.
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!
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.
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].
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!
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!
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!
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!
@@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.
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
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¿?
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!
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) ^^
