ScenarioImporter

• Getting the day, month and year from planningdate
• Change the name of the import button ImporterButtonUIName
• JoinWithExternalDB
• ConsolidationDemandLimit
• Name of the column to update when finishing orders ConsolidationUpdateOrdersOriginalOrderIdField
• Splitting the input file data according to the specified ScenarioSplitterColumnName parameter
• Defining the input file Delimiter
• Completing a non-existing document header - HeaderLine
• Not overwriting values when finishing orders - DoNotModify
• Deleting rows - LineNumbersForDeletion
• Replacing a mark in a column - ColumnsReplace
• Linking columns ColumnsConcatenate
• Add column ColumnsAdd
• Delete row RowsDelete
• Combining the contents of dynamic columns DynamicStringColumnsForConsolidation
• AfterConsolidationColumnsCalculated
• ColumnsCalculated
• ColumnsHeader
• NotTypeConvertedDynamicColumns
• Structure of ScenarioImporter when importing from xml
• Common mistakes and their solutions
• Automatically recognized column names
• Renaming a column - ColumnsRename
• SqlTransformCommandText

Config for importing data from different sources. Within the data loading it is possible to modify the input data. More detailed description in subsections.

Supported data formats: csv, txt, xls(x), xml, dbf

Settings name	Description	Basic value	Value type	Example of value
ImporterButtonUIName	Description of the button that appears in the top menu (group Imports)	empty string	string	Kate's importer
JoinWithExternalDB	Connection to the distribution database	false	bool	false
ExternalDBPath	Defines the path to the external database	empty string	string	C:\\DB
AllowAutoIdCreation	Enables automatic creation of id value (1....XX) - only in development version	false	bool	true
AllowConsolidation	Enable order merging for one customer	false	bool	false
AllowInfosConsolidationDuplicity	description	false	bool	false
AllowDynamicColumnsConsolidationDuplicity	description	false	bool	false
ConsolidationDemandLimit	Determines the maximum amount of demand for consolidated jobs	empty string	string	500
ConsolidationUpdateOrdersOriginalOrderIdField	Column name to update when finishing orders	empty string	string	originalId
DemandLimit	Job size limit	empty string	string	600
GeocodeWhenAddingJobs	Starting geocoding while finishing a job	true	string	false
ImportEncodingCodePage	Text encoding settings	1250	int	1250
ExternalDBEncodingCodePage	Text encoding settings	1250	int	1250
GeocodeWhenAddingJobs	Always starts geocoding after import. Normally, geocoding is not triggered when adding an import.	false	bool	false
MergeLocationsWithSameAddress	Combine locations with the same GPS values into one location	false	bool	false
ScenarioSplitterColumnName	Splitting the input file data according to the specified parameter	empty string	string	planningdate
Delimiter	Specifies the delimiter by which the input data is divided into columns	<![CDATA[ ]] >	string	<![CDATA[;]] >
TextQualifier	Marker in text in input data	"	string
NotTypeConvertedDynamicColumns	description	empty string	List<string>	xxx
HeaderLine	Defining the header of a headerless import file	empty string	string	id;name;info1
AddPlanningDateToDynamicColumns	description	false	bool	false
DoNotModifyMasterScenarioPlanning	The delivery date from the main scenario does not change when adding an import.	false	bool	false
DoNotModifyAddressWhenAddingJobsToExistingScenario	The address does not change when the import is added.	false	bool	false
DoNotModifyCoordinatesWhenAddingJobsToExistingScenario	The GPS does not change when the import is added.	false	bool	false
DoNotModifyDynamicColumnsWhenAddingJobsToExistingScenario	Dynamic columns do not change when importing.	false	bool	false
DoNotModifyDemand1WhenAddingJobsToExistingScenario	Demand1 does not change when the import is added.	false	bool	false
DoNotModifyDemand2WhenAddingJobsToExistingScenario	Demand2 does not change when the import is added.	false	bool	false
DoNotModifyDemand3WhenAddingJobsToExistingScenario	Demand3 does not change when the import is added.	false	bool	false
DoNotModifyDemand4WhenAddingJobsToExistingScenario	Demand4 does not change when the import is added.	false	bool	false
DoNotModifyDemand5WhenAddingJobsToExistingScenario	Demand5 does not change when the import is added.	false	bool	false
DoNotModifyInfo1WhenAddingJobsToExistingScenario	Note1 does not change when the import is added.	false	bool	false
DoNotModifyInfo2WhenAddingJobsToExistingScenario	Note2 does not change when the import is added.	false	bool	false
DoNotModifyInfo3WhenAddingJobsToExistingScenario	Note3 does not change when the import is added.	false	bool	false
DoNotModifyInfo1WhenReconsolidateJobs	Note1 in job is overwritten by note1 from order when order is split into job	false	bool	true
DoNotModifyInfo2WhenReconsolidateJobs	Note2 in job is overwritten by note2 from order when order is split into job	false	bool	false
DoNotModifyInfo3WhenReconsolidateJobs	Note3 in job is overwritten by note3 from order when order is split into job	false	bool	false
DoNotModifyNotServedPenaltyWhenAddingJobsToExistingScenario	The price for not serving does not change when the import is added.	false	bool	false
DoNotModifySpecialCodesWhenAddingJobsToExistingScenario	Special marks do not change when the import is added.	false	bool	false
DoNotModifyTimeWindowsWhenAddingJobsToExistedScenario	Time windows do not change when the import is added.	false	bool	false
LineNumbersForDeletion	Deletes x first rows of the document	empty string	List<int>	5
GlobalCharReplace	description	empty string	List<string>	false
GlobalReplace	description	empty string	List<string>	false
ColumnsHeader	description	empty string	List<string>	false
ColumnsReplace	Replacing a character in a column	empty string	List<string>	dynamic;typ;#;
ColumnsRename	Renaming the column name	empty string	List<string>	zakaznik;nazev
ColumnsConcatenate	description	empty string	List<string>	false
SqlTransformCommandText	SQL querry	empty string	List<string>
ColumnsCalculated	description	empty string	List<string>	false
ColumnsAdd	description	empty string	List<string>	false
ColumnsDelete	description	empty string	List<string>	false
RowsDelete	description	empty string	List<string>	false
DynamicStringColumnsForConsolidation	Combining the contents of dynamic columns	empty string	List<string>	id_objednávky
AfterConsolidationColumnsCalculated	description	empty string	List<string>	false
DynamicColumnsDeleteAtTheEnd	description	empty string	List<string>	false
ReconstructSolution	description	false	bool	true
JobSolutionVehicle	description	empty string	string	false
JobSolutionLeg	description	empty string	string	false
JobSolutionOrder	description	empty string	string	false
VehicleSolutionVehicle	description	empty string	string	false
OptimalizeRoutesAfterReconstruct	description	false	bool	true
MultiJob	description