<html>
<head>
</head>
<body>
<form runat="Server" id="MainForm">
<H2>QlikView WebTicket Example</H2>
Username: <asp:TextBox runat="server" id="txtUser">MyTestUser</asp:TextBox> <br />
Password: <asp:TextBox runat="server" id="txtPassword">MyPassword</asp:TextBox> <br />
Groups: <asp:TextBox runat="server" id="txtGroups">Sales,Finance</asp:TextBox> <br />
<asp:Button ID="GO" runat="server" Text="Login..." onclick="GO_Button_Click" />
</form>
</body>
</html>
<script language="c#" runat="server">
//Firsly Set up a few properties
static string QlikViewServerURL = @"http://localhost/QVAJAXZFC/getwebticket.aspx"; //address of the QlikView server
static string ticketinguser = "qvadmin"; //Service account used to ask for a ticket (QV Administrator), this is not the end user
static string ticketingpassword = "qvadmin1234";
static string document = "Sales compass.qvw"; // specify a single QVW or leave blank for access point
protected void GO_Button_Click(object sender, EventArgs e)
{
//Grab the details the user provides
string username = txtUser.Text;
string password = txtPassword.Text;
string groups = txtGroups.Text;
// Test if the user is valid
bool loginOK = ValidateUser(username, password);
//If the user is valid get a ticket and log them in
string ticket = "";
if (loginOK)
{
//Get the Ticket
ticket = getTicket(username, groups, ticketinguser, ticketingpassword); // add groups into the empty string if required
//Build a redirect link to either access point or to a single document
string RedirectLink = "";
if (document.Length > 0)
{//Send to a single document
RedirectLink = "/qvajaxzfc/authenticate.aspx?type=html&try=/qvajaxzfc/opendoc.htm?document=" + document + "&back=/LoginPage.htm&webticket=" + ticket;
}
else
{//Send to a Access Point
RedirectLink = "/qvajaxzfc/authenticate.aspx?type=html&try=/qlikview&back=/LoginPage.htm&webticket=" + ticket;
}
//Redirect the user
Response.Redirect(RedirectLink);
}
}
// This function is a place holder for code to test the user id and password against a database or LDAP
// For the purpose of this example we are not going to test it at all, just return "true" for logged in
// Of course this means anyone would be let in, so this needs to be added
private bool ValidateUser(string User, string pass)
{
//here you would have some logic to test the user id and password against a data base.
return true;
}
// This function is going to take the username and groups and return a web ticket from QV
// User and groups relate to the user you want to reuqest a ticket for
// ticketinguser and password are the credentials used to ask for the ticket and needs to be a QV admin
private string getTicket(string user,string usergroups,string ticketinguser, string ticketingpassword)
{
StringBuilder groups = new StringBuilder();
if (!string.IsNullOrWhiteSpace(usergroups))
{
groups.Append("<GroupList>");
foreach (string group in usergroups.Split(new char[] { ',' }))
{
groups.Append("<string>");
groups.Append(group);
groups.Append("</string>");
}
groups.Append("</GroupList>");
groups.Append("<GroupsIsNames>");
groups.Append("true");
groups.Append("</GroupsIsNames>");
}
string webTicketXml = string.Format("<Global method=\"GetWebTicket\"><UserId>{0}</UserId></Global>", user);
HttpWebRequest client = (HttpWebRequest)WebRequest.Create(new Uri(QlikViewServerURL));
client.PreAuthenticate = true;
client.Method = "POST";
client.AutomaticDecompression = DecompressionMethods.GZip | DecompressionMethods.Deflate;
client.Credentials = new NetworkCredential(ticketinguser,ticketingpassword);
using (StreamWriter sw = new StreamWriter(client.GetRequestStream()))
sw.WriteLine(webTicketXml);
StreamReader sr = new StreamReader(client.GetResponse().GetResponseStream());
string result = sr.ReadToEnd();
XDocument doc = XDocument.Parse(result);
return doc.Root.Element("_retval_").Value;
}
</script>
