I need to import data into AE CC 2019 from a Google sheet. I export the sheet as a .csv file which is the used to drive my animated contents. For some reason any higher numeric value in the .csv file is imported into AE clipped at 32,768. I understand that this value represents a pixel position limit, or the maximum RGB values in 16 bit mode. However there is no reason why a list of simple numbers, ranging from 0 to say 200,000, should be clipped at that value. I’m at a loss as to why that should be, yet obviously AE seems to be misinterpreting these values somehow. ANy suggestions what may the reason for this be, and even more importantly, how to resolve this issue?
Thank you for the suggestion, unfortunately again I was unable to make it work. I feel part of the problem is that the basic info on adobe site is too basic to resolve anything a bit out of the ordinary, but everything else is at this point still beyond me.
However, in the process of trying to make it work, I did discover that accessing the .csv from the project bin using the “footage().dataValue();” method as opposed to dropping the .csv into my comp and accessing its contents directly there, made the difference. Dropping it (or .tsv or .json) automatically clips the values to 32,768, whereas keeping it in the Project bin keeps the values intact. If anyone can explain that on to me I would greatly appreciate it.
I can’t figure a way in csv, unless someone can jump in but it you label your number as string in Json.
So Number returns back 32768, but Text returns 1000000, but as a string. So if you are wanting it to work as a number you just need to do the below method to create it into an integer. Or just leave be as it’ll work as a string.