Difference between revisions of "Importing Data"

From Eigenvector Research Documentation Wiki
Jump to navigation Jump to search
imported>Jeremy
imported>Jeremy
Line 1: Line 1:
 
In addition to the Matlab functions to read various file types, PLS_Toolbox provides various functions for reading common data formats into DataSet Objects. Also see the [[editds|DataSet Editor]].
 
In addition to the Matlab functions to read various file types, PLS_Toolbox provides various functions for reading common data formats into DataSet Objects. Also see the [[editds|DataSet Editor]].
+
 
+
===High-Level File and Source Readers===
 
:[[areadr]] - Reads ascii data and strips header.
 
:[[areadr]] - Reads ascii data and strips header.
 
:[[autoimport]] - Automatically reads specified file. Handles all standard filetypes.
 
:[[autoimport]] - Automatically reads specified file. Handles all standard filetypes.
 
:[[asfreadr]] - Reads Hamilton Sundstrand ASF files.
 
:[[asfreadr]] - Reads Hamilton Sundstrand ASF files.
 +
:[[getpidata]] - Uses the current PI connection to construct a DSO from 'taglist'.
 
:[[mtfreadr]] - Read AdventaCT Multi-Trace Format (MTF) files.
 
:[[mtfreadr]] - Read AdventaCT Multi-Trace Format (MTF) files.
 
:[[parsexml]] - Convert XML file to a MATLAB structure.
 
:[[parsexml]] - Convert XML file to a MATLAB structure.
 +
:[[querydb]] - Executes a query on a database defined by connection string.
 
:[[spcreadr]] - Reads a Galactic SPC file.
 
:[[spcreadr]] - Reads a Galactic SPC file.
 
:[[xclgetdata]] - Extracts matrix from an Excel spreadsheet.
 
:[[xclgetdata]] - Extracts matrix from an Excel spreadsheet.
Line 14: Line 16:
 
:[[xyreadr]]  - Reads one or more ASCII XY or XY... files into a DataSet object.
 
:[[xyreadr]]  - Reads one or more ASCII XY or XY... files into a DataSet object.
 
   
 
   
+
===Other Reading and Writing Utilities===
 
:[[lddlgpls]] - Dialog to load variable from workspace or MAT file.
 
:[[lddlgpls]] - Dialog to load variable from workspace or MAT file.
 
:[[svdlgpls]] - Dialog to save variable to workspace or MAT file.
 
:[[svdlgpls]] - Dialog to save variable to workspace or MAT file.
 
:[[builddbstr]] - Builds a database connection string.
 
:[[builddbstr]] - Builds a database connection string.
:[[querydb]] - Executes a query on a database defined by connection string.
 
:[[getpidata]] - Uses the current PI connection to construct a DSO from 'taglist'.
 
 
:[[parsemixed]] - Parse numerical and text data into a DataSet Object.
 
:[[parsemixed]] - Parse numerical and text data into a DataSet Object.
 
:[[writecsv]] - Export a DataSet object to a comma-separated values (CSV) file.
 
:[[writecsv]] - Export a DataSet object to a comma-separated values (CSV) file.
 
   
 
   
 
(Sub topic of [[Import_View_Data|Import_View_Data]])
 
(Sub topic of [[Import_View_Data|Import_View_Data]])

Revision as of 18:05, 3 September 2008

In addition to the Matlab functions to read various file types, PLS_Toolbox provides various functions for reading common data formats into DataSet Objects. Also see the DataSet Editor.

High-Level File and Source Readers

areadr - Reads ascii data and strips header.
autoimport - Automatically reads specified file. Handles all standard filetypes.
asfreadr - Reads Hamilton Sundstrand ASF files.
getpidata - Uses the current PI connection to construct a DSO from 'taglist'.
mtfreadr - Read AdventaCT Multi-Trace Format (MTF) files.
parsexml - Convert XML file to a MATLAB structure.
querydb - Executes a query on a database defined by connection string.
spcreadr - Reads a Galactic SPC file.
xclgetdata - Extracts matrix from an Excel spreadsheet.
xclputdata - Write matrix to an Excel spreadsheet.
xclreadr - Reads an ASCII or .XLS file in as a DataSet Object.
xlsreadr - Reads .XLS files from MS Excel and other spreadsheets.
xyreadr - Reads one or more ASCII XY or XY... files into a DataSet object.

Other Reading and Writing Utilities

lddlgpls - Dialog to load variable from workspace or MAT file.
svdlgpls - Dialog to save variable to workspace or MAT file.
builddbstr - Builds a database connection string.
parsemixed - Parse numerical and text data into a DataSet Object.
writecsv - Export a DataSet object to a comma-separated values (CSV) file.

(Sub topic of Import_View_Data)