Data Importing Formats: Difference between revisions
Jump to navigation
Jump to search
imported>Scott No edit summary |
imported>Scott No edit summary |
||
| Line 1: | Line 1: | ||
Data can be imported into PLS_Toolbox or Solo from a variety of sources using '''File>Import Data''' (or similar) menu itesm in the [[Workspace Browser]], [[Analysis GUI|Analysis]], and [[DataSet Editor]] windows. | Data can be imported into PLS_Toolbox or Solo from a variety of sources using '''File>Import Data''' (or similar) menu itesm in the [[Workspace Browser]], [[Analysis GUI|Analysis]], and [[DataSet Editor]] windows. | ||
== Unsupported File Formats == | |||
'''Note''': If you do not see the file type list below try the following: | '''Note''': If you do not see the file type list below try the following: | ||
# Export your data to a supported file type. Often this is delimited text, Excel, or SPC. | # Export your data to a supported file type. Often this is delimited text, Excel, or SPC. | ||
| Line 6: | Line 6: | ||
# Obtain a file format (specification) from the vendor. We're always happy to develop (or help develop) file importers. | # Obtain a file format (specification) from the vendor. We're always happy to develop (or help develop) file importers. | ||
== Common Formats == | |||
* Workspace/MAT file - ''see [[WorkspaceBrowser_ImportingData#To_import_a_.mat_file|Importing .mat Files]]'' | * Workspace/MAT file - ''see [[WorkspaceBrowser_ImportingData#To_import_a_.mat_file|Importing .mat Files]]'' | ||
* [[xclreadr|Delimited Text File (CSV,TXT)]] - ''see [[Text Import Settings]]'' | * [[xclreadr|Delimited Text File (CSV,TXT)]] - ''see [[Text Import Settings]]'' | ||
| Line 15: | Line 14: | ||
* Text from Clipboard (CSV,TXT,XML) | * Text from Clipboard (CSV,TXT,XML) | ||
* Extensible Markup Language (XML) - ''see [[DataSet XML Format]]'' | * Extensible Markup Language (XML) - ''see [[DataSet XML Format]]'' | ||
== Commercial Formats == | |||
* [[mtfreadr|AdventaCT MTF File (MTF)]] | * [[mtfreadr|AdventaCT MTF File (MTF)]] | ||
* [[asfreadr|AIT ASF File (ASF, AIF, BKH)]] | * [[asfreadr|AIT ASF File (ASF, AIF, BKH)]] | ||
| Line 34: | Line 33: | ||
Additional import methods may be available depending on the specific purchased options and the distributor of your copy of PLS_Toolbox or Solo. See other notes below. | Additional import methods may be available depending on the specific purchased options and the distributor of your copy of PLS_Toolbox or Solo. See other notes below. | ||
==Notes== | |||
* Our image processing products MIA_Toolbox and Solo+MIA include additional image-specifc importers. See [[Image_Importing_Formats]] and [[Constructing_Image_DataSets]] for more information. | * Our image processing products MIA_Toolbox and Solo+MIA include additional image-specifc importers. See [[Image_Importing_Formats]] and [[Constructing_Image_DataSets]] for more information. | ||
Revision as of 14:00, 1 July 2015
Data can be imported into PLS_Toolbox or Solo from a variety of sources using File>Import Data (or similar) menu itesm in the Workspace Browser, Analysis, and DataSet Editor windows.
Unsupported File Formats
Note: If you do not see the file type list below try the following:
- Export your data to a supported file type. Often this is delimited text, Excel, or SPC.
- Locate a community developed importer on the Matlab file exchange.
- Obtain a file format (specification) from the vendor. We're always happy to develop (or help develop) file importers.
Common Formats
- Workspace/MAT file - see Importing .mat Files
- Delimited Text File (CSV,TXT) - see Text Import Settings
- XY... Delimited Text Files (TXT,XY) - see Text Import Settings
- Excel File (XLS,XLSX,CSV,TXT)
- Experiment File (EXP,CSV,XLS,TXT)
- Text from Clipboard (CSV,TXT,XML)
- Extensible Markup Language (XML) - see DataSet XML Format
Commercial Formats
- AdventaCT MTF File (MTF)
- AIT ASF File (ASF, AIF, BKH)
- AIT PIONIR File (PDF)
- Analytical Spectral Devices (ASD) Indico (V6 and V7)
- Bruker OPUS
- Bruker XRPD (RAW)
- Grams Thermo Galactic File (SPC, DHB)
- Guided Wave File (SCAN, AUTOSCAN)
- Horiba JY Raman File (NGS, NGC)
- Horiba JY Aqualog ASCII File (DAT)
- JCAMP (DX,JDX)
- Omnic SPA File (SPA)
- PerkinElmer (FSM, SP, VIS, IMP)
- Stellarnet ABS File (ABS)
- Other... - Call Matlab importer.
Additional import methods may be available depending on the specific purchased options and the distributor of your copy of PLS_Toolbox or Solo. See other notes below.
Notes
- Our image processing products MIA_Toolbox and Solo+MIA include additional image-specifc importers. See Image_Importing_Formats and Constructing_Image_DataSets for more information.
- The Delimited Text File format provides a flexible way to import lots of different text file formats. For details on the format and the options available, see: Text Import Settings
- The Experiment File import method is used to import multiple data files at once along with corresponding reference values. For more information on the Experiment File format and features, see the reference page for experimentreadr.
- PLS_Toolbox users can access the importers through the autoimport command or the file import functions directly.
- In some cases you may have to use the DataSet Editor to add additional information to your dataset. For instance, you may add labels and or axis scales after you've imported the raw data. See Key_GUIs for more information on using the DataSet Editor.
- In cases involving n-way (multidimensional) data you man need to "build up" you dataset. More information about how to do that can be found here.
AutoImport Keywords
The following table lists keywords (aka method names) that can be used to import the corresponding file types when using Solo Scripting import commands or when using the autoimport PLS_Toolbox function.
| Keyword | File Type |
|---|---|
| workspace | Workspace/MAT file |
| text | Delimited Text File (CSV,TXT) |
| xy | XY... Delimited Text Files (TXT,XY) |
| excel | Excel File (XLS,XLSX,CSV,TXT) |
| experimentreadr | Experiment File (EXP,CSV,XLS,TXT) |
| clipboard | Text from Clipboard (CSV,TXT,XML) |
| xml | XML file (XML) |
| ------ | -------------------------------- |
| editds_mtfimport | AdventaCT MTF File (MTF) |
| asf | AIT ASF File (ASF, AIF, BKH) |
| pdfreadr | AIT PIONIR File (PDF) |
| asdreadr | Analytical Spectral Devices (ASD) Indico (V6 and V7) |
| opusreadr | Bruker OPUS File |
| brukerxrpdreadr | Bruker XRPD File (RAW) |
| spc | Grams Thermo Galactic File (SPC, DHB) |
| gwscanreadr | Guided Wave File (SCAN, AUTOSCAN) |
| hjyreadr | Horiba JY Raman File (NGS, NGC) |
| aqualogreadr | Horiba JY Aqualog File (DAT) |
| jcamp | JCAMP (DX,JDX,JCAMP) |
| spareadr | Omnic SPA File (SPA) |
| pereadr | PerkinElmer File (FSM, SP, VIS) |
| snabsreadr | Stellarnet ABS File (ABS) |
| ------ | -------------------------------- |
| camecard | Cameca Ion-Tof BIF/BIF6 Image (BIF,BIF6) |
| opotekenvirdr | ENVI Image Format (HDR) |
| lispixrawreadr | Lispix Raw Formatted Image (RAW) |
| opotektiffrdr | Multi-layer TIFF files (TIFF) |
| rawread | Physical Electronics RAW Image (RAW) |
| img | Image (Workspace/MAT file) |
| imgother | Image standard (JPG, TIFF, GIF, BMP, PNG) |