QVW Extractor.qvw

    (**Editor's Note: 08/13/2014 - This application has been updated.  If you are looking for the most recent copy of the QVW Extractor, you can find it at this thread:  Evolution of a QVD Extracting Application (the .QVW Juicer)

    Greetings All,



    I created a QlikView application for 'extracting' from existing stand alone applications.  And then the output window will generate some scripting that can be cut and paste into either a new application or can be inserted into the source application and run after the original script is either commented out or cleared.


    In a sense this is like a binary load except for two differences:


    - It creates local stand alone copy of a QVD for every table in the data-model (saved as the table name in the application), in a binary load all the data still resides resident within the source .QVW.


    - It scripts all the tables and fields that are included in the full package of tables.  A binary load will not have this scripted, you will have to manually introduce the field names/tables you wish to modify after loading.


    In a sense this may be useful for determining the functionality of applications that are 'cut-off' from their data source, or for scooping out the brains of an existing application so that you can insert your own script that may be run locally without having fear of losing the User Interface functionality.


    The instructions are as follows:


    1- Populate the 3 input boxes with the appropriate entries: 1. directory of source .qvw to be extracted 2. file name of .qvw to be extracted 3. an existing directory for .qvd output


    2- It is important to have the output window remain open so that you may cut & paste from it.  Run the application.


    3- From the output window cut and paste the portion of the script that follows the last section where it states "Auto-Script Generated"


    4- Paste that section of script into either the 'scooped out' version of the original .qvw OR a blank application.


    5- Use Fin/Replace to replace all instances of a single quote with Null() and then run the script.


    You should now have a local executable copy of the application that runs against local QVDs and is fully field scripted.


    ~E  Let me know if you a) Like This b) Think it is lame c) Have always been a fan of binary load d) Find it useful.. if you're into wasting time e) Like it, but.. then again liked 'About Steve'