topic Re: Qlik Sense Master Item Repository in Management & Governance

Qlik Sense Master Item Repository

borismichel — Thu, 09 May 2019 18:25:34 GMT

Hey everyone, I'm currently working on a solution that should enable users to extract their master items from apps to a database and then manage them (clone, edit, etc). There is also an option to export the measures/dimensions to another app.

You could use this tool to

Spread master items to apps with common data models
Maintain master items centrally
Backup/Version your Master Items
...

I wanted to share this with you to find out if this is interesting for some of you and also to hear about ideas/improvements you have when you see this.

You can find the project here: https://github.com/borismichel/qs-mir

I'm looking forward to your feedback

Re: Qlik Sense Master Item Repository

Vegar — Thu, 09 May 2019 18:32:38 GMT

It looks great by the pictures and what you are writing. I'll check it out. Do you want feedback in GitHub out here in the community?

Re: Qlik Sense Master Item Repository

borismichel — Thu, 09 May 2019 19:06:30 GMT

Thanks, man! Either channel should be fine tbh. I‘m just trying to figure out if it‘s worth pursuing this and if so, what people would want it to do to make it actually useful :). Let me know how you‘re getting on.

Re: Qlik Sense Master Item Repository

joachim_boivie — Fri, 10 May 2019 06:31:45 GMT

Hi @borismichel

Im working with @Vegar and I do believe this is a great tool. We have an extension to export / import masteritems to csv to manage them and to be able to move them between several apps. In this extension we also have the possibility to generate a markdown file for documentation purpose if needed. So keep it up. Looks promising.

Re: Qlik Sense Master Item Repository

s_kabir_rab — Fri, 10 May 2019 09:36:59 GMT

Looks great. I will be looking at the github repo.

PS: Just sent you a PM regarding testing.

Re: Qlik Sense Master Item Repository

ConnieVan — Wed, 05 Jun 2019 12:14:53 GMT

Yes, yes, yes! Please pursue this. Massive need for our in my organisation

Re: Qlik Sense Master Item Repository

honeybadger — Wed, 18 Dec 2019 09:53:53 GMT

this is a GREAT idea and a fantastic solution.

Re: Qlik Sense Master Item Repository

borismichel — Thu, 16 Jan 2020 08:01:10 GMT

Thanks for all the postitive feedback! The past months have been crazy and I haven't been able to give this the love it deserves. The project is far from abandoned though. Stay tuned!

Re: Qlik Sense Master Item Repository

lblumenfeld — Wed, 04 Mar 2020 14:53:22 GMT

Hi. I'm trying to install this, but the npm install fails. It looks like the directory for sqllite3 isn't in the distribution that's posted on github. Any guidance? Thanks.

Re: Qlik Sense Master Item Repository

borismichel — Wed, 04 Mar 2020 15:08:41 GMT

Hey, sorry to hear you’re having problems. I’ve just updated all dependencies. Please clone again and check if it works. Should you still have problems, let’s set up a call.
The SQLITE3 package sometimes has a few problems to compile in a non windows environment. I’ve troubleshot that a few times when I set up projects on unix based systems -RasPi or Mac. Made me think of going Postgres a few times ;-).

Re: Qlik Sense Master Item Repository

lblumenfeld — Tue, 17 Mar 2020 20:33:22 GMT

Hi Boris,

I downloaded the latest build. Got the same error.

19247 verbose stack Error: sqlite3@4.0.6 install: `node-pre-gyp install --fallback-to-build`
19247 verbose stack Exit status 1
19247 verbose stack at EventEmitter.<anonymous> (C:\Program Files\nodejs\node_modules\npm\node_modules\npm-lifecycle\index.js:332:16)
19247 verbose stack at EventEmitter.emit (events.js:210:5)
19247 verbose stack at ChildProcess.<anonymous> (C:\Program Files\nodejs\node_modules\npm\node_modules\npm-lifecycle\lib\spawn.js:55:14)
19247 verbose stack at ChildProcess.emit (events.js:210:5)
19247 verbose stack at maybeClose (internal/child_process.js:1023:16)
19247 verbose stack at Process.ChildProcess._handle.onexit (internal/child_process.js:281:5)
19248 verbose pkgid sqlite3@4.0.6
19249 verbose cwd C:\Projdev\qs-mir-master\qs-mir-master
19250 verbose Windows_NT 10.0.18363
19251 verbose argv "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\bin\\npm-cli.js" "install"
19252 verbose node v13.2.0
19253 verbose npm v6.13.1
19254 error code ELIFECYCLE
19255 error errno 1
19256 error sqlite3@4.0.6 install: `node-pre-gyp install --fallback-to-build`
19256 error Exit status 1
19257 error Failed at the sqlite3@4.0.6 install script.
19257 error This is probably not a problem with npm. There is likely additional logging output above.
19258 verbose exit [ 1, true ]

Re: Qlik Sense Master Item Repository

lblumenfeld — Thu, 19 Mar 2020 01:13:22 GMT

I was able to get it working. Posting what I did here, in case anyone has a similar issue.

1. I reinstalled Node.JS using the current 12.x version.
2. I installed the current JQuery version.
3. I tried the install for the Repository Manager again and still got the error message for Sqlite3, so
4. I downloaded Sqlite3 from the link that Boris sent me (https://github.com/mapbox/node-sqlite3) and installed it manually.
5. Then I reran the Repository Manager install and it worked.

Boris, the tool looks great. I'm starting to use it on our apps. Thanks so much for your assistance.

Re: Qlik Sense Master Item Repository

borismichel — Thu, 19 Mar 2020 06:43:21 GMT

Hey Leslie,

glad you got it working. Sorry for the hassle! Let me know what you think.

Stay safe and be well!

Boris

Re: Qlik Sense Master Item Repository

KrDrBr — Wed, 25 Aug 2021 19:26:57 GMT

Hey,

I found your app very useful, but it cannot run. This is the error message I receive :

Error: Cannot find module 'mkdirp'
Require stack:
- C:\Install\qs-mir-master\qs-mir-master\node_modules\@babel\register\lib\cache.js
- C:\Install\qs-mir-master\qs-mir-master\node_modules\@babel\register\lib\node.js
- C:\Install\qs-mir-master\qs-mir-master\node_modules\@babel\register\lib\index.js
- C:\Install\qs-mir-master\qs-mir-master\node_modules\@babel\node\lib\_babel-node.js
at Function.Module._resolveFilename (internal/modules/cjs/loader.js:889:15)
at Function.Module._load (internal/modules/cjs/loader.js:745:27)
at Module.require (internal/modules/cjs/loader.js:961:19)
at require (internal/modules/cjs/helpers.js:92:18)
at Object.<anonymous> (C:\Install\qs-mir-master\qs-mir-master\node_modules\@babel\register\lib\cache.js:17:15)
at Module._compile (internal/modules/cjs/loader.js:1072:14)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:1101:10)
at Module.load (internal/modules/cjs/loader.js:937:32)
at Function.Module._load (internal/modules/cjs/loader.js:778:12)
at Module.require (internal/modules/cjs/loader.js:961:19) {
code: 'MODULE_NOT_FOUND',
requireStack: [
'C:\\Install\\qs-mir-master\\qs-mir-master\\node_modules\\@babel\\register\\lib\\cache.js',
'C:\\Install\\qs-mir-master\\qs-mir-master\\node_modules\\@babel\\register\\lib\\node.js',
'C:\\Install\\qs-mir-master\\qs-mir-master\\node_modules\\@babel\\register\\lib\\index.js',
'C:\\Install\\qs-mir-master\\qs-mir-master\\node_modules\\@babel\\node\\lib\\_babel-node.js'
]
}
[nodemon] app crashed - waiting for file changes before starting...

Could you please help?

Many thanks!