Quintiq file version 2.0 
 | 
#parent: #root 
 | 
Method ImportExcels ( 
 | 
  LibSOPImpExp_UserInputs userInput_i, 
 | 
  ScenarioManager scenarioManager_i, 
 | 
  MPSync mpsync, 
 | 
  BinaryValues mpBinaryValues_i, 
 | 
  Strings mpBrokers_i 
 | 
) 
 | 
{ 
 | 
  Description: 'Import from Excel, used by web app.' 
 | 
  TextBody: 
 | 
  [* 
 | 
    // @userInput_i - Array of data group that user imports 
 | 
    // @mpBinaryValues_i - Array of uploaded Excels in binary value. Binary at position x matches @mpBrokers_i at same position 
 | 
    // @mpBrokers_i - Array of uploaded Excels' broker name 
 | 
     
 | 
    is3DDrive := false; 
 | 
     
 | 
    // Check if each data group has files uploaded by user for import 
 | 
    this.Synchronize( LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_SupplyChainParameters() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_GlobalParameters() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_Periods() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MP_Functionality_InventorySpecifications() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MP_Functionality_InventorySupplies() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_Products() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_Forecasts() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_ServiceLevels() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_Campaigns() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_Entities() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_Costs() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_Lanes() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_Routings() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_Capacities() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MP_Functionality_SupplySpecifications() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_Recipes() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MP_Designer_Actuals() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MP_GlobalParameters_KPIFeedbackName() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_OptimizerPuzzles() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_PostponementSpecAndFulfillmentRestriction() ), 
 | 
                      LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_CustomerOrder() ), 
 | 
                      false, /* isImportBinary */ 
 | 
                      mpBinaryValues_i.Copy(), 
 | 
                      mpBrokers_i, 
 | 
                      is3DDrive, 
 | 
                      construct( FileItems ), /* 3ddrive, ignore */ 
 | 
                      construct( Strings ) /* 3ddrive, ignore */ ); 
 | 
     
 | 
    scenarioManager_i.Import( LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_Strategies() ), 
 | 
                              LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_Accounts() ), 
 | 
                              LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_Bookmarks() ), 
 | 
                              LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_KPISetting() ), 
 | 
                              mpBinaryValues_i.Copy(),  
 | 
                              mpBrokers_i,  
 | 
                              is3DDrive,  
 | 
                              construct( FileItems ), /* 3ddrive, ignore */  
 | 
                              construct( Strings ) /* 3ddrive, ignore */ ); 
 | 
     
 | 
    mpsync.Import( LibSOPImpExp_ExportExcel::IsDataSourceIncluded( userInput_i, Translations::MPSync_ObjectGroup_ImportProfiles() ), 
 | 
                   mpBinaryValues_i.Copy(), mpBrokers_i, is3DDrive, construct( FileItems), construct( Strings ) ); 
 | 
  *] 
 | 
} 
 |