Tip 071 - How To Create & Use a CSV File in After Effects
Вставка
- Опубліковано 10 вер 2018
- Tip 071 - How To Create & Use a CSV File in After Effects
Tip 066: • Tip 066 - How To Creat...
Tip 067: • Tip 067 - How To Creat...
Tip 068: • Tip 068 - How To Acces...
Tip 069: • Tip 069 - Practical Ex...
Tip 070: • Tip 070 - How To Creat...
LINKS:
Ukramedia Podcast: ukramedia.com/category/podcast/
Sergei at Adobe Max: www.adobe-max.com/connect/att...
Learn Expressions in After Effects: ukramedia.com/course/adobe-af...
Ukramedia Mentoring Group: / ukramedia
Get Adobe After Effects and CC: clk.tradedoubler.com/click?p(...)
Get Adobe CC Trial: clk.tradedoubler.com/click?p(...)
Get Adobe CC Student: clk.tradedoubler.com/click?p(...)
Find The Perfect Asset For Your Next Creative Project: clk.tradedoubler.com/click?p(...)
LET’S CONNECT:
Facebook: / ukramedia
Sergei's Facebook Page: / sergeiprokhnevskiy
Twitter: / ukramedia
Instagram: / ukramedia
Pinterest: / ukramedia
Linkedin: / ukramedia
UA-cam: / ukramedia
Mailing Address:
P.O. Box 621
Huntersville, NC 28070
*** MUSIC BY: VLAD SOLOKHA. Vlad is a family friend who is a very talented musician. You can reach out to him by going to his facebook at vlad.solokha....
Thanks a lot fot this! you saved my life with a project that requires a lot of name changes :)
this is going to save me a loooot of time. Thanks!!
wow... this blew my mind! Thanks
thanks, this is very useful and a great explanation!
Thank you so much for this! :D
This is what I want to learn. Thanks a lot again sir.
That's great to hear, Shakil! Thanks for watching it!
Hi thanks for this tutorial! helped me a lot. what should I type in the expression box if I want to connect it to a dropdown menu in my Excel CSV?
Big Thanks! Great help!
Glad it helped!
Great tutorial mate! When I use this, media encoder renders the text as "undefined" - it looks good in AE. When I change text and save, AE refreshes, everything looks great. I know this must be a path issue since Media Encoder saves it's own AE file into Filename_AME folder - but no matter where I copy-pasted the .csv file, Media Encoder wouldn't see it.
Amazing tip .. and I am so happy that you are going to hit 1Lakh Subscriber soon.... I have seen your journey .. and I have lots of respect what you are doing to educate us all .. Thank you so much, from the bottom of my heart.
Hi Sergei!
Hope you are amazing!
Can we assign the values from CSV to individual keyframes of a layer's position using the expressions or script?
Really like these daily tips and very useful for want I'm currently working on. I have link the CSV excel file to text layer>source text number. Is there a way to link the text layer>source text number to an point control number counter end number? Would this be an var expression or something similar?
muito útil!!! Thanks for sharing
Great video. Much appreciated.
Glad it was helpful, Jeff!
Very Good!!!!
awesome video
you are the best you helped me a lot
I didn't know what CSV is but i can understand because of you thanks for your teaching an good video clips and tips
That's great to hear! Thanks for your comment!
Привет! Молодец ... This tip helped me cut part of a dayly task. I had written a extendscript to update an animation (a bar graph with results for the local stock exchange), now reading form a CSV file and making a few adjustments, the task is a bit more automated. Спасибо большое из Бразилии
That's great to hear! This knowledge is very valuable.
hello, first i would like to say this is a great video thank you so much for your hard work and sharing it with us in a nice simple manner.
second i have a question, if i wanna link the number of values in a column to a slide control what expression should i write like if a column got a title and 30 rows i wanna link it to a slide control so that it turns 31 what is the expression here?
again thank you so much
great！！
So cool! Can you change a color by putting the hex values in a column?
Great and so simple ! I try the same text with ".json" and it works. Thanks
Thank you, Mr Polo! You're right, it works well with .json as well.
And the important thing for me, i can open it (csv & json) with LibreOffice calc (excel) :)
Yup!
Hi! Thank you for the video! It helped me to understand how it work! I have a question. When I use CSV file in my project, After Effects run much much more slower. It really affects my work a lot even though I have quite fast computer. I googled it and found that some people had this problem as well but I didn’t find a solution. Do you have an idea why CSV slows the AF performance so much and how to avoid this? It would really help me A LOT!!! Thank you! :-)
Great Tutorial....One question...if I'm giving sting value then how I will get the dataValue...eg: if the dataValue([0,1]) = ukramedia, how I will get dataValue if typing the sting same name (ukramedia) at any text layer. it will be great help for me if you are answer this question.
Nice efforts Sir
Thank you this is epic. Is there away to auto export a composition multiple times using a csv file? If lets say for example I want the each video to change the name of a person that appears in it.
Thanks so much for this tip Sergei. I am having a couple of small issues, though. First, this only seems to want to work with a basic text editor program like Notepad or Notepad++. Every time I've attempted to edit with something like Excel or another CSV editor, extra characters or spaces are added to the file, which then causes it to show error messages in AE. I then have to go back into Notepad, delete what has been added, and reload the csv in AE for it to be read again. Are there any spreadsheet style editors that you would suggest to make it easier for my team to be able to keep track of the data they're editing and won't cause these issues?
Second, when I attempt to export via Media Encoder, all of the text is replaced with "Undefined". Is there a way to allow ME to encode this project, or will I have to render through AE?
I actually figured out my first issue. There was somehow a tab space before one of the fields. After fixing that, I was able to edit in Excel and Save As a csv to update text.
I'm glad you were able to figure it out, Jeremy. You should join our free online mentoring group at ukramedia.com/community. We have a lot of very knowledgeable/talented artists who are very passionate about helping others. See you there!
can it work with replacing images as well?
how do you change the font with expression to that layer?
Great, what about multilines, can I import multilines with breaks in each cell
Thanks alot
Thank YOU, Aktham!
good job . great tutorial . and a nice person to explain it
Thank you, Hamza!
ukramedia can you make more after effects expressions tutorials
I am planning to do that soon. :-)
I'll be waiting for it . Thanks
I have a lot of texts titles, I need to render images, how can I make every frame to render the next string?
hey, thanks for your knowledge, but i have probleme when i use csv, it doesnt work in the render, please, can u help me ?
Can this be done with from a csv file online? Like can we call it from a website?
Hi, Thanks for the tutorial.
QUESTION: How do you go about batch exporting multiple compositions so each has their own unique information displayed from the CSV?
You need as many comps as you have rows but basically you would need to write an expression.
column = 0;
row = parseFloat(thisComp.name.toString());
footage("sample.csv").dataValue([column,row]);
In this example my comp name is just a number, if you want to have a long comp name you'll have to change the expression using something like a .split("-")
When you have a bunch of comps called 1,2,3... the expression will see the number and pick that row.
There might be an easier way but just saw this video and your comment and thought I'd give it a go solving it.
@@GregW05 You are amazing Gegory
This is great. Is there a way to use CSV to import an image from a specific file location in the same manor?
example CSV line would be
Brian, Videographer, /photo/brian-600x600.jpg
Was hoping someone would have answered. Maybe the answer is no I guess
Yep, just put the full file path in the cell.
I was wondering the same. If you find a way to do it do let me know :)
How do I replace an audio clip similar to this method? I will create a song with a "name" section and I want to export same song with different names, is there any way to it? Thanks in advance?
Can you do this using image or just only text?
So I used the second method. How would I go about dropping a new CSV into there and keep all the pickwick values the same? I currently make 24 different compositions on the same video but they have different values. I assume that if I change values in the CSV it'll change it on every after effects file. there's like 20 different text boxes so I can't really change it all.
can you apply colors from a csv file by using color codes or something?
Can you make it read down the column of data to show one value per frame (or per second, or whatever timestep you choose)?
Great question, Kate! Yes, you can, I'll have to do a tutorial on that. Thank you for your feedback!
Please do! I have searched everywhere to learn how to do that. I have a few ways I do it myself, but it's very clunky and I would love to learn a more elegant way that would allow you to use larger datasets without creating too much havoc.
Can you Do That For Pictures , Videos and Audios ??
This doesn't seem to work on CC 2015. No such import possible and there I was all ready to go :)
Nice tut, but is it possible to make a line break (if i add a line break the csv doesn't display correclty)?
ctrl + enter will break the line and this will be read byAE
can we change the names using slider controller ?
Woah, so powerfull. I'm exporting Lower thirds for my clients conference at lightspeed now!
But, when I render I get a video with the text 'undefined' in it. Please help
@@PhilipDirven I've been using this method of CSV data for over a year, and only started getting "Undefined" during export since a CC update in Jan 2021. I cannot find any solution except to export individual videos directly from Premiere Pro. Would love to know if anyone has found a solution to encode through Adobe Media Encoder.
@@PhilipDirven The other way is to click and drag the .csv file into the comp in After Effects, which doesn't work for projects with large numbers of comps referencing the same .csv. It also creates huge files sizes and slow processing. Very frustrating it's changed for no reason!
@@PhilipDirven Hey mate, just talked to Adobe Support. The only solution we found was to roll back the version of AME to v14.0 (others possibly work but I just tried the oldest available). It appears that for some reason the expression linking functionality has broken in newer versions. I don't know if it will be fixed, but at least they're aware of it now.
@@FlexLineMedia There is another solotion. It's called 'CompsFromSpreadsheet' and is a paid app. I have it but didn't look into it yet.
how to get data from another comps csv data?
What if you need a comma in the displayed text?
Thank you ukramedia. But i had an issue with rendering, then i found on reddit : "In order to make AME read the data file you have to put the data file into every composition, that is referencing it." (aetipps)
Sir, can you please tell me, JSON or CSV files support in AE CS6 or not?
I'm not sure about that. I no longer have CS6 installed on my computer. You should join our free online mentoring group at ukramedia.com/community. We have a lot of very talented people on there who would love to help you. See you there!
@@ukramedia tnx u sir
What about cyrillic in csv?
Can we call image as the same?
Please make a plug-in like this
Has this now changed with the release of AfterEffects CC 2019?
I don't think it has, but I haven't tried it yet.
I'm sorry, but I don't know how you were able to import the csv file into aftereffects. I have CC 2018 and it just won't let me import it! It doesn't even show any errors, no text files are even available as an option for me to import. Help? :(
Were you able to figure it out?
@@ukramedia I was not. I can import json files for some reason, but nothing else. Is it something pretty obvious I'm missing?
I have the same problem, if you have solved let me know please. Thanks
I tried it with Arabic text and doesn't work :(
desnt work for me. idk why.
What version of After Effects are you using?
@@ukramedia CC. I had to find a different method to succed it and i havent found a decent way yet.
" ... & Use a CSV File in After Effects"? you are funny!
can it work with replacing images as well?