Origin 8.5.1 Import Export
From OriginLab Wiki
|Revision as of 18:33, 31 January 2011 (edit)
Easwar (Talk | contribs)
(→Data Import Improvements)
← Previous diff
|Revision as of 17:54, 4 February 2011 (edit) (undo)
Greg (Talk | contribs)
m (→SQL Editor for Database Import)
Next diff →
|Line 18:||Line 18:|
|<li> The new SQL editor supports syntax coloring and LabTalk substitution</li>||<li> The new SQL editor supports syntax coloring and LabTalk substitution</li>|
|-||<li> LabTalk variables can be ||+||<li> LabTalk variables can be '''Before Query Script''' and Preview button is available to allow :</li>|
|-||<li> Workbook templates can be made to allow ||+||<li> Workbook templates can be made to allow simple script to conditions. In this example, user can simply change the book's long name and import data from different countries.</li>|
|-||+||with pivot table features and embedded graphs in the book, the template can be completely self-contained and easily .|
|[[:Category:Origin_8.5.1|Back to main page...]]||[[:Category:Origin_8.5.1|Back to main page...]]|
|==Graph Export Improvements==||==Graph Export Improvements==|
|===Transparency Support for PDF and EPS===||===Transparency Support for PDF and EPS===|
Revision as of 17:54, 4 February 2011
SQL Editor for Database Import
When importing from a database, user now can select from two import dialogs:
Then 2nd radio for Query Builder will open the dialog that existed in previous versions where user can graphically create a query.
The 1st radio option opens a new dialog where user can simply type or paste in the SQL string. This dialog is designed for advanced users who know some SQL and prefer to directly work in that environment.
- Separate buttons are available now for both the new and the old dialog
- The new SQL editor supports syntax coloring and LabTalk substitution
- LabTalk variables can be initialized in Before Query Script and a Preview button is available to allow verify substitution in the SQL Query:
- Workbook templates can be made to allow simple script to modify query conditions. In this example, user can simply change the book's long name and import data from different countries.
Combined with pivot table features and embedded graphs in the book, the template can be completely self-contained and easily reused.
Graph Export Improvements
Transparency Support for PDF and EPS
In 8.5.0 graphs with color transparency did not export properly to EPS and PDF. The export code has been updated for both EPS and PDF to support transparency.
With EPS export, as there is no native support for transparency in EPS, the output will contain raster elements when graph contains elements with transparency. The raster elements are compressed to minimize file size.
PDF has better support for transparency. Also with PDF export there is option for compression which will create more compact files than before. The compression option always existed, but has now been turned on by default.
Other Graph Export Improvements
- Add a radio group in ExpGraph dialog for supporting raster embedding
- "Raster Compression" checkbox is added at the bottom of "EPS Options" for better compression for eps export. It's checked by default.
Data Import Improvements
- Support has been added to importing 3 more third party files:
- TDMS file created by LabView 2009
- Graphpad Prism files.
- MZXML files.
- Import ASCII improvements
- The Import ASCII menu always imports with default/sheet theme
- Reuse the "Add Sparklines" option in impASC dialogue for thumbnails when importing data into matrix.
- Import Wizard improvements
- Two radio buttons have been added on Advanced Options Page in Import wizard, to specify whether to run LabTalk script runs at the end of each file import, or only after all files have been imported.
- The Remove Leading Zeros from Numbers option is ON by default in Import Wizard and impASCII.
- "Drag&Drop Exclusion" column is added in Import Filter Manager, which specifies what extensions would be excluded when Drag and Drop.