Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Creating a Crystl Report against an ldap export ldif file

 3 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Kate Liamero
Veteran Member
Posts: 70
Veteran Member
10/6/2008 11:34 AM
    We have to do an audit on our Lawson Users.  I have an ldap export in an ldif file.  I then imported that in excel and wanted to create a crystal report against it.  My problem is the lawson security fields for Groups and roles.  They are multivalued fields/ arrays.  I want to be able to list the user and then in one column extract the list of  the users groups and in another column list their roles. This can probably be done right in the excel file also but I have no idea how to do this there either. I tried searching for a way in an access database too.  I'm formula impaired.

    Thanks

    Kate
     

    k-rock
    Veteran Member
    Posts: 142
    Veteran Member
    10/6/2008 1:23 PM
      can you post a "fake" line of data?
      Kate Liamero
      Veteran Member
      Posts: 70
      Veteran Member
      10/6/2008 1:32 PM
        name cn zzlwsnattrCheckLS zzlwsnattrEmail zzlwsnattrFirstName zzlwsnattrGroup zzlwsnattrLastName zzlwsnattrName zzlwsnattrPortalRole zzlwsnattrPrimaryStructure zzlwsnattrProductLine zzlwsnattrRole zzlwsnattrSites zzlwsnattrWFUser zzlwsnattrAccess zzlwsnattrAddins zzlwsnattrDepartment zzlwsnattrAllowJobQueue zzlwsnattrServiceName zzlwsnattrSvcEntryAttrList zzlwsnattrPortalAdmin
        asmith asmith YES anyone@anywhere.com Anne LBI LBI-PROCUREMENT RSS basiclawson Smith Anne Smith no_shortcuts.xml PROCUREMENT PROD PRODAccess ProcessFlowRole Buyer RptGenRole LawsonQueryToolsRole BUYERWITHITEMMAST REQUESTER PortalBookmarkAdminRole POSUPER BatchRole ALL 0 N DENY ALL Y
        k-rock
        Veteran Member
        Posts: 142
        Veteran Member
        10/7/2008 8:19 AM
          quickly, you could do Text to Columns using space as a delimiter. That would give you many columns for groups and roles. Ideally, you would have a separate record for each role and each group.