Скрипты для синхронизации справочников ФФОМС

UPDATE OR INSERT INTO SYNC_REFERENCE (SYNCREFID,REFNAME,REFCODE,REFTABLE,REFHANDLER,REFTYPE,DICREFID,PARENTREFID,REFTEMPLATE,REFENCODING,REFFOLDER) VALUES (7,'V006 Классификатор условий оказания меди-цинской помощи','V006','NSI_V006','NSI_SYNC_V006',2,55,42,'<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" encoding="windows-1251" indent="yes"/> 
<xsl:template match="/packet">
<xsl:element name="root"> 
  <properties>
    <version>
      <xsl:attribute name="number">
        <xsl:value-of select="zglv/version"/>
      </xsl:attribute>
      <xsl:attribute name="date">
        <xsl:value-of select="zglv/date"/>
      </xsl:attribute>
    </version>
  </properties>
  <xsl:for-each select="zap">
    <xsl:element name="zap">
           <xsl:attribute name="IDUMP">
                   <xsl:value-of select="IDUMP"/>
                </xsl:attribute> 
                <xsl:attribute name="UMPNAME">
                   <xsl:value-of select="UMPNAME"/>
                </xsl:attribute>               
                <xsl:attribute name="DATEBEG">
                   <xsl:value-of select="DATEBEG"/>
                </xsl:attribute>            
                <xsl:attribute name="DATEEND">
                   <xsl:value-of select="DATEEND"/> 
                </xsl:attribute>
          </xsl:element>
  </xsl:for-each>
</xsl:element>
</xsl:template>
</xsl:stylesheet>','CP1251','C:\NSI');





UPDATE OR INSERT INTO SYNC_REFERENCE (SYNCREFID,REFNAME,REFCODE,REFTABLE,REFHANDLER,REFTYPE,DICREFID,PARENTREFID,REFTEMPLATE,REFENCODING,REFFOLDER) VALUES (10,'V009 Классификатор результатов обращения за МП','V009','NSI_V009','NSI_SYNC_V009',2,-10003,42,'<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" encoding="windows-1251" indent="yes"/> 
<xsl:template match="/packet">
<xsl:element name="root"> 
  <properties>
    <version>
      <xsl:attribute name="number">
        <xsl:value-of select="zglv/version"/>
      </xsl:attribute>
      <xsl:attribute name="date">
        <xsl:value-of select="zglv/date"/>
      </xsl:attribute>
    </version>
  </properties>
  <xsl:for-each select="zap">
    <xsl:element name="zap">
           <xsl:attribute name="IDRMP">
                   <xsl:value-of select="IDRMP"/>
                </xsl:attribute> 
                <xsl:attribute name="RMPNAME">
                   <xsl:value-of select="RMPNAME"/>
                </xsl:attribute>               
                <xsl:attribute name="DATEBEG">
                   <xsl:value-of select="DATEBEG"/>
                </xsl:attribute>            
                <xsl:attribute name="DATEEND">
                   <xsl:value-of select="DATEEND"/> 
                </xsl:attribute>
                <xsl:attribute name="DL_USLOV">
                   <xsl:value-of select="DL_USLOV"/> 
                </xsl:attribute>
          </xsl:element>
  </xsl:for-each>
</xsl:element>
</xsl:template>
</xsl:stylesheet>','CP1251','C:\NSI');






UPDATE OR INSERT INTO SYNC_REFERENCE (SYNCREFID,REFNAME,REFCODE,REFTABLE,REFHANDLER,REFTYPE,DICREFID,PARENTREFID,REFTEMPLATE,REFENCODING,REFFOLDER) VALUES (12,'V012 Классификатор исходов заболевания','V012','NSI_V012','NSI_SYNC_V012',2,-10017,42,'<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" encoding="windows-1251" indent="yes"/> 
<xsl:template match="/packet">
<xsl:element name="root"> 
  <properties>
    <version>
      <xsl:attribute name="number">
        <xsl:value-of select="zglv/version"/>
      </xsl:attribute>
      <xsl:attribute name="date">
        <xsl:value-of select="zglv/date"/>
      </xsl:attribute>
    </version>
  </properties>
  <xsl:for-each select="zap">
    <xsl:element name="zap">
           <xsl:attribute name="IDIZ">
                   <xsl:value-of select="IDIZ"/>
                </xsl:attribute> 
                <xsl:attribute name="IZNAME">
                   <xsl:value-of select="IZNAME"/>
                </xsl:attribute>               
                <xsl:attribute name="DATEBEG">
                   <xsl:value-of select="DATEBEG"/>
                </xsl:attribute>            
                <xsl:attribute name="DATEEND">
                   <xsl:value-of select="DATEEND"/> 
                </xsl:attribute>
                <xsl:attribute name="DL_USLOV">
                   <xsl:value-of select="DL_USLOV"/> 
                </xsl:attribute>
          </xsl:element>
  </xsl:for-each>
</xsl:element>
</xsl:template>
</xsl:stylesheet>','CP1251','C:\NSI');

sql