Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Partner
Partner

Reading .meta file into Qlikview

Hello,

I am currently managing a large number of users using the QEMC via Document Authorization. Is there a way to read the .meta file into Qlikview so i can view the user list that is stored inside?

I am currently using Qlikview 9.0 SR6 in DMS mode.

If I am unable to read the .meta file directly into Qlikview, does anyone know what format the file is stored in?

Lucas Blancher

BizXcel Inc.

16 Replies
Not applicable

Reading .meta file into Qlikview

Hi,

Get the original authorization data from QVPR XML files, or the QVPR database .

-Alex

www.snowflakejoins.com

Not applicable

Reading .meta file into Qlikview

You might want to look also at zipped QVPR files. For example QVW file might be in valid use even if someone deleted the task in QEMC .

-Alex

www.snowflakejoins.com

Highlighted
Partner
Partner

Reading .meta file into Qlikview

HI Alex,

It appears that the QVPR files are related to publishers configuration. Our QVS server is not running publisher at the moment, all users are configured manually via Documents >> User Documents >> {Document Name} >> Authorization.

Lucas

danielrozental
Honored Contributor II

Reading .meta file into Qlikview

You should be able to query the assigned authorizations through the server API, you would have to write a vbscript or similar code to do that.

I don't believe you can read .meta files as they are binary files.

Not applicable

Reading .meta file into Qlikview

Publisher stored "recipients" for the purpose of distribuion tasks

-Alex

Not applicable

Reading .meta file into Qlikview

You can't read the meta files. But you can read the QVS logs, and make a list of all accounts who successfully opened each file in the last 6 months .

This is not complete , but a good approximation of the security of active users.

-Alex

Not applicable

Reading .meta file into Qlikview

Hi

I manage to read the META-files.

I am lucky that all userid starts with letter Q.

Here is how I done it.

LOAD
'Finance_Reporting' as Document,
@1 as User

FROM

(txt, codepage is 1252, no labels, delimiter is spaces, msq, filters(
Transpose()
))
Where left(@1,1) = 'Q';

Regards

Anders

Not applicable

Reading .meta file into Qlikview

Cool 🙂

You assume there is nothing more in that file, except usernames starting with Q . There is also the name of the category where the QVW file belongs to. You need to handle those as well.

-Alex

Not applicable

Reading .meta file into Qlikview

Hi

I made a inline table with document and Category to handle that.

Regards

Anders