Trace progress of loading multiple files

[MT4T]

Hi,

I use sharepoint metadata connector and sharepoint connector to load multiple files from one sharepoint folder.

I need to trace % of progress during loading. 

I have created a few variables but it does not work properly... 

LET vfilename =replace(Peek('ListFiles.ServerRelativeUrl','$(i)','List_of_SKD_FILES'),'/sites/05_BUSINESSPLANNING/','');
LETvCountFileList = NoOfRows('List_of_SKD_FILES');
LET vrecno = (Peek('recno,'$(i)','List_of_SKD_FILES');
LET vindex = NUM(SUM('$(vrecno)' / '$(vCountFileList)'), '00%');

and trace: 

trace Index ∞∞∞ $(vindex) ∞∞∞ filename ∞∞∞ $(vfilename);

It only shows vfilename.

Can you help? 

[marcus_sommer · Accepted solution]

There are various syntax and logic issues within your approach, like wrongly placed brackets and quotes and applying an aggregation within the variable-assigning. So instead of:

LET vrecno = (Peek('recno,'$(i)','List_of_SKD_FILES');
LET vindex = NUM(SUM('$(vrecno)' / '$(vCountFileList)'), '00%');

you may use:

LET vindex = NUM($(i) / $(vCountFileList), '00%');

to get the rate of the loaded files.