Hi All,

In an attempt to semi-automate the the process of updating business process look-up rules between environments as resolved by Scott Wilson here:  http://answers.laserfiche.com/questions/89648/Feature-Request--disable-Lookup-Rules#89660 i though i'd share something I have been using in case it is of use to anyone else.

When loading Forms business processes from a dev environment to a test environment (or test to production) and back it is possible to transform the XML file using XSLT which allows you to substitute the server and user names quickly.

I have a file for each environment as follows :-

<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output omit-xml-declaration="yes" indent="yes"/>
<xsl:strip-space elements="*"/>
    
<xsl:template match="@*|node()">
  <xsl:copy>
    <xsl:apply-templates select="@*|node()"/>
  </xsl:copy>
</xsl:template>

 <xsl:template match="externaldatabase/server/text()">
   <xsl:text>WIN2K12\LASERFICHE</xsl:text>
 </xsl:template>
 <xsl:template match="externaldatabase/user/text()">
   <xsl:text>WIN2K12\Administrator</xsl:text>
 </xsl:template>
 
<xsl:template match="lookup/server/text()">
   <xsl:text>WIN2K12\LASERFICHE</xsl:text>
</xsl:template>
<xsl:template match="lookup/user/text()">
   <xsl:text>WIN2K12\Administrator</xsl:text>
</xsl:template>

 
</xsl:stylesheet>
 

And go to http://freeformatter.com/xsl-transformer.html and paste the xslt stylesheet into the xsl input window for the environment I am targetting (obviously substitue your user and server names appropriately).

Then upload the business process XML to the XML input window and hit the transform button to get the transformed document for the target environment.

I find this a quick way to get any changes synchronised between environments, particularly if there are a number of data sources and databases.  (This script assumes that the databases are named the same in each environment).

Hopefully at some point Forms will just disable rules rather than delete them as has already been discussed but until then...