GaryDev

Latest version of my Azure - ReadViewEntries utility03/09/2009 02:49:05 PM

I’ve finished the Azure utility for Notes/Domino. This is a “no touch” method of pulling live data out of Notes/Domino and can be used with any Domino Server.

Please give it a try. Here is how:

Show the customer a Notes view (http://www.msdomino.net/products.nsf/productslist?openview or
http://www.msdomino.net/orders.nsf/customer%20orders?openview ) in a browser.

Then show the native XML over HTTP Domino functionality of the ReadViewEntries URL command for these views:
http://www.msdomino.net/products.nsf/productslist?readviewentries&count=-1 or
http://www.msdomino.net/orders.nsf/customer%20orders?readviewentries&count=-1

Once the customer sees this XML, we add my utility by putting “http://readviewentriespage.cloudapp.net/Default.aspx?” in front of the ReadViewEntries URL:
http://readviewentriespage.cloudapp.net/Default.aspx?http://www.msdomino.net/products.nsf/productslist?readviewentries&count=-1 or
http://readviewentriespage.cloudapp.net/Default.aspx?http://www.msdomino.net/orders.nsf/customer%20orders?readviewentries&count=-1

The result is a nicely formatted XML displayed.

Now open Excel 2007. In a blank worksheet, select the “Data” tab then “From Web”.
Image:GaryDev - Latest version of my Azure - ReadViewEntries utility

Image:GaryDev - Latest version of my Azure - ReadViewEntries utility

In the dialog box, paste the combined URL in the address text box and select “Go”.
(http://readviewentriespage.cloudapp.net/Default.aspx?http://www.msdomino.net/orders.nsf/customer%20orders?readviewentries&count=-1)

Once the XML is displayed, select the arrow in the upper left corner of the text box and hit the “Import” button near the bottom right.
Image:GaryDev - Latest version of my Azure - ReadViewEntries utility

A notification will appear saying there is no schema for this XML so Excel will create one. Select “OK”.
Image:GaryDev - Latest version of my Azure - ReadViewEntries utility

Excel will ask you where to put the data; use the default by selecting “OK”.
Image:GaryDev - Latest version of my Azure - ReadViewEntries utility

The result is live Notes/Domino data in you spreadsheet:
Image:GaryDev - Latest version of my Azure - ReadViewEntries utility

To show the data is live, delete much of the data. The under “Data”, “Refresh All” pull down, select Refresh.
The data is over written.

Image:GaryDev - Latest version of my Azure - ReadViewEntries utility

Comments

1. Alanna03/25/2009 02:58:04 AM
Homepage: http://www.craigslistguide.info

I recently came across your blog and have been reading along. I thought I would leave my first comment. I don't know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often.

Alanna

{ Link }

GaryDev

The blog is hosted by the ADVISOR NETWORK.

Su	Mo	Tu	We	Th	Fr	Sa
	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30	31