﻿<?xml version="1.0" encoding="utf-8"?><XmlProjectInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Id="692eaa4e-60cf-437f-b332-b1ca187feecf" Name="while-do" Type="0" OutputPath="build\" DefaultPublishProfile="Default" Version="2.12.3214.0" NotReplaceMacroInPreview="false" DisableMacroExtensions="false" TargitDbVersion="Version_1_281"><FileSystemObjects><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.XmlProjectModelInfo"><XmlProjectModelInfo FileName="while-do.impm" BuildAction="Yes" Id="1b7eb36c-4c1b-4183-a650-b84b47d78152" Created="2022-09-14T07:23:14.3596451+02:00" CreatedBy="TARGIT-INET\niels_t" Edited="2022-09-14T07:33:30.3077877+02:00" EditedBy="TARGIT-INET\niels_t" IsOpened="true" CubeName="while-do" PublishToServer="true" Is32BitExecutionMode="false" IsBaseScriptLocked="false" ExecuteOnScheduleOnly="false" IsStandard="false" RetryAttempts="0" RetryIntervalMins="0" RestartOnServiceFailure="true" RemoveDatabaseFromScheduler="true"><Instructions><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlGroupInstructionInfo"><XmlGroupInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.GroupToolSurfaceViewModel" Name="Load data for each company 2" Id="00000000-0000-0000-0000-000000000000" IsExpanded="true"><InnerInstructions><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlScriptInstructionInfo"><XmlScriptInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ScriptToolSurfaceViewModel" Name="WHILE 2" Id="00000000-0000-0000-0000-000000000000" Query="declare @Company as string&#xD;&#xA;declare @COMPID as int&#xD;&#xA;&#xD;&#xA;while wdCompany.EOF=false    /* Import data from each company listed in the wdCompany table */&#xD;&#xA;&#xD;&#xA;set @Company=wdCompany.Prefix&#xD;&#xA;set @COMPID=wdCompany.Company" IsDisableMacro="false" /></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlParallelInstructionInfo"><XmlParallelInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ParallelToolSurfaceViewModel" Name="Import Data in parallel 2" Id="00000000-0000-0000-0000-000000000000" IsExpanded="true" IsParallelExecution="false" BatchSize="0"><InnerInstructions><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlImportInstructionInfo"><XmlImportInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ImportToolSurfaceViewModel" Name="dCloseOpportunityCode 2" Id="00000000-0000-0000-0000-000000000000" DataSourceId="00000000-0000-0000-0000-000000000000" DataSourceText="Dynamics NAV" DataSourceQuery="select &#xD;&#xA;&quot;Code&quot; [Code],&#xD;&#xA;&quot;Description&quot; [Description],&#xD;&#xA;@@COMPID as &quot;Company&quot; &#xD;&#xA;from &quot;@@COMPANY$Close Opportunity Code&quot;" DataSourceQueryType="1" IsDisableMacro="false" IsUncolumnized="false" UseDisk="false" /></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlImportInstructionInfo"><XmlImportInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ImportToolSurfaceViewModel" Name="dFixedAsset 2" Id="00000000-0000-0000-0000-000000000000" DataSourceId="00000000-0000-0000-0000-000000000000" DataSourceText="Dynamics NAV" DataSourceQuery="select &#xD;&#xA;&quot;Description&quot; [Description],&#xD;&#xA;&quot;No_&quot; [No],&#xD;&#xA;@@COMPID as &quot;Company&quot; from &quot;@@COMPANY$Fixed Asset&quot;" DataSourceQueryType="1" IsDisableMacro="false" IsUncolumnized="false" UseDisk="false" /></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlImportInstructionInfo"><XmlImportInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ImportToolSurfaceViewModel" Name="dCampaignStatus 2" Id="00000000-0000-0000-0000-000000000000" DataSourceId="00000000-0000-0000-0000-000000000000" DataSourceText="Dynamics NAV" DataSourceQuery="select &#xD;&#xA;&quot;Code&quot; [Code],&#xD;&#xA;&quot;Description&quot; [Description],&#xD;&#xA;@@COMPID as &quot;Company&quot; from &quot;@@COMPANY$Campaign Status&quot;" DataSourceQueryType="1" IsDisableMacro="false" IsUncolumnized="false" UseDisk="false" /></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlImportInstructionInfo"><XmlImportInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ImportToolSurfaceViewModel" Name="dPurchCrMemoHdr 2" Id="00000000-0000-0000-0000-000000000000" DataSourceId="00000000-0000-0000-0000-000000000000" DataSourceText="Dynamics NAV" DataSourceQuery="select &#xD;&#xA;&quot;No_&quot; [No],&#xD;&#xA;&quot;Buy-from Vendor No_&quot; [BuyFromVendorNo],&#xD;&#xA;&quot;Pay-to Vendor No_&quot; [PayToVendorNo],&#xD;&#xA;&quot;Posting Date&quot; [PostingDate],&#xD;&#xA;&quot;Currency Factor&quot; [CurrencyFactor],&#xD;&#xA;&quot;Purchaser Code&quot; [PurchaserCode],&#xD;&#xA;&quot;Source Code&quot; [SourceCode],&#xD;&#xA;&quot;Ship-to Code&quot; [ShipToCode],&#xD;&#xA;&quot;Prices Including VAT&quot; [PricesIncludingVAT],&#xD;&#xA;@@COMPID as &quot;Company&quot; &#xD;&#xA;from &quot;@@COMPANY$Purch_ Cr_ Memo Hdr_&quot;" DataSourceQueryType="1" IsDisableMacro="false" IsUncolumnized="false" UseDisk="false" /></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlImportInstructionInfo"><XmlImportInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ImportToolSurfaceViewModel" Name="dGLBudgetName 2" Id="00000000-0000-0000-0000-000000000000" DataSourceId="00000000-0000-0000-0000-000000000000" DataSourceText="Dynamics NAV" DataSourceQuery="select &#xD;&#xA;&quot;Name&quot; [Name],&#xD;&#xA;&quot;Description&quot; [Description],&#xD;&#xA;@@COMPID as &quot;Company&quot; &#xD;&#xA;from &quot;@@COMPANY$G_L Budget Name&quot;" DataSourceQueryType="1" IsDisableMacro="false" IsUncolumnized="false" UseDisk="false" /></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlImportInstructionInfo"><XmlImportInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ImportToolSurfaceViewModel" Name="dCampaign 2" Id="00000000-0000-0000-0000-000000000000" DataSourceId="00000000-0000-0000-0000-000000000000" DataSourceText="Dynamics NAV" DataSourceQuery="select &#xD;&#xA;&quot;Description&quot; [Description],&#xD;&#xA;&quot;Status Code&quot; [StatusCode],&#xD;&#xA;&quot;No_&quot; [No],&#xD;&#xA;@@COMPID as &quot;Company&quot; &#xD;&#xA;from &quot;@@COMPANY$Campaign&quot;" DataSourceQueryType="1" IsDisableMacro="false" IsUncolumnized="false" UseDisk="false" /></IStorageInfo></InnerInstructions></XmlParallelInstructionInfo></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlScriptInstructionInfo"><XmlScriptInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ScriptToolSurfaceViewModel" Name="LOOP / MoveNext 2" Id="00000000-0000-0000-0000-000000000000" Query="&#xD;&#xA;movenext wdCompany&#xD;&#xA;&#xD;&#xA;LOOP" IsDisableMacro="false" /></IStorageInfo></InnerInstructions></XmlGroupInstructionInfo></IStorageInfo></Instructions><Schedules><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.XmlSchedule"><XmlSchedule Name="Nightly update" ScheduleValue="0 0 2 1/1 * ? *" ExecutionTimeLimit="0" /></IStorageInfo></Schedules></XmlProjectModelInfo></IStorageInfo></FileSystemObjects><PublishProfiles><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Publish.XmlPublishProfileInfo"><XmlPublishProfileInfo Name="Default"><PublishStrategyInfo xsi:type="XmlSchedulerServicePublishStrategyInfo" Server="localhost:9098" OpenOutputFolderInWindowsExplorer="false" ExecuteAndFetchResultsLocally="false" DeleteAllExistingFiles="false" /></XmlPublishProfileInfo></IStorageInfo></PublishProfiles><DataSources /><Macros /><Synchronization IsEnabled="false" /></XmlProjectInfo>