I can't add CSV files of a certain size to my timeline. I've tried CSV(3.6mb), TSV(3.6mb), Json (20mb, converted from csv), Json with arrays (5mb), and the CSV file split up in several small files with about 240kb (see Video https://www.youtube.com/watch?v=TGy52imsbIg ).
The results are always basically infinite loading times without any result. I've let that process run for me 3.6MB CSV file for 2 hours and ended up with a memory consumption of 13gb but still no result.
The files syntax is correct since i can already use that file without adding it to my timeline. but adding that file to the timeline is essential for exporting it with media encoder.
Thank you for reporting this slowdown. This is a known issue with .csv or other data footage within project files, specifically when added to a Composition as a layer as required to track the data footage as a dependency for rendering in Media Encoder or in Motion Graphics Templates. The team is aware of the issue and is considering possible solutions.
In the meantime, a workaround is to place your .csv into a single Composition ( we'll call this the "Data Comp" ) and place that comp as a layer of the rendering Compositions to track the data footage use. To reference the data, either pick whip to it directly in the Project panel or pick whip to specific data items within Data Comp. While not as easy as adding the data footage directly as a layer, this should greatly improve your saving/loading times when working with data sources.
Let me know if that all makes sense, happy to describe or demonstrate in more detail. - John, After Effects Engineering Team