Multiple fields in a table rather than one per table?
Hi, I am wanting to create some custom fields in the user profile but it seems that D7 creates a new table for each field which isn't logical in some instances.. For example I want to get users to put in their addresses on their user profiles.. So I want to have fields for.. House number Address line 1 Address line 2 County / State Country Code By default this would create 6 tables.. How do I get D7 to create a single table with the 7 fields? Thanks for any help..
Isn't that what Field Groups do? Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
________________________________ From: Wipe_Out <wipe_out@users.sourceforge.net> To: support@drupal.org Sent: Saturday, July 9, 2011 6:23 PM Subject: [support] Multiple fields in a table rather than one per table?
Hi, I am wanting to create some custom fields in the user profile but it seems that D7 creates a new table for each field which isn't logical in some instances.. For example I want to get users to put in their addresses on their user profiles.. So I want to have fields for.. House number Address line 1 Address line 2 County / State Country Code By default this would create 6 tables.. How do I get D7 to create a single table with the 7 fields? Thanks for any help.. -- [ Drupal support list | http://lists.drupal.org/ ]
Hi Nancy, As I understand it Field Groups is for grouping fields together for presentation on the site, it doesn't change the way each field is stored in a separate table in the database.. I may be wrong and if someone can confirm this it would be great.. Thanks.. On 10 July 2011 00:31, Ms. Nancy Wichmann <nan_wich@bellsouth.net> wrote:
Isn't that what Field Groups do?
*Nancy*
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
------------------------------ *From:* Wipe_Out <wipe_out@users.sourceforge.net> *To:* support@drupal.org *Sent:* Saturday, July 9, 2011 6:23 PM *Subject:* [support] Multiple fields in a table rather than one per table?
Hi, I am wanting to create some custom fields in the user profile but it seems that D7 creates a new table for each field which isn't logical in some instances.. For example I want to get users to put in their addresses on their user profiles.. So I want to have fields for.. House number Address line 1 Address line 2 County / State Country Code By default this would create 6 tables.. How do I get D7 to create a single table with the 7 fields? Thanks for any help..
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
Wipe_Out wrote:
Hi Nancy,
As I understand it Field Groups is for grouping fields together for presentation on the site, it doesn't change the way each field is stored in a separate table in the database.. I may be wrong and if someone can confirm this it would be great..
One file per field has always been the way the profile module worked its magic. If you want something else you'll have to find another module or write one yourself using the form hooks and your own DB table or perhaps store the data in the user data column using the user hooks. -- Earnie -- http://progw.com -- http://www.for-my-kids.com
Hi Ernie, Thanks for the clarification.. At least I know for sure what I am working with and so can decide how to work around it.. On 10 July 2011 14:37, Earnie Boyd <earnie@users.sourceforge.net> wrote:
Wipe_Out wrote:
Hi Nancy,
As I understand it Field Groups is for grouping fields together for presentation on the site, it doesn't change the way each field is stored in a separate table in the database.. I may be wrong and if someone can confirm this it would be great..
One file per field has always been the way the profile module worked its magic. If you want something else you'll have to find another module or write one yourself using the form hooks and your own DB table or perhaps store the data in the user data column using the user hooks.
-- Earnie -- http://progw.com -- http://www.for-my-kids.com -- [ Drupal support list | http://lists.drupal.org/ ]
You might try content_profile module. It stores profiles as cck elements, so it probably would work to get them all into one table. -----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Earnie Boyd Sent: Sunday, July 10, 2011 6:38 AM To: support@drupal.org Subject: Re: [support] Multiple fields in a table rather than one per table? Wipe_Out wrote:
Hi Nancy,
As I understand it Field Groups is for grouping fields together for presentation on the site, it doesn't change the way each field is stored in a separate table in the database.. I may be wrong and if someone can confirm this it would be great..
One file per field has always been the way the profile module worked its magic. If you want something else you'll have to find another module or write one yourself using the form hooks and your own DB table or perhaps store the data in the user data column using the user hooks. -- Earnie -- http://progw.com -- http://www.for-my-kids.com -- [ Drupal support list | http://lists.drupal.org/ ]
Hi David, I am using D7 so as I understand it the core fields module is the new cck so its what I am using by default.. On 11 July 2011 16:44, Metzler, David <metzlerd@evergreen.edu> wrote:
You might try content_profile module. It stores profiles as cck elements, so it probably would work to get them all into one table.
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Earnie Boyd Sent: Sunday, July 10, 2011 6:38 AM To: support@drupal.org Subject: Re: [support] Multiple fields in a table rather than one per table?
Wipe_Out wrote:
Hi Nancy,
As I understand it Field Groups is for grouping fields together for presentation on the site, it doesn't change the way each field is stored in a separate table in the database.. I may be wrong and if someone can confirm this it would be great..
One file per field has always been the way the profile module worked its magic. If you want something else you'll have to find another module or write one yourself using the form hooks and your own DB table or perhaps store the data in the user data column using the user hooks.
-- Earnie -- http://progw.com -- http://www.for-my-kids.com -- [ Drupal support list | http://lists.drupal.org/ ] -- [ Drupal support list | http://lists.drupal.org/ ]
participants (4)
-
Earnie Boyd -
Metzler, David -
Ms. Nancy Wichmann -
Wipe_Out