7 Steps to making the new XPages Wiki simpler ( about an hour )

The “new” XPages wiki on Openntf ( known as the Xpage Documentation Wiki ) has some useful improvements over the older version but the tailoring for its use in the IBM product Wikis has also made it more complicated. This is a very quick article showing how it can be simplified so that it is easier to use for general projects etc..

The end result

Image:7 Steps to making the new XPages Wiki simpler ( about an hour )

Step 1 – Hide the media gallery if you don’t want it

Image:7 Steps to making the new XPages Wiki simpler ( about an hour )

Step 2 – Hide the extra tabs at the top

These are quite clever but too complicated for this use case

Image:7 Steps to making the new XPages Wiki simpler ( about an hour )

Image:7 Steps to making the new XPages Wiki simpler ( about an hour )

Step 3 – Change the Go Elsewhere Footer

This has a complicated “hide – when” on it. delete the computed fields and replace them with links. You can copy the ones from the adjacent panel but remember that the individual links have hide-when properties too.

Image:7 Steps to making the new XPages Wiki simpler ( about an hour )

Image:7 Steps to making the new XPages Wiki simpler ( about an hour )

Step 4 – Change the default opening page for the web

Image:7 Steps to making the new XPages Wiki simpler ( about an hour )

Step 5 – Hide the company contributors panel

Image:7 Steps to making the new XPages Wiki simpler ( about an hour )

Step 6- Correct a bizzare URL issue

This one stumped me.
When you click on a new document link within the body of a document i.e. [[document name]] where document name does not yet exist, it was trying to open a wiki at the URL /dwlhub.swg.usma.ibm.com. I cannot find this anywhere in the design or in the profile documents.
The problem also affects the plus.gif icon
The changes to the code below solve the problem. Judging by the print statements I am not the first to have had this problem.

Image:7 Steps to making the new XPages Wiki simpler ( about an hour )

Step 7 – Correct a missing MenuUtility.js file

This js file is not used and does not exist but it is down as a resource on two custom controls. If you check Firefox you will see that it is generating an error.
Remove the references
Image:7 Steps to making the new XPages Wiki simpler ( about an hour )

SNTT : Pulling Notes data into Excel via http / XML

Just a very quick tip to show how you can dynamically pull your latest Notes / Domino data into an Excel Spreadsheet.
Note that this method will only work for domino applications which do not require authentication

Basic Idea

In Excel go to Data and click on the Data and then “From Web” options

Image:SNTT : Pulling Notes data into Excel via http / XML

Next paste in the URL of your Domino XML feed ( more on that later )

Accept all of the options and your data will be added in a nicely formatted table.
The table is also given a name so that when you reference it from pivot charts etc.. the chart will always contain all of the data from the XML feed.

Creating the XML Feed

I knocked up a simple agent that will generate XML based on a search string or a view name and some other configuration.
The code is not great and should really have been done using classes but it works well enough. I have attached a demo database to the end of this article.

The config looks like this :

selection##view##vActionsAll##
reference##field text##Reference_Tx##TBA
days_old##field delta date days##IssuedDate_Tx##@now
unid##formula##docalcres = “this bit is calculated => ” + doc.universalid##

The construction of the configuration varies. For line 2
part1 = XML property name
part2 = “the method”
part3 = the Notes filed name
part4 = the value to publish if the field name is empty

for line 3
part1 = XML property name
part2 = “the method”
part3 = the first date
part4 = the second date

for line 4
part 4 is a lotusscript expression that will be evaluated.

You can see the output here :
http://deliverytoolkit.com/public/fdt/moc/mocdemo.nsf/xmlagent?openagent&XML_Feed_Test

Numbers as text and modifying the schema

Although Excel is very clever in automatically generating a schema for the XML feed it does not allow you to edit it. This is where the new .xlsx format comes into its own.

If you change the .xlsx to .zip you can open the Excel file and modify the schema.

Image:SNTT : Pulling Notes data into Excel via http / XML

Image:SNTT : Pulling Notes data into Excel via http / XML

Note : you will need to delete the affected column in Excel and re-create it for the new schema to kick in

Image:SNTT : Pulling Notes data into Excel via http / XML

Thanks to Gary Devendorf

I have been using variations of this technique for some time. The idea originally came from Gary Devendorf who has published examples of how it can be done with earlier versions of Excel.

Download

The download link is below. You can see examples of the same database here :
http://seancull.co.uk/public/examples/SC/XML_Excel_Demo.nsf/xmlagent?openagent&XML_DEMO_View

XML_Excel_Demo_Download.zip
Book1.xlsx