Table Wizard
The Table Wizard facilitates dealing with database tables:
- It allows surfacing any table in the Drupal default database through Views 2.
- Relationships between the tables it manages can be defined, so views combining data in the tables can be constructed.
- It performs analysis of the tables it manages, reporting on empty fields, data ranges, ranges of string lengths, etc.
- It provides an API for other modules to views-enable their tables.
- It provides an API for importing data into tables in the Drupal default database (automatically doing the views integration above).
- It is bundled with an implementation of this API, for importing comma- and tab-delimited files.
Applications of Table Wizard include:
- Module developers can use Table Wizard to views-enable their data tables without writing their own Views hook.
- Developers and administrators can use Table Wizard to create views of all tables in the database, whether or not their creators provided Views integration.
- Data to be migrated into Drupal can be made available to the Migrate module.
- Users could upload spreadsheets and apply Views to them.
Requirements
Resources
- Angie from Lullabot introduces table wizard and migrater modules and provides a great tutorial.
- Cyrve presented their data migration process and tools at Drupalcon DC 2008. The video is available for free. Note that this is just one use case for table wizard module.
Status
Version 1.1 is now available. It adds significantly more flexibility in creating relationships - they can be defined as either Automatic (using Views joins) or Manual (using Views relationships), and tables exposed to views through other modules (such as node) can now have relationships to Table Wizard-managed tables.
These are currently the top priorities for 1.2:
- #498874: Handle date/time fields intelligently
- #429130: Add option to disable autocreated views by default
- #424448: Add quick way to ignore empty fields
- #392424: Handle large fields nicely
- #466550: Categorize and group tables
- #524324: Add ability to add notes/description to table
My primary focus for the forseeable future is the Migrate module, and I don't expect to be putting much time into the above issues before migrate reaches RC status. Any contributions from the community towards these issues, however, will be welcome.
Contributions
Contributed patches are welcome. Please be sure your patch applies against the latest CVS, and that you have run the Table Wizard simpletests cleanly, before submitting your patch.
Acknowledgements
Much of the Table Wizard functionality was sponsored by GenomeWeb and The Economist.
Releases
| Official releases | Date | Size | Links | Status | |
|---|---|---|---|---|---|
| 6.x-1.1 | 2009-Jul-22 | 28.86 KB | Download · Release notes | Recommended for 6.x |  |
| Development snapshots | Date | Size | Links | Status | |
|---|---|---|---|---|---|
| 6.x-1.x-dev | 2009-Nov-07 | 31.16 KB | Download · Release notes | Development snapshot |  |
