topic Problem with SERIAL for Section Access in QlikView

Problem with SERIAL for Section Access

amars — Wed, 08 Jul 2009 18:22:12 GMT

Hi all,

I have a file with section access, I have two types of user's one ADMIN user & other user coming from database field. Now I have to reload the file using a background job but I can't figure out how to provide the SERIAL & the user id as * & password as * for only one user. I want to provide SERIAL for only one user which will reload the file. I have tried various thing's but every time the file can't be opened after reload.

If anyone could give me any solution. Thanks in advance

Regards,

Amar[:(]

Problem with SERIAL for Section Access

Thu, 16 Jul 2009 12:53:59 GMT

Hi Amar,

Try using the following:-

=============================

Section

LOAD

[
ACCESS, USERID, PASSWORD, SERIAL
ADMIN, *, *, Your Serial Number
ADMIN, ADMIN, ADMIN, *
];

concatenate

LOAD

[ACCESS],

[USERID]

[PASSWORD]

'*'

as SERIAL

FROM

Section

=============================

Thanks & Best Regards

Kuldeep Tak

Application; [excelfile]; * INLINE Access;

Problem with SERIAL for Section Access

Thu, 15 Dec 2011 09:00:02 GMT

Appreciate this is an old thread but I had a similar problem where the documentation said to use the serial number from the QV server although I couldn't get it to work, I managed to fix the problem but using another method.

I'm using QV10, I have a server and publisher which schedules reload tasks.

Set up the Section access with at least one USERID, PASSWORD and ACCESS as:

ADMIN,123,ADMIN

On QEMC when you're setting up a schedule task, on the second tab "Reload" there is an option to enter a USERID and PASSWORD for Section Access. Enter what you have previously set up in the QVW and the refresh will now work......