error importing numbers from csv data

[sylvaint98129551]

Seems to be an issue with the way numbers larger than 32768 are imported into AE from a CSV file for data-driven animations.

Steps to reproduce:

1 - Import CSV with numbers smaller and larger than 32768 and add to comp.
2 - Drag out Number data from CSV to composition.
3 - Notice that any numbers larger that 32768 are imported as being "32768" (E.g: Number data point should be 40,000, imports into AE as 32768.

merci beaucoup

[Mylenium]

Not an issue, just a general limitation. 16 bit integers in AE can never be larger than that exact value in AE. Import your values as strings, remap their ranges, import float values or whatever. A million ways around that limitation.

Mylenium

[sylvaint98129551]

thanks for your answer but i don't understand how to convert my csv into floating value and remap their ranges

is it possible to do this with the my file

X Labels,LINE DATA 01,TOTAL
4,2,32623
9,5,
13,24,
17,94,
21,219,
26,2021,
30,4162,
34,6997,
38,10031,
43,13557,
47,16798,
51,20126,
55,23267,
60,27538,
64,39623,

merci beaucoup

[Mylenium]

A string is simply characters encapsulated by " at the beginning and end. Easily done by defining a suitable custom format in Excel before exporting just like multiplying all values by 0.01 or something like that would be to bring them into lower fractional ranges.

Mylenium