View Comparisons

Posted on 2005-04-26
Medium Priority
Last Modified: 2013-12-18
Does anyone have any suggestions on how to compare a view with an excel spreadsheet and note the differences either in a another view or some other way?  Or perhaps compare 2 similiar views with each other and note the differences in a 3rd view?

Columns in both the Excel spreadsheet and the view to be compared with would match as far as names.

The reason for this is as follows:
We have a report that comes down from our mainframe each month showing usernames and the applications and transactions that they have. I open this report in monarch, apply a model, then export it to a table and save it as an excel spreadsheet.

Users request transactions and applications using a Notes database which goes through an approval process.  I want to make sure that what the users are approved for matches what they have in the downloaded report.

Any suggestions would be appreciated.
Question by:schmad01

Expert Comment

ID: 13866564
Here's a couple of suggestions:

If you have R6, you can use the Edit > Copy Selected To Table feature to copy the view entries then paste them into the excel spreadsheet.  Then you could use excel functions to compare row by row.

For comparisons of text files, I use a great freeware utility called ExamDiff:  http://www.prestosoft.com/ps.asp?page=edp_examdiff

You could try exporting both the excel sheet and view to two text files and then use this program to compare the differences.

Author Comment

ID: 13866580
Using R5
LVL 31

Expert Comment

ID: 13868703
Why not just export to Excel for the compare?

The other way to do this is to take one of the export to Excel agents form Notes.Net, but program it so that instead of actually taking each cell value and pushing it to Excel, just grab the value from the cell that it would have been pushed to and compare.  Shoudl not be too difficult, even if you don't know that much about Excel OLE programming.... just change the line of code that sets the value to instead get the same value, and add a line to compare that to teh value that you WOULD have set.

As far as storing the results, I would start off with just writing out a text file noting the cell number for the cells that don't match.
LVL 13

Accepted Solution

CRAK earned 2000 total points
ID: 13870363
Or a solution within notes.... assuming that's what we're most familiar with!

Import the Excel sheet in Notes as a different form (searching for "COL" in designer help often helps when importing plain as text).
Have two views, sorted: one containing the existing notes docs, the other showing the imported stuff.
Using LS, start at the top of both views. 3 situations may occur when comparing the column values:

1) DocA > DocB
-> take action and continue using GetNextDocument(DocA)

2) DocA = DocB
-> I guess you require no actuin but to continue using the next documents of both DocA and DocB

3) DocA < DocB
-> take action and continue using GetNextDocument(DocB)

Author Comment

ID: 13920875
Great thanks all.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question