TM1 Forum

Dear All,

Is there any function in TI process to check the size of a file. I tried google and tm1 reference guide but couldn't find anything.
If not, is there a way to get the returnvalue from Executecommand().

Thanks.

vishalpoddar90 wrote: ↑Fri Apr 06, 2018 7:00 am Is there any function in TI process to check the size of a file. I tried google and tm1 reference guide but couldn't find anything.
If not, is there a way to get the returnvalue from Executecommand().

"Size" in what sense; rows, bytes, kilobytes...?

If by size you mean bytes,

I have a batch script to get the last modified date of a file, but it can be easily tweaked to get the file size, so the code below:
I then use the "Put the output to this file" as a data source in a TI to load the value into an admin cube

cheers, Mark

Powershell is the way to go rather than TI processes.