Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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

Highlighted
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

Highlighted
Master II
Master 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.

Highlighted
Not applicable

Reading .meta file into Qlikview

Publisher stored "recipients" for the purpose of distribuion tasks

-Alex

Highlighted
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

Highlighted
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

Highlighted
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

Highlighted
Not applicable

Reading .meta file into Qlikview

Hi

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

Regards

Anders