-
CSV scripting output
Trying to automate a pile of tags for affiliates from a CSV provided by another department. Thankfully just stills, no animation. However my automation skills are weak and my scripting skills are nonexistent. Stealing and combining chunks of code from various online examples, I think I’ve got everything working, pulling info from a CSV that uses an AE dropdown menu to show the correct logo file and populates the text layers, but I’m stuck on the output.
I have a loop set up that saves each tag individually, but I can’t get the filename to populate with the station call letters correctly. It just names it with the current loop number (i). Can someone help with the code to properly save each version of the tag with the Column 0 CSV text value in the row matching the loop number?
-
7 Replies
-
hey bro! no panic just send me the project file and the script you have and i’ll send that back to you fully working along with a short tutorial guide, i hope you appreciate the help!
-
Much obliged! Legal won’t let me release anything “identifiable” so let me replace anything they might find problematic and I’ll post it up. And yes, help is definitely appreciated!
-
Okay, think I’ve eliminated anything that might give Legal a breakdown and replaced it with generic info. The .js file is a mess, but it was cobbled together with chunks from the internet that seemed to do what I needed. No doubt there’s a much more elegant solution.
End of the day, I’m hoping to take the CSV from another department (that will be getting changed and updated constantly), run through the length of the CSV, and spit out a PNG for each CSV row, named with the info in the STATION column. I’m 90% there but can’t get the filename to use the STATION data.
-
Alright Jeff here’s the fixed materials that now do the things you said along with notes, give it a try, i hope this makes your day slightly better
-
Amazing! Works like a charm. I can understand maybe an eighth of the actual script, but the results are perfect! Many, many thanks! You just saved me piles of time and headaches.
-
my pleasure bro! whenever you need more help, you know where to find me
-
Thanks for solving this, John!
Reply to this Discussion! Login or Sign Up