After effect : my csv text vanished after Media Encoder encoding....

Report · Jul 27, 2022

Hi,

Here's my point :

In AE 22.5 build 53 :

- A composition only displaying a text from .csv UTF-8 file from Excel

- Text displayed thru expression " footage("Classeur1.csv").dataValue([0,1]) "

- Everything works out right in AE preview, my text is here on the screen

In Media Encoder 22.5 build 57 :

- Encoding in h264 from AE export command

None of my .csv text is displayed. Nothing. Text entered in AE is correctly displayed but any of my .csv text is ignored...

What to do ?

Thanks for helping... I'm quite dying with that thing !

GP

Report · Jul 27, 2022

This is a known issue/ limitation. references directly from the project panel will disappear because AME cannot resolve the file path correctly. You need to add the file as a footage item to the timeline ands link it from there. Otherwise simply render an intermediate file directly from AE and convert it later.

Mylenium

Report · Jul 28, 2022

Hi Mylenium,

You want it marble ou steel ? I mean the statue I'll erect to your effigy.

Thank's so much for your feedback. I thought it was due to a bad UTF encoding and made so many trials...

footage(thisComp.layer("Classeur1.csv")).dataValue([0,1]) and hop, problem solved !

Thanks again.

GP

Report · Oct 13, 2022

Thanks for this info!

I have a CSV with a bunch of telemetry pertaining to speed, GPS position, G-forces, etc. Each row represents 0.05 seconds, and the full file is over 30,000 rows long. When I trimmed it down to just a few thousand rows After Effects could import it to the timeline just fine, but with the original file it will just sit there and load for as long as it's left alone. (I let it go for 40 minutes.)

For anyone in the future coming from Google (like I was) working with time-based CSV files, if you make your first column into milliseconds then run it through this website, by @0kajuna0 (or if the website is down there's a github version) it will convert to correctly timed mgJSON automatically, which turned out to be perfect for my usecase. Good luck!