Highlighted

error importing numbers from csv data

New Here ,
May 05, 2020

Copy link to clipboard

Copied

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

Topics

Error or problem

Views

118

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

error importing numbers from csv data

New Here ,
May 05, 2020

Copy link to clipboard

Copied

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

Topics

Error or problem

Views

119

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Most Valuable Participant ,
May 05, 2020

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
New Here ,
May 06, 2020

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mylenium LATEST
Most Valuable Participant ,
May 06, 2020

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...