Creative Communities of the World Forums

The peer to peer support community for media production professionals.

Forums Adobe After Effects Expressions AE CC16.1.3 clipping high numeric values from an imported .csv file at 32,768

  • AE CC16.1.3 clipping high numeric values from an imported .csv file at 32,768

  • peter kovalik

    April 12, 2020 at 3:39 am

    Hey users,

    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

  • peter kovalik

    April 12, 2020 at 5:59 am

    I just want to add that since posting this issue, I also tried exporting the data from the Google Sheet as .tsv and .json, and the clipping occurred in these cases as well.

  • Andrei Popa

    April 12, 2020 at 10:45 am

    I don’t know about csv and tsv and i am reaaaaly busy now and can’t test. But here is a solution for JSON.

    Import your JSON file.

    add this expression to where you want to use it

    eval("var myVar = "+footage("data.json").sourceText)

    data.json is the name of the json file, case-sensitive.

    variable is the name of the particular variable/row/data you want to use, also case-sensitive

    You may also try this with csv and tsv, it may work. Also, check adobe’s page with dealing with data files :

    My Envato portfolio.

  • peter kovalik

    April 13, 2020 at 8:50 am

    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.

  • Scott McGee

    April 14, 2020 at 11:05 am

    I can’t figure a way in csv, unless someone can jump in but it you label your number as string in Json.


    “Number”: 1000000,
    “Text”: “10000000”

    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.


Viewing 1 - 5 of 5 posts

Log in to reply.

We use anonymous cookies to give you the best experience we can.
Our Privacy policy | GDPR Policy