6 Replies Latest reply: Aug 9, 2010 1:16 PM by pulasti choudhary RSS

    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

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

          no on???

           

          Smile

          • 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

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

                 

                 

                 

                  • Is it possible to export back to (my)SQL ???
                    pulasti choudhary

                    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!