I as an Lotus notes admin is required to find number of users department wise in my organisation. I have made a practice to complete entries in Work/Home tab of person document immediately after registration. Is there any way I can export all person documents in a excel sheet where I can perform of departmentwise sorting/filter.
Thanks in advance.
Subject: Sure
Not without any customization but with a custom agent no problem. Just export all or just selected document to excel worksheet.And even send the updated information back.
/Fredrik
Subject: You would have to find or create a view displaying all relevant data…
Select all Documents (Ctr-A) and select Edit -Copy as Table
Open Excel afterwards and past the content of the Clipboard (works from every view, by the time)
Subject: Thanks
Sorry, I was so busy searching for solution that I forgot to check back the responses. However , solution found in www.openntf.org. It provides excellent codes for administrators including one I needed.
Thanks to both of you.
Ragards
Vikas