Environment Settings Exporter (EnvironmentSettingsExporter.exe)

The Environment Settings Exporter (EnvironmentSettingsExporter.exe) is a tool that reads a specially formatted Excel spreadsheet in either Excel Binary or Excel SpreadsheetML XML format and exports the configuration settings in the workbook to multiple XML files, one per defined environment (development, test, production, etc.).

The exporter can export to three different XML formats, but the Deployment Framework for BizTalk uses only the first:

XmlPreprocess format
.NET <appSettings> format
WiX include format with a <CustomTable> definition

EnvironmentSettingsExporter <File.xls/x or File.xml> <OutputPath> [/F:<XmlPreprocess/AppSettings/WixCustomTable>]

Arguments

Argument	Description
File.xls/x or File.xml	The path to a configuration settings spreadsheet, either in binary (.xls or .xlsx) or Excel SpreadsheetML XML format. Surround the path in double-quotes if it contains spaces.
OutputPath	The path to a folder that will contain the exported XML files, one for each defined environment and named per the filenames defined in the spreadsheet.
F (Format)	An optional parameter that specifies the output XML format: XmlPreprocess, AppSettings or WixCustomTable. The default, and the only option used by the Deployment Framework for BizTalk, is XmlPreprocess.

Remarks

Newly created Deployment Framework for BizTalk projects contain a default settings spreadsheet in the file EnvironmentSettings\SettingsFileGenerator.xml.