Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
Are there any examples of what this does? Is there a site that uses this that produces a table people can see?
also.. how do you set the primary key? I can't figure out the acronyms at the top of the fields. I see PF.. but I can't figure out how to change it.
I'm trying to create a table that is viewable and can be edited by users. Can I do this with table wizard? I was able to import the data, I see the fields.. but how do I view a table?
The purpose of Table Wizard is to make table data, and information about the data (the analysis page), available to the Views module and to administrators. Table Wizard does not support changing table definitions - that is not within the scope of the module. To change field types, set a primary key, etc. you need to use a database administration tool (MySQL Administrator, phpMyAdmin, etc.). Once your table has a primary key, there will be a default view of the table visible when clicking on the table name, and you can also create your own views using the table as a base.
Ahhh, I see some of your confusion, the help text on the analysis page had some obsolete information from when this was part of the migrate module, I've done some updating. At one point you could set the PK from the analysis page, but I decided that table manipulation was best done by tools designed for administering databases...
Comments
Comment #1
mikeryanDocumentation has been added to README.txt - feedback welcome.
Comment #2
ikati commentedAre there any examples of what this does? Is there a site that uses this that produces a table people can see?
also.. how do you set the primary key? I can't figure out the acronyms at the top of the fields. I see PF.. but I can't figure out how to change it.
I'm trying to create a table that is viewable and can be edited by users. Can I do this with table wizard? I was able to import the data, I see the fields.. but how do I view a table?
Ack.. I think I'm lost...
Comment #3
ikati commentedNot sure if this is a bug.. but I cannot change:
I read help, and it keeps telling me I need to specify a primary key.. but how do I do that if I can't edit PK?
kati
Comment #4
mikeryanThe purpose of Table Wizard is to make table data, and information about the data (the analysis page), available to the Views module and to administrators. Table Wizard does not support changing table definitions - that is not within the scope of the module. To change field types, set a primary key, etc. you need to use a database administration tool (MySQL Administrator, phpMyAdmin, etc.). Once your table has a primary key, there will be a default view of the table visible when clicking on the table name, and you can also create your own views using the table as a base.
Comment #5
mikeryanAhhh, I see some of your confusion, the help text on the analysis page had some obsolete information from when this was part of the migrate module, I've done some updating. At one point you could set the PK from the analysis page, but I decided that table manipulation was best done by tools designed for administering databases...
Comment #6
ikati commentedThanks, Mike.
I guess this isn't what I thought.. I guess I will try YUI DataTable (http://developer.yahoo.com/yui/datatable/)
Thanks anyway for explaining.
ikati
Comment #7
mikeryanDocumentation moved from README.txt to drupal.org.