Command: DataFileLoadSel

Display all  Hide all

Command: DataFileLoadSel

Loads selected channels from a data file into the DIAdem Data Portal.

Input Parameters

DataFilename	Specifies the name of a data file with the filename extension and the path. String variable Note  If you do not specify a path, DIAdem uses the NAVIGATOR user path for loading or saving.
FileImportFilter	Specifies which DataPlugin DIAdem uses for loading a data file into the Data Portal. String Access: Read/Write If you do not specify a DataPlugin, DIAdem automatically uses the DataPlugin assigned to the file type. The valid values for this variable vary according to the registered DataPlugin. The following values are valid: Value of the Variables Meaning Filename Extension TDM DIAdem TDM files TDM TDMS DIAdem TDM streaming files TDMS LVM LabVIEW LVM files LVM CSV Comma-separated values CSV DAT DIAdem DAT files DAT Note  To specify the value of the FileImportFilter variable for a file type, enable the Recording mode and open a file with the appropriate filename extension in the Open dialog box. In the script recorded in the script editor, you then receive the value of the variable as a parameter of the DataFileLoad command. Note  Visit the DataPlugin Website to find existing DataPlugins you can download.
ImportSelection	Specifies which data channels to load from a data file. String Access: Read/Write  If you do not assign a value to this variable, DIAdem loads all data channels. You can use the following syntax for the ImportSelection variable: "[GroupIndex]/[ChannelIndex]" Uses indexes to specify which channels to load. The expression "[1]/[2]", for example, loads the second channel of the first channel group. The expression [2]/* loads all channels from the second channel group. The expression [2]/[2,5-8] loads channel 2 and the channels 5 to 8 of the second channel group. "Identifier" Uses a condition to specify which channels to load. Use a question mark (?) as a wildcard for one character, and an asterisk (*) as a wildcard for any number of characters. The expression "Example/D*", for example, specifies that DIAdem loads all channels with names starting with the letter D from the Example channel group. If the conditions do not meet the name conventions for channels, DIAdem replaces the invalid characters with valid characters. If you use the wildcard * for a channel group, DIAdem creates a new channel group in the Data Portal. If you enter channel numbers, DIAdem appends the selected channels to the default group in the Data Portal. Note  Use the vertical separator |, to load channels from several channel groups, for example, Call DataFileLoadSel("Example.tdm","TDM","[1]/[2]|[2]/[4]|[3]/[5]","Load").
[ImportParameterSet]	Specifies how DIAdem imports data into the Data Portal. Use the ImportParameter object for the ImportParameterSet parameter. You can also use one of the following script terms as an alternative. If the script term contains "|ChnXYRelation", DIAdem maintains the reference to the x-channel for xy-channels. Variant Script Term Interface Term, Explanation "Load" Load "Load|ChnXYRelation" Load with x-channel reference "Register" Register "Register|ChnXYRelation" Login with x-channel reference "Append" Append "Append|ChnXYRelation" Append with x-channel reference "LoadImmediately" Always load bulk data "LoadImmediately|ChnXYRelation" Always load bulk data with x-channel reference "LoadOnFirstAccess" Load bulk data on first access "LoadOnFirstAccess|ChnXYRelation" Load bulk data with x-channel reference on first access "LoadOnWriteAccess" Load bulk data when writing channel data "LoadOnWriteAccess|ChnXYRelation" Load bulk data with x-channel reference when writing channel data

Return Parameters

Note  If you are using the ImportParameter object for the ImportParameterSet variable, the DataFileLoadSel command supports the following properties: ImportMode, BulkDataLoadingMode, LoadReturnMode, AppendCheckGroupName, PropertyHandling.AutoUpdateChnCharacteristics, PropertyHandling.InheritanceSeparator, PropertyHandling.InheritanceMode, PropertyHandling.NamingSchema, PropertyHandling.NameMappingFile, and PropertyHandling.ValueMappingFile. The command ignores all other properties.

Note  The page Loading Bulk Data - General contains important information on the extended loading behavior of TDM and TDMS files. The Append Data topic describes the behavior of DIAdem when you assign the value Append to the variable ImportParameterSet or when you assign the value eAppend to the ImportParameter object of the ImportMode property. If you want to append data from many files to channels in the Data Portal, you can improve speed by transferring the filenames as a composite text instead of calling the DataFileLoadSel command individually for each file. Separate the individual filenames in the composite text with the "|" character.

Examples

The following example loads the channels with the indexes 2 and 3 from the first group of the C:\Example.tdm file into the Data Portal. The example appends the new channels to the last channel of the default group of the data store in the Data Portal. The example then determines the mean value of all loaded channels:

Dim oMyElementList
Set oMyElementList = DataFileLoadSel("C:\Example.tdm",,"[1]/[2,3]")
Call ChnAverage(oMyElementList, "/Average")

oMyElementList = dd.DataFileLoadSel("C:\\Example.tdm","" ,"[1]/[2,3]") 
dd.ChnAverage(oMyElementList, "/Average") 

The following example uses the TDM loader to register the channels with the indexes 2 and 3 from the first group of the C:\Example.tdm file in the Data Portal. The example appends the new channels to the last channel of the default group of the data store in the Data Portal.

Call DataFileLoadSel("C:\Example.tdm","TDM","[1]/[2,3]","Register")

dd.DataFileLoadSel("C:\\Example.tdm","TDM","[1]/[2,3]","Register") 

The following example loads the second channel of the first, the second, and the third channel group into the Data Portal.

Call DataFileLoadSel(ProgramDrv & "Examples\Data\Report_expl.tdm",,"[1]/[2]|[2]/[2]|[3]/[2]")

dd.DataFileLoadSel(dd.ProgramDrv + "Examples\\Data\\Report_expl.tdm","" ,"[1]/[2]|[2]/[2]|[3]/[2]") 

The following example loads the second and third channel of the first channel group of the data set Example.tdm with the settings made in the oMyImportParameter object in the Data Portal:

Dim oMyImportParameter
Set oMyImportParameter = Navigator.Settings.CreateImportParameter("Load")
oMyImportParameter.BulkDataLoadingMode = eBulkDataLoadingOnFirstAccess
oMyImportParameter.PropertyHandling.AutoUpdateChnCharacteristics = True
oMyImportParameter.PropertyHandling.InheritanceMode = ePropInheritanceCopyToChannelLevel
Call DataFileLoadSel("Example.tdm",, "[1]/[2,3]", oMyImportParameter)

oMyImportParameter = dd.Navigator.Settings.CreateImportParameter("Load") 
oMyImportParameter.BulkDataLoadingMode = dd.eBulkDataLoadingOnFirstAccess 
oMyImportParameter.PropertyHandling.AutoUpdateChnCharacteristics = True 
oMyImportParameter.PropertyHandling.InheritanceMode = dd.ePropInheritanceCopyToChannelLevel 
dd.DataFileLoadSel("Example.tdm","" , "[1]/[2,3]", oMyImportParameter) 

Related Topics

Command: ChnValExpand | Command: DataFileLoad | Command: DataFileLoadRed | Command: DataFileSave | Command: DataFileSaveSel | Command: DataFileSelDlg | Command: FileDlgShow | Command: FileNameGet | Command: PathDlgShow | Commands and Variables for Working with Data | Variable: FileExportFilter | Variable: FileFilter | Variable: FileImportFilter