/ Forums / Advansys Formativ / Creating Solutions with Formativ / Export Categories to Excel

  • Creator
    Topic
  • #4327
    ManfredS
    Participant

      Hallo,
      i would like to export items from a GroupWise 7 addressbook including the categories into an excelsheet.

      Can somebody help me how categories can be exported.

      Later i want to export only items which belong to a special category (e.g. private)

      Thanks for help

    • Author
      Replies
    • #7833
      Support 3
      Participant

        See the sample code below to access the categories from an address book entry. See the Object API for more information (http://developer.novell.com/documentation/gwobjapi/index.html?gwobjenu/data/h7ikbsqg.html).

          
         dim oBook
         dim oEntry
         dim oCategory
        
         set oBook = GroupWise.Account.AddressBooks.item("Test Book")
        
         set oEntry = oBook.AddressBookEntries.Item(1)
        
         for each oCategory in oEntry.Categories
           msgbox oCategory.name & oCategory.Primary
         next
        
         set oCategory = nothing
         set oEntry = nothing
         set oBook = nothing
        

        Hope this helps.

        Regards,
        Advansys Support

      Viewing 1 replies (of 1 total)
      • You must be logged in to reply to this topic.