Getting Dialog List Values into Excel from Notes database

Posted on 2003-02-21
Medium Priority
Last Modified: 2013-12-18
I have two fields in a notes view 'testView' EmpNo and his Interest. The Interest is from a Dialog List consisting of multiple values for an employee. How will I output the same information into a excel file. example row 1 will be emp 1 and Interest 1 which is checked. row 2 will be emp 1 and Interset 2 which is checked.

Question by:RaghunathR
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
  • 3
  • 2

Expert Comment

ID: 7994853
You can select [File][Export] from the menu, and whatever is displayed in the view will be exported.  Select "Lotus 1-2-3" as the file type and this can then be read by Excel. If you want only selected documents, just select the ones you want before you click the menu commands.

Author Comment

ID: 7994946
I need to write an agent for the same, can you let me know how to read the values.. I can write the same in excel if I will be able to get the selected list values for a particular employee

Expert Comment

ID: 7995317
YOu best bet programatically is to create a CSV expoprt file. There is some sample code in two posts that I made at SearchDomino.com. They should be a good starting place.

See "Formats a text output file" for how to create the output file and process the view:  http://searchdomino.discussions.techtarget.com/WebX?msgInContext@253.7elmabZhARo.2@.ee7740b/8904

See "check post 8905" for the code used to append a row for each record processed: http://searchdomino.discussions.techtarget.com/WebX?msgInContext@253.7elmabZhARo.1@.ee7740b/15479


Author Comment

ID: 7997287
This doesn't help can you let me know how to read the values from a Dialog List(Multi select list box)


Accepted Solution

burmontpoint earned 400 total points
ID: 8008244
Here is a sample from the help files. Substitute your field name for "SendTo". and then change the code inside the forall loop to process each value in the field.

Dim doc As NotesDocument
Dim item As NotesItem
Dim j As Integer
'...set value of doc...
Set item = doc.GetFirstItem( "SendTo" )
' if there's no SendTo item
' try to find another item of type Names, that has a value
If ( item Is Nothing ) Then
  Forall i In doc.Items
    If i.IsNames And ( i.Values( 0 ) <> "" ) Then
      Set item = i
      Exit Forall
    End If
  End Forall
  ' if we found an item of type Names
  ' mail the document to people in that item
  If Not ( item Is Nothing ) Then
    Call doc.Send( False, item.Values )
  End If
' if there is a SendTo item, no parameters needed    
' mail the document
  Call doc.Send( False )
End If

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

771 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