• Search Forums
    Advanced Search Topics Posts
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.