Module Description
This module provides a field formatter that will display the contents of an uploaded file as a table. This allows you easily display and update table data on a site without importing as nodes or another entity. This module currently only supports CSV-formatted files.
This module can optionally be used with the DataTables module (https://drupal.org/project/datatables) to provide javascript client-side sorting of the generated tables.
Installation
* Copy the file_table_formatter module to sites/all/modules directory.
* Enable the module at Administer >> Modules.
Usage
* To configure the table formatter on a content type, go to Administer >> Structure >> Content Types.
* Add a file field to the content type, if necessary, under Manage Fields next to a specific content type.
* Click Manage Display next to the content type with your file field.
* Select "Display file contents as a table" from the Format box next to the file field.
* If your files have a header row, enable this feature by clicking the gear icon and checking the box.
* Click Save at the bottom of the page.
* Create a node of the selected type and upload a CSV-formatted file to the field you set the formatter on. When viewing the node, you should see tables displayed in place of file links.
* To add titles to the tables, use the file Description field.
To enable javascript sorting of tables:
* Download and install the DataTables module.
* Go to Manage Display for the content type with the file field you want to format.
* Click the gear next the field and check the "Use javascript sortable data tables" box.
* Click Save at the bottom of the page.
NOTE: DataTables tables with this formatter default to disabling pagination and a default sorting column. To enable these, override the theme_file_table_formatter_table() function in your theme.
Drupal 8+ Version It works, but does not have DataTables support. It can be added once the DataTables module is updated: https://www.drupal.org/node/2393345.
This module can optionally be used with the DataTables module (https://drupal.org/project/datatables) to provide javascript client-side sorting of the generated tables.
Installation
* Copy the file_table_formatter module to sites/all/modules directory.
* Enable the module at Administer >> Modules.
Usage
* To configure the table formatter on a content type, go to Administer >> Structure >> Content Types.
* Add a file field to the content type, if necessary, under Manage Fields next to a specific content type.
* Click Manage Display next to the content type with your file field.
* Select "Display file contents as a table" from the Format box next to the file field.
* If your files have a header row, enable this feature by clicking the gear icon and checking the box.
* Click Save at the bottom of the page.
* Create a node of the selected type and upload a CSV-formatted file to the field you set the formatter on. When viewing the node, you should see tables displayed in place of file links.
* To add titles to the tables, use the file Description field.
To enable javascript sorting of tables:
* Download and install the DataTables module.
* Go to Manage Display for the content type with the file field you want to format.
* Click the gear next the field and check the "Use javascript sortable data tables" box.
* Click Save at the bottom of the page.
NOTE: DataTables tables with this formatter default to disabling pagination and a default sorting column. To enable these, override the theme_file_table_formatter_table() function in your theme.
Drupal 8+ Version It works, but does not have DataTables support. It can be added once the DataTables module is updated: https://www.drupal.org/node/2393345.
Module Link
Project Usage
205
Security Covered
Covered By Security Advisory
Version Available
Production
Module Summary
This module solves the problem of displaying and updating table data on a site without importing as nodes or another entity by providing a field formatter that displays the contents of an uploaded file as a table, with optional support for javascript client-side sorting using the DataTables module.
Data Name
file_table_formatter