Export excel file that shows warnings by user

[s.othman]

I want to make a script that creates an excel file that shows each warning and the name of the user who have done it

[sovitek]

Hi @s.othman could you show how far you are in that project ?

[Draxl_Andreas]

@s.othman ,

hahaha after that you won`t have friends any more … we address warnings this way … its more like creating “homework”

fil01 = DSOffice.Data.ImportCSV(errRpt);
rpt01 = String.Remove(List.DropItems(List.DropItems(String.Concat(List.Transpose(fil01)),3),-1),0,4);

//Elements
eID01 = List.TakeEveryNthItem(rpt01,2,0);
eID02 = String.AllIndicesOf(eID01," id ");
eID03 = String.ToNumber(String.Substring(eID01,eID02+3,7));
elm01 = Revit.Elements.ElementSelector.ByElementId(eID03);

//Error Messages
err01 = List.TakeEveryNthItem(rpt01,2,1);
err02 = String.IndexOf(err01,">")+3;
err03 = String.LastIndexOf(err01,"<") - String.IndexOf(err01,">") - 5;
err04 = List.TakeItems(String.Substring(err01,err02,err03),List.Count(eID03));

KR

Andreas

[s.othman]

In fact, I am building a Power BI dashboard that shows me everything about warnings, currently I have extracted these Data about warnings ( Number and Type ) and I want to add the user’s name to engage Modelers to resolve these warnings and avoid ignoring them.