public List<string> GetFieldValues(app app, IAppField appField2) { List<string> strValues = new List<string>(); Uri uri = new Uri(url + ":443"); ILocation remoteQlikSenseLocation = Qlik.Engine.Location.FromUri(uri); remoteQlikSenseLocation.AsNtlmUserViaProxy(); IAppIdentifier appidentifier = remoteQlikSenseLocation.AppWithId(app.ID); using (var doc = remoteQlikSenseLocation.App(appidentifier)) { var field = doc.GetAppField(appField2.DimensionInfo.FallbackTitle); var p = new List<NxPage> { new NxPage { Height = 20, Width = 1 } }; var dataPages = field.GetData(p); foreach (var dataPage in dataPages) { var matrix = dataPage.Matrix; foreach (var cellRows in matrix) { foreach (var cellRow in cellRows) { strValues.Add(cellRow.Text); //Console.WriteLine("## " + cellRow.Text + " - " + cellRow.State); } } } } return strValues; }
private IApp GetAppHandle(string appid) { Uri uri = new Uri(url + ":443"); ILocation remoteQlikSenseLocation = Qlik.Engine.Location.FromUri(uri); remoteQlikSenseLocation.AsNtlmUserViaProxy(); IAppIdentifier appidentifier = remoteQlikSenseLocation.AppWithId(appid); return remoteQlikSenseLocation.App(appidentifier); }
private static IApp GetApp(ILocation location, IAppIdentifier appId, bool noData) { try { return(location.App(appId, Session.Random, noData: noData)); } catch { return(null); } }
private void listSheets(string appName) { IAppIdentifier foundAppIdentifier = _location.AppWithNameOrDefault(appName); IApp application = _location.App(foundAppIdentifier); ISheetList sheetList = application.GetSheetList(); foreach (ISheetObjectViewListContainer item in sheetList.Items) { dropDown2.Items.Add(CreateRibbonDropDownItem()); dropDown2.Items.Last().Label = item.Data.Title; } }
static void LoadCache(ILocation location, IAppIdentifier id, bool opensheets, QlikSelection Selections) { IApp app = null; try { //open up the app Print(LogLevel.Info, "{0}: Opening app", id.AppName); app = location.App(id); Print(LogLevel.Info, "{0}: App open", id.AppName); //see if we are going to open the sheets too if (opensheets) { //see of we are going to make some selections too if (Selections != null) { for (int i = 0; i < Selections.fieldvalues.Length; i++) { //clear any existing selections Print(LogLevel.Info, "{0}: Clearing Selections", id.AppName); app.ClearAll(true); //apply the new selections Print(LogLevel.Info, "{0}: Applying Selection: {1} = {2}", id.AppName, Selections.fieldname, Selections.fieldvalues[i]); app.GetField(Selections.fieldname).Select(Selections.fieldvalues[i]); //cache the results cacheObjects(app, location, id); } } else { //clear any selections Print(LogLevel.Info, "{0}: Clearing Selections", id.AppName); app.ClearAll(true); //cache the results cacheObjects(app, location, id); } } Print(LogLevel.Info, "{0}: App cache completed", id.AppName); app.Dispose(); } catch (Exception ex) { if (app != null) { app.Dispose(); } throw ex; } }
private static string[] GetExtensionUsage(ILocation location, IAppIdentifier appId, ICollection <string> extensionNames) { Console.WriteLine($"Scanning app \"{appId.AppName}\" ({appId.AppId})"); using (var app = GetApp(location, appId, true) ?? GetApp(location, appId, false)) { if (app == null) { throw new Exception($"Unable to open app {appId.AppName}."); } var sheets = app.GetSheets(); var objectTypes = sheets.SelectMany(GetObjectTypes); return(objectTypes.Where(extensionNames.Contains).ToArray()); } }
internal QlikAppSession(ILocation location, IAppIdentifier appIdentifier, bool createDefaultSession) { Id = Guid.NewGuid(); if (createDefaultSession) { CurrentApp = location.App(appIdentifier, Session.WithApp(appIdentifier, SessionType.Default), true, false); } else { CurrentApp = location.App(appIdentifier, Session.Random, true, false); } SessionId = location.SessionCookie?.Split('=').ElementAtOrDefault(1) ?? null; Selections = new QlikSelections(CurrentApp); IsFree = false; }
static void cacheObjects(IApp app, ILocation location, IAppIdentifier id) { //get a list of the sheets in the app Print(LogLevel.Info, "{0}: Getting sheets", id.AppName); var sheets = app.GetSheets().ToArray(); //get a list of the objects in the app Print(LogLevel.Info, "{0}: Number of sheets - {1}, getting children", id.AppName, sheets.Count()); IGenericObject[] allObjects = sheets.Concat(sheets.SelectMany(sheet => GetAllChildren(app, sheet))).ToArray(); //draw the layout of all objects so the server calculates the data for them Print(LogLevel.Info, "{0}: Number of objects - {1}, caching all objects", id.AppName, allObjects.Count()); var allLayoutTasks = allObjects.Select(o => o.GetLayoutAsync()).ToArray(); Task.WaitAll(allLayoutTasks); Print(LogLevel.Info, "{0}: Objects cached", id.AppName); }
private void OpenApplication(IAppIdentifier appIdentifier) { if (ActiveApp != null) { ActiveApp.Dispose(); } try { ActiveApp = CurrentLocation.App(appIdentifier, noVersionCheck: true); Session.WithApp(appIdentifier, SessionType.Random); Notify("Open app: " + appIdentifier.AppName); SetModeToOpen(); } catch (MethodInvocationException ex) { Notify("Could not open " + appIdentifier.AppName + ", error " + ex.Message); } }
private void listObjects(string sheetName, string appName) { IAppIdentifier foundAppIdentifier = _location.AppWithNameOrDefault(appName); IApp application = _location.App(foundAppIdentifier); IEnumerable <ISheet> sheets = application.GetSheets(); foreach (ISheet sheet1 in sheets) { if (sheet1.MetaAttributes.Title == sheetName) { foreach (IGenericObject child in sheet1.Children) { dropDown3.Items.Add(CreateRibbonDropDownItem()); dropDown3.Items.Last().Label = child.GetLayout().As <VisualizationBaseLayout>().Title + " <" + child.Info.Type.ToString() + ">"; dropDown3.Items.Last().Tag = child.Info.Id; } } } }
private static async Task ReloadApplicationTask(IAppIdentifier appIdentifier) { using (IApp app = await _qlikSenseServer.AppAsync(appIdentifier, noVersionCheck: true)) { Console.WriteLine("App with name {0} opened", appIdentifier.AppName); AsyncHandle reloadHandle = new AsyncHandle("reloadTask"); // By setting mode parameter on reload you can affect the behaviour check the help for more information. // http://help.qlik.com/sense/2.1/en-US/apis/net%20sdk/html/M_Qlik_Engine_App_DoReload.htm // During the reload task you can cancel the reload by calling app.Session.Hub.CancelReload() you should also need to cancel the "reloadTask" try { var reloadTask = app.DoReloadAsync(reloadHandle, OnReloaded); bool doWork = true; while (doWork) { var progress = await app.Session.Hub.GetProgressAsync(reloadHandle); Console.WriteLine("Progress: " + progress.TransientProgress + " Finished : " + progress.Finished); if (progress.Finished) { doWork = false; } System.Threading.Thread.Sleep(1000); // Give the qlik engine time to work before we check the progress again. } await app.DoSaveAsync(); Console.WriteLine("App with name {0} saved and last reloaded {1}", appIdentifier.AppName, (await app.GetAppLayoutAsync()).LastReloadTime); } catch (TimeoutException e) { // We got a timeout exception from the SDK, handle this should be handled. In this example will just cancel the reload in the engine and igonre it. app.Session.Hub.CancelReload(); } } }
static void LoadApp(ILocation location, IAppIdentifier id) { Print("{0}: Opening app", id.AppName); // Load the app to memory. var app = location.App(id); Print("{0}: App opened, getting sheets", id.AppName); var sheets = app.GetSheets().ToArray(); Print("{0}: Number of sheets - {1}, getting children", id.AppName, sheets.Count()); var allObjects = sheets.Concat(sheets.SelectMany(sheet => GetAllChildren(app, sheet))).ToArray(); Print("{0}: Number of objects - {1}, getting layouts", id.AppName, allObjects.Count()); // Trigger the engine to execute all evaluations required to display all objects included in the app. // The evaluation results are stored in memory so that subsequent identical queries do not need // to be recomputed. var allLayoutTasks = allObjects.Select(o => o.GetLayoutAsync()); Task.WaitAll(allLayoutTasks.ToArray <Task>()); Print("{0}: Completed loading layouts", id.AppName); }
public async Task <IEnumerable <ISheet> > GetSheetsAsync(string appId) { string id = appId; QSConnections qsConn = new QSConnections(); var location = await qsConn.GetLocation(); IAppIdentifier appIdentifier = location.AppWithId(appId); try { IApp app = location.App(appIdentifier, session: Session.Random); var sheets = app.GetSheets(); return(sheets); } catch (NullReferenceException e) { throw e; } catch (Exception e) { throw e; } }
private static void DoWork(Options options) { Uri serverURL; string appname; string appid; bool openSheets; string virtualProxy; QlikSelection mySelection = null; ILocation remoteQlikSenseLocation = null; try { if (options.Debug) { DEBUG_MODE = true; Print(LogLevel.Debug, "Debug logging enabled."); } Print(LogLevel.Debug, "setting parameter values in main"); serverURL = new Uri(options.Server); appname = options.AppName; appid = options.AppID; virtualProxy = !string.IsNullOrEmpty(options.VirtualProxy) ? options.VirtualProxy : ""; openSheets = options.FetchObjects; if (options.SelectionField != null) { mySelection = new QlikSelection(); mySelection.fieldname = options.SelectionField; mySelection.fieldvalues = options.SelectionValues.Split(','); } //TODO need to validate the params ideally Print(LogLevel.Debug, "setting remoteQlikSenseLocation");; ////connect to the server (using windows credentials QlikConnection.Timeout = Int32.MaxValue; var d = DateTime.Now; remoteQlikSenseLocation = Qlik.Engine.Location.FromUri(serverURL); Print(LogLevel.Debug, "validating http(s) and virtual proxy");; if (virtualProxy.Length > 0) { remoteQlikSenseLocation.VirtualProxyPath = virtualProxy; } bool isHTTPs = false; if (serverURL.Scheme == Uri.UriSchemeHttps) { isHTTPs = true; } remoteQlikSenseLocation.AsNtlmUserViaProxy(isHTTPs, null, false); Print(LogLevel.Debug, "starting to cache applications"); ////Start to cache the apps IAppIdentifier appIdentifier = null; if (appid != null) { //Open up and cache one app, based on app ID appIdentifier = remoteQlikSenseLocation.AppWithId(appid); Print(LogLevel.Debug, "got app identifier by ID"); LoadCache(remoteQlikSenseLocation, appIdentifier, openSheets, mySelection); Print(LogLevel.Debug, "finished caching by ID"); } else { if (appname != null) { //Open up and cache one app appIdentifier = remoteQlikSenseLocation.AppWithNameOrDefault(appname); Print(LogLevel.Debug, "got app identifier by name"); LoadCache(remoteQlikSenseLocation, appIdentifier, openSheets, mySelection); Print(LogLevel.Debug, "finished caching by name"); } else { //Get all apps, open them up and cache them remoteQlikSenseLocation.GetAppIdentifiers().ToList().ForEach(id => LoadCache(remoteQlikSenseLocation, id, openSheets, null)); Print(LogLevel.Debug, "finished caching all applications"); } } ////Wrap it up var dt = DateTime.Now - d; Print(LogLevel.Info, "Cache initialization complete. Total time: {0}", dt.ToString()); remoteQlikSenseLocation.Dispose(); Print(LogLevel.Debug, "done"); return; } catch (UriFormatException) { Print(LogLevel.Info, "Invalid server paramater format. Format must be http[s]://host.domain.tld."); return; } catch (WebSocketException webEx) { if (remoteQlikSenseLocation != null) { Print(LogLevel.Info, "Disposing remoteQlikSenseLocation"); remoteQlikSenseLocation.Dispose(); } Print(LogLevel.Info, "Unable to connect to establish WebSocket connection with: " + options.Server); Print(LogLevel.Info, "Error: " + webEx.Message); return; } catch (TimeoutException timeoutEx) { Print(LogLevel.Info, "Timeout Exception - Unable to connect to: " + options.Server); Print(LogLevel.Info, "Error: " + timeoutEx.Message); return; } catch (Exception ex) { if (ex.Message.Trim() == "Websocket closed unexpectedly (EndpointUnavailable):") { Print(LogLevel.Info, "Error: licenses exhausted."); return; } else { Print(LogLevel.Info, "Unexpected error."); Print(LogLevel.Info, "Message: " + ex.Message); return; } } }
public QlikAppSession(ILocation location, IAppIdentifier appIdentifier) : this(location, appIdentifier, false) { }
private void availableApplications_DoubleClick(object sender, EventArgs e) { SelectedApplication = availableApplications.SelectedValue as IAppIdentifier; DialogResult = SelectedApplication != null ? DialogResult.OK : DialogResult.Cancel; }
private void OpenButtonClick(object sender, EventArgs e) { SelectedApplication = availableApplications.SelectedValue as IAppIdentifier; DialogResult = SelectedApplication != null ? DialogResult.OK : DialogResult.Cancel; }
private void OpenApplication(IAppIdentifier appIdentifier) { if (ActiveApp != null) { ActiveApp.Dispose(); } try { ActiveApp = CurrentLocation.App(appIdentifier, noVersionCheck: true); Session.WithApp(appIdentifier, SessionType.Random); Notify("Open app: " + appIdentifier.AppName); SetModeToOpen(); } catch (MethodInvocationException ex) { Notify("Could not open " + appIdentifier.AppName + ", error " + ex.Message); } }
private static void Main(string[] args) { //////Setup var options = new Options(); Uri serverURL; string appname; bool openSheets; QlikSelection mySelection = null; //// process the parameters using the https://commandline.codeplex.com/ if (CommandLine.Parser.Default.ParseArguments(args, options)) { serverURL = new Uri(options.server); appname = options.appname; openSheets = options.fetchobjects; if (options.selectionfield != null) { mySelection = new QlikSelection(); mySelection.fieldname = options.selectionfield; mySelection.fieldvalues = options.selectionvalues.Split(','); } //TODO need to validate the params ideally } else { throw new Exception("Check parameters are correct"); } Print($"{nameof(options.server)}:{options.server}"); Print($"{nameof(options.appname)}:{options.appname}"); Print($"{nameof(options.usingProxy)}:{options.usingProxy}"); Print($"{nameof(options.User)}:{options.User}"); Print($"{ nameof(options.fetchobjects)}:{options.fetchobjects}"); ////connect to the server (using windows credentials QlikConnection.Timeout = int.MaxValue; var d = DateTime.Now; ILocation remoteQlikSenseLocation = Qlik.Engine.Location.FromUri(serverURL); var isHTTPs = serverURL.Scheme == Uri.UriSchemeHttps; if ((!string.IsNullOrWhiteSpace(options.User)) && (!string.IsNullOrWhiteSpace(options.staticHeader))) { remoteQlikSenseLocation.VirtualProxyPath = options.usingProxy; remoteQlikSenseLocation.AsStaticHeaderUserViaProxy(options.User, options.staticHeader, isHTTPs); } else if (!string.IsNullOrWhiteSpace(options.usingProxy)) { remoteQlikSenseLocation.VirtualProxyPath = options.usingProxy; remoteQlikSenseLocation.AsNtlmUserViaProxy(isHTTPs); } else if ((!string.IsNullOrWhiteSpace(options.User)) && !string.IsNullOrWhiteSpace(options.Directory) && options.directConnection) { remoteQlikSenseLocation.AsDirectConnection(options.Directory, options.User); } else { remoteQlikSenseLocation.AsNtlmUserViaProxy(isHTTPs); } ////Start to cache the apps if (appname != null) { //Open up and cache one app IAppIdentifier appidentifier = remoteQlikSenseLocation.AppWithNameOrDefault(appname, false); LoadCache(remoteQlikSenseLocation, appidentifier, openSheets, mySelection); } else { //Get all apps, open them up and cache them remoteQlikSenseLocation.GetAppIdentifiers(true) .ToList() .ForEach(id => LoadCache(remoteQlikSenseLocation, id, openSheets, null)); } ////Wrap it up var dt = DateTime.Now - d; Print("Cache initialization complete. Total time: {0}", dt.ToString()); //Console.ReadKey(); }
static void Main(string[] args) { //////Setup Options options = new Options(); Uri serverURL; string appname; bool openSheets; string virtualProxy; QlikSelection mySelection = null; //// process the parameters using the https://commandline.codeplex.com/ if (CommandLine.Parser.Default.ParseArguments(args, options)) { serverURL = new Uri(options.server); appname = options.appname; virtualProxy = !string.IsNullOrEmpty(options.virtualProxy) ? options.virtualProxy : ""; openSheets = options.fetchobjects; if (options.selectionfield != null) { mySelection = new QlikSelection(); mySelection.fieldname = options.selectionfield; mySelection.fieldvalues = options.selectionvalues.Split(','); } //TODO need to validate the params ideally } else { throw new Exception("Check parameters are correct"); } ////connect to the server (using windows credentials QlikConnection.Timeout = Int32.MaxValue; var d = DateTime.Now; ILocation remoteQlikSenseLocation = Qlik.Engine.Location.FromUri(serverURL); if (virtualProxy.Length > 0) { remoteQlikSenseLocation.VirtualProxyPath = virtualProxy; } bool isHTTPs = false; if (serverURL.Scheme == Uri.UriSchemeHttps) { isHTTPs = true; } remoteQlikSenseLocation.AsNtlmUserViaProxy(isHTTPs, null, false); ////Start to cache the apps if (appname != null) { //Open up and cache one app IAppIdentifier appidentifier = remoteQlikSenseLocation.AppWithNameOrDefault(appname); LoadCache(remoteQlikSenseLocation, appidentifier, openSheets, mySelection); } else { //Get all apps, open them up and cache them remoteQlikSenseLocation.GetAppIdentifiers().ToList().ForEach(id => LoadCache(remoteQlikSenseLocation, id, openSheets, null)); } ////Wrap it up var dt = DateTime.Now - d; Print("Cache initialization complete. Total time: {0}", dt.ToString()); }