topic Re: Simple QlikView Writeback Extension in QlikView

Simple QlikView Writeback Extension

joshabbott — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

Could anyone give me assistance on a QlikView writeback extension that exists or writing a simple one? All that I need to do is have an input box and a submit button. When the user enters text into the input box and clicks submit, it kicks off a stored procedure on our Teradata database server and passes the text from the input box as a parameter to write the data to the database table.

I've tried macro's, but because of limitations on our server, I can't work this through.

I've also reached out to several extension companies online and am not having any luck. Thank you for your help!

Josh

Re: Simple QlikView Writeback Extension

Brett_Bleess — Tue, 20 Oct 2020 15:31:41 GMT

An easier option may be to do a Database Command Supporting Task that would run the Stored Proc call, I am not sure about the parameter piece in this case though...

Here is Help Doc for Extensions just in case you had not found that:

https://help.qlik.com/en-US/qlikview-developer/April2020/Subsystems/Extensions/Content/QV_Extensions/extensions-start.htm

Here is Help doc on the Support Task I mentioned:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/QMC/Content/QV_QMC/QMC_System_SupportingTasks_DatabaseCommand.htm

Hopefully this gets you moving forward with things.

Regards,
Brett

Re: Simple QlikView Writeback Extension

joshabbott — Tue, 20 Oct 2020 16:20:00 GMT

Thank you for your reply!! I'm not understanding the 'Database Command', even looking through the documentation. Is it something set up in the QMC under the document? Maybe it is hidden to me since I don't own the server, but I can do most things with tasks in the QMC.