Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
agigliotti
Partner - Champion
Partner - Champion

Data entry in Qlik Sense writing to database

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

25 Replies
agigliotti
Partner - Champion
Partner - Champion
Author

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
Employee
Employee

jquery uses that parameters for internal control

Clever_Anjos
Employee
Employee

Hold on, writing a hack

Clever_Anjos
Employee
Employee

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
Partner - Champion
Partner - Champion
Author

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

agigliotti
Partner - Champion
Partner - Champion
Author

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

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

Clever_Anjos
Employee
Employee

Good to read that

Not applicable

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

Not applicable

see: http://www.apparo.solutions

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