Problem with loop and reading from Active Directory

Tue, 23 Sep 2014 08:21:08 GMT

Hi,

i want to read the e-mail adresses from Active Directory. The connection works good, when i type a person name and surname it gives me his/her e-mail adress. But i have a problem with a loop which gets the name and surname from excel and then asks the active direcotry for e-mail.

My loop looks like this:

LET rowTextMail = NoOfRows('PM');

for i=1 to rowTextMail

let firstName = chr(39)&'%'&mid(FieldValue('op_name_pm',$(i)), 1, Index(FieldValue('op_name_pm',$(i)), ' '))&'%'&chr(39);

let surName = chr(39)&'%'&mid(FieldValue('op_name_pm',$(i)), Index(FieldValue('op_name_pm',$(i)), ' ')+1)&'%'&chr(39) ;

ADReportPM:

LOAD

userPrincipalName as mail_pm,

sn as sn_pm

;

SQL select

userPrincipalName, sn, givenName

FROM 'LDAP://xxxxxxx' WHERE sn=$(surName) AND givenName=$(firstName);

I've checked and firstName and surName give me perfect name and surname, but when i loop i get nothing.

But when i type:

FROM 'LDAP://xxxxxxx' WHERE sn='Nowak' AND givenName='Piotr';

it works...

Where is the problem? I've tried diffrent types of passing the variables: WHERE sn='$(surName)' AND givenName='$(firstName)'; but none of them worked...

Re: Problem with loop and reading from Active Directory

Tue, 23 Sep 2014 09:33:03 GMT

I have the same problem, something is wrong with passing the variable ...

topic Problem with loop and reading from Active Directory in QlikView

Problem with loop and reading from Active Directory

Re: Problem with loop and reading from Active Directory