Hello, i ve made agent which import data into form and after i want to make agent which delete redundant duplicate documents which was imported into database.
But i cannot get the value form this imported document with script
Sub Initialize
Dim s As New notessession
Dim db As notesdatabase
Set db =s.currentdatabase
Set people = db.getview("backlog")
Dim doc1 As notesdocument
Dim doc2 As notesdocument
Dim doc3 As notesdocument
Dim SAP1 As String
Dim SAP2 As String
On Error Resume Next
Set doc1=people.getfirstdocument
Set doc2=people.getnextdocument(doc1)
Set doc3=people.getnextdocument(doc1)
Do While Not (doc3 Is Nothing)
SAP1 = Doc1.backlog_lenovo_order_number(0)
…
…
…
when i run debugger in SAP1 is nothing
when i manually edit and save document and after I run this script
i get the value in SAP1.
Do you know whre coud be problem??
Subject: excel import and get the value from field
It’s probably because SAP1 field is not imported from Excel, but is computed to get value from another field (e.g. field SAP), which was imported. You can try to use doc.ComputeWithForm(false, false) to automatically populate computed fields when you are saving imported documents.
For an agent to quickly import large amout of data from Excel, see here:
Subject: excel import and get the value from field
We have a free Lotus Notes / Domino utility you can download from our website at:Import Utility for Notes
It’s a completely free product which we fully support.
It supports importing from:
One of the features of it is to lookup and update existing documents from imported values. It has many other features including the ability to provide your own scripts to run on imported documents, imports can be scheduled & many more.
Hope it provides some assistance for you.
Alex