topic Re: Data entry in Qlik Sense writing to database in App Development

Data entry in Qlik Sense writing to database

agigliotti — Tue, 23 Aug 2016 07:43:06 GMT

Hello,

Our customer ask us to be able to do data entry ex. for budgeting inside a Qlik Sense app.

I looked at the branch but I did not find any extensions regarding this topic.

I'd like to prototyping a simple HTML table with two columns (ex. last year amount sold and current year budget) for all customers.

That is a simple HTML form with an input text for budget entry for each customer.

After the form is submitted the data should be written on database table (ex. MySql or others).

Could someone guide me to the right direction to achieve it ?

Many thanks in advance.

Best Regards

Andrea

Re: Data entry in Qlik Sense writing to database

Anonymous — Tue, 23 Aug 2016 07:51:08 GMT

Hi Andrea,

In the first instance it maybe worth reviewing SQL Writeback from QlikView extension object.

First I would put together a simple table extension, or take one from Qlik Branch. Would then embed a form/button calling an external PHP page with the values to write back.

Charlie

Re: Data entry in Qlik Sense writing to database

agigliotti — Wed, 24 Aug 2016 07:19:27 GMT

thanks for your suggestion...

i'm working around developing an extension using angluarjs and making a jquery ajax call to nodejs with expressjs to write back form parameters to postgres database table.

Now I'm in troubles with the jquery ajax call because it seems to work only in GET method...even I specified type = POST

below my extension js code:

$.ajax({

type: "GET",

url: "http://localhost:3000/endpoint",

data: jsonTxt,

crossDomain: "true",

contentType: "application/json; charset=utf-8",

dataType: "jsonp",

jsonpCallback: 'callback',

cache: false,

async: false,

jsonp: 'jsonp',

success: function( resp ) {

alert('SUCCESS !!!');

console.log( resp ); // server response

error: function() {

console.log('Uh Oh!');

}

});

working via GET request the url I get is like below:

http://localhost:3000/endpoint?jsonp=callback&{%22firstName%22:%20%22dvv%22,%22lastName%22:%20%22vcvccv%22}&_=1472049305…

and at server side using express js the parse function return an error parsing the request as below

var query = url.parse(req.url).query

JSON.parse(decodeURIComponent(query))

It would expect the following url:

http://localhost:3000/endpoint?{%22firstName%22:%20%22dvv%22,%22lastName%22:%20%22vcvccv%22}

What does it means "jsonp" and "_" parameters in query string ?

while forcing post method in jquery ajax (using $.post rather than $.ajax) the url called is like below:

http://localhost:4848/sense/[object%20Object]

I can't understand why !!!

In both way I have some problem.

Can anybody help me to fix it ?

Many thanks in advance.

Best Regards

Andrea

Re: Data entry in Qlik Sense writing to database

Clever_Anjos — Thu, 25 Aug 2016 12:10:10 GMT

What happens if you use $.post() instead of $.ajax()?

Re: Data entry in Qlik Sense writing to database

agigliotti — Thu, 25 Aug 2016 12:45:57 GMT

as i wrote above I get the following url:

http://localhost:4848/sense/[object%20Object]

but I was expecting the same specified in the ajax call...!?

Re: Data entry in Qlik Sense writing to database

Clever_Anjos — Thu, 25 Aug 2016 13:47:57 GMT

It seems to be a Cross domain issue https://zinoui.com/blog/cross-domain-ajax-request

Please put

alert(window.location); at somewhere into your code

Re: Data entry in Qlik Sense writing to database

agigliotti — Fri, 26 Aug 2016 07:34:05 GMT

I get as below:

Re: Data entry in Qlik Sense writing to database

agigliotti — Fri, 26 Aug 2016 10:04:29 GMT

I really don't understand why using type: "POST" it seems to be ignored... because it still uses GET method !!!

Re: Data entry in Qlik Sense writing to database

Clever_Anjos — Fri, 26 Aug 2016 12:28:22 GMT

As you pointing to same server but different ports (3000 x 4848) is considered a Cross Domain Post (Are different ports on the same server considered cross-domain? (Ajax-wise) - Stack Overflow)

When a Cross Domain Post occurs, it´s not possible to make a POST request using Ajax unless you configure to enable it

javascript - how to solve cross domain in ajax - Stack Overflow‌

javascript - What is the cross domain issue - Stack Overflow

Re: Data entry in Qlik Sense writing to database

Clever_Anjos — Fri, 26 Aug 2016 12:29:07 GMT

Please take a look at my last answer, that´s why your POST is being ignored

Re: Data entry in Qlik Sense writing to database

agigliotti — Fri, 26 Aug 2016 12:59:48 GMT

Ok I understand why POST method is being ignored.

As I wrote above I just tried to make a GET request but I got the below url:

http://localhost:3000/endpoint?jsonp=callback&{%22firstName%22:%20%22dvv%22,%22lastName%22:%20%22vcvccv%22}&_=1472049305…

that cause me a parsing error, below the code:

var query = url.parse(req.url).query

JSON.parse(decodeURIComponent(query))

that's why there are two parameters (json and _ that should not exists) in the query string,

the parsing statement would expect only the json data...

What does the two parameters means ?

Re: Data entry in Qlik Sense writing to database

Clever_Anjos — Fri, 26 Aug 2016 13:19:26 GMT

jquery uses that parameters for internal control

Re: Data entry in Qlik Sense writing to database

Clever_Anjos — Fri, 26 Aug 2016 13:20:07 GMT

Hold on, writing a hack

Re: Data entry in Qlik Sense writing to database

Clever_Anjos — Fri, 26 Aug 2016 13:25:09 GMT

A javascript hack

var s ='http://localhost:3000/endpoint?jsonp=callback&{%22firstName%22:%20%22dvv%22,%22lastName%22:%20%22vcvccv%22}&_=1472049305033';
var q =  s.split('&');
var o = JSON.parse(decodeURIComponent(q[1]));

Re: Data entry in Qlik Sense writing to database

agigliotti — Fri, 26 Aug 2016 13:44:25 GMT

When I do res.jsonp(o); I get the below error in ajax call:

"Refused to execute script from 'http://localhost:3000/endpoint?jsonp=callback&{%22firstName%22:%20%22ggggh%22,%22lastName%22:%20%22hhhhh%22}&_=1472219930227' because its MIME type ('application/json') is not executable, and strict MIME type checking is enabled."

Re: Data entry in Qlik Sense writing to database

Clever_Anjos — Fri, 26 Aug 2016 16:13:59 GMT

javascript - Refused to execute script from '*' because its MIME type ('application/json') is not executable, and strict…

Re: Data entry in Qlik Sense writing to database

agigliotti — Mon, 29 Aug 2016 08:20:20 GMT

I solved appending '/jsonp?callback=?' to the url in ajax call like below:

url: "http://localhost:3000/endpoint" + '/jsonp?callback=?'

Re: Data entry in Qlik Sense writing to database

Clever_Anjos — Mon, 29 Aug 2016 11:26:28 GMT

Good to read that

Re: Data entry in Qlik Sense writing to database

Tue, 30 Aug 2016 08:54:05 GMT

Hello,

There is actually a ready-to-use solution 'Apparo Fast Edit for Qlik', which allows security controlled data entry.
Please check this brief vid or visit http://apparo.solutions

Regards

Re: Data entry in Qlik Sense writing to database

Mon, 26 Sep 2016 06:59:25 GMT

see: http://www.apparo.solutions

This addon is helpful for data entry, data import from Excel and eMail.