Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Is it possible to export back to (my)SQL ???

I am testing qw and have connected a mysql db thru mysql odbc connector.

I have selected 1 DB and 2 tables... and got everything working...

Is it possible to create a record with the result into another table??????

Greetings Eddie

6 Replies
Not applicable

Is it possible to export back to (my)SQL ???

no on???

Smile

Not applicable

Is it possible to export back to (my)SQL ???

I believe that from QlikView 9 (sr 3) you should be able to store data into a text file with the "store into" function and that you should be able to set the delimitor yourself. Check out this thread: http://community.qlik.com/forums/t/22658.aspx

After that you should import it back into your database.

Luminary
Luminary

Is it possible to export back to (my)SQL ???

Eddie,

You could export data from QlikView automatically using a marco and I imagine have mySQL look of the csv, txt or xml file in a certain folder to import it or another option might be to run a stored procedure passing the parameters necessary to update the mySQL table. Here's the code to run a stored procedure in QlikView script.

sql execute QV_SBO..Test @Input='2009/01/01';

Regards, Karl

Not applicable

Is it possible to export back to (my)SQL ???

tnx karl and keller...

i have to read more about your suggest...

My Sweedish friend in Norway works at the QW norway and I have just got hold of the produkt...

Since my company (Microsoft) only use MS products its wierd to try something other . *SS*

Love the product, so if connecting to 2-3-4-5 sources kan makes it possible to export the result direct into a mysql og sql or any odbc compatible source, I would LOOVE it eve more :-)

Again tnx...

Eddie

Not applicable

Is it possible to export back to (my)SQL ???

I "cowboyed" this to work for an application that populates data from a sql database, allows for manual updates via input boxes, then exports the changes to a spreadsheet and uploads it back to the sql db.

Once it's been reuploaded, I have a vbs file that fires off the reload task in Publisher so that the server contains the "changed" version of the application.

Sub to export the manually updated object...

Sub Export_Manual_Table
ActiveDocument.ClearAll

set table_manual = ActiveDocument.GetSheetObject("CH03")
set gp=table_manual.GetProperties
table_manual.SetProperties gp
table_manual.ExportBiff("pathname\filename_manual.xls")

table_manual.SetProperties gp
ActiveDocument.ClearAll
end sub


The above xls is stored on the network, the app then fires off a script to run the DTS package on SQL to pick up the xls and append/update the sql table.

DTSRun /S "SERVER" /N "PACKAGE" /G "GUID PACKAGE ID" /E


The app then fires the reload script - both called from OPEn URL in the add actions menu - where the vbs or bat file are the url.

Not applicable

Is it possible to export back to (my)SQL ???

Hi,

I tried the export subroutine for an input box

Sub Export_Manual_Table
ActiveDocument.ClearAll
set table_manual = ActiveDocument.GetSheetObject("IB01")
set gp=table_manual.GetProperties
table_manual.SetProperties gp
table_manual.ExportBiff("pathname\filename_manual.xls")
table_manual.SetProperties gp
ActiveDocument.ClearAll
end sub

I got an error - Object doesn't support this property or method: 'table_manual.ExportBiff'

Could you pl help?

Thanks!

Community Browser