Jump to: navigation, search

Difference between revisions of "Activity:CreateCSVValue (Activity)"


(Created page with "{{ActivityInfoBox | title = Create CSV Value | name = CreateCSVValue | image = 220px | imagecaption = CreateCSVValue (Expanded) | purpo...")
 
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
The CreateCSVValue activity writes a single [http://en.wikipedia.org/wiki/Comma-separated_values Comma-separated-values] value to a column within a CSV row, hence it writes to a specific cell of a CSV document.
 +
 +
=Description=
 
{{ActivityInfoBox
 
{{ActivityInfoBox
 
| title = Create CSV Value
 
| title = Create CSV Value
Line 5: Line 8:
 
| imagecaption = CreateCSVValue (Expanded)
 
| imagecaption = CreateCSVValue (Expanded)
 
| purpose = Write a single CSV value
 
| purpose = Write a single CSV value
| category = Data Exchange
+
| category = UBIK Data Exchange
 
| returns = True if successful
 
| returns = True if successful
 
| version = 2.2.0+
 
| version = 2.2.0+
 
}}
 
}}
The CreateCSVValue Activity writes a single [http://en.wikipedia.org/wiki/Comma-separated_values Comma-separated-values] value to a column within a CSV row, hence it writes to a specific cell.
 
 
 
 
 
 
 
 
 
==Arguments==
 
  
 +
===Arguments===
 
{| class="wikitable sortable" | width = "50%"
 
{| class="wikitable sortable" | width = "50%"
 
|-
 
|-
 
! Argument!! Type !! Direction !! Purpose  
 
! Argument!! Type !! Direction !! Purpose  
 
|- align="left"
 
|- align="left"
| AttributeText|| String || In || An expression which's result will be written to the cell value
+
| AttributeText|| {{String_MSDN}} || In || An expression which's result will be written to the cell value
 
|- align="left"
 
|- align="left"
| CSVDocument|| String || In || -
+
| CSVDocument|| {{String_MSDN}} || In || Alternative document to use instead of the hosting scope
 
|- align="left"
 
|- align="left"
| CreatedText|| String || Out || The evaluated result of the ''AttributeText'' expression
+
| CreatedText|| {{String_MSDN}} || Out || The evaluated result of the ''AttributeText'' expression
 
|- align="left"
 
|- align="left"
| Result|| Boolean|| Out || True if successful, false if failed
+
| Result|| {{Boolean_MSDN}}|| Out || True if successful, false if failed
 
|}
 
|}
  
==Usage==
+
===Usage===
  
This activity is used to write a value to a single cell in a CSVRow, as a nested activity within a [[CreateCSVRow (Activity)|CreateCSVRow]] activity. The column it writes to is depending on the order in the hosting activity, from left to right. So the very left CSVValue Activity will write into the first column of the row, the very right into the last column.
+
This activity is used to write a value to a single cell in a CSVRow, as a nested activity within a [[Activity:CreateCSVRow (Activity)|CreateCSVRow]] activity. The column it writes to is depending on the order in the hosting activity, from left to right. So the very left CSVValue Activity will write into the first column of the row, the very right into the last column.
  
==Example==
+
=Example=
 
+
The CreateCSVValue activity, as used in the larger example "Export Multilanguage Properties of all Instances":<br />
The CreateCSVValue activity, as used in the larger example "Export Multilanguage Properties of all Instances":
+
  
 
[[File:UI_Activity_CreateCSVValue_Example.png|x700px]]
 
[[File:UI_Activity_CreateCSVValue_Example.png|x700px]]
 +
 +
<headertabs />
  
 
==See also==
 
==See also==
 
* [[Workflow Designer]]
 
* [[Workflow Designer]]
* [[CreateCSVRow (Activity)]]
+
* [[Activity:CreateCSVRow (Activity)]]
* [[CreateCSVScope (Activity)]]
+
* [[Activity:CreateCSVScope (Activity)]]
  
[[Category:Workflows]] [[Category:Activities]] [[Category:Interfacing]]
+
[[Category:CSV]]

Latest revision as of 12:38, 23 February 2015

The CreateCSVValue activity writes a single Comma-separated-values value to a column within a CSV row, hence it writes to a specific cell of a CSV document.

[edit]

Description

Create CSV Value
Name CreateCSVValue
Purpose Write a single CSV value
Category UBIK Data Exchange
Returns True if successful
Version 2.2.0+

Arguments

Argument Type Direction Purpose
AttributeText String In An expression which's result will be written to the cell value
CSVDocument String In Alternative document to use instead of the hosting scope
CreatedText String Out The evaluated result of the AttributeText expression
Result Boolean Out True if successful, false if failed

Usage

This activity is used to write a value to a single cell in a CSVRow, as a nested activity within a CreateCSVRow activity. The column it writes to is depending on the order in the hosting activity, from left to right. So the very left CSVValue Activity will write into the first column of the row, the very right into the last column.

Example

The CreateCSVValue activity, as used in the larger example "Export Multilanguage Properties of all Instances":

UI Activity CreateCSVValue Example.png

See also