Data entry in Qlik Sense writing to database

[agigliotti]

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

[agigliotti]

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%22vcv...

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 ?

[Clever_Anjos]

jquery uses that parameters for internal control

[Clever_Anjos]

Hold on, writing a hack

[Clever_Anjos]

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]));

[agigliotti]

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."

[Clever_Anjos]

javascript - Refused to execute script from '*' because its MIME type ('application/json') is not ex...

[agigliotti]

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

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

[Clever_Anjos]

Good to read that

[#10]

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

[#11]

see: http://www.apparo.solutions

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