Quintiq file version 2.0
#parent: #root
Method ImportDataFromExcel () as Boolean id:Method_DialogImport_ImportDataFromExcel
{
  #keys: '[136682.0.2008489111]'
  Body:
  [*
    // Import data from excel
    // UserData is set by text box responses depending on whether there is a user-specified path.
    importpath := EditFieldExcelPath.Text();
    
    binaryvalues := construct( BinaryValues );
    broker := construct( Strings );
    smbinaryvalues := construct ( BinaryValues );
    smbrokers := construct( Strings );
    fileNames := construct( Strings );
    smFileNames := construct( Strings );
    
    isbinary := importpath <>'';
    //format path to correct format
    //F.FormatPath( importpath );
    
    is3DDrive := RadioButtonGroupSource.BoundValue() = MPSyncUtility::ID_Source_3DDrive();
    missingFiles := construct( Strings );
    if( is3DDrive or importpath <> '' )
    {
      Form.ImportFiles( importpath, binaryvalues, broker, smbinaryvalues, smbrokers, fileNames, smFileNames, missingFiles );
    }
    
    canimport := missingFiles.Size()=0;
    
    
    if ( canimport /*and guard( binaryvalues.Size() >0, false )*/ )
    {
      // call synchronize
      MacroPlan.Synchronize( Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_SupplyChainParameters() ),   // general
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_GlobalParameters() ),        // globalparameters
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_Periods() ),                 // periods
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_InventorySpecifications() ), // inventoryspecifications
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_InventorySupplies() ),       // inventorysupplies
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_Products() ),                // products and disaggregation factor
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_Forecast() ),             // salesdemands
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_ServiceLevels() ),           // servicelevels
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_Campaigns() ),               // campaigns and transition types
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_Entities() ),                // entities
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_Costs() ),                   // entitiescosts
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_Lanes() ),                   // lanes
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_Routings() ),                // routings
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_Capacities() ),              // stockingpointcapacities and unitcapacities
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_SupplySpecifications() ),    // supplyspecifications
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_Recipes() ),                 // recipes
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_Actuals() ),                 // actuals pispip and actual unit periods
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_Feedback() ),                // feedbacks
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_OptimizerPuzzle() ),         // optimizer puzzles
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_PostponementSpecAndFulfillmentRestriction() ), //Postponement spec and fulfillment restriction
                             Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_CustomerOrder() ),           // customer order
                             isbinary,
                             binaryvalues,
                             broker,
                             is3DDrive,
                             DataHolderFileItems.Data(),
                             fileNames
                           );  
    }
    
    if ( canimport and guard( smbinaryvalues.Size() >0, false ) )
    {
        ScenarioManager.Import( Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_Strategies() ), // strategies
                                Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_Accounts() ),   // accounts
                                Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_Bookmarks() ),  // bookmarks
                                Form.GetIsIncluded(MPSyncUtility::ID_ObjectGroup_KPISetting() ), // kpi settings
                                smbinaryvalues.Copy(), smbrokers, is3DDrive, DataHolderFileItems.Data(), smFileNames );
    
        MPSync.Import( Form.GetIsIncluded( MPSyncUtility::ID_ObjectGroup_ImportProfiles() ),
                       smbinaryvalues, smbrokers, is3DDrive, DataHolderFileItems.Data(), smFileNames ); 
    }
    
    if ( not canimport )
    {   
        WebMessageBox::Information( Translations::MP_Import_MissingFiles( missingFiles.ToString( ', ' ) ) );
    }                                 
                                                                                 
    
    return canimport;
  *]
}