Page 1 of 1
Cheking File Size
Posted: Fri Apr 06, 2018 7:00 am
by vishalpoddar90
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.
Re: Cheking File Size
Posted: Fri Apr 06, 2018 7:22 am
by Alan Kirk
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...?
Re: Cheking File Size
Posted: Fri Apr 06, 2018 11:00 am
by Mark RMBC
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:
Code: Select all
wmic datafile where Name="Name of File Path\Name of file.csv" get FileSize >> "Put the output to this file.txt"
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
Re: Cheking File Size
Posted: Mon Apr 09, 2018 12:11 am
by macsir
Powershell is the way to go rather than TI processes.