: 3492 | 87812 | 9797

Make the Files view exportable to .csv from the administrator client 
Now Available: "The Social Software Platform You Already Own" Position Paper from Elguji Software. A must read for every IBM Lotus Software customer.
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
:
: / 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
ideajam ideas - Lotusphere
-5
Make Ideajam database as default application on domino
18
All Design Elements view in Designer
0
Create an AppStore for $1.99 apps
13
Symphony API integration in Agents
5
In the view-quick-search dialog, there should an "advanced search" option to find a document in the current view based on the NoteID or UNID
8
Standardize Definition of Application
12
Cleanup process for mystery problems
3
DDM could benefit from addng Twitter or SMS to Notifications
15
license model for universities and schools (education)
4
Dogear: Plugin for many browsers to store bookmark in dogear
8
Give Domino an up-to-date Servlet Engine
13
Admin Client - Server Console
9
Notes Calendar - Show Calendars
12
I wish FilePath would consistently return a relative path whenever possible
26
Select Category option in Views to tick all documents within a category and sub-categories
11
Calendar overlay: documentation how to overlay application calendar
6
inbox: newest first
7
Lotus Script: record call history for for informative debugging
8
Feed Readers page for Domino
17
Get Rid of "Copy as Table" in instances where it doesn't work
16
Expose the SPR database to customers so others can easily get added to the request
10
Multi value core control







IdeaJam developed by




Hosting by