Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportCampaignsFromExcelBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationCampaignsForExcelImport
|
{
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputcampaignstomodel'
|
EDIMLTable IOCampaignType_MP
|
{
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: UnitID
|
TargetType: IOCampaignType_MP
|
TypeIndex: IOCampaignTypeTypeIndex
|
EDIMLColumn Color { Attribute: Color ValueType: String }
|
EDIMLColumn DefaultMaxDuration { Attribute: DefaultMaxDuration ValueType: Duration }
|
EDIMLColumn DefaultMaxQuantity { Attribute: DefaultMaxQuantity ValueType: Real }
|
EDIMLColumn DefaultMinDuration { Attribute: DefaultMinDuration ValueType: Duration }
|
EDIMLColumn DefaultMinQuantity { Attribute: DefaultMinQuantity ValueType: Real }
|
EDIMLColumn HasInputMaxDuration { Attribute: HasInputMaxDuration ValueType: Boolean }
|
EDIMLColumn HasInputMaxQuantity { Attribute: HasInputMaxQuantity ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable IOCampaign_MP
|
{
|
PrimaryKeyColumns: CampaignID
|
PrimaryKeyColumns: UnitID
|
TargetType: IOCampaign_MP
|
TypeIndex: IOCampaignTypeIndex
|
EDIMLColumn CampaignID { Attribute: CampaignID ValueType: String }
|
EDIMLColumn CampaignTypeName { Attribute: CampaignTypeName ValueType: String }
|
EDIMLColumn Comment { Attribute: Comment ValueType: String }
|
EDIMLColumn Duration { Attribute: Duration ValueType: Duration }
|
EDIMLColumn EarliestStart { Attribute: EarliestStart ValueType: DateTime }
|
EDIMLColumn HasInputMaxDuration { Attribute: HasInputMaxDuration ValueType: Boolean }
|
EDIMLColumn HasInputMaxQuantity { Attribute: HasInputMaxQuantity ValueType: Boolean }
|
EDIMLColumn HasNextTransitionDurationByOpt { Attribute: HasNextTransitionDurationByOpt ValueType: String }
|
EDIMLColumn MaxDuration { Attribute: MaxDuration ValueType: Duration }
|
EDIMLColumn MaxQuantity { Attribute: MaxQuantity ValueType: Real }
|
EDIMLColumn MinDuration { Attribute: MinDuration ValueType: Duration }
|
EDIMLColumn MinQuantity { Attribute: MinQuantity ValueType: Real }
|
EDIMLColumn NextTransitionDurationByOpt { Attribute: NextTransitionDurationByOpt ValueType: Real }
|
EDIMLColumn OptNextCampaignTypeName { Attribute: OptNextCampaignTypeName ValueType: String }
|
EDIMLColumn SequenceNumber { Attribute: SequenceNumber ValueType: Number }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable IOOperationInCampaignType
|
{
|
PrimaryKeyColumns: CampaignTypeName
|
PrimaryKeyColumns: OperationID
|
PrimaryKeyColumns: UnitID
|
TargetType: IOOperationInCampaignType
|
TypeIndex: IOOperationInCampaignTypeTypeIndex
|
EDIMLColumn CampaignTypeName { Attribute: CampaignTypeName ValueType: String }
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable IOOperationInTransitionType
|
{
|
PrimaryKeyColumns: OperationID
|
PrimaryKeyColumns: TransitionTypeName
|
PrimaryKeyColumns: UnitID
|
TargetType: IOOperationInTransitionType
|
TypeIndex: IOOperationInTransitionTypeTypeIndex
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
EDIMLColumn TransitionTypeName { Attribute: TransitionTypeName ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable IOTransitionType_MP
|
{
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: UnitID
|
TargetType: IOTransitionType_MP
|
TypeIndex: IOTransitionTypeTypeIndex
|
EDIMLColumn DefaultMaxDuration { Attribute: DefaultMaxDuration ValueType: Duration }
|
EDIMLColumn DefaultMaxQuantity { Attribute: DefaultMaxQuantity ValueType: Real }
|
EDIMLColumn DefaultMinDuration { Attribute: DefaultMinDuration ValueType: Duration }
|
EDIMLColumn DefaultMinQuantity { Attribute: DefaultMinQuantity ValueType: Real }
|
EDIMLColumn FromCampaignTypeName { Attribute: FromCampaignTypeName ValueType: String }
|
EDIMLColumn HasInputMaxDuration { Attribute: HasInputMaxDuration ValueType: Boolean }
|
EDIMLColumn HasInputMaxQuantity { Attribute: HasInputMaxQuantity ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn ToCampaignTypeName { Attribute: ToCampaignTypeName ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationCampaignsForExcelImport
|
{
|
EDITableTransformation
|
{
|
InputTable: CampaignTypes_MP
|
OutputTable: IOCampaignType_MP
|
EDIColumnMatch { InputColumn: Color OutputColumn: Color }
|
EDIColumnMatch
|
{
|
InputColumn: DefaultMaxDuration
|
OutputColumn: DefaultMaxDuration
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToDuration xmlns="http://www.quintiq.com/GEB/StringToDuration" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<SingularDayString>day</SingularDayString>
|
<PluralDayString>days</PluralDayString>
|
</StringToDuration>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: DefaultMaxQuantity
|
OutputColumn: DefaultMaxQuantity
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToReal xmlns="http://www.quintiq.com/GEB/StringToReal" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToReal>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: DefaultMinDuration
|
OutputColumn: DefaultMinDuration
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToDuration xmlns="http://www.quintiq.com/GEB/StringToDuration" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<SingularDayString>day</SingularDayString>
|
<PluralDayString>days</PluralDayString>
|
</StringToDuration>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: DefaultMinQuantity
|
OutputColumn: DefaultMinQuantity
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToReal xmlns="http://www.quintiq.com/GEB/StringToReal" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToReal>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: HasInputMaxDuration OutputColumn: HasInputMaxDuration }
|
EDIColumnMatch { InputColumn: HasInputMaxQuantity OutputColumn: HasInputMaxQuantity }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: Campaign_MP
|
OutputTable: IOCampaign_MP
|
EDIColumnMatch { InputColumn: CampaignID OutputColumn: CampaignID }
|
EDIColumnMatch { InputColumn: CampaignTypeName OutputColumn: CampaignTypeName }
|
EDIColumnMatch { InputColumn: Comment OutputColumn: Comment }
|
EDIColumnMatch
|
{
|
InputColumn: Duration
|
OutputColumn: Duration
|
}
|
EDIColumnMatch
|
{
|
InputColumn: EarliestStart
|
OutputColumn: EarliestStart
|
}
|
EDIColumnMatch { InputColumn: HasInputMaxDuration OutputColumn: HasInputMaxDuration }
|
EDIColumnMatch { InputColumn: HasInputMaxQuantity OutputColumn: HasInputMaxQuantity }
|
EDIColumnMatch { InputColumn: HasNextTransitionDurationByOpt OutputColumn: HasNextTransitionDurationByOpt }
|
EDIColumnMatch
|
{
|
InputColumn: MaxDuration
|
OutputColumn: MaxDuration
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToDuration xmlns="http://www.quintiq.com/GEB/StringToDuration" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<SingularDayString>day</SingularDayString>
|
<PluralDayString>days</PluralDayString>
|
</StringToDuration>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: MaxQuantity
|
OutputColumn: MaxQuantity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: MinDuration
|
OutputColumn: MinDuration
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToDuration xmlns="http://www.quintiq.com/GEB/StringToDuration" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<SingularDayString>day</SingularDayString>
|
<PluralDayString>days</PluralDayString>
|
</StringToDuration>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: MinQuantity
|
OutputColumn: MinQuantity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: NextTransitionDurationByOpt
|
OutputColumn: NextTransitionDurationByOpt
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToReal xmlns="http://www.quintiq.com/GEB/StringToReal" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToReal>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: OptNextCampaignTypeName OutputColumn: OptNextCampaignTypeName }
|
EDIColumnMatch
|
{
|
InputColumn: SequenceNumber
|
OutputColumn: SequenceNumber
|
}
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationInCampaignTypes_MP
|
OutputTable: IOOperationInCampaignType
|
EDIColumnMatch { InputColumn: CampaignTypeName OutputColumn: CampaignTypeName }
|
EDIColumnMatch { InputColumn: OperationID OutputColumn: OperationID }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationInTransitionTypes_MP
|
OutputTable: IOOperationInTransitionType
|
EDIColumnMatch { InputColumn: OperationID OutputColumn: OperationID }
|
EDIColumnMatch { InputColumn: TransitionTypeName OutputColumn: TransitionTypeName }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: TransitionTypes_MP
|
OutputTable: IOTransitionType_MP
|
EDIColumnMatch
|
{
|
InputColumn: DefaultMaxDuration
|
OutputColumn: DefaultMaxDuration
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToDuration xmlns="http://www.quintiq.com/GEB/StringToDuration" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<SingularDayString>day</SingularDayString>
|
<PluralDayString>days</PluralDayString>
|
</StringToDuration>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: DefaultMaxQuantity
|
OutputColumn: DefaultMaxQuantity
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToReal xmlns="http://www.quintiq.com/GEB/StringToReal" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToReal>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: DefaultMinDuration
|
OutputColumn: DefaultMinDuration
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToDuration xmlns="http://www.quintiq.com/GEB/StringToDuration" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<SingularDayString>day</SingularDayString>
|
<PluralDayString>days</PluralDayString>
|
</StringToDuration>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: DefaultMinQuantity
|
OutputColumn: DefaultMinQuantity
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToReal xmlns="http://www.quintiq.com/GEB/StringToReal" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToReal>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: FromCampaignTypeName OutputColumn: FromCampaignTypeName }
|
EDIColumnMatch { InputColumn: HasInputMaxDuration OutputColumn: HasInputMaxDuration }
|
EDIColumnMatch { InputColumn: HasInputMaxQuantity OutputColumn: HasInputMaxQuantity }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: ToCampaignTypeName OutputColumn: ToCampaignTypeName }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
}
|
EDIXLSLink.Source MPSync_SourceInputCampaignsForExcelImport
|
{
|
FileName: 'MP_Campaigns.xlsx'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.inputcampaignsfromexcel'
|
EDIXLSLinkTable CampaignTypes_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn Color { ValueType: String }
|
EDIXLSLinkColumn DefaultMaxDuration { ValueType: String }
|
EDIXLSLinkColumn DefaultMaxQuantity { ValueType: String }
|
EDIXLSLinkColumn DefaultMinDuration { ValueType: String }
|
EDIXLSLinkColumn DefaultMinQuantity { ValueType: String }
|
EDIXLSLinkColumn HasInputMaxDuration { ValueType: String }
|
EDIXLSLinkColumn HasInputMaxQuantity { ValueType: String }
|
EDIXLSLinkColumn Name { ValueType: String }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable Campaign_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn CampaignID { ValueType: String }
|
EDIXLSLinkColumn CampaignTypeName { ValueType: String }
|
EDIXLSLinkColumn Comment { ValueType: String }
|
EDIXLSLinkColumn Duration { ValueType: Duration }
|
EDIXLSLinkColumn EarliestStart { ValueType: DateTime }
|
EDIXLSLinkColumn HasInputMaxDuration { ValueType: String }
|
EDIXLSLinkColumn HasInputMaxQuantity { ValueType: Boolean }
|
EDIXLSLinkColumn HasNextTransitionDurationByOpt { ValueType: String }
|
EDIXLSLinkColumn MaxDuration { ValueType: String }
|
EDIXLSLinkColumn MaxQuantity { ValueType: Real }
|
EDIXLSLinkColumn MinDuration { ValueType: String }
|
EDIXLSLinkColumn MinQuantity { ValueType: Real }
|
EDIXLSLinkColumn NextTransitionDurationByOpt { ValueType: String }
|
EDIXLSLinkColumn OptNextCampaignTypeName { ValueType: String }
|
EDIXLSLinkColumn SequenceNumber { ValueType: Number }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable OperationInCampaignTypes_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn CampaignTypeName { ValueType: String }
|
EDIXLSLinkColumn OperationID { ValueType: String }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable OperationInTransitionTypes_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn OperationID { ValueType: String }
|
EDIXLSLinkColumn TransitionTypeName { ValueType: String }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable TransitionTypes_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn DefaultMaxDuration { ValueType: String }
|
EDIXLSLinkColumn DefaultMaxQuantity { ValueType: String }
|
EDIXLSLinkColumn DefaultMinDuration { ValueType: String }
|
EDIXLSLinkColumn DefaultMinQuantity { ValueType: String }
|
EDIXLSLinkColumn FromCampaignTypeName { ValueType: String }
|
EDIXLSLinkColumn HasInputMaxDuration { ValueType: String }
|
EDIXLSLinkColumn HasInputMaxQuantity { ValueType: String }
|
EDIXLSLinkColumn Name { ValueType: String }
|
EDIXLSLinkColumn ToCampaignTypeName { ValueType: String }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
]
|
}
|
}
|
}
|
