Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportUnitAvailabilitiesFromExcelBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationUnitAvailabilitiesForExcelImport
|
{
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputunitavailabilitiestomodel'
|
EDIMLTable IOUnitAvailability
|
{
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
TargetType: IOUnitAvailability
|
TypeIndex: IOUnitAvailabilityTypeIndex
|
EDIMLColumn Allocation { Attribute: Allocation ValueType: Real }
|
EDIMLColumn Efficiency { Attribute: Efficiency ValueType: Real }
|
EDIMLColumn Maintenance { Attribute: Maintenance ValueType: Duration }
|
EDIMLColumn MaximumLoadPercentage { Attribute: MaximumLoadPercentage ValueType: Real }
|
EDIMLColumn MinimumLoadThreshold { Attribute: MinimumLoadThreshold ValueType: Real }
|
EDIMLColumn NrOfUnitsOpen { Attribute: NrOfUnitsOpen ValueType: Number }
|
EDIMLColumn ShiftPatternName { Attribute: ShiftPatternName ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationUnitAvailabilitiesForExcelImport
|
{
|
EDITableTransformation
|
{
|
InputTable: UnitAvailabilities_MP
|
OutputTable: IOUnitAvailability
|
EDIColumnMatch { InputColumn: Allocation OutputColumn: Allocation }
|
EDIColumnMatch { InputColumn: Efficiency OutputColumn: Efficiency }
|
EDIColumnMatch
|
{
|
InputColumn: Maintenance
|
OutputColumn: Maintenance
|
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: MaximumLoadPercentage OutputColumn: MaximumLoadPercentage }
|
EDIColumnMatch { InputColumn: MinimumLoadThreshold OutputColumn: MinimumLoadThreshold }
|
EDIColumnMatch { InputColumn: NrOfUnitsOpen OutputColumn: NrOfUnitsOpen }
|
EDIColumnMatch { InputColumn: ShiftPatternName OutputColumn: ShiftPatternName }
|
EDIColumnMatch
|
{
|
InputColumn: Start
|
OutputColumn: Start
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<DateTimeToDate xmlns="http://www.quintiq.com/GEB/DateTimeToDate" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
</DateTimeToDate>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
}
|
EDIXLSLink.Source MPSync_SourceInputUnitAvailabilitiesForExcelImport
|
{
|
FileName: 'MP_UnitAvailabilities.xlsx'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.inputunitavailabilitiesfromexcel'
|
EDIXLSLinkTable UnitAvailabilities_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn Allocation { ValueType: Real }
|
EDIXLSLinkColumn Maintenance { ValueType: String }
|
EDIXLSLinkColumn MaximumLoadPercentage { ValueType: Real }
|
EDIXLSLinkColumn NrOfUnitsOpen { ValueType: Number }
|
EDIXLSLinkColumn ShiftPatternName { ValueType: String }
|
EDIXLSLinkColumn TimeUnit { ValueType: String }
|
EDIXLSLinkColumn Efficiency { ValueType: Real }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
EDIXLSLinkColumn Start { ValueType: DateTime }
|
EDIXLSLinkColumn MinimumLoadThreshold { ValueType: Real }
|
]
|
}
|
}
|
}
|
