Examples
This documentation needs work. See "Help improve this page" in the sidebar.
A list of CSV examples per fields:
- General
- Number
- Reference
- Text
Boolean
Suppose we have Boolean (machine_name: field_boolean) field in our entity:
Allowed value: 1 or 0
Node example:
title,field_boolean
Node 1,1Taxonomy example:
name,field_boolean
Term 1,0User example:
name,field_boolean
User 1,1Suppose we have Email (machine_name: field_email) field in our entity:
Allowed value: Email (for instance: example@example.com)
Node example:
title,field_email
Node 1,example@example.comTaxonomy example:
name,field_email
Term 1,example@example.comUser example:
name,field_email
User 1,example@example.comLink
Suppose we have Link (machine_name: field_link) field in our entity:
Allowed value: Link (internal or external for instance: http://example.com or internal:/node/1)
Node example:
title,field_link|uri,field_link|title
Node 1,http://example.com,Link title 1Taxonomy example:
name,field_link|uri,field_link|title
Term 1,internal:/node/1,Link title 1User example:
name,field_link|uri,field_link|title
User 1,http://example.com,Link title 1Timestamp
Suppose we have Timestamp (machine_name: field_timestamp) field in our entity:
Allowed value: Timestamp (for instance: 1517392432)
Node example:
title,field_timestamp
Node 1,1517392432Taxonomy example:
name,field_timestamp
Term 1,1517392432User example:
name,field_timestamp
User 1,1517392432Entity status (Published)
Suppose we have Status (machine_name: status) field in our entity:
Allowed values: 0 or 1
Node example:
title,status
Node 1,1Path Alias
Suppose we have Path Alias(machine_name: alias) field in our entity:
Allowed value: (internal or external for instance: http://example.com or internal:/node/1)
Node example:
title,path|alias
Node 1,/node/1List (float)
Suppose we have List (float) (machine_name: field_list_float) field in our entity and following key|value storage:
- 1|17.1
- 2|17.2
- 3|17.3
Allowed value: mixed (the key name of the value)
Node example:
title,field_list_float
Node 1,2Taxonomy example:
name,field_list_float
Term 1,3User example:
name,field_list_float
User 1,1List (integer)
Suppose we have List (integer) (machine_name: field_list_integer) field in our entity and following key|value storage:
- key_1|17
- key_2|18
- key_3|19
Allowed value: mixed (the key name of the value)
Node example:
title,field_list_integer
Node 1,key_1Taxonomy example:
name,field_list_integer
Term 1,key_2User example:
name,field_list_integer
User 1,key_3Number (integer)
Suppose we have Number (integer) (machine_name: field_number_integer) field in our entity:
Allowed value: Integer number
Node example:
title,field_number_integer
Node 1,10Taxonomy example:
name,field_number_integer
Term 1,20User example:
name,field_number_integer
User 1,30Number (decimal)
Suppose we have Number (decimal) (machine_name: field_number_decimal) field in our entity:
Allowed value: Decimal number
Node example:
title,field_number_decimal
Node 1,0.123Taxonomy example:
name,field_number_decimal
Term 1,1.234User example:
name,field_number_decimal
User 1,17.55555Number (float)
Suppose we have Number (float) (machine_name: field_number_float) field in our entity:
Allowed value: Float number
Node example:
title,field_number_float
Node 1,17.1Taxonomy example:
name,field_number_float
Term 1,17.2User example:
name,field_number_float
User 1,17.3Content
Suppose we have Content (machine_name: field_content_reference) field in our entity:
Allowed value: target_id (Node id)
Node example:
title,field_content_reference
Node 1,1111Taxonomy example:
name,field_content_reference
Term 1,2222User example:
name,field_content_reference
User 1,3333Taxonomy term
Suppose we have Taxonomy term (machine_name: field_taxonomy_reference) field in our entity:
Allowed value: target_id (Term id)
Node example:
title,field_taxonomy_reference
Node 1,71Taxonomy example:
name,field_taxonomy_reference
Term 1,72User example:
name,field_taxonomy_reference
User 1,73Geolocation
Suppose we have Geolocation coordinates (machine_name: field_geolocation_reference) field in our entity:
Allowed value: geolocation
Node example:
title,field_geolocation_reference|lat,field_geolocation_reference|lng
Node 1,32.123,-95.123
Taxonomy example:
title,field_geolocation_reference|lat,field_geolocation_reference|lng
Term 2,33.123,-96.123
User example:
title,field_geolocation_reference|lat,field_geolocation_reference|lng
User 3,34.123,-97.123
User
Suppose we have User (machine_name: field_user_reference) field in our entity:
Allowed value: target_id (User id)
Node example:
title,field_user_reference
Node 1,1Taxonomy example:
name,field_user_reference
Term 1,2User example:
name,field_user_reference
User 1,3List (text)
Suppose we have List (text) (machine_name: field_list_text) field in our entity and following key|value storage:
- csv_1|Text 1
- csv_2|Text 2
- csv_3|Text 3
Allowed value: mixed (the key name of the value)
Node example:
title,field_list_text
Node 1,csv_1Taxonomy example:
name,field_list_text
Term 1,csv_2User example:
name,field_list_text
User 1,csv_3Text (formatted)
Suppose we have Text (formatted) (machine_name: field_text_formatted) field in our entity:
Allowed value: Formatted text (for instance: <strong>Hello CSV</strong>)
Node example:
title,field_text_formatted|format,field_text_formatted|value
Node 1,full_html,<strong>Hello CSV</strong>Taxonomy example:
name,field_text_formatted
Term 1,<strong>Hello CSV</strong>User example:
name,field_text_formatted
User 1,<strong>Hello CSV</strong>Text (plain)
Suppose we have Text (plain) (machine_name: field_text_plain) field in our entity:
Allowed value: Plain text (for instance: Hello CSV)
Node example:
title,field_text_plain
Node 1,Hello CSVTaxonomy example:
name,field_text_plain
Term 1,Hello CSVUser example:
name,field_text_plain
User 1,Hello CSVHelp improve this page
You can:
- Log in, click Edit, and edit this page
- Log in, click Discuss, update the Page status value, and suggest an improvement
- Log in and create a Documentation issue with your suggestion
