PermaLink 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

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


Commentsv

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 }




Enter Comments^



Email addresses provided are not made available on this site.





You can use UUB Code in your posts.

[b]bold[/b]  [i]italic[/i]  [u]underline[/u]  [s]strikethrough[/s]

URL's will be automatically converted to Links


:cool: :-p :huh: :rolleyes: ;-) :-D :-( :laugh: :cry: :-\ :-o :-x :grin: :angry: :-) :emb:






Remember me    

GaryDev
The blog is hosted by the ADVISOR NETWORK.
By Gary Devendorf
Recent Entries
Calendar
March 2010
Su
Mo
Tu
We
Th
Fr
Sa
1
2
4
5
6
7
8
9
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Archive
ADVISOR.com
ADVISOR
MSDN Blogs
The BlogRoll
Lotus Domino ND6 RSS News Feed RSS Comments Feed Geo URL RSS Validator BlogSphere
Powered by
Blogsphere