User Tools

Site Tools


playground:playground

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
playground:playground [2023/02/01 18:39] craigtplayground:playground [2023/11/03 12:11] (current) – add List sheets description craigt
Line 1: Line 1:
-{{ transformations:retrievecatalogitemaction.png}} +{{ transformations:ImportGoogleSheetsAction.png}} 
-====== RETRIEVE CATALOG ITEM ====== +====== IMPORT  GOOGLE SHEETS====== 
-Category: Workflow / App/Cloud\\+Category: Import / App/Cloud\\
  
 \\  \\ 
 =====Description===== =====Description=====
-This action retrieves static or computed item from the Data Catalog. +Import data from Google Sheets file.\\
- +
-\\ +
-=====Use cases===== +
-Use the various modes of this action to extract information about Catalog items, and manipulate the structure of the Data Catalog. +
- +
-Use field items to store and retrieve metadata items about the resource or resource's data.+
  
 \\  \\ 
-=====Action settings===== +===== Action settings =====
-^ Setting  ^ Description +
-|Retrieve|Select the type of Catalog resource to retrieve.  Options: //Dataset// (an EasyMorph .dset file), //File// (any non-.dset file), or //URL//.| +
-|Catalog item<sup>*</sup>|Enter or browse to the Catalog resource to retrieve.|+
  
-<sup>*</sup> Setting can be specified using a [[:parameters|parameter]] or the first value of column.\\+^ Setting  ^ Description ^ 
 +|Connector<sup>*</sup>| A configured connector to Google Drive.  See [[connectors:googledrive|Google Drive connector]].  | 
 +|Spreadsheet<sup>*</sup>| The path to the source Google Sheet document.  This is set after the //Connector// is created. 
 +|Import action|Options:  //Import table// (retrieve data from sheet, see details below) or //List sheets// (produce a list of sheet names within the Sheets file).|
  
 +\\
 +==== Import table settings ====
 +^ Setting  ^ Description ^
 +|Sheet or range<sup>*</sup>| Sheet or range to be imported.  This list will be populated once the //Connector// is set and the //Spreadsheet// is selected.  |
 +|Skip first lines<sup>*</sup>|The number of rows to skip before reading in your data.  If your data does not start on the first row\\ (i.e., leading rows with metadata, blank rows), use this setting to skip these rows.|
 +|Columns don't have headers|Check this if your dataset does not include a row with header information|
 +|Load all columns|This option imports all columns in the sheet.|
 +|Load only selected columns|This option allows you to select which columns to import.  A list of columns found in the sheet will be\\ presented for you to select.|
 +<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
  
-====Results settings==== +\\ 
-Note:  These options are only available for the //Dataset// and //File// Catalog item types. +====List sheets settings==== 
-^Setting  ^Description +**Description:**  Produce list of sheet names within the selected Sheets file.  There are no settings required for this action.
-|Return file path as action's output|Returns single-row, 4-column dataset containing information about the selected Catalog resource:  the resource's relative path, the connector type used, the connector name used, and the resource's item type.| +
-|Save as<sup>*</sup>|Downloads and saves the resource.  Enter or browse to a folder on the local system and enter a filename.|+
  
 +\\ 
 +=====Advanced options=====
 +^Setting^Description^
 +|Do not automatically offset imported range|By default, EasyMorph will align the first column and first row of imported data with column 1 and row 1\\ in the dataset.  To prevent this, and to preserve the actual positioning of data within the source file, //check// this option.|
 +|When a floating-point number can't\\ be converted to a fixed point number: | Options:  //Produce error (default)//, //Convert the number to text//.|
  
-====Parameters settings===== +\\  
-//Dataset// Catalog items (EasyMorph native .dset files) can contain parameters that may be set here by selecting the //Parameter// in the list and selecting the field in //This project// to use for the value.+=====Shortcuts===== 
 +Fast ways to create the action: 
 +  * Press the "Add data" menu button. Pick "Fetch from cloud/application".
  
 +\\ 
 +=====See also=====
 +  *[[connectors:googledrive|Google Drive connector]]
  
  
-\\  
-=====Remarks===== 
-**Delete directory** - Use this mode //with caution// as any items stored within the selected directory will be deleted as well.  Structure your workflow to detect and/or move any items you wish to keep before running this mode. 
  
-You can **set and remove field items and settings //manually//** using the //Data catalog// section from the //Start// tab.  Click the down arrow at the top-right corner of the resource and select "Edit..." In the "Edit catalog item" window that appears, select the //Fields// tab. 
  
  
-\\  
-=====See also===== 
- 
-  * [[transformations:retrievecatalogitem|Retrieve Catalog item]] 
  
playground/playground.txt · Last modified: 2023/11/03 12:11 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki