Solved

Need a slick code that ROCKS everyone here !!!

Posted on 2003-10-23
20
278 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
 

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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
VBA Lotus notes 2 185
Add a cc field to email code 6 94
See used databases in Domino 8 96
LotusScript: Merge Data to Word File 22 73
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…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now