Categories
Common Macros and Automatisation QlikView /en Tips n Tricks /en

Export a Chart or Tablebox via VBScript

As sometimes it makes sense to export data with a loop using VBScript. This little toolset should do the job for you: Sub ExecByFieldValues SET Doc = ActiveDocument SET Field = Doc.Fields(getVariable(“pstrFieldName”)) SET Values = Field.GetPossibleValues FOR i = 0 TO Values.Count-1 ExportObject Values.item(i).Text NEXT End Sub Be aware that you need some helpers: rem […]

Categories
Common

Connect QlikView to UpdateCRM – xmlInterface

Grepping metadata To get the information about a table, just use: <?xml version=”1.0″?> <request> <metainfo tablename=”Company”/> </request> Loading Data To retrieve all data from table company: <?xml version=”1.0″?> <request> <query dateformatout=”%Y%m%d” dateformatin=”ymd”> <tables> <table tablename=”Company”/> </tables> <fields tablename=”Company” fields=”*”/> </query> </request>    

Categories
Common QlikView /en

Update QlikView Services by batch

@echo off ECHO %date% %time%: started QV_restart.bat >>”QV_restart.log” REM ——————————————————- REM – File: QlikViewServer11_Stop.bat REM – Description: Stop all QlikView related services (v10) REM ——————————————————- echo Stop QlikView Services echo ====================================================== net stop “QlikView Server” net stop “Qlikview Directory Service Connector” net stop “QlikView Distribution Service” net stop “QlikView Management Service” net stop “QlikView WebServer” […]

Categories
Common

yii2 fullcalendar extension

Hi, due to some people are really using the yii2 fullcalendar extension – of course I use it in my own projects – I made some fixes, upgraded to the latest version 2.1 and put up an demo site of the extension, which can be found here: http://yii2fullcalendar.beeye.org/ Enjoy! If you have any questions, pls. […]

Categories
Common

Setting up a new workstation (apple mac pro)

Today I got a new MacPro, as my old one died of ram and batteries decease:( For myself and all other crazy developers, I describe what I’m setting up, step by step, to get a production machine! Startpoint To make it simpe, I just clicked through the apple wizzards and ended up with a ready […]

Categories
Common Yii2 Coding /en

New Karaoke Catalogue

Hey, I just developed a karaoke catalogue. It show’s you how to use the amazing possibilities of big data and open data on how to put different content sources together and get a more or less powerfull application. I will enhance the app a little bit more within the next days! If you have any […]

Categories
Common

Sunday Funday

Hi, as i gained a little bit weight during the last view months, I decided to start with sports again. Just so you know, in my past, I was pretty used to do sports and due to an accident with my feets, I didn’t get the chance to continue. But now, as the time has […]

Categories
Common

QlikView ObjectTypes

The following object types for macro automatisation are existing: 0=Unknown 1=Listbox 2=Multibox 3=Statisticsbox 4=Tablebox 5=Button 6=Textarea 7=Currentselectionbox 8=Inputbox 9=Linearrow 10=Pivottable 11=Straighttablebox 12=Barchart 13=Piechart 14=Scatterchart 15=Linechart 16=Combochart 17=Customobject 18=Bookmarkobject 19=Slider Derived 20=Gridchart 21=Radarchart 22=Gaugechart 23=Chart Derived 24=Sheet 25=Tabrow 26=Document 27=Blockchart 28=Funnelchart 29=Internal Layout 30=Inter Sheet Transfer 31=Searchobject 32=Bookmark 33=Report 34=Slider 35=Calendar 36=Container 37=Mekkochart To read the […]

Categories
Common

Quality Enhancements on User-Feedback

Dear all! Based upon recent user requests “readers” which are telling me, that content is always usable, but the presentation needs to be improved a lot… I promise for now and the future to keep in mind, that not every reader is already used to VBA or any other programming language. If an post seems […]

Categories
Common

QlikView Send Email by Passing Report ID as Parameter

SUB sendOneMail(reportFile) Dim objEmail Dim strMailTo Const cdoSendUsingPort = 2 ‘ Send the message using SMTP Const cdoBasic = 1 ‘basic (clear-text) authentication ‘Const cdoNTLM = 2 ‘NTLM SMTPServer = “smtp.gmail.com” SMTPPort = 465 ‘ Port number for SMTP Const SMTPTimeout = 60 ‘ Timeout for SMTP in seconds mailusername = “youruser@gmail.com” mailpassword = “topsecret” […]