: 1995 | 49314 | 5830

Make the Files view exportable to .csv from the administrator client 
Come see IdeaJam and LinkJam at Lotusphere 2009 in the Product Showcase at pedestal #227
Use this IdeaSpace to post ideas about Domino Administrator

: 46
: 46
: 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.












Watch Our Videos




IdeaJam can be easily installed, setup and customized by your company.

Learn more >

Introducing 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.


-48
Open Source the Domino Product Line
38
Make an SMTP/POP3 only version of the mail client part of Symphony
22
Specific template for mail-in databases (TeamMailbox from OpenNTF ?)
13
Replication - Deafult Replication Server Issue
29
Make tasks alphabetical on the server console when issuing "Show tasks"
-4
Prevent unauthorized document creation
9
Improve discoverability of old ideas via a "suggest" feature based on user voting behavior
0
Continue statement in LotusScript
-7
Configure the applications to open an attachment
17
Add more options to event trigger notifications
6
Make calendar invites more obvious in the inbox
4
Domino Search as Google Search
13
Less cryptic errormessages
10
Add "merge across" function for tables
9
A "component"-wise extendable / partly enrich-/replaceable, and skinnable Notes client
-3
Referenced Design Inheretence
12
Sametime widget that provides Facebook-like status tracking
12
To separate To Do
6
Installation of sametime on linux with symbolic links to the linux/latest directory
12
Allow pasting in dialog-list fields
9
Automatic creation of archive DB when registering (a) new user(s)
8
Make Truncated documents more obvious
15
Resources reservations : add refreshments (coffee,...) when you book a meeting room
18
Use different color on private calendar entries
19
Out of office (no end date for long absence)
8
Improve paragraph styles
11
Mark proposed new date/time in calendar when countering meeting invites
18
Default Design/Replace to last used server
7
64 bit memory support for Linux x64 distros
12
User friendly version of Domino directory

IdeaJam is hosted by