UNI and P4CA - Course manual repository

Format options

Export format

Warning: Opening delimited text files with spreadsheet applications may expose you to formula injection or other security vulnerabilities. When the submissions contain data from untrusted users and the downloaded file will be used with Microsoft Excel, use 'HTML table' format.

Use UUIDs for all entity references

Warning: Opening delimited text files with spreadsheet applications may expose you to formula injection or other security vulnerabilities. When the submissions contain data from untrusted users and the downloaded file will be used with Microsoft Excel, use 'HTML table' format.

Delimiter text format

Generate Excel compatible file

Open HTML table in Excel

File name

Element options

Element multiple values delimiter

Header options

Column header format

Element titles (label)

Element keys (key)

Include an element's title with all sub elements and values in each column header

Column header label delimiter

Column header key delimiter

Select menu, radio buttons, and checkboxes options

Options single value format

Compact, with the option values delimited by commas in one column.

Separate, with each possible option value in its own column.

Options multiple values format

Compact, with the option values delimited by commas in one column.

Separate, with each possible option value in its own column.

Options item format

Option labels, the human-readable value (label)

Option values, the raw value stored in the database (key)

Entity reference options

Entity reference format

ID, an entity's unique identified

Title, an entity's title/label

URL, an entity's URL

Column options

	Title	Name	Date type/Element type
Serial number	Serial number	serial	integer
Submission ID	Submission ID	sid	integer
Submission UUID	Submission UUID	uuid	uuid
Submission URI	Submission URI	uri	string
Created	Created	created	created
Completed	Completed	completed	timestamp
Changed	Changed	changed	changed
Is draft	Is draft	in_draft	boolean
Current page	Current page	current_page	string
Remote IP address	Remote IP address	remote_addr	string
Submitted by	Submitted by	uid	entity_reference
Language	Language	langcode	language
Webform	Webform	webform_id	entity_reference
Submitted to: Entity type	Submitted to: Entity type	entity_type	string
Submitted to: Entity ID	Submitted to: Entity ID	entity_id	string
Locked	Locked	locked	boolean
Sticky	Sticky	sticky	boolean
Notes	Notes	notes	string_long
Course name	Course name	course_name	textfield
Name of academic (owner of the material)	Name of academic (owner of the material)	name_of_academic_owner_of_the_material_	textfield
Email address	Email address	email_address	email
Topic	Topic	topic	checkboxes
Course website	Course website	course_website	url
Main course information	Main course information	main_course_information	textarea
Geographical scale	Geographical scale	geographical_scale	checkboxes
Region Examined	Region Examined	region_examined	checkboxes
Language	Language	language	checkboxes
Other language: Please specify	Other language: Please specify	other_language_please_specify	textfield
Level of Instruction	Level of Instruction	level_of_instruction	checkboxes
Year of publication (last updated max 5 years ago)	Year of publication (last updated max 5 years ago)	year	number
Course manual	Course manual	course_manual	webform_document_file
Reading list	Reading list	reading_list	webform_document_file
Assignments/Exams	Assignments/Exams	assignments_exams	webform_document_file
Study Guides	Study Guides	study_guides	webform_document_file
Other materials	Other materials	other_materials	webform_document_file
Accepted	Accepted	accepted	checkbox