Solved

Need a slick code that ROCKS everyone here !!!

Posted on 2003-10-23
20
283 Views
Last Modified: 2013-12-18
History:

I have an application with too many views.  Out of which 15 of them are shared - desktop private on first use.
I decided to bring this down to 5 or 6 with design changes on them ofcourse.  The application is replicated on about 40 users laptop.

Requirement :
A Code that will delete all instances of all of the private views !!!

Bonus Requirement:
Just a knowledge on how the private views are treated if they are derived from server and/or local ???  How many views will a person have altogether if he clicks all the private views on server and the clicks all the private views on local ???

Bonus Pts :
This question is worth 5000 pts FYKI !!!
0
Comment
Question by:Arunkumar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 4
  • 3
  • +2
20 Comments
 
LVL 5

Assisted Solution

by:snocross
snocross earned 50 total points
ID: 9607385
What does FYKI mean?  Sorry I know nothing in this area of any help.
0
 
LVL 9

Author Comment

by:Arunkumar
ID: 9608124
For Your Kind Information !!!
0
 

Expert Comment

by:jhoetzl
ID: 9608607
Certainly not worth the 5k points, but might get you somewhere...Your users would be prompted with messageboxes like "removing this icon will delete n private views" and if the database if open, you will probably have other issues...

MyServer:="YourServerNameHere";
DbFilename:="Your .nsf file name here";
@Command([WindowWorkspace]);
@Command([FileOpenDatabase];MyServer:DbFilename);
@Command([FileCloseWindow]);
@PostedCommand([EditClear]);
@PostedCommand([FileOpenDatabase];MyServer:DBFilename)
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Expert Comment

by:jhoetzl
ID: 9608651
Big time kludge, but did the job for me a while back...after instructing the users...

MyServer:="servernamehere";
@Command([WindowWorkspace]);
@Command([FileOpenDatabase];MyServer:"database.nsf");
@Command([FileCloseWindow]);
@PostedCommand([EditClear]);
@PostedCommand([FileOpenDatabase];MyServer:"database.nsf")

Problem here is that the user will be prompted with "Do you want to delete" and "Deleting this will remove x number of private views, do you wish to continue..."  They would have to answer yes...
And, if the database is already open, don't know what it will do...

0
 

Assisted Solution

by:jhoetzl
jhoetzl earned 50 total points
ID: 9608660
arrgh, sorry, double post
0
 
LVL 9

Author Comment

by:Arunkumar
ID: 9608662
And forgot to mention removing and re-adding the icon is not the solution i am looking at.

The thing should work seamlessly without user intervention.  

And even this code fails saying unable to find server ! I have seen all these discussions in Notes.Net and finally i am here with this stupid question, offering 5k pts.

jhoetzl, I appreciate your participation though.
0
 
LVL 9

Author Comment

by:Arunkumar
ID: 9608668
The reason i dont want prompts is.... "You dont know my users !!!"
0
 
LVL 14

Expert Comment

by:p_partha
ID: 9609983
Arun,
Have a look at this link:
http://www-10.lotus.com/ldd/__852565590065A86D.nsf/0/54a247786a4a2e6585256a4f005ad0ec?OpenDocument

Also put this code in a button and send to every user like this:

Dim session As New notessession
      Dim db As notesdatabase
      Dim col As NotesDocumentCollection
      Dim newsletter As NotesNewsletter
      Set db = session.currentdatabase
      Set col = db.UnprocessedDocuments
      count = col.Count
      If count > 0 Then
            Set newsletter = New NotesNewsletter( col )
            Set maildoc = newsletter.FormatDocument( db, 1 )
            maildoc.form = "memo"
            maildoc.subject  = "test"
            maildoc.sendto  = "UR EMAIL ID"
            maildoc.send(False)
      End If
      By this u will have the button for the user to execute and delete the private views...

Partha
0
 
LVL 14

Expert Comment

by:p_partha
ID: 9610013
Read all the posts under the link i provided, some useful tips have been given..

If i get 5000 points then i will be very happy ;-)

Partha
0
 
LVL 14

Expert Comment

by:p_partha
ID: 9610077
0
 
LVL 9

Author Comment

by:Arunkumar
ID: 9610197
Partha!
I have gone through all these links. except notesninjas.  Let me try...
0
 
LVL 9

Author Comment

by:Arunkumar
ID: 9610280
Alright guys...
                    I have a temporary solution for now and I need a permanent one since this makes the database design so very ugly.

This is what i have implemented for now....

Created new set of private shared desktop on first use and relinked all the outline pointers. **** !!!

The next time any design change I will create a new set of views and send it across.  The old ones remain on their desktop where ever i dont care.

Partha, Your effort is again appreciated. But for a guy like me you need to spoon feed the solution and that too for 5000 pts.  Try to use the code that you have given me !  Throws all kinds of errors !!!

;-)
0
 
LVL 14

Assisted Solution

by:p_partha
p_partha earned 50 total points
ID: 9610303
hey that code is jsut for example.. u can embed the form which contains the button to delete the private view and send it
so when the users open their mail they will have a button whcih on clicking will search the relevant datbase and delete the private view

HOpe i make sense

Partha
0
 
LVL 9

Author Comment

by:Arunkumar
ID: 9610318
The problem is the views are not stored in the database. They are stored in the desktop of users !
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 9610586
Well, for the new views, you shoudl allow them to be stored in the database.

It is possible to lop through all the notes in the DESKTOP5.DSK and "guess" which ones are our views, and then delete them.

I beleve there is also an option buried somewhere that allows you to force derived priavte views to "rederive" themselves from teh source private on first use design, but I don't remember what it is ir if it is 5 or 6.
0
 
LVL 9

Author Comment

by:Arunkumar
ID: 9614050
Storing in database will blow my db size for sure.  I have read so many many threads on the size of the db growing beyond control.
And it cannot be controlled because people need private views.

Desktop5.dsk did not get me my private views on R5.

I hate to say, I tried changing this to single category view, and the view SUCKS without a selection margin/ sortable column headings or action buttons.

Just 30 mins back, i moved my new view into production and what happened ?   - No complaints.  Everyone are happy.  Is this what I want ?  Yes and NO !!!

:-(
Arun.
0
 
LVL 31

Accepted Solution

by:
qwaletee earned 350 total points
ID: 9617669
#1) It is possible to have a selection margin and sortable columns in a single catgeory view

#2) Desktop5.dsk DOES contain the private views, unless they really are on the server. You just have to know how to find them :)

#3) Database bloat from private views.  Not necessarily.  First, set the indexes to expire frequently.  A lot of people use their private views (or many of them) infrequently, so they will dies away.  Also, it will have a big positive effect on performance, not just for the user building the view.  That's because teh idnexer on teh server runs slowly in the background, while a user building a local view against teh database is actually openeing every document in full in a high-prioroity thread, and then flooding teh network with them.  How do you spell trade off?
0
 
LVL 5

Expert Comment

by:snocross
ID: 9696498
Why did you give me an assist... you're so goofy!
0
 
LVL 9

Author Comment

by:Arunkumar
ID: 9696593
haa haa haa.. I wanted to give points so, i gave everyone pts.  
0
 
LVL 5

Expert Comment

by:snocross
ID: 9696602
Ah, I see... thanks.  Can I have your car now and some spending cash?
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

749 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