<NewDataSet>
  <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="DS_WEAC_IntegrationSetup" msdata:UseCurrentLocale="true">
      <xs:complexType>
        <xs:choice minOccurs="0" maxOccurs="unbounded">
          <xs:element name="DS_WEAC_IntegrationSetup">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="ConnectionString" type="xs:string" minOccurs="0" />
                <xs:element name="InterfaceID" type="xs:string" minOccurs="0" />
                <xs:element name="TabCaption" type="xs:string" minOccurs="0" />
                <xs:element name="Description" type="xs:string" minOccurs="0" />
                <xs:element name="Target" type="xs:string" minOccurs="0" />
                <xs:element name="Provider" type="xs:string" minOccurs="0" />
                <xs:element name="ServerName" type="xs:string" minOccurs="0" />
                <xs:element name="Database" type="xs:string" minOccurs="0" />
                <xs:element name="UserName" type="xs:string" minOccurs="0" />
                <xs:element name="Password" type="xs:string" minOccurs="0" />
                <xs:element name="SourceTableName" type="xs:string" minOccurs="0" />
                <xs:element name="MapTableName" type="xs:string" minOccurs="0" />
                <xs:element name="SourceAreaKeyField" type="xs:string" minOccurs="0" />
                <xs:element name="UniqueField" type="xs:string" minOccurs="0" />
                <xs:element name="DescriptionField" type="xs:string" minOccurs="0" />
                <xs:element name="ProgressField" type="xs:string" minOccurs="0" />
                <xs:element name="StartField" type="xs:string" minOccurs="0" />
                <xs:element name="FinishField" type="xs:string" minOccurs="0" />
                <xs:element name="HistValueField" type="xs:string" minOccurs="0" />
                <xs:element name="HistCaption" type="xs:string" minOccurs="0" />
                <xs:element name="MarkerField" type="xs:string" minOccurs="0" />
                <xs:element name="MarkerCaption" type="xs:string" minOccurs="0" />
                <xs:element name="GetFields" type="xs:string" minOccurs="0" />
                <xs:element name="WhereClause" type="xs:string" minOccurs="0" />
                <xs:element name="UserShadowTableName" type="xs:string" minOccurs="0" />
                <xs:element name="ActiveIndex" type="xs:double" minOccurs="0" />
              </xs:sequence>
            </xs:complexType>
          </xs:element>
        </xs:choice>
      </xs:complexType>
    </xs:element>
  </xs:schema>
  <DS_WEAC_IntegrationSetup>
    <ConnectionString>Provider=AutoDetect;Data Source=.\IntegrationDummy.xls;Extended Properties="Excel 8.0;HDR=YES;"</ConnectionString>
    <InterfaceID>Dummy2</InterfaceID>
    <TabCaption>Dummy</TabCaption>
    <Target>Excel</Target>
    <Database>.\IntegrationDummy.xls</Database>
    <SourceTableName>[DummyData$]</SourceTableName>
    <MapTableName>[MapTable$]</MapTableName>
    <SourceAreaKeyField>AreaCode</SourceAreaKeyField>
    <UniqueField>UniqueID</UniqueField>
    <GetFields>*</GetFields>
    <ActiveIndex>0.5</ActiveIndex>
  </DS_WEAC_IntegrationSetup>
  <DS_WEAC_IntegrationSetup>
    <ConnectionString>Provider=AutoDetect;Data Source=.\IntegrationDummy.xls;Extended Properties="Excel 8.0;HDR=YES;"</ConnectionString>
    <InterfaceID>Dummy1</InterfaceID>
    <TabCaption>Dummy</TabCaption>
    <Target>Excel</Target>
    <Database>.\IntegrationDummy.xls</Database>
    <SourceTableName>[DummyData$]</SourceTableName>
    <MapTableName>[MapTable$]</MapTableName>
    <SourceAreaKeyField>AreaCode</SourceAreaKeyField>
    <UniqueField>UniqueID</UniqueField>
    <GetFields>*</GetFields>
    <ActiveIndex>0.5</ActiveIndex>
  </DS_WEAC_IntegrationSetup>
  <DS_WEAC_IntegrationSetup>
    <ConnectionString>Provider=AutoDetect;Data Source=.\ImportFiles\SynergiTestIntegration.xls;Extended Properties="Excel 8.0;HDR=YES;"</ConnectionString>
    <InterfaceID>Synergi</InterfaceID>
    <TabCaption>Synergi</TabCaption>
    <Description>Read Excel export from Synergi</Description>
    <Target>Excel</Target>
    <Database>.\ImportFiles\SynergiTestIntegration.xls</Database>
    <SourceTableName>[BaseData$]</SourceTableName>
    <MapTableName>Proteus_AreaMap</MapTableName>
    <SourceAreaKeyField>'c8ceb667-c099-44e2-8bba-dc7292cb9f04'</SourceAreaKeyField>
    <UniqueField>UniqueID</UniqueField>
    <DescriptionField>Actiondescription</DescriptionField>
    <StartField>Casedate</StartField>
    <FinishField>Actiondeadline</FinishField>
    <HistValueField>Numberofregistrations</HistValueField>
    <HistCaption>Test</HistCaption>
    <MarkerField>Modifieddate</MarkerField>
    <MarkerCaption>Modified</MarkerCaption>
    <GetFields>*,
Caseno &amp; '|' &amp; Actionno as UniqueID,
'http://SYNERGITRD/synergi/default.aspx?dmn=7831&amp;trsid=' + Caseno + '&amp;trsnm=' + Actionno as SynergiLink,
left(Actionpriority, 1) as Priority,
iif(Actiondeadline &lt; Now(), 1, 0) as IsOverdue
</GetFields>
    <UserShadowTableName>Proteus_UserShadow</UserShadowTableName>
    <ActiveIndex>0</ActiveIndex>
  </DS_WEAC_IntegrationSetup>
  <DS_WEAC_IntegrationSetup>
    <ConnectionString>Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Desktop\Projects\Proteus\WEAC\Floatel\EnduranceSimulatedComplianceData.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";</ConnectionString>
    <InterfaceID>AdeptDemo</InterfaceID>
    <TabCaption>Adept Concept</TabCaption>
    <Description>Demo of how simulated Adept complance values can be visualized in Proteus WEAC</Description>
    <Provider>Microsoft.ACE.OLEDB.12.0;Data Source=D:\Desktop\Projects\Proteus\WEAC\Floatel\EnduranceSimulatedComplianceData.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";</Provider>
    <SourceTableName>[ComplianceX$]</SourceTableName>
    <MapTableName>[MapX$]</MapTableName>
    <SourceAreaKeyField>UnitID</SourceAreaKeyField>
    <UniqueField>UniqueID</UniqueField>
    <DescriptionField>Finding</DescriptionField>
    <ProgressField>Progress</ProgressField>
    <StartField>Start</StartField>
    <FinishField>Finish</FinishField>
    <HistValueField>EstHours</HistValueField>
    <HistCaption>Est Hrs</HistCaption>
    <GetFields>*</GetFields>
    <ActiveIndex>0</ActiveIndex>
  </DS_WEAC_IntegrationSetup>
  <DS_WEAC_IntegrationSetup>
    <ConnectionString>Provider=msdaora;Data Source=xe;User Id=admuser;Password=admuser</ConnectionString>
    <InterfaceID>Oracle Tasks</InterfaceID>
    <TabCaption>P6 Tasks</TabCaption>
    <Description>Primavera Tasks</Description>
    <Target>Oracle</Target>
    <ServerName>xe</ServerName>
    <UserName>admuser</UserName>
    <Password>admuser</Password>
    <SourceTableName>TASK</SourceTableName>
    <MapTableName>PROTEUS_MAPTABLE</MapTableName>
    <SourceAreaKeyField>TASK_CODE</SourceAreaKeyField>
    <UniqueField>TASK_CODE</UniqueField>
    <DescriptionField>TASK_NAME</DescriptionField>
    <ProgressField>PHYS_COMPLETE_PCT</ProgressField>
    <StartField>EARLY_START_DATE</StartField>
    <FinishField>EARLY_END_DATE</FinishField>
    <HistValueField>REMAIN_DRTN_HR_CNT</HistValueField>
    <HistCaption>Remain Hrs</HistCaption>
    <MarkerField>LATE_END_DATE</MarkerField>
    <MarkerCaption>Late End Date</MarkerCaption>
    <GetFields>*</GetFields>
    <WhereClause>PROJ_ID=368</WhereClause>
    <UserShadowTableName>PROTEUS_USERSHADOW</UserShadowTableName>
    <ActiveIndex>0</ActiveIndex>
  </DS_WEAC_IntegrationSetup>
  <DS_WEAC_IntegrationSetup>
    <ConnectionString>Provider=msdaora;Data Source=xe;User Id=admuser;Password=admuser</ConnectionString>
    <InterfaceID>Primavera Tasks</InterfaceID>
    <TabCaption>P6 Tasks</TabCaption>
    <Description>P6 Tasks from Oracle</Description>
    <Target>Oracle</Target>
    <ServerName>xe</ServerName>
    <UserName>admuser</UserName>
    <Password>admuser</Password>
    <SourceTableName>TASK</SourceTableName>
    <SourceAreaKeyField>TASK_NAME</SourceAreaKeyField>
    <UniqueField>TASK_ID</UniqueField>
    <DescriptionField>TASK_CODE</DescriptionField>
    <ProgressField>PHYS_COMPLETE_PCT</ProgressField>
    <StartField>EARLY_START_DATE</StartField>
    <FinishField>EARLY_END_DATE</FinishField>
    <HistValueField>TARGET_WORK_QTY</HistValueField>
    <HistCaption>Target Qty</HistCaption>
    <MarkerField>EXPECT_END_DATE</MarkerField>
    <MarkerCaption>Expected End date</MarkerCaption>
    <GetFields>*</GetFields>
    <UserShadowTableName>Proteus_UserShadow</UserShadowTableName>
    <ActiveIndex>0</ActiveIndex>
  </DS_WEAC_IntegrationSetup>
  <DS_WEAC_IntegrationSetup>
    <ConnectionString>Provider=AutoDetect;Data Source=d:\WEActions.xls;Extended Properties="Excel 8.0;HDR=YES;"</ConnectionString>
    <InterfaceID>Action Register</InterfaceID>
    <TabCaption>Action Register</TabCaption>
    <Description>Action Register from CoP</Description>
    <Target>Excel</Target>
    <Database>d:\WEActions.xls</Database>
    <SourceTableName>[Sheet1$]</SourceTableName>
    <MapTableName>MapTable</MapTableName>
    <SourceAreaKeyField>AreaCode</SourceAreaKeyField>
    <UniqueField>WE_ID</UniqueField>
    <GetFields>*</GetFields>
    <UserShadowTableName>Proteus_UserShadow</UserShadowTableName>
    <ActiveIndex>0</ActiveIndex>
  </DS_WEAC_IntegrationSetup>
  <DS_WEAC_IntegrationSetup>
    <ConnectionString>Provider=AutoDetect;Data Source=d:\WEACIntergrationTest.xls;Extended Properties="Excel 8.0;HDR=YES;"</ConnectionString>
    <InterfaceID>ExcelDemo</InterfaceID>
    <TabCaption>Erik Demo</TabCaption>
    <Description>Test by Erik</Description>
    <Target>Excel</Target>
    <Database>d:\WEACIntergrationTest.xls</Database>
    <SourceTableName>[Sheet1$]</SourceTableName>
    <MapTableName>MyMap</MapTableName>
    <SourceAreaKeyField>MyArea</SourceAreaKeyField>
    <UniqueField>MyID</UniqueField>
    <GetFields>*</GetFields>
    <UserShadowTableName>Proteus_UserShadow</UserShadowTableName>
    <ActiveIndex>0</ActiveIndex>
  </DS_WEAC_IntegrationSetup>
  <DS_WEAC_IntegrationSetup>
    <ConnectionString>Provider=sqloledb;Server=(local)\sqlexpress;Database=Safran;Uid=ErikDBO;Pwd=ErikDBO;Trusted_Connection=no</ConnectionString>
    <InterfaceID>Safran Networks</InterfaceID>
    <TabCaption>Test</TabCaption>
    <Description>Testing</Description>
    <Target>SQLServer</Target>
    <ServerName>(local)\sqlexpress</ServerName>
    <Database>Safran</Database>
    <UserName>ErikDBO</UserName>
    <Password>ErikDBO</Password>
    <SourceTableName>networks</SourceTableName>
    <MapTableName>WEAC_AreaMap_Networks</MapTableName>
    <SourceAreaKeyField>name</SourceAreaKeyField>
    <UniqueField>net_id</UniqueField>
    <GetFields>*</GetFields>
    <UserShadowTableName>Proteus_UserShadow</UserShadowTableName>
    <ActiveIndex>0</ActiveIndex>
  </DS_WEAC_IntegrationSetup>
  <DS_WEAC_IntegrationSetup>
    <ConnectionString>Provider=sqloledb;Server=(local)\sqlexpress;Database=Safran;Uid=;Pwd=ErikDBO;Trusted_Connection=yes</ConnectionString>
    <InterfaceID>Safran Plan</InterfaceID>
    <TabCaption>Safran</TabCaption>
    <Description>Loads data from Safran</Description>
    <Target>SQLServer</Target>
    <ServerName>(local)\sqlexpress</ServerName>
    <Database>Safran</Database>
    <Password>ErikDBO</Password>
    <SourceTableName>activities</SourceTableName>
    <MapTableName>WEAC_AreaKeyMap</MapTableName>
    <SourceAreaKeyField>(select short from codeset c where c.config_id = 4 and c.rfield_nr = 3 and SRC.r3 = c.code)</SourceAreaKeyField>
    <UniqueField>an</UniqueField>
    <DescriptionField>des</DescriptionField>
    <ProgressField>current_progress</ProgressField>
    <StartField>esa</StartField>
    <FinishField>ef</FinishField>
    <HistValueField>du</HistValueField>
    <HistCaption>Hours</HistCaption>
    <MarkerField>ces</MarkerField>
    <MarkerCaption>MyMarker</MarkerCaption>
    <GetFields>*</GetFields>
    <WhereClause>net_id = case when SelectedInstallation = 'Demo' then 4 else 1 end</WhereClause>
    <UserShadowTableName>Proteus_UserShadow</UserShadowTableName>
    <ActiveIndex>0</ActiveIndex>
  </DS_WEAC_IntegrationSetup>
  <DS_WEAC_IntegrationSetup>
    <ConnectionString>Provider=AutoDetect;Data Source=.\IntegrationData1.xls;Extended Properties="Excel 8.0;HDR=YES;"</ConnectionString>
    <InterfaceID>Job Data</InterfaceID>
    <TabCaption>Job Card Data</TabCaption>
    <Description>Loads related data from job card system</Description>
    <Target>Excel</Target>
    <Database>.\IntegrationData1.xls</Database>
    <SourceTableName>[IntegrationData$]</SourceTableName>
    <MapTableName>[AreaKeyMapping$]</MapTableName>
    <SourceAreaKeyField>AreaCode</SourceAreaKeyField>
    <UniqueField>Work_No</UniqueField>
    <DescriptionField>Description</DescriptionField>
    <ProgressField>Progress</ProgressField>
    <StartField>Start</StartField>
    <FinishField>Finish</FinishField>
    <HistValueField>Mhrs</HistValueField>
    <HistCaption>Hours</HistCaption>
    <MarkerField>Finish</MarkerField>
    <MarkerCaption>Demo</MarkerCaption>
    <GetFields>*, 
Iif(job_hot_work='x', 1, 0) as HotWork_01, 
Iif(WENonConformity='x', 1, 0) as WENonConf_01,
'Item: &lt;size=12&gt;&lt;color=red&gt;{Work_No}&lt;/color&gt;&lt;/size&gt;
&lt;b&gt;Description&lt;/b&gt;: {Description}' as _ToolTip_Work_No</GetFields>
    <UserShadowTableName>[Proteus_UserShadow$]</UserShadowTableName>
    <ActiveIndex>0</ActiveIndex>
  </DS_WEAC_IntegrationSetup>
</NewDataSet>