3 Replies Latest reply on Aug 2, 2012 8:01 AM by Tristan

    Mass Query Import to ePO 4.6.2

    pboedges

      I am looking for a way to import over 1300 custom queries into ePO 4.6.2.  Currently I am having to do it one by one which is slowly driving me to want to play in traffic, if anyone knows of a way to facilitate this type of import I would be grateful for your knowledge.

        • 1. Re: Mass Query Import to ePO 4.6.2
          pboedges

          Figured out how to create a SQL script that allowed me to insert the query information directly into the database and have it show up in the proper location within the ePO application.

          • 2. Re: Mass Query Import to ePO 4.6.2
            protector

            Can you share this information?  I am trying to do something very similar.  I actually thought this was a feature in ePO 4.6 but I guess not.  Don't remember where I heard that from.  I must have been confused.  Since we are able to see the queries of a report i just assumed we would be able to import one as well.  You can contact me at hjaquez@gmail.com

            • 3. Re: Mass Query Import to ePO 4.6.2
              Tristan

              A easier way of doing it if you don't want to mess with SQL directly (and potentially break your DB integrety) is to concatenate the queries together into one file.

               

              The exported queries are just XML so as long as you don't break the XML schema you can import them all in one file

               

              Example:

               

              <queries>

              <query>

                <name language="en">xxxxxxxxxxxxxxxx</name>

                <description language="en">Example 1</description>

                <property name="target">Example 1</property>

                <property name="tableURI">query</property>

                <property name="conditionURI">query</property>

                <property name="summaryURI">query</property>

              </query>

              <query>

                <name language="en">yyyyyyyyyyyyyyy</name>

                <description language="en">Example 2</description>

                <property name="target">Example 2</property>

                <property name="tableURI">query</property>

                <property name="conditionURI">query</property>

                <property name="summaryURI">query</property>

              </query>

              </queries>

               

              Message was edited by: Tristan on 02/08/12 14:01:15 IST