Section access from CSV not working - user not found

Mon, 26 Jan 2026 18:19:17 GMT

Hello, the section access of Qlikview is driving me crazy.

I am loading data from a CSV file but when i try to enter the user it is not recognized.

Meaning I am prompted for a Username and when i enter admin, it asks me for a user name again.

Here the CSV LAYOUT I use

"ID","USERNAME"

"001","robert"

and here the Code i use in the script

AccessTable:

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, admin, admin

];

AccessTable_tmp:

LOAD [ID] as [USER_KEY]

,'ADMIN' as ACCESS

,[USERNAME] as [USERID]

,[USERNAME] as [PASSWORD]

FROM

"..\InputData\ref_ter_users-Copy.csv"

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Concatenate(AccessTable)

load distinct ACCESS, USERID, PASSWORD resident AccessTable_tmp;

Section Access;

load ACCESS, USERID, PASSWORD resident AccessTable;

Section Application;

Anybody got a clue where my error is?

thanks

Robert

Re: Section access from CSV not working - user not found

Tue, 05 Feb 2013 22:08:33 GMT

Try using uppercase for all field names and values on the Section Access, even for user names and IDs.

Tue, 05 Feb 2013 22:26:07 GMT

Thanks a lot for the fast reply. I almost thought that it was such a small thing.