levi-turner

Connect-Qlik -Computername "QlikSenseServer.company.com"
Invoke-QlikUpload -path /qrs/extension/upload -filename C:\extension.zip

levi-turner

# Service Initialize to work-around QLIK-73792
# v0.1 - Levi Turner
# This tool is provided free of charge and is not supported.
# This .ps1 is not an official Qlik Sense product and is provided without warranty.
# Use of this script is entirely at the user's own risk.
# May not be needed depending on the node
start-service QlikSenseRepositoryDatabase
start-sleep 10
# Non-psql nodes start from here
start-service QlikSenseServiceDispatcher

levi-turner

# Script function:  Import a QVF from disk
#                   Reload the app
#                   Publish the app
# Dependencies: Qlik CLI (https://github.com/ahaydon/Qlik-Cli)
# v0.1 - Levi Turner
# Connect to the Qlik Sense site
# Assumes executing user has sufficient permissions
Connect-Qlik -computername "SenseServer.company.com"
# Custom function for an ad-hoc reload
# Endpoint = POST /qrs/App/GUID/reload

levi-turner

/* ##############################################################################################################################
   Script Name: CreateQlikUsers
   Description: the script is intended to create a tables and rows of users in MS SQL which will can be used as an ODBC UDC in Qlik Sense
   Revision history:
   Version     Date         Author    		Change Notes
   # 0.0.1     2017-07-01   Levi Turner 	Initial version
   ##############################################################################################################################
 */

 -- Step 1. Create necessary database (Optional)

levi-turner

mkdir D:\ProgramData\Qlik\Sense\Apps
mkdir D:\ProgramData\Qlik\Sense\Log
mkdir D:\ProgramData\Qlik\Sense\Engine
mkdir D:\ProgramData\Qlik\Sense\Scheduler
mkdir D:\ProgramData\Qlik\Sense\Proxy
mkdir D:\ProgramData\Qlik\Sense\Repository\AppContent
mkdir "D:\ProgramData\Qlik\Sense\Repository\Archived Logs"
mkdir D:\ProgramData\Qlik\Sense\Repository\Content
mkdir D:\ProgramData\Qlik\Sense\Repository\Extensions
mkdir "D:\ProgramData\Qlik\Sense\Repository\Transaction Logs"

levi-turner

DO
SLEEP 5000;
LET _fwMessage = QvdNoOfRecords ('lib://My Library/myqvdfile.qvd');
TRACE $(_fwMessage);
LOOP WHILE (LEN('$(_fwMessage)') = 0)

levi-turner

COPY Categories FROM 's3://{s3bucket}/sourcedata/Categories.csv' CREDENTIALS 'aws_access_key_id={accesskey};aws_secret_access_key={secretkey}' DELIMITER ',' IGNOREHEADER 1;
 
COPY Invoices FROM 's3://{s3bucket}/sourcedata/Invoices.csv' CREDENTIALS 'aws_access_key_id={accesskey};aws_secret_access_key={secretkey}' DELIMITER ',' IGNOREHEADER 1;
 
COPY SKU FROM 's3://{s3bucket}/sourcedata/SKU.csv' CREDENTIALS 'aws_access_key_id={accesskey};aws_secret_access_key={secretkey} ',' IGNOREHEADER 1 CSV QUOTE '"';

levi-turner

Connect-Qlik -computername qlikserver1.domain.local
while ($true) {
  $startTime = (Get-Date -format "HH:mm:ss") >> start.txt
  Import-QlikApp -file .\test-original.qvf -name Test -upload
  $endTime = (Get-Date -format "HH:mm:ss") >> finish.txt
  Get-QlikApp -filter "name eq 'Test'" | Remove-QlikApp
  ;
}

levi-turner

@ECHO OFF
net stop "Qlik Sense Engine Service"
net stop "Qlik Sense Printing Service"
net stop "Qlik Logging Service"
net stop "Qlik Sense Proxy Service"
net stop "Qlik Sense Scheduler Service"
net stop "Qlik Sense Repository Service"
net stop "Qlik Sense Service Dispatcher"
net stop "Qlik Sense Repository Database"

levi-turner

@ECHO OFF
net start "Qlik Sense Repository Database"
TIMEOUT 10
net start "Qlik Sense Service Dispatcher"
TIMEOUT 2
net start "Qlik Logging Service"
TIMEOUT 2
net start "Qlik Sense Repository Service"
TIMEOUT 2
net start "Qlik Sense Engine Service"