LDAP Data not showing in report since v5 Upgrade

[retro2707]

Hi,

I setup a map file in config.pm with the following information:

Code: Select all

	Map => [

	# var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly, http-link-target
		[ 'UserFirstname', 'Firstname', 'givenname', 1, 1, 'var' ],
		[ 'UserLastname', 'Lastname', 'sn', 1, 1, 'var' ],
		[ 'UserLogin', 'Login', 'sAMAccountName', 1, 1, 'var' ],
		[ 'UserEmail', 'Email', 'mail', 1, 1, 'var' ],
		[ 'UserCustomerID', 'CustomerID', 'mail', 0, 1, 'var' ],
		[ 'UserPhone', 'Phone', 'telephonenumber', 1, 0, 'var' ],
		[ 'UserDepartment', 'Department', 'department', 1, 0, 'var' ],
		[ 'UserOffice', 'Office', 'physicalDeliveryOfficeName', 1, 0, 'var' ],
		[ 'UserCompany', 'Company', 'company', 1, 0, 'var' ],
		[ 'UserManager', 'Manager', 'manager', 1, 0, 'var' ],
		[ 'UserExtension', 'Extension', 'ipPhone', 1, 0, 'var' ],

      ],

In v4, I had a report which output this information pulled from Active Directory. However, in v5, the report just shows blank information for the fields like Office, Company, Department etc. I know the data is being imported because when I go to customer information, all the data is there. Additionally, all data is there up to the point that I did the upgrade, just data after that time is blank. The same goes for any reports I run for things like time spent on tickets using the Company or Department fields, they did work ok but not now.

I have recreated the reports but no change, rebooted the server, no change, and upgraded to version 5 patch 17, but the problem is still there.

Could anyone please help?

Thanks,

Brendan

[nedmaj]

Hi,

What report are you talking about? Is that a OTRS report?

[retro2707]

Hi and thanks for replying,

Correct, this is just a standard OTRS ticket list report.

The way I did it was to create dynamic fields for each one of LDAP attributes I want to map, with the same name as the "storage" entry in the map file (e.g. company,manager,department)

I select the attributes to be printed in the report, and I just select the dynamic fields I created above. I know the data is being pulled into OTRS because under the customer user management, all these fields contain data for users. I have also confirmed that new users created since the upgrade have this information mapped too, which is why I thought it was more of a reporting issue. Just any tickets created since the v5 upgrade dont seem to report this information.

Bit of a strange one!

Brendan

[jojo]

Data is not copied automatically. You have to set it up in sysconfig (after creation of dynamic fields)

Search for DynamicFieldFromCustomerUser in Sysconfig

[retro2707]

jojo! If I could give you a high five/ hug/ kiss I would, that worked perfectly!! Not sure why this changed with the upgrade. Thanks so much. You saved my day!

[nedmaj]

Not sure why this changed with the upgrade.

Strange. Suggest you double check the ZZZAuto.pm.