Lotus Script Help

Posted on 2004-10-05
Last Modified: 2013-12-18
Hi, I'm extracting some data from an excel spread sheet and placing the values in the form I'm in.
When I'm doing this, I'm actually in the form. When I click the button this agent runs and it works fine.
But I've to back out of the document and come back in again to view the imported values.

Do I have to change something here...

here is the code:
Sub Initialize
      Dim session As New NotesSession
      Dim db As NotesDatabase
      Dim view As NotesView
      Dim view1 As NotesView
      Dim doc As NotesDocument      
      Set db = session.CurrentDatabase
      Set doc = session.DocumentContext
      Let AddMANBANCount = 0
      Let UpdatedMANBANCount = 0
      Let DropMANBANCount = 0
      Dim FileNum As Integer
      Dim xlFilename As String
      On Error Goto Errorhandler
      Filenum% = Freefile()
      xlFileName$ = Inputbox("Enter the excel file name and path here? example:C:\filename.xls")
      If xlFileName$="" Then
            Messagebox "The file location was not specified correctly. Please enter the file location correctly.",,"Account Information"
            Exit Sub
      End If      
      Dim One As String      
      Dim row As Integer
      Dim Written As Integer
      Dim Dropped As Integer
      Dim Switch_Y As String
      '// Next we connect to Excel and open the file. Then start pulling over the records.
      Dim Excel As Variant
      Dim xlWorkbook As Variant
      Dim xlSheet As Variant
      Print "Connecting to Excel..."
        Set Excel = CreateObject( "Excel.Application" )
      Excel.Visible = False '// Don't display the Excel window
      Print "Opening " & xlFilename & "..."
      Excel.Workbooks.Open xlFilename '// Open the Excel file
      Set xlWorkbook = Excel.ActiveWorkbook
      Set xlSheet = xlWorkbook.ActiveSheet
      '// Cycle through the rows of the Excel file, pulling the data over to Notes
      Goto Records
      Print "Disconnecting from Excel..."
      xlWorkbook.Close False '// Close the Excel file without saving (we made no changes)
      Excel.Quit '// Close Excel
      Set Excel = Nothing '// Free the memory that we'd used
      Print " " '// Clear the status line
      Let row = 0 '// These integers intialize to zero anyway
      Let Written = 0
      Let tmpnullrows=0
      Print "Starting import from Excel file..."
      Do While True
            With xlSheet
                  Let row = row + 1
                  If .Cells (row, 1).Value = "" Then
                        Let tmpnullrows=     tmpnullrows+1
                        If tmpnullrows=2 Then
                              Goto Done
                        End If
                        Goto Process
                  End If
                  If .Cells (row, 1).Value = "Accounts" Then
                        Let Switch_Y = "Y"
                        Goto Process
                  End If
                  Dim EMAN As String
                  Dim EMANTrim As String
                  If Switch_Y = "Y" Then            
                        Let EMAN$ = Val(.Cells( row, 1 ).Value)
                        Dim MANItem As NotesItem
                        Set MANItem = doc.GetFirstItem("MTN")
                        Let EMANTrim$ = Fulltrim(EMAN$)
                        Select Case Len(EMANTrim$)
                        Case "13"                  
                              Call MANItem.AppendToTextList(EMANTrim$)  
                              Let Written = Written + 1
                              Print Written
                              Let tmpnullrows=0
                        Case "12"
                              Let EMANTrim$ = EMANTrim$ & " "
                              Call MANItem.AppendToTextList(EMANTrim$)  
                              Let Written = Written + 1
                              Print "Written Count is: " & Written & " (" & EMANTrim$ & ") "
                              Let tmpnullrows=0
                        Case "10"
                              EMANTrim$ = EMANTrim$ & "   "
                              Call MANItem.AppendToTextList(EMANTrim$)    
                              Let Written = Written + 1
                              Print "Written Count is: " & Written & " (" & EMANTrim$ & ") "
                              Let tmpnullrows=0
                        Case Else
                              Let Dropped = Dropped + 1
                              Print "Dropped Count is: " & Dropped & " (" & EMANTrim$ & ") "
                              Let tmpnullrows=0
                        End Select                        
                  End If      
                  Call doc.Save( True, True ) '// Save the new doc
                  Goto Process
            End With
      Print "Error" & Str(Err) & ": " & Error$
      Resume Next
      Print "Done"
End Sub
Question by:chakrika
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

Accepted Solution

kalios earned 500 total points
ID: 12229227

Replace this

Dim session As New NotesSession
     Dim db As NotesDatabase
     Dim view As NotesView
     Dim view1 As NotesView
     Dim doc As NotesDocument    
     Set db = session.CurrentDatabase
     Set doc = session.DocumentContext


                Dim workspace As New NotesUIWorkspace
      Dim uidoc As NotesUIDocument
      Dim doc As NotesDocument
      Set uidoc = workspace.CurrentDocument
      Set doc = uidoc.Document

LVL 31

Expert Comment

ID: 12229297
You need to use the NotesDocument coming from the open form, so that there is an association between the UI and back end.  DocumentContext won't give that to you.

Dim ws as New NotesUiWorkspace
Dim doc as nptesDocument
Set doc = ws.currentDocument.document 'ws.currentDocument is the notesUiDocument object that represents the open form, currentDocument.document is a notesDocument that is synced into the currentDocument

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
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…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

623 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