SQL Where Clause to XML Export Window – Support Debugging Tool Build 15

Today, I am going to discuss another new feature of Support debugging Tool in new build 15. The option to export data from and import it back in another company or another setup. You can refer to the following article for details about using the XML export and import.

Dynamics GP SDT Essential Series 2– Transfer AA Dimensions and Codes from Test to Production

Now, you can enter the Where Clause in the XML Table Export. You can select the column using the lookup window. The syntax is similar to SQL.

 

Also, you can view the total number of records in the table and records count returned after where clause

 

 

Some example for using this -

• David Musgrave showed – how to transfer Security Tasks and Roles between Systems. This is useful when you are migrating security from Test to Production.
• Mariano Gomez used the XML Table import as one of the ways of Transferring Extender customizations from one company database to another

 

 

No Responses to “SQL Where Clause to XML Export Window – Support Debugging Tool Build 15”

1. Everything Dynamics GP #10 - About Dynamics, Development and Life - GP Technical Blogs - Microsoft Dynamics Community says:

   July 28, 2011 at 8:05 am

   [...] SQL Where Clause to XML Export Window – Support Debugging Tool Build 15 | Dynamics GP Help (Rubal) . [...]
2. Using the Support Debugging Tool with Real Life Examples - Developing for Microsoft Dynamics GP - GP Technical Blogs - Microsoft Dynamics Community says:

   August 5, 2011 at 1:58 am

   [...] SQL Where Clause to XML Export Window – Support Debugging Tool Build 15 [...]
3. Using the Support Debugging Tool with Real Life Examples - Developing for Dynamics GP - Dynamics User Group says:

   August 5, 2011 at 3:44 am

   [...] SQL Where Clause to XML Export Window – Support Debugging Tool Build 15 [...]
4. Using the Support Debugging Tool with Real Life Examples | Gurubootcamp: Microsoft says:

   August 5, 2011 at 9:50 pm

   [...] SQL Where Clause to XML Export Window – Support Debugging Tool Build 15 [...]
5. Using the Support Debugging Tool with Real Life Examples - Developing for Dynamics GP - Site Home - MSDN Blogs says:

   August 9, 2011 at 3:28 am

   [...] SQL Where Clause to XML Export Window – Support Debugging Tool Build 15 [...]