Quintiq file version 2.0
|
#parent: #root
|
Method ImportFromXLS (String brokerID_i, String dataTransformationID_i, Boolean doSynchronize_i) as Boolean id:Method_LibDIF_GlobalState_ImportFromXLS
|
{
|
#keys: '[146730.0.583908152]'
|
Body:
|
[*
|
// Import data from XLS.
|
success := false;
|
|
// Ask the user for the filename.
|
filename := Application.GetOpenFileName( "xlsx" );
|
|
if( filename <> "" )
|
{
|
// Make sure that the Integration-dataset is selected.
|
if( this.EnsureIntegrationDataset() )
|
{
|
// Convert the BinaryData to a BinaryValue so it can be passed to the Server.
|
xlsData := Application.ReadBinaryFile( filename ).AsBinaryValue();
|
|
// Call the import broker to import the data as integration objects.
|
// Synchronize the data if applicable.
|
api := this.GetIntegrationAPI();
|
if( not isnull( api ) )
|
{
|
if( doSynchronize_i )
|
{
|
api.ImportFromXLSAndSynchronize( xlsData, brokerID_i, dataTransformationID_i );
|
}
|
else
|
{
|
api.ImportFromXLS( xlsData, brokerID_i, dataTransformationID_i );
|
}
|
|
success := true;
|
}
|
}
|
}
|
|
return success;
|
*]
|
}
|
