Navigation:  Project File >

FileFormat

Previous pageReturn to chapter overviewNext page

The Project file is a simple XML text file that can be edited with any standard text editor such as notepad.

When manually editing XML files be aware that the names of tags are Case-sensitive. Misspelling will cause failures.

 

Tip:

prepare your project using the Synkronizer  form, save it, then edit it to suit your needs.

 

This is the layout of the file for a project where sheets are auto matched, without any options set for any of the pairs.

You'll notice that there are no individual pairs listed inside the <Pairs> tag..

 

<?xml version="1.0" standalone="yes"?>

<Synkronizer>

   <Project ID="1">

      <Settings>

         <CompareType>0</CompareType>

         <Formats>0</Formats>

         <Filters>0</Filters>

         <FilterTolerance>0</FilterTolerance>

         <FilterPattern/>

         <ReportType>0</ReportType>

         <HighlightType>1</HighlightType>

         <ShowHide>0</ShowHide>

      </Settings>

      <Files>

         <Filename0>C:\Folder\SubFolder\File 1.xls</Filename0>

         <Filename1>C:\Folder\SubFolder\File 2.xls</Filename1>

      </Files>

      <Pairs>

         <MatchType>1</MatchType>

         <MatchInclude>2</MatchInclude>

      </Pairs>

   </Project>

</Synkronizer>

 

 

For a project where pairs have individual settings the file will look like this:

(MatchType will be set to 0 as soon as you set a pair option such as RangeAddr or DBKeys.)

 

The pair tags must be sequentially numbered via the ID attribute.

 

 

<?xml version="1.0" standalone="yes"?>

<Synkronizer>

   <Project ID="1">

      <Settings>

         <CompareType>0</CompareType>

         <Formats>0</Formats>

         <Filters>0</Filters>

         <FilterTolerance>0</FilterTolerance>

         <FilterPattern/>

         <ReportType>0</ReportType>

         <HighlightType>1</HighlightType>

         <ShowHide>0</ShowHide>

      </Settings>

      <Files>

         <Filename0>C:\Folder\SubFolder\File 1.xls</Filename0>

         <Filename1>C:\Folder\SubFolder\File 2.xls</Filename1>

      </Files>

      <Pairs>

         <MatchInclude>3</MatchInclude>

         <MatchType>0</MatchType>

         <PairCount>3</PairCount>

         <Pair ID="1">

            <SheetName0>Addresses</SheetName0>

            <SheetName1>Addresses</SheetName1>

         </Pair>

         <Pair ID="2">

            <SheetName0>Controlling</SheetName0>

            <SheetName1>Controlling</SheetName1>

            <RangeAddr0>$A$4:$AC$75</RangeAddr0>

            <RangeAddr1>$A$4:$AC$75</RangeAddr1>

            <DBRow>5</DBRow>

            <DBKeys>1</DBKeys>

            <DBOptionsMask>14</DBOptionsMask>

         </Pair>

         <Pair ID="3">

            <SheetName0>Budget</SheetName0>

            <SheetName1>Budget</SheetName1>

         </Pair>

      </Pairs>

   </Project>

</Synkronizer>