Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
2551 lines (2550 sloc) 87.4 KB
<?xml version="1.0" encoding="UTF-8"?>
<transformation>
<info>
<name>Import Custom Groups and Fields</name>
<description />
<extended_description />
<trans_version />
<trans_type>Normal</trans_type>
<directory>/</directory>
<parameters>
</parameters>
<log>
<trans-log-table>
<connection />
<schema />
<table />
<size_limit_lines />
<interval />
<timeout_days />
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>CHANNEL_ID</id>
<enabled>Y</enabled>
<name>CHANNEL_ID</name>
</field>
<field>
<id>TRANSNAME</id>
<enabled>Y</enabled>
<name>TRANSNAME</name>
</field>
<field>
<id>STATUS</id>
<enabled>Y</enabled>
<name>STATUS</name>
</field>
<field>
<id>LINES_READ</id>
<enabled>Y</enabled>
<name>LINES_READ</name>
<subject />
</field>
<field>
<id>LINES_WRITTEN</id>
<enabled>Y</enabled>
<name>LINES_WRITTEN</name>
<subject />
</field>
<field>
<id>LINES_UPDATED</id>
<enabled>Y</enabled>
<name>LINES_UPDATED</name>
<subject />
</field>
<field>
<id>LINES_INPUT</id>
<enabled>Y</enabled>
<name>LINES_INPUT</name>
<subject />
</field>
<field>
<id>LINES_OUTPUT</id>
<enabled>Y</enabled>
<name>LINES_OUTPUT</name>
<subject />
</field>
<field>
<id>LINES_REJECTED</id>
<enabled>Y</enabled>
<name>LINES_REJECTED</name>
<subject />
</field>
<field>
<id>ERRORS</id>
<enabled>Y</enabled>
<name>ERRORS</name>
</field>
<field>
<id>STARTDATE</id>
<enabled>Y</enabled>
<name>STARTDATE</name>
</field>
<field>
<id>ENDDATE</id>
<enabled>Y</enabled>
<name>ENDDATE</name>
</field>
<field>
<id>LOGDATE</id>
<enabled>Y</enabled>
<name>LOGDATE</name>
</field>
<field>
<id>DEPDATE</id>
<enabled>Y</enabled>
<name>DEPDATE</name>
</field>
<field>
<id>REPLAYDATE</id>
<enabled>Y</enabled>
<name>REPLAYDATE</name>
</field>
<field>
<id>LOG_FIELD</id>
<enabled>Y</enabled>
<name>LOG_FIELD</name>
</field>
<field>
<id>EXECUTING_SERVER</id>
<enabled>N</enabled>
<name>EXECUTING_SERVER</name>
</field>
<field>
<id>EXECUTING_USER</id>
<enabled>N</enabled>
<name>EXECUTING_USER</name>
</field>
<field>
<id>CLIENT</id>
<enabled>N</enabled>
<name>CLIENT</name>
</field>
</trans-log-table>
<perf-log-table>
<connection />
<schema />
<table />
<interval />
<timeout_days />
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>SEQ_NR</id>
<enabled>Y</enabled>
<name>SEQ_NR</name>
</field>
<field>
<id>LOGDATE</id>
<enabled>Y</enabled>
<name>LOGDATE</name>
</field>
<field>
<id>TRANSNAME</id>
<enabled>Y</enabled>
<name>TRANSNAME</name>
</field>
<field>
<id>STEPNAME</id>
<enabled>Y</enabled>
<name>STEPNAME</name>
</field>
<field>
<id>STEP_COPY</id>
<enabled>Y</enabled>
<name>STEP_COPY</name>
</field>
<field>
<id>LINES_READ</id>
<enabled>Y</enabled>
<name>LINES_READ</name>
</field>
<field>
<id>LINES_WRITTEN</id>
<enabled>Y</enabled>
<name>LINES_WRITTEN</name>
</field>
<field>
<id>LINES_UPDATED</id>
<enabled>Y</enabled>
<name>LINES_UPDATED</name>
</field>
<field>
<id>LINES_INPUT</id>
<enabled>Y</enabled>
<name>LINES_INPUT</name>
</field>
<field>
<id>LINES_OUTPUT</id>
<enabled>Y</enabled>
<name>LINES_OUTPUT</name>
</field>
<field>
<id>LINES_REJECTED</id>
<enabled>Y</enabled>
<name>LINES_REJECTED</name>
</field>
<field>
<id>ERRORS</id>
<enabled>Y</enabled>
<name>ERRORS</name>
</field>
<field>
<id>INPUT_BUFFER_ROWS</id>
<enabled>Y</enabled>
<name>INPUT_BUFFER_ROWS</name>
</field>
<field>
<id>OUTPUT_BUFFER_ROWS</id>
<enabled>Y</enabled>
<name>OUTPUT_BUFFER_ROWS</name>
</field>
</perf-log-table>
<channel-log-table>
<connection />
<schema />
<table />
<timeout_days />
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>CHANNEL_ID</id>
<enabled>Y</enabled>
<name>CHANNEL_ID</name>
</field>
<field>
<id>LOG_DATE</id>
<enabled>Y</enabled>
<name>LOG_DATE</name>
</field>
<field>
<id>LOGGING_OBJECT_TYPE</id>
<enabled>Y</enabled>
<name>LOGGING_OBJECT_TYPE</name>
</field>
<field>
<id>OBJECT_NAME</id>
<enabled>Y</enabled>
<name>OBJECT_NAME</name>
</field>
<field>
<id>OBJECT_COPY</id>
<enabled>Y</enabled>
<name>OBJECT_COPY</name>
</field>
<field>
<id>REPOSITORY_DIRECTORY</id>
<enabled>Y</enabled>
<name>REPOSITORY_DIRECTORY</name>
</field>
<field>
<id>FILENAME</id>
<enabled>Y</enabled>
<name>FILENAME</name>
</field>
<field>
<id>OBJECT_ID</id>
<enabled>Y</enabled>
<name>OBJECT_ID</name>
</field>
<field>
<id>OBJECT_REVISION</id>
<enabled>Y</enabled>
<name>OBJECT_REVISION</name>
</field>
<field>
<id>PARENT_CHANNEL_ID</id>
<enabled>Y</enabled>
<name>PARENT_CHANNEL_ID</name>
</field>
<field>
<id>ROOT_CHANNEL_ID</id>
<enabled>Y</enabled>
<name>ROOT_CHANNEL_ID</name>
</field>
</channel-log-table>
<step-log-table>
<connection />
<schema />
<table />
<timeout_days />
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>CHANNEL_ID</id>
<enabled>Y</enabled>
<name>CHANNEL_ID</name>
</field>
<field>
<id>LOG_DATE</id>
<enabled>Y</enabled>
<name>LOG_DATE</name>
</field>
<field>
<id>TRANSNAME</id>
<enabled>Y</enabled>
<name>TRANSNAME</name>
</field>
<field>
<id>STEPNAME</id>
<enabled>Y</enabled>
<name>STEPNAME</name>
</field>
<field>
<id>STEP_COPY</id>
<enabled>Y</enabled>
<name>STEP_COPY</name>
</field>
<field>
<id>LINES_READ</id>
<enabled>Y</enabled>
<name>LINES_READ</name>
</field>
<field>
<id>LINES_WRITTEN</id>
<enabled>Y</enabled>
<name>LINES_WRITTEN</name>
</field>
<field>
<id>LINES_UPDATED</id>
<enabled>Y</enabled>
<name>LINES_UPDATED</name>
</field>
<field>
<id>LINES_INPUT</id>
<enabled>Y</enabled>
<name>LINES_INPUT</name>
</field>
<field>
<id>LINES_OUTPUT</id>
<enabled>Y</enabled>
<name>LINES_OUTPUT</name>
</field>
<field>
<id>LINES_REJECTED</id>
<enabled>Y</enabled>
<name>LINES_REJECTED</name>
</field>
<field>
<id>ERRORS</id>
<enabled>Y</enabled>
<name>ERRORS</name>
</field>
<field>
<id>LOG_FIELD</id>
<enabled>N</enabled>
<name>LOG_FIELD</name>
</field>
</step-log-table>
<metrics-log-table>
<connection />
<schema />
<table />
<timeout_days />
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>CHANNEL_ID</id>
<enabled>Y</enabled>
<name>CHANNEL_ID</name>
</field>
<field>
<id>LOG_DATE</id>
<enabled>Y</enabled>
<name>LOG_DATE</name>
</field>
<field>
<id>METRICS_DATE</id>
<enabled>Y</enabled>
<name>METRICS_DATE</name>
</field>
<field>
<id>METRICS_CODE</id>
<enabled>Y</enabled>
<name>METRICS_CODE</name>
</field>
<field>
<id>METRICS_DESCRIPTION</id>
<enabled>Y</enabled>
<name>METRICS_DESCRIPTION</name>
</field>
<field>
<id>METRICS_SUBJECT</id>
<enabled>Y</enabled>
<name>METRICS_SUBJECT</name>
</field>
<field>
<id>METRICS_TYPE</id>
<enabled>Y</enabled>
<name>METRICS_TYPE</name>
</field>
<field>
<id>METRICS_VALUE</id>
<enabled>Y</enabled>
<name>METRICS_VALUE</name>
</field>
</metrics-log-table>
</log>
<maxdate>
<connection />
<table />
<field />
<offset>0.0</offset>
<maxdiff>0.0</maxdiff>
</maxdate>
<size_rowset>10000</size_rowset>
<sleep_time_empty>50</sleep_time_empty>
<sleep_time_full>50</sleep_time_full>
<unique_connections>N</unique_connections>
<feedback_shown>Y</feedback_shown>
<feedback_size>50000</feedback_size>
<using_thread_priorities>Y</using_thread_priorities>
<shared_objects_file />
<capture_step_performance>N</capture_step_performance>
<step_performance_capturing_delay>1000</step_performance_capturing_delay>
<step_performance_capturing_size_limit>100</step_performance_capturing_size_limit>
<dependencies>
</dependencies>
<partitionschemas>
</partitionschemas>
<slaveservers>
</slaveservers>
<clusterschemas>
</clusterschemas>
<created_user>-</created_user>
<created_date>2017/07/07 16:18:30.979</created_date>
<modified_user>-</modified_user>
<modified_date>2017/07/07 16:18:30.979</modified_date>
<key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key>
<is_key_private>N</is_key_private>
</info>
<notepads>
<notepad>
<note>FIXME: This doesn't work when you don't have any custom fields that do NOT use an option value.</note>
<xloc>432</xloc>
<yloc>16</yloc>
<width>605</width>
<heigth>25</heigth>
<fontname>Sans</fontname>
<fontsize>9</fontsize>
<fontbold>N</fontbold>
<fontitalic>N</fontitalic>
<fontcolorred>0</fontcolorred>
<fontcolorgreen>0</fontcolorgreen>
<fontcolorblue>0</fontcolorblue>
<backgroundcolorred>255</backgroundcolorred>
<backgroundcolorgreen>205</backgroundcolorgreen>
<backgroundcolorblue>112</backgroundcolorblue>
<bordercolorred>100</bordercolorred>
<bordercolorgreen>100</bordercolorgreen>
<bordercolorblue>100</bordercolorblue>
<drawshadow>Y</drawshadow>
</notepad>
</notepads>
<order>
<hop>
<from>api_custom_field</from>
<to>Wait for CustomGroup to finish</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>Wait for OptionGroup to finish</from>
<to>Create OptionValue</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>api_custom_group</from>
<to>Create CustomGroup</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>Wait for CustomGroup to finish</from>
<to>Stream lookup</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>Stream lookup</from>
<to>Create CustomField</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>Get OptionGroup ID from JSON</from>
<to>Stream lookup</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>api_option_group</from>
<to>Filter the bogus export group</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>Filter the bogus export group</from>
<to>Create OptionGroup</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>api_option_value</from>
<to>Filter the bogus export value</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>Filter the bogus export value</from>
<to>Wait for OptionGroup to finish</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>Create OptionGroup</from>
<to>Detect empty stream</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>Detect empty stream</from>
<to>Get OptionGroup ID from JSON</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>Create OptionGroup</from>
<to>Get OptionGroup ID from JSON</to>
<enabled>Y</enabled>
</hop>
</order>
<step>
<name>Create CustomField</name>
<type>CiviCrmOutput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<ApiKey>${APIKEY}</ApiKey>
<SiteKey>${SITEKEY}</SiteKey>
<Entity>CustomField</Entity>
<EntityAction>create</EntityAction>
<RestUrl>${RESTPATH}</RestUrl>
<ResultField>result</ResultField>
<DebugMode>N</DebugMode>
<action-name>create</action-name>
<action-name>delete</action-name>
<action-name>getfield</action-name>
<action-name>getlist</action-name>
<action-name>getrefcount</action-name>
<action-name>setvalue</action-name>
<action-name>validate</action-name>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","name":"is_view","description":"Is this property set by PHP Code? A code field is viewable but not editable","localizable":0,"type":16,"title":"Field is Viewable","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>is_view</fieldName>
<name>is_view</name>
<title>Field is Viewable</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","name":"help_post","description":"Description and\/or help text to display after this field.","localizable":1,"type":32,"title":"Custom Field Post Text","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>help_post</fieldName>
<name>help_post</name>
<title>Custom Field Post Text</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","name":"text_length","description":"field length if alphanumeric","localizable":0,"type":1,"title":"Field Length","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>text_length</fieldName>
<name>text_length</name>
<title>Field Length</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","name":"is_required","description":"Is a value required for this property.","localizable":0,"type":16,"title":"Custom Field Is Required?","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>is_required</fieldName>
<name>is_required</name>
<title>Custom Field Is Required?</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"maxlength":32,"pseudoconstant":{"callback":"CRM_Core_SelectValues::customHtmlType"},"description":"HTML types plus several built-in extended types.","type":2,"title":"Custom Field HTML Type","table_name":"civicrm_custom_field","is_core_field":true,"required":true,"bao":"CRM_Core_BAO_CustomField","size":20,"name":"html_type","localizable":0,"entity":"CustomField"}</fieldDef>
<fieldName>html_type</fieldName>
<name>html_type</name>
<title>Custom Field HTML Type</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","name":"help_pre","description":"Description and\/or help text to display before this field.","localizable":1,"type":32,"title":"Custom Field Pre Text","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>help_pre</fieldName>
<name>help_pre</name>
<title>Custom Field Pre Text</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","name":"option_group_id","description":"For elements with options, the option group id that is used","localizable":0,"type":1,"title":"Field Option Group","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>option_group_id</fieldName>
<name>option_group_id</name>
<title>Field Option Group</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","name":"is_search_range","description":"Is this property range searchable.","localizable":0,"type":16,"title":"Search as a Range","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>is_search_range</fieldName>
<name>is_search_range</name>
<title>Search as a Range</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","api.aliases":["custom_field_id"],"name":"id","description":"Unique Custom Field ID","localizable":0,"type":1,"title":"Custom Field ID","table_name":"civicrm_custom_field","is_core_field":true,"required":true,"entity":"CustomField"}</fieldDef>
<fieldName>id</fieldName>
<name>id</name>
<title>Custom Field ID</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","size":30,"maxlength":64,"name":"mask","description":"Optional format instructions for specific field types, like date types.","localizable":0,"type":2,"title":"Custom Field Formatting","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>mask</fieldName>
<name>mask</name>
<title>Custom Field Formatting</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","name":"note_columns","description":" Number of columns in Note Field ","localizable":0,"type":1,"title":"Field Note Columns","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>note_columns</fieldName>
<name>note_columns</name>
<title>Field Note Columns</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","name":"note_rows","description":" Number of rows in Note Field ","localizable":0,"type":1,"title":"Field Note Rows","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>note_rows</fieldName>
<name>note_rows</name>
<title>Field Note Rows</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","name":"is_searchable","description":"Is this property searchable.","localizable":0,"type":16,"title":"Allow Searching on Field?","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>is_searchable</fieldName>
<name>is_searchable</name>
<title>Allow Searching on Field?</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","name":"start_date_years","description":"Date may be up to start_date_years years prior to the current date.","localizable":0,"type":1,"title":"Field Start Date","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>start_date_years</fieldName>
<name>start_date_years</name>
<title>Field Start Date</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","name":"is_active","description":"Is this property active?","localizable":0,"type":16,"title":"Custom Field Is Active?","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>is_active</fieldName>
<name>is_active</name>
<title>Custom Field Is Active?</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","name":"time_format","description":"time format for custom date","localizable":0,"type":1,"title":"Field Time Format","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>time_format</fieldName>
<name>time_format</name>
<title>Field Time Format</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","name":"end_date_years","description":"Date may be up to end_date_years years after the current date.","localizable":0,"type":1,"title":"Field End Date","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>end_date_years</fieldName>
<name>end_date_years</name>
<title>Field End Date</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","size":45,"maxlength":255,"name":"column_name","description":"Name of the column that holds the values for this field.","localizable":0,"type":2,"title":"Field Column Name","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>column_name</fieldName>
<name>column_name</name>
<title>Field Column Name</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","default":"1","name":"weight","description":"Controls field display order within an extended property group.","localizable":0,"type":1,"title":"Order","table_name":"civicrm_custom_field","is_core_field":true,"required":true,"entity":"CustomField"}</fieldDef>
<fieldName>weight</fieldName>
<name>weight</name>
<title>Order</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","size":45,"maxlength":255,"name":"default_value","description":"Use form_options.is_default for field_types which use options.","localizable":0,"type":2,"title":"Custom Field Default","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>default_value</fieldName>
<name>default_value</name>
<title>Custom Field Default</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","size":45,"maxlength":255,"name":"label","description":"Text for form field label (also friendly name for administering this custom property).","localizable":1,"type":2,"title":"Custom Field Label","table_name":"civicrm_custom_field","is_core_field":true,"required":true,"entity":"CustomField"}</fieldDef>
<fieldName>label</fieldName>
<name>label</name>
<title>Custom Field Label</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","size":45,"maxlength":255,"name":"javascript","description":"Optional scripting attributes for field.","localizable":0,"type":2,"title":"Custom Field Javascript","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>javascript</fieldName>
<name>javascript</name>
<title>Custom Field Javascript</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","name":"options_per_line","description":"number of options per line for checkbox and radio","localizable":0,"type":1,"title":"Field Options Per Line","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>options_per_line</fieldName>
<name>options_per_line</name>
<title>Field Options Per Line</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","size":45,"maxlength":255,"name":"filter","description":"Stores Contact Get API params contact reference custom fields. May be used for other filters in the future.","localizable":0,"type":2,"title":"Field Filter","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>filter</fieldName>
<name>filter</name>
<title>Field Filter</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","size":30,"maxlength":64,"name":"name","description":"Variable name\/programmatic handle for this group.","localizable":0,"type":2,"title":"Custom Field Name","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>name</fieldName>
<name>name</name>
<title>Custom Field Name</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"maxlength":16,"pseudoconstant":{"callback":"CRM_Core_BAO_CustomField::dataType"},"description":"Controls location of data storage in extended_data table.","type":2,"title":"Custom Field Data Type","table_name":"civicrm_custom_field","is_core_field":true,"required":true,"bao":"CRM_Core_BAO_CustomField","size":12,"name":"data_type","localizable":0,"html":{"size":12,"maxlength":16,"type":"Select"},"entity":"CustomField"}</fieldDef>
<fieldName>data_type</fieldName>
<name>data_type</name>
<title>Custom Field Data Type</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","size":45,"maxlength":255,"name":"attributes","description":"Store collection of type-appropriate attributes, e.g. textarea needs rows\/cols attributes","localizable":0,"type":2,"title":"Custom Field Attributes","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>attributes</fieldName>
<name>attributes</name>
<title>Custom Field Attributes</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","size":30,"maxlength":64,"name":"date_format","description":"date format for custom date","localizable":0,"type":2,"title":"Field Data Format","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>date_format</fieldName>
<name>date_format</name>
<title>Field Data Format</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"pseudoconstant":{"keyColumn":"id","labelColumn":"title","table":"civicrm_custom_group"},"description":"FK to civicrm_custom_group.","type":1,"title":"Custom Group","table_name":"civicrm_custom_field","is_core_field":true,"required":true,"FKApiName":"CustomGroup","bao":"CRM_Core_BAO_CustomField","FKClassName":"CRM_Core_DAO_CustomGroup","name":"custom_group_id","localizable":0,"html":{"size":6,"maxlength":14,"type":"Select"},"entity":"CustomField"}</fieldDef>
<fieldName>custom_group_id</fieldName>
<name>custom_group_id</name>
<title>Custom Group</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomField","name":"in_selector","description":"Should the multi-record custom field values be displayed in tab table listing","localizable":0,"type":16,"title":"Field Display","table_name":"civicrm_custom_field","is_core_field":true,"entity":"CustomField"}</fieldDef>
<fieldName>in_selector</fieldName>
<name>in_selector</name>
<title>Field Display</title>
<type>2</type>
<source>getfields</source>
</field>
<key-index>label</key-index>
<key-index>name</key-index>
<key-index>custom_group_id</key-index>
<key-index>option_group_id</key-index>
<key-index>data_type</key-index>
<key-index>html_type</key-index>
<key-index>default_value</key-index>
<key-index>is_required</key-index>
<key-index>is_searchable</key-index>
<key-index>is_search_range</key-index>
<key-index>weight</key-index>
<key-index>is_active</key-index>
<key-index>is_view</key-index>
<key-index>text_length</key-index>
<key-index>in_selector</key-index>
<output-field>
<input-field>is_searchable</input-field>
<output-field>is_searchable</output-field>
</output-field>
<output-field>
<input-field>is_active</input-field>
<output-field>is_active</output-field>
</output-field>
<output-field>
<input-field>is_view</input-field>
<output-field>is_view</output-field>
</output-field>
<output-field>
<input-field>weight</input-field>
<output-field>weight</output-field>
</output-field>
<output-field>
<input-field>default_value</input-field>
<output-field>default_value</output-field>
</output-field>
<output-field>
<input-field>label</input-field>
<output-field>label</output-field>
</output-field>
<output-field>
<input-field>text_length</input-field>
<output-field>text_length</output-field>
</output-field>
<output-field>
<input-field>is_required</input-field>
<output-field>is_required</output-field>
</output-field>
<output-field>
<input-field>option_group_id</input-field>
<output-field>option_group_id</output-field>
</output-field>
<output-field>
<input-field>html_type</input-field>
<output-field>html_type</output-field>
</output-field>
<output-field>
<input-field>name</input-field>
<output-field>name</output-field>
</output-field>
<output-field>
<input-field>data_type</input-field>
<output-field>data_type</output-field>
</output-field>
<output-field>
<input-field>is_search_range</input-field>
<output-field>is_search_range</output-field>
</output-field>
<output-field>
<input-field>custom_group_id</input-field>
<output-field>custom_group_id</output-field>
</output-field>
<output-field>
<input-field>in_selector</input-field>
<output-field>in_selector</output-field>
</output-field>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>816</xloc>
<yloc>320</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>Create CustomGroup</name>
<type>CiviCrmOutput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<ApiKey>${APIKEY}</ApiKey>
<SiteKey>${SITEKEY}</SiteKey>
<Entity>CustomGroup</Entity>
<EntityAction>create</EntityAction>
<RestUrl>${RESTPATH}</RestUrl>
<ResultField>result</ResultField>
<DebugMode>N</DebugMode>
<action-name>create</action-name>
<action-name>delete</action-name>
<action-name>getfield</action-name>
<action-name>getlist</action-name>
<action-name>getrefcount</action-name>
<action-name>setvalue</action-name>
<action-name>validate</action-name>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","name":"min_multiple","description":"minimum number of multiple records (typically 0?)","localizable":0,"type":1,"title":"Minimum Multiple Records","table_name":"civicrm_custom_group","is_core_field":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>min_multiple</fieldName>
<name>min_multiple</name>
<title>Minimum Multiple Records</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","name":"collapse_adv_display","description":"Will this group be in collapsed or expanded mode on advanced search display ?","localizable":0,"type":1,"title":"Collapse Group Display","table_name":"civicrm_custom_group","is_core_field":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>collapse_adv_display</fieldName>
<name>collapse_adv_display</name>
<title>Collapse Group Display</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","name":"collapse_display","description":"Will this group be in collapsed or expanded mode on initial display ?","localizable":0,"type":1,"title":"Collapse Custom Group?","table_name":"civicrm_custom_group","is_core_field":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>collapse_display</fieldName>
<name>collapse_display</name>
<title>Collapse Custom Group?</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","name":"is_active","description":"Is this property active?","localizable":0,"type":16,"title":"Custom Group Is Active?","table_name":"civicrm_custom_group","is_core_field":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>is_active</fieldName>
<name>is_active</name>
<title>Custom Group Is Active?</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","serialize":1,"size":45,"maxlength":255,"name":"extends_entity_column_value","description":"linking custom group for dynamic object","localizable":0,"type":2,"title":"Custom Group Subtype","table_name":"civicrm_custom_group","is_core_field":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>extends_entity_column_value</fieldName>
<name>extends_entity_column_value</name>
<title>Custom Group Subtype</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","default":"1","name":"weight","description":"Controls display order when multiple extended property groups are setup for the same class.","localizable":0,"type":1,"title":"Order","table_name":"civicrm_custom_group","is_core_field":true,"required":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>weight</fieldName>
<name>weight</name>
<title>Order</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","size":30,"maxlength":64,"name":"title","description":"Friendly Name.","localizable":1,"type":2,"title":"Custom Group Title","table_name":"civicrm_custom_group","is_core_field":true,"required":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>title</fieldName>
<name>title</name>
<title>Custom Group Title</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","name":"help_post","description":"Description and\/or help text to display after fields in form.","localizable":1,"html":{"type":"TextArea","rows":4,"cols":80},"type":32,"title":"Custom Group Post Text","rows":4,"cols":80,"table_name":"civicrm_custom_group","is_core_field":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>help_post</fieldName>
<name>help_post</name>
<title>Custom Group Post Text</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","size":45,"maxlength":255,"name":"table_name","description":"Name of the table that holds the values for this group.","localizable":0,"type":2,"title":"Table Name","table_name":"civicrm_custom_group","is_core_field":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>table_name</fieldName>
<name>table_name</name>
<title>Table Name</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","name":"is_multiple","description":"Does this group hold multiple values?","localizable":0,"type":16,"title":"Supports Multiple Records","table_name":"civicrm_custom_group","is_core_field":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>is_multiple</fieldName>
<name>is_multiple</name>
<title>Supports Multiple Records</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","name":"is_reserved","description":"Is this a reserved Custom Group?","localizable":0,"type":16,"title":"Reserved Group?","table_name":"civicrm_custom_group","is_core_field":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>is_reserved</fieldName>
<name>is_reserved</name>
<title>Reserved Group?</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","FKClassName":"CRM_Contact_DAO_Contact","name":"created_id","description":"FK to civicrm_contact, who created this custom group","localizable":0,"type":1,"title":"Custom Group Created By","table_name":"civicrm_custom_group","is_core_field":true,"entity":"CustomGroup","FKApiName":"Contact"}</fieldDef>
<fieldName>created_id</fieldName>
<name>created_id</name>
<title>Custom Group Created By</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","default":"Contact","size":45,"maxlength":255,"name":"extends","description":"Type of object this group extends (can add other options later e.g. contact_address, etc.).","localizable":0,"type":2,"title":"Custom Group Extends","table_name":"civicrm_custom_group","is_core_field":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>extends</fieldName>
<name>extends</name>
<title>Custom Group Extends</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","name":"help_pre","description":"Description and\/or help text to display before fields in form.","localizable":1,"html":{"type":"TextArea","rows":4,"cols":80},"type":32,"title":"Custom Group Pre Text","rows":4,"cols":80,"table_name":"civicrm_custom_group","is_core_field":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>help_pre</fieldName>
<name>help_pre</name>
<title>Custom Group Pre Text</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","size":30,"maxlength":64,"name":"name","description":"Variable name\/programmatic handle for this group.","localizable":0,"type":2,"title":"Custom Group Name","table_name":"civicrm_custom_group","is_core_field":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>name</fieldName>
<name>name</name>
<title>Custom Group Name</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","default":"1","name":"is_public","description":"Is this property public?","localizable":0,"type":16,"title":"Custom Group Is Public?","table_name":"civicrm_custom_group","is_core_field":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>is_public</fieldName>
<name>is_public</name>
<title>Custom Group Is Public?</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","default":"NULL","name":"extends_entity_column_id","description":"FK to civicrm_option_value.id (for option group custom_data_type.)","localizable":0,"type":1,"title":"Custom Group Subtype List","table_name":"civicrm_custom_group","is_core_field":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>extends_entity_column_id</fieldName>
<name>extends_entity_column_id</name>
<title>Custom Group Subtype List</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"maxlength":15,"pseudoconstant":{"callback":"CRM_Core_SelectValues::customGroupStyle"},"description":"Visual relationship between this form and its parent.","type":2,"title":"Custom Group Style","table_name":"civicrm_custom_group","is_core_field":true,"bao":"CRM_Core_BAO_CustomGroup","size":12,"name":"style","localizable":0,"html":{"size":12,"maxlength":15,"type":"Select"},"entity":"CustomGroup"}</fieldDef>
<fieldName>style</fieldName>
<name>style</name>
<title>Custom Group Style</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","api.aliases":["custom_group_id"],"name":"id","description":"Unique Custom Group ID","localizable":0,"type":1,"title":"Custom Group ID","table_name":"civicrm_custom_group","is_core_field":true,"required":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>id</fieldName>
<name>id</name>
<title>Custom Group ID</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","name":"created_date","description":"Date and time this custom group was created.","localizable":0,"type":12,"title":"Custom Group Created Date","table_name":"civicrm_custom_group","is_core_field":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>created_date</fieldName>
<name>created_date</name>
<title>Custom Group Created Date</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_CustomGroup","name":"max_multiple","description":"maximum number of multiple records, if 0 - no max","localizable":0,"type":1,"title":"Maximum Multiple Records","table_name":"civicrm_custom_group","is_core_field":true,"entity":"CustomGroup"}</fieldDef>
<fieldName>max_multiple</fieldName>
<name>max_multiple</name>
<title>Maximum Multiple Records</title>
<type>2</type>
<source>getfields</source>
</field>
<key-index>title</key-index>
<key-index>name</key-index>
<key-index>style</key-index>
<key-index>collapse_adv_display</key-index>
<key-index>collapse_display</key-index>
<key-index>extends</key-index>
<key-index>extends_entity_column_id</key-index>
<key-index>extends_entity_column_value</key-index>
<key-index>is_active</key-index>
<key-index>is_public</key-index>
<key-index>is_reserved</key-index>
<key-index>weight</key-index>
<output-field>
<input-field>is_reserved</input-field>
<output-field>is_reserved</output-field>
</output-field>
<output-field>
<input-field>collapse_adv_display</input-field>
<output-field>collapse_adv_display</output-field>
</output-field>
<output-field>
<input-field>collapse_display</input-field>
<output-field>collapse_display</output-field>
</output-field>
<output-field>
<input-field>is_active</input-field>
<output-field>is_active</output-field>
</output-field>
<output-field>
<input-field>extends</input-field>
<output-field>extends</output-field>
</output-field>
<output-field>
<input-field>name</input-field>
<output-field>name</output-field>
</output-field>
<output-field>
<input-field>extends_entity_column_value</input-field>
<output-field>extends_entity_column_value</output-field>
</output-field>
<output-field>
<input-field>is_public</input-field>
<output-field>is_public</output-field>
</output-field>
<output-field>
<input-field>extends_entity_column_id</input-field>
<output-field>extends_entity_column_id</output-field>
</output-field>
<output-field>
<input-field>weight</input-field>
<output-field>weight</output-field>
</output-field>
<output-field>
<input-field>style</input-field>
<output-field>style</output-field>
</output-field>
<output-field>
<input-field>title</input-field>
<output-field>title</output-field>
</output-field>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>192</xloc>
<yloc>272</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>Create OptionGroup</name>
<type>CiviCrmOutput</type>
<description />
<distribute>N</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<ApiKey>${APIKEY}</ApiKey>
<SiteKey>${SITEKEY}</SiteKey>
<Entity>OptionGroup</Entity>
<EntityAction>create</EntityAction>
<RestUrl>${RESTPATH}</RestUrl>
<ResultField>result</ResultField>
<DebugMode>N</DebugMode>
<action-name>create</action-name>
<action-name>delete</action-name>
<action-name>getfield</action-name>
<action-name>getlist</action-name>
<action-name>getrefcount</action-name>
<action-name>setvalue</action-name>
<action-name>validate</action-name>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionGroup","default":"1","name":"is_reserved","description":"Is this a predefined system option group (i.e. it can not be deleted)?","localizable":0,"type":16,"title":"Option Group Is Reserved?","table_name":"civicrm_option_group","is_core_field":true,"entity":"OptionGroup"}</fieldDef>
<fieldName>is_reserved</fieldName>
<name>is_reserved</name>
<title>Option Group Is Reserved?</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionGroup","name":"is_locked","description":"A lock to remove the ability to add new options via the UI.","localizable":0,"type":16,"title":"Option Group Is Locked","table_name":"civicrm_option_group","is_core_field":true,"entity":"OptionGroup"}</fieldDef>
<fieldName>is_locked</fieldName>
<name>is_locked</name>
<title>Option Group Is Locked</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionGroup","name":"is_active","description":"Is this option group active?","localizable":0,"type":16,"title":"Option Group Is Active?","table_name":"civicrm_option_group","is_core_field":true,"entity":"OptionGroup"}</fieldDef>
<fieldName>is_active</fieldName>
<name>is_active</name>
<title>Option Group Is Active?</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionGroup","size":30,"maxlength":64,"name":"name","description":"Option group name. Used as selection key by class properties which lookup options in civicrm_option_value.","localizable":0,"type":2,"title":"Option Group Name","table_name":"civicrm_option_group","is_core_field":true,"required":true,"entity":"OptionGroup"}</fieldDef>
<fieldName>name</fieldName>
<name>name</name>
<title>Option Group Name</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionGroup","size":45,"maxlength":128,"pseudoconstant":{"callback":"CRM_Utils_Type::dataTypes"},"name":"data_type","description":"Option group description.","localizable":0,"type":2,"title":"Data Type for this option group","table_name":"civicrm_option_group","is_core_field":true,"entity":"OptionGroup"}</fieldDef>
<fieldName>data_type</fieldName>
<name>data_type</name>
<title>Data Type for this option group</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionGroup","size":45,"maxlength":255,"name":"description","description":"Option group description.","localizable":1,"type":2,"title":"Option Group Description","table_name":"civicrm_option_group","is_core_field":true,"entity":"OptionGroup"}</fieldDef>
<fieldName>description</fieldName>
<name>description</name>
<title>Option Group Description</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionGroup","api.aliases":["option_group_id"],"name":"id","description":"Option Group ID","localizable":0,"type":1,"title":"Option Group ID","table_name":"civicrm_option_group","is_core_field":true,"required":true,"entity":"OptionGroup"}</fieldDef>
<fieldName>id</fieldName>
<name>id</name>
<title>Option Group ID</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionGroup","size":45,"maxlength":255,"name":"title","description":"Option Group title.","localizable":1,"type":2,"title":"Option Group title","table_name":"civicrm_option_group","is_core_field":true,"entity":"OptionGroup"}</fieldDef>
<fieldName>title</fieldName>
<name>title</name>
<title>Option Group title</title>
<type>2</type>
<source>getfields</source>
</field>
<key-index>name</key-index>
<key-index>title</key-index>
<key-index>description</key-index>
<key-index>data_type</key-index>
<key-index>is_reserved</key-index>
<key-index>is_active</key-index>
<key-index>is_locked</key-index>
<output-field>
<input-field>is_reserved</input-field>
<output-field>is_reserved</output-field>
</output-field>
<output-field>
<input-field>is_locked</input-field>
<output-field>is_locked</output-field>
</output-field>
<output-field>
<input-field>is_active</input-field>
<output-field>is_active</output-field>
</output-field>
<output-field>
<input-field>name</input-field>
<output-field>name</output-field>
</output-field>
<output-field>
<input-field>data_type</input-field>
<output-field>data_type</output-field>
</output-field>
<output-field>
<input-field>description</input-field>
<output-field>description</output-field>
</output-field>
<output-field>
<input-field>title</input-field>
<output-field>title</output-field>
</output-field>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>352</xloc>
<yloc>224</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>Create OptionValue</name>
<type>CiviCrmOutput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<ApiKey>${APIKEY}</ApiKey>
<SiteKey>${SITEKEY}</SiteKey>
<Entity>OptionValue</Entity>
<EntityAction>create</EntityAction>
<RestUrl>${RESTPATH}</RestUrl>
<ResultField>result</ResultField>
<DebugMode>N</DebugMode>
<action-name>create</action-name>
<action-name>delete</action-name>
<action-name>getfield</action-name>
<action-name>getlist</action-name>
<action-name>getrefcount</action-name>
<action-name>setvalue</action-name>
<action-name>validate</action-name>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionValue","FKClassName":"CRM_Core_DAO_Component","pseudoconstant":{"keyColumn":"id","labelColumn":"name","table":"civicrm_component"},"name":"component_id","description":"Component that this option value belongs\/caters to.","localizable":0,"html":{"size":6,"maxlength":14,"type":"Select"},"type":1,"title":"Option Component","table_name":"civicrm_option_value","is_core_field":true,"entity":"OptionValue"}</fieldDef>
<fieldName>component_id</fieldName>
<name>component_id</name>
<title>Option Component</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionValue","default":"1","name":"is_active","description":"Is this option active?","localizable":0,"type":16,"title":"Option Is Active","table_name":"civicrm_option_value","is_core_field":true,"entity":"OptionValue"}</fieldDef>
<fieldName>is_active</fieldName>
<name>is_active</name>
<title>Option Is Active</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionValue","default":"NULL","size":45,"maxlength":255,"name":"color","description":"Hex color value e.g. #ffffff","localizable":0,"type":2,"title":"Color","table_name":"civicrm_option_value","is_core_field":true,"entity":"OptionValue"}</fieldDef>
<fieldName>color</fieldName>
<name>color</name>
<title>Color</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionValue","default":"NULL","size":45,"maxlength":255,"name":"icon","description":"crm-i icon class","localizable":0,"type":2,"title":"Icon","table_name":"civicrm_option_value","is_core_field":true,"entity":"OptionValue"}</fieldDef>
<fieldName>icon</fieldName>
<name>icon</name>
<title>Icon</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionValue","name":"weight","description":"Controls display sort order.","localizable":0,"type":1,"title":"Order","table_name":"civicrm_option_value","is_core_field":true,"required":true,"entity":"OptionValue"}</fieldDef>
<fieldName>weight</fieldName>
<name>weight</name>
<title>Order</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionValue","name":"description","description":"Optional description.","localizable":1,"html":{"type":"TextArea","rows":8,"cols":60},"type":32,"title":"Option Description","rows":8,"cols":60,"table_name":"civicrm_option_value","is_core_field":true,"entity":"OptionValue"}</fieldDef>
<fieldName>description</fieldName>
<name>description</name>
<title>Option Description</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionValue","size":45,"maxlength":512,"name":"label","description":"Option string as displayed to users - e.g. the label in an HTML OPTION tag.","localizable":1,"type":2,"title":"Option Label","table_name":"civicrm_option_value","is_core_field":true,"required":true,"entity":"OptionValue"}</fieldDef>
<fieldName>label</fieldName>
<name>label</name>
<title>Option Label</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionValue","name":"is_default","description":"Is this the default option for the group?","localizable":0,"type":16,"title":"Option is Default?","table_name":"civicrm_option_value","is_core_field":true,"entity":"OptionValue"}</fieldDef>
<fieldName>is_default</fieldName>
<name>is_default</name>
<title>Option is Default?</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionValue","size":45,"maxlength":255,"name":"grouping","description":"Use to sort and\/or set display properties for sub-set(s) of options within an option group. EXAMPLE: Use for college_interest field, to differentiate partners from non-partners.","localizable":0,"type":2,"title":"Option Grouping Name","table_name":"civicrm_option_value","is_core_field":true,"entity":"OptionValue"}</fieldDef>
<fieldName>grouping</fieldName>
<name>grouping</name>
<title>Option Grouping Name</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionValue","name":"filter","description":"Bitwise logic can be used to create subsets of options within an option_group for different uses.","localizable":0,"type":1,"title":"Filter","table_name":"civicrm_option_value","is_core_field":true,"entity":"OptionValue"}</fieldDef>
<fieldName>filter</fieldName>
<name>filter</name>
<title>Filter</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionValue","name":"is_reserved","description":"Is this a predefined system object?","localizable":0,"type":16,"title":"Option Is Reserved?","table_name":"civicrm_option_value","is_core_field":true,"entity":"OptionValue"}</fieldDef>
<fieldName>is_reserved</fieldName>
<name>is_reserved</name>
<title>Option Is Reserved?</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionValue","FKClassName":"CRM_Core_DAO_Domain","pseudoconstant":{"keyColumn":"id","labelColumn":"name","table":"civicrm_domain"},"name":"domain_id","description":"Which Domain is this option value for","localizable":0,"type":1,"title":"Option Domain","table_name":"civicrm_option_value","is_core_field":true,"entity":"OptionValue","FKApiName":"Domain"}</fieldDef>
<fieldName>domain_id</fieldName>
<name>domain_id</name>
<title>Option Domain</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"api.aliases":["option_group_name"],"pseudoconstant":{"keyColumn":"id","labelColumn":"name","table":"civicrm_option_group"},"description":"Group which this option belongs to.","type":1,"title":"Option Group ID","table_name":"civicrm_option_value","is_core_field":true,"required":true,"FKApiName":"OptionGroup","bao":"CRM_Core_BAO_OptionValue","FKClassName":"CRM_Core_DAO_OptionGroup","name":"option_group_id","localizable":0,"html":{"size":6,"maxlength":14,"type":"Select"},"entity":"OptionValue"}</fieldDef>
<fieldName>option_group_id</fieldName>
<name>option_group_id</name>
<title>Option Group ID</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"headerPattern":"","import":true,"maxlength":255,"description":"Stores a fixed (non-translated) name for this option value. Lookup functions should use the name as the key for the option value row.","dataPattern":"","type":2,"title":"Option Name","table_name":"civicrm_option_value","is_core_field":true,"bao":"CRM_Core_BAO_OptionValue","size":45,"name":"name","localizable":0,"where":"civicrm_option_value.name","export":true,"entity":"OptionValue"}</fieldDef>
<fieldName>name</fieldName>
<name>name</name>
<title>Option Name</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionValue","api.aliases":["option_value_id"],"name":"id","description":"Option ID","localizable":0,"type":1,"title":"Option Value ID","table_name":"civicrm_option_value","is_core_field":true,"required":true,"entity":"OptionValue"}</fieldDef>
<fieldName>id</fieldName>
<name>id</name>
<title>Option Value ID</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionValue","default":"NULL","name":"visibility_id","localizable":0,"type":1,"title":"Option Visibility","table_name":"civicrm_option_value","is_core_field":true,"entity":"OptionValue"}</fieldDef>
<fieldName>visibility_id</fieldName>
<name>visibility_id</name>
<title>Option Visibility</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionValue","size":45,"maxlength":512,"name":"value","description":"The actual value stored (as a foreign key) in the data record. Functions which need lookup option_value.title should use civicrm_option_value.option_group_id plus civicrm_option_value.value as the key.","localizable":0,"type":2,"title":"Option Value","table_name":"civicrm_option_value","is_core_field":true,"required":true,"entity":"OptionValue"}</fieldDef>
<fieldName>value</fieldName>
<name>value</name>
<title>Option Value</title>
<type>2</type>
<source>getfields</source>
</field>
<field>
<fieldDef>{"bao":"CRM_Core_BAO_OptionValue","name":"is_optgroup","description":"Is this row simply a display header? Expected usage is to render these as OPTGROUP tags within a SELECT field list of options?","localizable":0,"type":16,"title":"Option is Header?","table_name":"civicrm_option_value","is_core_field":true,"entity":"OptionValue"}</fieldDef>
<fieldName>is_optgroup</fieldName>
<name>is_optgroup</name>
<title>Option is Header?</title>
<type>2</type>
<source>getfields</source>
</field>
<key-index>label</key-index>
<key-index>option_group_id</key-index>
<key-index>value</key-index>
<key-index>name</key-index>
<key-index>grouping</key-index>
<key-index>filter</key-index>
<key-index>is_default</key-index>
<key-index>weight</key-index>
<key-index>description</key-index>
<key-index>is_optgroup</key-index>
<key-index>is_reserved</key-index>
<key-index>is_active</key-index>
<key-index>component_id</key-index>
<key-index>domain_id</key-index>
<key-index>visibility_id</key-index>
<key-index>icon</key-index>
<key-index>color</key-index>
<output-field>
<input-field>component_id</input-field>
<output-field>component_id</output-field>
</output-field>
<output-field>
<input-field>is_active</input-field>
<output-field>is_active</output-field>
</output-field>
<output-field>
<input-field>color</input-field>
<output-field>color</output-field>
</output-field>
<output-field>
<input-field>icon</input-field>
<output-field>icon</output-field>
</output-field>
<output-field>
<input-field>weight</input-field>
<output-field>weight</output-field>
</output-field>
<output-field>
<input-field>description</input-field>
<output-field>description</output-field>
</output-field>
<output-field>
<input-field>label</input-field>
<output-field>label</output-field>
</output-field>
<output-field>
<input-field>is_default</input-field>
<output-field>is_default</output-field>
</output-field>
<output-field>
<input-field>grouping</input-field>
<output-field>grouping</output-field>
</output-field>
<output-field>
<input-field>filter</input-field>
<output-field>filter</output-field>
</output-field>
<output-field>
<input-field>is_reserved</input-field>
<output-field>is_reserved</output-field>
</output-field>
<output-field>
<input-field>domain_id</input-field>
<output-field>domain_id</output-field>
</output-field>
<output-field>
<input-field>option_group_id</input-field>
<output-field>option_group_id</output-field>
</output-field>
<output-field>
<input-field>name</input-field>
<output-field>name</output-field>
</output-field>
<output-field>
<input-field>visibility_id</input-field>
<output-field>visibility_id</output-field>
</output-field>
<output-field>
<input-field>value</input-field>
<output-field>value</output-field>
</output-field>
<output-field>
<input-field>is_optgroup</input-field>
<output-field>is_optgroup</output-field>
</output-field>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>1040</xloc>
<yloc>320</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>Detect empty stream</name>
<type>DetectEmptyStream</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>416</xloc>
<yloc>288</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>Filter the bogus export group</name>
<type>FilterRows</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<send_true_to />
<send_false_to />
<compare>
<condition>
<negated>N</negated>
<leftvalue>title</leftvalue>
<function>&lt;></function>
<rightvalue />
<value>
<name>constant</name>
<type>String</type>
<text>do not import this</text>
<length>-1</length>
<precision>-1</precision>
<isnull>N</isnull>
<mask />
</value>
</condition>
</compare>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>352</xloc>
<yloc>160</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>Filter the bogus export value</name>
<type>FilterRows</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<send_true_to />
<send_false_to />
<compare>
<condition>
<negated>N</negated>
<leftvalue>label</leftvalue>
<function>&lt;></function>
<rightvalue />
<value>
<name>constant</name>
<type>String</type>
<text>do not import this</text>
<length>-1</length>
<precision>-1</precision>
<isnull>N</isnull>
<mask />
</value>
</condition>
</compare>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>1040</xloc>
<yloc>160</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>Get OptionGroup ID from JSON</name>
<type>JsonInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<include>N</include>
<include_field />
<rownum>N</rownum>
<addresultfile>N</addresultfile>
<readurl>N</readurl>
<removeSourceField>N</removeSourceField>
<IsIgnoreEmptyFile>N</IsIgnoreEmptyFile>
<doNotFailIfNoFile>N</doNotFailIfNoFile>
<ignoreMissingPath>N</ignoreMissingPath>
<rownum_field />
<file>
<name />
<filemask />
<exclude_filemask />
<file_required>N</file_required>
<include_subfolders>N</include_subfolders>
</file>
<fields>
<field>
<name>id</name>
<path>id</path>
<type>Integer</type>
<format>0</format>
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
<repeat>N</repeat>
</field>
</fields>
<limit>0</limit>
<IsInFields>Y</IsInFields>
<IsAFile>N</IsAFile>
<valueField>Result</valueField>
<shortFileFieldName />
<pathFieldName />
<hiddenFieldName />
<lastModificationTimeFieldName />
<uriNameFieldName />
<rootUriNameFieldName />
<extensionFieldName />
<sizeFieldName />
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>352</xloc>
<yloc>368</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>Stream lookup</name>
<type>StreamLookup</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<from>Get OptionGroup ID from JSON</from>
<input_sorted>N</input_sorted>
<preserve_memory>Y</preserve_memory>
<sorted_list>N</sorted_list>
<integer_pair>N</integer_pair>
<lookup>
<key>
<name>option_group</name>
<field>name</field>
</key>
<value>
<name>id</name>
<rename>option_group_id</rename>
<default />
<type>None</type>
</value>
</lookup>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>816</xloc>
<yloc>256</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>Wait for CustomGroup to finish</name>
<type>BlockUntilStepsFinish</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<steps>
<step>
<name>Create CustomGroup</name>
<CopyNr>0</CopyNr>
</step>
</steps>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>816</xloc>
<yloc>176</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>Wait for OptionGroup to finish</name>
<type>BlockUntilStepsFinish</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<steps>
<step>
<name>Create OptionGroup</name>
<CopyNr>0</CopyNr>
</step>
</steps>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>1040</xloc>
<yloc>240</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>api_custom_field</name>
<type>CsvInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<filename>${LOCALFILES}/raw data/api_custom_field.csv</filename>
<filename_field />
<rownum_field />
<include_filename>N</include_filename>
<separator>,</separator>
<enclosure>"</enclosure>
<header>Y</header>
<buffer_size>50000</buffer_size>
<lazy_conversion>N</lazy_conversion>
<add_filename_result>N</add_filename_result>
<parallel>N</parallel>
<newline_possible>N</newline_possible>
<encoding />
<fields>
<field>
<name>label</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>name</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>custom_group_id</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>option_group</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>data_type</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>html_type</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>default_value</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>is_required</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>is_searchable</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>is_search_range</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>weight</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>is_active</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>is_view</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>text_length</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>in_selector</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
</fields>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>816</xloc>
<yloc>80</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>api_custom_group</name>
<type>CsvInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<filename>${LOCALFILES}/raw data/api_custom_group.csv</filename>
<filename_field />
<rownum_field />
<include_filename>N</include_filename>
<separator>,</separator>
<enclosure>"</enclosure>
<header>Y</header>
<buffer_size>50000</buffer_size>
<lazy_conversion>N</lazy_conversion>
<add_filename_result>N</add_filename_result>
<parallel>N</parallel>
<newline_possible>N</newline_possible>
<encoding />
<fields>
<field>
<name>title</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>name</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>style</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>collapse_adv_display</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>collapse_display</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>extends</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>extends_entity_column_id</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>extends_entity_column_value</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>is_active</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>is_public</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>is_reserved</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>weight</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
</fields>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>192</xloc>
<yloc>80</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>api_option_group</name>
<type>CsvInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<filename>${LOCALFILES}/raw data/api_option_group.csv</filename>
<filename_field />
<rownum_field />
<include_filename>N</include_filename>
<separator>,</separator>
<enclosure>"</enclosure>
<header>Y</header>
<buffer_size>50000</buffer_size>
<lazy_conversion>N</lazy_conversion>
<add_filename_result>N</add_filename_result>
<parallel>N</parallel>
<newline_possible>N</newline_possible>
<encoding />
<fields>
<field>
<name>name</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>title</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>description</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>data_type</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>is_reserved</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>is_active</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>is_locked</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
</fields>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>352</xloc>
<yloc>80</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>api_option_value</name>
<type>CsvInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<filename>${LOCALFILES}/raw data/api_option_value.csv</filename>
<filename_field />
<rownum_field />
<include_filename>N</include_filename>
<separator>,</separator>
<enclosure>"</enclosure>
<header>Y</header>
<buffer_size>50000</buffer_size>
<lazy_conversion>N</lazy_conversion>
<add_filename_result>N</add_filename_result>
<parallel>N</parallel>
<newline_possible>N</newline_possible>
<encoding />
<fields>
<field>
<name>label</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>option_group_id</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>value</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>name</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>grouping</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>filter</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>is_default</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>weight</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>description</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>is_optgroup</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>is_reserved</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>is_active</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>component_id</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>domain_id</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>visibility_id</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>icon</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>color</name>
<type>String</type>
<format />
<currency />
<decimal />
<group />
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
</fields>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>1040</xloc>
<yloc>80</yloc>
<draw>Y</draw>
</GUI>
</step>
<step_error_handling>
</step_error_handling>
<slave-step-copy-partition-distribution>
</slave-step-copy-partition-distribution>
<slave_transformation>N</slave_transformation>
</transformation>