Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportDetailedScheduleFromExcelBroker
|
{
|
MDSDefinition: MPSync
|
TimeZone: 'ACT'
|
UseOSTimeZone: false
|
EDIModelLink.Destination MPSync_DestinationScheduledWorkOrdersForExcelImport
|
{
|
EDIMLTable IODetailedSchedule
|
{
|
PrimaryKeyColumns: ID
|
TargetType: IODetailedSchedule
|
TypeIndex: IOScheduledWorkOrderTypeIndex
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn Quantity { Attribute: Quantity ValueType: Real }
|
EDIMLColumn ResourceID { Attribute: ResourceID ValueType: String }
|
EDIMLColumn RoutingID { Attribute: RoutingID ValueType: String }
|
EDIMLColumn RoutingStepSeqNr { Attribute: RoutingStepSeqNr ValueType: Number }
|
EDIMLColumn ScheduledEnd { Attribute: ScheduledEnd ValueType: DateTime }
|
EDIMLColumn ScheduledStart { Attribute: ScheduledStart ValueType: DateTime }
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationScheduledWorkOrdersForExcelImport
|
{
|
EDITableTransformation
|
{
|
InputTable: Operation
|
OutputTable: IODetailedSchedule
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: Quantity OutputColumn: Quantity }
|
EDIColumnMatch { InputColumn: ResourceID OutputColumn: ResourceID }
|
EDIColumnMatch { InputColumn: RoutingID OutputColumn: RoutingID }
|
EDIColumnMatch
|
{
|
InputColumn: RoutingStepSequenceNr
|
OutputColumn: RoutingStepSeqNr
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" 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>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: ScheduledEnd OutputColumn: ScheduledEnd }
|
EDIColumnMatch { InputColumn: ScheduledStart OutputColumn: ScheduledStart }
|
}
|
}
|
EDIXLSLink.Source MPSync_SourceScheduledWorkOrdersForExcelImport
|
{
|
FileName: 'DetailedSchedule.xlsx'
|
EDIXLSLinkTable Operation
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn RoutingID { ValueType: String }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn ScheduledStart { ValueType: DateTime }
|
EDIXLSLinkColumn ScheduledEnd { ValueType: DateTime }
|
EDIXLSLinkColumn ResourceID { ValueType: String }
|
EDIXLSLinkColumn Quantity { ValueType: Real }
|
EDIXLSLinkColumn RoutingStepSequenceNr { ValueType: String }
|
]
|
}
|
}
|
}
|
