<< Click to Display Table of Contents >> FileFormat Project |
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.
Prepare your project using the Synkronizer tab, 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 with pairs of individual settings the file will look like this:
(MatchType will be set to 0 as soon as you select 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>