Available MIME types

Image/JPEG
Text/Plain
Application/Octetstream
Image/PNG
Text/Octetstream

Available browser display transformations

Browser display transformation	Description
Application/Octetstream: Download	Displays a link to download the binary data of the column. You can use the first option to specify the filename, or use the second option as the name of a column which contains the filename. If you use the second option, you need to set the first option to the empty string.
Application/Octetstream: Hex	Displays hexadecimal representation of data. Optional first parameter specifies how often space will be added (defaults to 2 nibbles).
Image/JPEG: Inline	Displays a clickable thumbnail. The options are the maximum width and height in pixels. The original aspect ratio is preserved.
Image/JPEG: Link	Displays a link to download this image.
Image/PNG: Inline	Displays a clickable thumbnail. The options are the maximum width and height in pixels. The original aspect ratio is preserved.
Text/Octetstream: Sql	Formats text as SQL query with syntax highlighting.
Text/Plain: Binarytoip	Converts an Internet network address stored as a binary string into a string in Internet standard (IPv4/IPv6) format.
Text/Plain: Bool2Text	Converts Boolean values to text (default 'T' and 'F'). First option is for TRUE, second for FALSE. Nonzero=true.
Text/Plain: Dateformat	Displays a TIME, TIMESTAMP, DATETIME or numeric unix timestamp column as formatted date. The first option is the offset (in hours) which will be added to the timestamp (Default: 0). Use second option to specify a different date/time format string. Third option determines whether you want to see local date or UTC one (use "local" or "utc" strings) for that. According to that, date format has different value - for "local" see the documentation for PHP's strftime() function and for "utc" it is done using gmdate() function.
Text/Plain: External	LINUX ONLY: Launches an external application and feeds it the column data via standard input. Returns the standard output of the application. The default is Tidy, to pretty-print HTML code. For security reasons, you have to manually edit the file libraries/classes/Plugins/Transformations/Output/Text_Plain_External.php and list the tools you want to make available. The first option is then the number of the program you want to use and the second option is the parameters for the program. The third option, if set to 1, will convert the output using htmlspecialchars() (Default 1). The fourth option, if set to 1, will prevent wrapping and ensure that the output appears all on one line (Default 1).
Text/Plain: Formatted	Displays the contents of the column as-is, without running it through htmlspecialchars(). That is, the column is assumed to contain valid HTML.
Text/Plain: Imagelink	Displays an image and a link; the column contains the filename. The first option is a URL prefix like "https://www.example.com/". The second and third options are the width and the height in pixels.
Text/Plain: Json	Formats text as JSON with syntax highlighting.
Text/Plain: Sql	Formats text as SQL query with syntax highlighting.
Text/Plain: Xml	Formats text as XML with syntax highlighting.
Text/Plain: Link	Displays a link; the column contains the filename. The first option is a URL prefix like "https://www.example.com/". The second option is a title for the link.
Text/Plain: Longtoipv4	Converts an (IPv4) Internet network address stored as a BIGINT into a string in Internet standard dotted format.
Text/Plain: PreApPend	Prepends and/or Appends text to a string. First option is text to be prepended, second is appended (enclosed in single quotes, default empty string).
Text/Plain: Substring	Displays a part of a string. The first option is the number of characters to skip from the beginning of the string (Default 0). The second option is the number of characters to return (Default: until end of string). The third option is the string to append and/or prepend when truncation occurs (Default: "…").

Available input transformations

Input transformation	Description
Image/JPEG: Upload	Image upload functionality which also displays a thumbnail. The options are the width and height of the thumbnail in pixels. Defaults to 100 X 100.
Text/Plain: FileUpload	File upload functionality for TEXT columns. It does not have a textarea for input.
Text/Plain: Iptobinary	Converts an Internet network address in (IPv4/IPv6) format to binary
Text/Plain: JsonEditor	Syntax highlighted CodeMirror editor for JSON.
Text/Plain: RegexValidation	Validates the string using regular expression and performs insert only if string matches it. The first option is the Regular Expression.
Text/Plain: SqlEditor	Syntax highlighted CodeMirror editor for SQL.
Text/Plain: XmlEditor	Syntax highlighted CodeMirror editor for XML (and HTML).
Text/Plain: Link	Displays a link; the column contains the filename. The first option is a URL prefix like "https://www.example.com/". The second option is a title for the link.
Text/Plain: Longtoipv4	Converts an (IPv4) Internet network address stored as a BIGINT into a string in Internet standard dotted format.
Text/Plain: PreApPend	Prepends and/or Appends text to a string. First option is text to be prepended, second is appended (enclosed in single quotes, default empty string).
Text/Plain: Substring	Displays a part of a string. The first option is the number of characters to skip from the beginning of the string (Default 0). The second option is the number of characters to return (Default: until end of string). The third option is the string to append and/or prepend when truncation occurs (Default: "…").