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
Solved

Need a slick code that ROCKS everyone here !!!

Posted on 2003-10-23
20
282 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
  • 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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

 

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Peculiar IBM Lotus Notes / Cisco VPN Issue 21 924
If no attachment, dont send email - lotus notes/vba 10 387
Lotus notes email code 2 126
Lotus Notes Calendar Issue 5 113
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…

856 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