Solved

Archiving via a replica

Posted on 2000-04-12
2
207 Views
Last Modified: 2013-12-18
Hi,

I'm writing an archive routine in script to remove all documents that haven't been modified in over a year. The problem is that I created a replica yesterday, I don't want to work on the live db. As a consequence of this the lastmodified property in script is giving yesterdays date. If you right click on an old document the modified date is the true modified date, and the 'modified in this file' is yesterdays date. Is there an easy way to access the first modified date through script? I'm using Notes 4.6

Thanks
0
Comment
Question by:srandrews
2 Comments
 

Accepted Solution

by:
floriangrimm earned 50 total points
ID: 2707768
bad news
no you cannot

but...
you can copy the file - you have stop the server (are you admin?)...


don't you replicate to any server?
if yes you may have a problem, but also a simple solution

create an field e.g. "lastsave" (date)
in the recalc-event you set the field to now
(FIELD lastsave := @Now;
@Success).
(Now you can set the field in an Agent
FIELD lastsave := @Modified;
SELECT @ALL)

now test the new field in your script.

if you often modify these documents, there is a problem --- replica and save conflicts...
{but you might help do test the field befor seting...
FIELD lastsave := lastsave;
@if(lastsave <= @Adjust(@Now;0;0;-7);
  @SetField("lastsave"; @Now);
  @Success);
@Success
)

i hope this helps....
bye Flori
0
 

Author Comment

by:srandrews
ID: 2707796
Not what I was wanting to here! But I was expecting it. I don't want to modify 100,000 documents, which is how big the database is. I have just checked and @Modified returns the correct modified date so I'll use the Evaluate command in Script.

Cheers Flori
0

Featured Post

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!

Question has a verified solution.

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

  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.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

763 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