Origin 8.5.1 Import Export

From OriginLab Wiki

Jump to: navigation, search

Contents


Back to main page...

[edit] SQL Editor for Database Import

When importing from a database, users can select from two import dialog options: Open Sql Editor, or Open Query Builder.

On the File menu, select Database Import, and then click New. This will open a dialog box from which you can choose an import dialog option.

Image:DBMessage.png

Alternatively, click the Open Sql Editor or the Open Query Builder button on the Database Access toolbar.

Image:New_SQL_editor_toolbar_button.png

Selecting Query Builder opens a dialog box in which users can generate a SQL query using a graphical user interface (GUI).

Selecting SQL Editor opens a dialog box in which users can type or paste in a SQL string. This option is intended for advanced users who prefer to work within the SQL environment.

  • The SQL Editor supports syntax coloring and LabTalk substitution.

Image:SQL_editor_dialog.png

  • LabTalk variables can be initialized using the Before Query Script dialog box. Click the Preview button on the Database Access toolbar to test LabTalk substitutions before importing.

Image:SQL_editor_dialog_LT_preview.jpg

  • Create workbook templates containing simple scripts for modifying query conditions. The script in the example below changes the workbook’s long name in order to import data from multiple countries.

Image:SQL_editor_Before_query_dialog.jpg

Combining scripts, pivot table features, and embedded graphs, templates can be completely self-contained and easily reused.

Back to main page...

[edit] Graph Export

[edit] Transparency Support for PDF and EPS

As there is no native support for transparency in Encapsulated PostScript (EPS), EPS output contains raster elements when graphs contain elements with transparency.

  • By default, raster elements are compressed to minimize file size. To turn off this default, clear the Raster Compression check box under EPS Options in the Import and Export dialog box.
  • To turn off transparency in EPS, select Draw as Opaque in the Semi-transparent Regions group under EPS Options.

Portable Document Format (PDF) has better support for transparency, and in PDF export Origin provides a compression option which enables the creation of more compact files.

Back to main page...

[edit] Data Import

Origin can import the following third-party file types:

  • TDMS (LabView 2009)
  • Graphpad Prism
  • MZXML

ASCII Import:

  • ASCII files are always imported using the System Default dialog theme unless a user-defined theme has been saved to the worksheet or selected from the Dialog Theme menu. Expand Import Options to define a new dialog theme.
  • Use the Add Sparklines menu under Import Options to show or hide thumbnails after importing.

Import Wizard:

  • The import wizard supports custom time formats. Custom Time Format options are available in the Data Columns dialog box of the Import Wizard.
  • In the Import Wizard, under Advanced Options, select Run script after each file imported to run a LabTalk script at the end of each import. Select Run script after all files imported to run a LabTalk script after all files have completed importing.
Image:ImportWizardAdvanced.png
  • The Import Filter Manager includes a Drag&Drop Exclusion column. This column specifies which file extensions are to be excluded when using Drag and Drop. This can be useful when a filter format supports multiple file types and you want to exclude some file types but include others.
Image:DragDropExclude.png

Back to main page...