Does anyone have any suggestions how to detach a excel file on a local drive via Lotus Notes automatically.I already did some tests with a local scheduled agent detaching the file. But it has to run on several local machines. All with a different userID.
How can I sign the agent with the username and how do I have to set the replcation settings, so that I can update the excel file and leave the agent as it is…
How can I accomplish this? Or has anyone an other idea. All help appreciated.
Subject: Automatically detach excel file on local drive
By ‘detach’ do you mean ‘remove from Notes and save on the local drive’ or do you mean ‘make a copy of the file on the local drive and leave it in Notes’?
If it’s the latter, why not do it when the doc is saved? The code would then live in the form, be easily maintained, and the QS event (or something else if that works better) could handle the local file save automatically for you.
Why do you need a scheduled process?
Subject: Automatically detach excel file on local drive
I would using local agents, it’s hard to maintain and to be sure they are executing.If it’s stored in a common database and it’s enough if the file is detached when opening the database write the code in the Postopen Event of the database script.
To fix the signing problem update the ECL on all clients with a specific ID that is used to sign the agent and give that ID proper access. Check with an administrator how it’s done.