Use .csv data string as source text
I have generated a .csv Excel sheet from GoPro footage that includes gps, acceleration, gyro, etc. data.
Every data set is build up similiar like the example i've pasted in below.
What i need is kind of a script for my source text in AE that can handle the given values and automatically creates keyframes/switches through the list.
Is this possible with a string expression?
Thank's for your help.
You could create a script that would read the file and create keyframes for the data, or, with newer versions of AE, you could import the csv file and use an expression to interpolate and display the the data.
The syntax for accessing the data from an expression would be something like this:
where the dataValue() parameters specify the column and row of the data element you want to parse. Presumably, your expression would need to read through the data to find the timestamps before and after the current comp time and interpolate the data from those timestamps to get the current value. Hard to be more specific without knowing exactly what you're trying to do.
Thank's for your reply Dan!
I've already found out how to access the JSON with:
My problem is that i'm only looking at the first case and AE doesn't cycle through the cases.
I would need the script to be modified so that every frame/millisecond the case would go on.
Starting with .