CSV File is generated when you click on the Hashtag Analysis button in the Manage page. Let me explain it using an example:
"KG:QtrlyAppraisals","Sabu Francis","1","#accounts",5,"ASA" "KG:QtrlyAppraisals","Sabu Francis","1","#admin",8,"ASA" "KG:QtrlyAppraisals","Sabu Francis","1","#admin",59,"Blah blah blah" "R:lll_work2025","Sushil|Reshma","work.txt","#accounts",53,"Sushil:abc|Reshma:pqr"
In the above example; line starting with “KG:” means it originated from a Kanban group, whose name is given after the colon. If the line starts with “R:” it means it is for a file in a repository whose name is given after the colon.
The 2nd value is the name of the card owner, on which the comment was place. In case of file-notes, it could have multiple values for these user names because those people all had something to comment on the file. If there are multiple values, they are separated by the pipe character (|)
The 3rd value is the column number on which the hashtag value was given. (0 means the 1st column) If that is not a number, then it is the filename-path for the file on which the notes were written.
The 4th value is the actual hashtag that was collected. E.g. #admin
The fifth value is actually the hashtag value. What the value represents is all up to you. For e.g. If the owner placed #admin:85 It could mean (in one office) as 85% … In another office, the convention may be to represent it as actual money: $85
The sixth and final value of each row is either the title of the Kanban card. Or, in case of file-notes, it would be the notes written by each person who had placed a comment, separated by the pipe character (|)