: 3143 | 80515 | 9088

Make the Files view exportable to .csv from the administrator client 
Learn more about Elguji's social software product suite at http://elguji.com
Use this IdeaSpace to post ideas about Domino Administrator.

: 53
: 53
: 0
: Domino Administrator / Admin Tools
: administrator, column, export, excel, files
: David Killingsworth 30 Jan 2008
: Open
: / Email
I often times visit the files view in the administrator to look at which mail files on a server are using which template (we have several different templates in operation), which database have quotas and which don't, which databases are over quota, which are the largest databases, etc. etc.
 
It would be great to be able to export the column headings and the actual data to a .csv so that it could be opened with excel.
 
This is currently possible, but through these tedious steps:
  • go to the server console on the actual server with PCA/Remote Desktop
  • (not possible with the admin client itself)
  • sh dir -xml >filename.xml
  • File Transfer with PCA/Remote Desktop/FTP and move the filename.xml to your local machine.
  • Open filename.xml with Excel, select "As XML List" when it imports
  • Let Excel create the XML schema
  • Delete the columns and databases that you don't want and re-save as .xls file
 
 



1) Henning Kunz (30 Jan 2008)
Very good suggestion. Furthermore I would like to be able to export all the viewlike data from adminclient.

Like Notes Users, Database Users etc. from Server Status tab
2) Stephan H. Wissel (30 Jan 2008)
Have a look at the WebAdmin client. I think you call pull the data as XML from it.
:-) stw
3) David Killingsworth (01 Feb 2008)
In some cases, an admin may not use the web admin client, or the HTTP task may not be loaded.
4) Scott Stewart (07 Feb 2008)
How about extending the "Copy Selected as Table" feature to the Domino Administrator? This should include not only the values in the columns listed in the Admin client, but also a link to any database link to any databases, doclinks to server documents, people, etc.
5) Chris Mobley (15 Feb 2008)
I've been dying for this capability for years. Even a simple copy/paste would help.
6) Chris Whisonant (15 Feb 2008)
You can get most of this out of catalog.nsf. You'll need to create some custom views, but there are many fields (such as DbInheritTemplateName) that would help you get what you need. Then you could copy the view as a table and paste into Excel or just export as csv.










:
:

Buy IdeaJam Today!


You can run IdeaJam in your company. It's easy to install, setup and customize and your employees and customers will immediately see results.

Phone: +1 (360) 450-5022

Email: sales@elguji.com

Learn more >>

Welcome to IdeaJam


IdeaJam is a place where people can post and share their ideas, and gauge the marketability, popularity and viability with input from others.

When an idea gets posted, others can help promote or demote the idea and provide comments. Popular ideas will bubble to the top.

Make your opinion count.

Share


Post your idea - from ways we can improve IBM Lotus Software to things we've haven't even yet thought of.

Vote


Check out other people's ideas and vote on the ones you like best. The community votes. The community decides.


Discuss


Talk about ideas with your peers in the IBM Lotus Community and help make them even better.



4
Identify and or filter out duplicates in a view.
-15
Make NTFs viewable in Web browser
-4
Would like to set Policies based on Computer name
9
Ability to tweet a search phrase to @LotusTechInfo, and be returned a search result from the wikis
17
Calendar profile Error for forwarded mail users MUST stop or be configurable
11
Allow anyone to add tags to my idea
11
Time bar to let you know when an ID and mail box file will be completed
-3
Add a per user mail policy.
19
New mail notification for a mail in database or shared mail database
14
Allow Enter key to be used as field exit
3
Combine Server Docs, Ini Settings, and Config Docs (At least from the admins perspective)
5
Add option to be able to save a 'link' to a search result
24
Replace Passport Advantage with something simple
19
Store "Applications" and "Working Sets" in a NSF
20
Possibility to use sortable columns in embedded view, keeping view categories intact
19
Lotus-Notes Designer Best Practice Guide updated for R8/R8.5.x
33
Compact and Fixup and update server tasks should provide a progress indicator
10
Tool to convert lotusscript into javascript
3
Tags should include all ideas
19
TypeAhead for LotusScript Libraries
154
Create empty NotesDocumentCollection
14
Xpages outline view - Expand/Collapse all
7
Features that you would like to see on a mobile from Lotus Wikis
4
Export to csv in IdeasJam advanced search does not include status
5
Add a Status column to the Advanced Search exports







IdeaJam developed by




Hosting by