Prolog:
I'm not a Networker, so maybe my description of the problem sounds a bit strange ....
Description:
TC offers the content-plugin where the file content "file owner" displays the "name / login name / account name" of the user, like "john_x" and "susan_y".
If the user e.g. leaves the company and his account is erased by the admin then the "file owner" displays nothing. "File-properties" (Alt+Enter) of the file displays the SID Security Identifier "S-123-456-...." as "Owner". I have a list of some SIDs with "john_x: S-123..." and "susan_y: S-987...."
Questions:
a) Is it possible to display the SID in a user-defined-column?
b) Is it (simple!!) possible to connect the user-defined-column of SID with my SID-list to display the former users again?
You may simply create custom column set and add owner field from this plugin if you want to see SIDs for unknown users. But I doubt you can associate that SIDs with ones from your list within TC (it seems that simplest way is to create little database with filelist and sidlist and a small request).
Actually you can do it with e.g. Excel. There is a function VLOOKUP that does all you need: it finds passed value in first table column and returns value from second (or other) column.
1. Create book with 2 sheets ('TC Data', 'SIDs').
2. Assign column headers 'SID', 'User Name' for columns A and B of 'SIDs' sheet (fill cells A1, B1), and paste contents of your file with SIDs beginning from second line (A2, B2 - first SID and user, A3, B3 - second etc). If your SIDs and usernames are divided with Tab character (and lines are divided with line breaks), you may just copy-paste text from file to cell A2.
3. Assign column headers 'File Name', 'Ext', 'SID', 'Found User Name' for columns A, B, C, D of 'TC Data' sheet (fill cells A1, B1, C1, D1), copy-paste data with all columns from TC to first three columns (use corresponding column set in TC).
4. Set formula for cell D2 to =VLOOKUP(C2; 'SIDs'!$A$2:$B$20; 2; FALSE) (where 20 is line number of your last line with data on 'SIDs' sheet or larger number for the future user lists processing), apply it via Enter.
5. Click on the lower right corner of cell D2 and drag it down to cell D30 (where 30 is last used line number), and Excel will display usernames for files whoose SIDs were found in table on 'SIDs' sheet in D column. You may also drag D2 cell's corner to line with larger number (e.g. 1000 instead of 30) to create formulas for many lines (Excel will use them if you paste more data to columns A, B, C later).
To apply new list to new data you need to paste new user list to 'SIDs' sheet starting with cell A2 (if needed) and paste data copied from TC to 'TC Data' sheet starting with cell A2 (and maybe drag formula in D column for new cells).
I believe same thing may be done in open-source OpenOffice.Calc.
