After Effects Scripting Tutorial: Read and Automate with CSV Files

[@sergedruz7261]

Man, thanks for sharing your knowledge, I'm so glad I found you channel, I came from Ukramedia btw, from a video about scripting introduction. God bless youtube))

[@zohaibmalik819]

Same with me. Ukramedia referred me to here.

[@LukeKroeker]

Your videos were incredibly helpful in getting my first scripting project off the ground. Cheers!

[@johncalvert4535]

Great tutorials! Exactly what I've been looking for!

[@zohaibmalik819]

Thanks! Nice tutorial.

[@dimawebdesigner]

Thanks Nate for so cool explanation. You meant, that we can not only to read but also to write csv-file (with "w" key). Is it mean we can update this csv-file at the end of the script after all manipulation? And if it's true, how it can be done?

[@NTProductions]

with .open("w") and .write(info)

[@dimawebdesigner]

@@NTProductions Thank you very much. Went to study)

[@subaphonic]

That is incredibly useful, I've been looking for that method for so long. Thank you ! Do you know if there is any way we can automate the csv file creation in Google Spreadsheets? I mean by that not having to create it manually, but have a script that automatically does it periodically ?

[@LetTheWritersWrite]

Really awesome stuff. Had a question for you, do you think there's a way to create a web browser interface to autogenerate a template video for non AE savy users? Something simple like a text field and a submit button. I see this tutorial as one of the pieces to the puzzle. (webbrowser writes or updates a json or csv file). What I'm not certain of is how to start the export. I know you have another tutorial to setup a watch folder but not quite sure if that's the right approach.

[@NTProductions]

With a script, probably not! But with an extension, definitely! Extensions allow you to use GET/POST/FETCH requests and interact with APIs and servers.

[@marcelduplessis]

Thanks for this! My idea is to create a template in AE and replace images and text from csv. Is this possible? If so, where would I start?

[@stewi80]

Really nice and well made tutorial, thanks for sharing. Is it possible to create a window that loads a csv from any location rather than a pre-assigned path?

[@NTProductions]

Yep you can just use a selectDlg() to select a file or folder!

[@nahmevibestudio]

Thank you very much.

[@SJ98296]

Hey Nate, do you know if there is a way that AE can read commas, not as breaks, in a CSV doc? I am trying to use the CSV method to aid in video localizations and we need to be able to include commas. Thanks in advance!

[@NTProductions]

If you're using a CSV, you can't use commas, similar to if you were using a TSV, you couldn't use tabs! You will have to use a different character if you want to read it!

[@AC-id5ow]

wrap comma like this "line of text,",

[@shekhkasim2099]

Batch text image from csv file. This is possible

[@automation-nv4ww]

yes.possible

[@shekhkasim2099]

@@automation-nv4ww please share script. If any KZbin videos.

[@sagarvadaliahacks]

I have a video invitation for marriage where I want to individually send to 500 people with their specify name for personal touch . Is it possible to take name from excel sheet and paste to all 500 videos with different name for example one video inside name is Mr A & B , like wise second video should be Mr Y & Z . I know we can do individual rendering by entering name but I want to be done at one click or easy way to finish the project , a help would save me lots of time and really appreciate if you could help me thanks

[@automation-nv4ww]

There is automation script that does it

[@mamdohelseefy]

display a value every 1 second from a csv in after effects