« Receive Drupal Security Announcements | Main | Vista and viruses »

August 15, 2010

Storing data in tables (not csv's)

Updated section on the Data module with pointers to relevant forum posts.

Spent the morning investigating the ways in which a datafile can be stored in drupal. As with images and other complex questions, there are many (attempts at) solutions:

Warrant further investigation:
Webform module - could work for data entry because one webform is a node and each form submission ends up as a row in a table. Views compatibility seems to exist. Would need a separate solution to cover datafiles that are already digital?

Data module helps you model, manage and query related sets of tables. See posts #1 and #6 in this thread. This post hits on D7 and has a few other tidbits as well.

Discussion about moving Data to D7.

While you're not obligated to install it, you need the Schema module for the GUI in Data to work.

Table Wizard module - somehow similar to Data module. Compatible with Views2

CCK TableField module allows you to attach tabular data to a node in Drupal 6 or any entity in Drupal 7. Data is stored in a single db field so I don't know how handy it is for large datasets. CSV import available but primitive. Views can display the table.

Node Table module provides functionality for creating, uploading, editing, and presenting HTML tables within nodes or as nodes. Similar to table manager.

Dead in the water:
Dataset module is for grouping nodes together in sets. Nice name, not relevant

Table Manager module - the maintainer is trying to merge this module with Node Table.

Views Table Group Module is a Views style plugin to display Views results as cells in a table, grouping by row and column. - 1 dev commit thus far, although no bugs.

Cool but not relevant:
DataTables module appears to be for theming Views table views. Still in dev.

Posted by kkwaiser at August 15, 2010 11:24 AM

Comments

Login to leave a comment. Create a new account.