topic Re: how to write to database? in QlikView

how to write to database?

Anonymous — Mon, 26 Jan 2015 08:20:40 GMT

Hello everyone,

I ask you something not easy, I'd like to know if it is possible to write in the database via QlikView.

I know that QlikView does not natively support this feature. So I've done several researches but I have not found anything that would be useful to me.

Has anyone ever had to deal with something like that?

Any help is appreciated, thanks

Re: how to write to database?

Gysbert_Wassenaar — Mon, 26 Jan 2015 08:34:06 GMT

You can use macro's to instantiate a writable connection with a database and write data to a database. Simply search the internet for vbscript code that writes to a database.

Re: how to write to database?

robert_mika — Mon, 26 Jan 2015 08:36:20 GMT

Does this help:

How to export data from a qvw file to another database (Firebird, Access, SQL...)

Re: how to write to database?

Anonymous — Mon, 26 Jan 2015 08:42:42 GMT

unfortunately no, this explains how to export.

What should I do is write on my db where I get my data, so every time I launch the script the data that the user entered is not lost

Re: how to write to database?

ashfaq_haseeb — Mon, 26 Jan 2015 08:49:45 GMT

Hi,

Check if this helps

SQL Writeback from QlikView extension object.

Regards

ASHFAQ

Re: how to write to database?

Anonymous — Mon, 26 Jan 2015 08:55:02 GMT

this might be useful.

I also found this "Writeback Extension Installer" on QV market, has anyone tried it?

Re: how to write to database?

Anonymous — Mon, 26 Jan 2015 09:15:13 GMT

Yes I know, but I'm not an expert and some examples I found are not easy to understand.

Re: how to write to database?

Anonymous — Mon, 26 Jan 2015 14:59:46 GMT

well guys,

I followed this guide Write back to database via XML output or web service, and I solved the problem by saving the data to XML. Now saving is working properly but I have two small problems:

1) saving only works on the elements currently viewing. Let me explain, mine is a dynamic scenario that changes in response to customer choice. the customer is chosen through a list box, and the table for entries is updated in relation to the customer chose. Each client is associated with a family of products and the table changes its number of lines in relation to the family. So there will never be a constant number of rows.

I'd like to save everything and not just data related to the customer chose.

2) how can I load the saved data in the table?