Views Questions - How to show the data from custom table
Hi All I have custom tables in mysql database. I want to have a view, where I want to show the data from custom tables in a tabular format with certain conditions. Example: *UID* *Name* *Email ID* *Alternate Email ID* *Phone number* *Alternte phone number* *DOB* *Years of experience* *Preferred work location* *Highest Qualification* 1 Austin austi@yahoo.com au@rediffmail.com 123456789 987654321 1/15/1975 10 Texas B.E (Electrical) 2 John john@yahoo.com jo@rediffmail.com 3333333333 5555555555 2/16/1989 6 Washington DC BSC 3 Russel r@yahoo.com r@rediffmail.com 777777777 99999999 3/8/1987 8 Seoul MSC Lets say, in a view I want to show data from this table with a condition. Let the condition is "people who work in Texas". I have now basic knowledge on views. Can somebody give me a step wise help , how to acheive this. Regards Austin
http://drupal.org/project/data On Thu, Apr 7, 2011 at 7:03 AM, Austin Einter <austin.einter@gmail.com>wrote:
Hi All I have custom tables in mysql database. I want to have a view, where I want to show the data from custom tables in a tabular format with certain conditions.
Example: *UID* *Name* *Email ID* *Alternate Email ID* *Phone number* *Alternte phone number* *DOB* *Years of experience* *Preferred work location* *Highest Qualification* 1 Austin austi@yahoo.com au@rediffmail.com 123456789 987654321 1/15/1975 10 Texas B.E (Electrical) 2 John john@yahoo.com jo@rediffmail.com 3333333333 5555555555 2/16/1989 6 Washington DC BSC 3 Russel r@yahoo.com r@rediffmail.com 777777777 99999999 3/8/1987 8 Seoul MSC
Lets say, in a view I want to show data from this table with a condition. Let the condition is "people who work in Texas".
I have now basic knowledge on views. Can somebody give me a step wise help , how to acheive this.
Regards Austin
-- [ Drupal support list | http://lists.drupal.org/ ]
Hi Victor Thanks for response. The link you have given is for data module. Does data module help to retreive the data from and show in *view*. What I am looking at his how do we show the custom table data in view. Regards Austin On Thu, Apr 7, 2011 at 3:49 PM, Victor Kane <victorkane@gmail.com> wrote:
http://drupal.org/project/data
On Thu, Apr 7, 2011 at 7:03 AM, Austin Einter <austin.einter@gmail.com>wrote:
Hi All I have custom tables in mysql database. I want to have a view, where I want to show the data from custom tables in a tabular format with certain conditions.
Example: *UID* *Name* *Email ID* *Alternate Email ID* *Phone number* *Alternte phone number* *DOB* *Years of experience* *Preferred work location* *Highest Qualification* 1 Austin austi@yahoo.com au@rediffmail.com 123456789 987654321 1/15/1975 10 Texas B.E (Electrical) 2 John john@yahoo.com jo@rediffmail.com 3333333333 5555555555 2/16/1989 6 Washington DC BSC 3 Russel r@yahoo.com r@rediffmail.com 777777777 99999999 3/8/1987 8 Seoul MSC
Lets say, in a view I want to show data from this table with a condition. Let the condition is "people who work in Texas".
I have now basic knowledge on views. Can somebody give me a step wise help , how to acheive this.
Regards Austin
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
Yes, the Data module makes your table available in a view. In fact, it creates a view for you with all of your table columns visible, and you can modify it from there. On Apr 7, 2011, at 4:25 AM, Austin Einter wrote:
Hi Victor Thanks for response.
The link you have given is for data module.
Does data module help to retreive the data from and show in view.
What I am looking at his how do we show the custom table data in view.
Regards Austin
On Thu, Apr 7, 2011 at 3:49 PM, Victor Kane <victorkane@gmail.com> wrote: http://drupal.org/project/data
On Thu, Apr 7, 2011 at 7:03 AM, Austin Einter <austin.einter@gmail.com> wrote: Hi All I have custom tables in mysql database. I want to have a view, where I want to show the data from custom tables in a tabular format with certain conditions.
Example: UID Name Email ID Alternate Email ID Phone number Alternte phone number DOB Years of experience Preferred work location Highest Qualification 1 Austin austi@yahoo.com au@rediffmail.com 123456789 987654321 1/15/1975 10 Texas B.E (Electrical) 2 John john@yahoo.com jo@rediffmail.com 3333333333 5555555555 2/16/1989 6 Washington DC BSC 3 Russel r@yahoo.com r@rediffmail.com 777777777 99999999 3/8/1987 8 Seoul MSC
Lets say, in a view I want to show data from this table with a condition. Let the condition is "people who work in Texas".
I have now basic knowledge on views. Can somebody give me a step wise help , how to acheive this.
Regards Austin
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
Anyone know if there is a Drupal 7 version planned or a promising looking equivalent? * Ryan LeTulle*
bayousoft <http://twitter.com/bayousoft> -twitter
On Thu, Apr 7, 2011 at 9:10 AM, Steve Edwards <killshot91@gmail.com> wrote:
Yes, the Data module makes your table available in a view. In fact, it creates a view for you with all of your table columns visible, and you can modify it from there.
On Apr 7, 2011, at 4:25 AM, Austin Einter wrote:
Hi Victor Thanks for response.
The link you have given is for data module.
Does data module help to retreive the data from and show in *view*.
What I am looking at his how do we show the custom table data in view.
Regards Austin
On Thu, Apr 7, 2011 at 3:49 PM, Victor Kane <victorkane@gmail.com> wrote:
http://drupal.org/project/data
On Thu, Apr 7, 2011 at 7:03 AM, Austin Einter <austin.einter@gmail.com>wrote:
Hi All I have custom tables in mysql database. I want to have a view, where I want to show the data from custom tables in a tabular format with certain conditions.
Example: *UID* *Name* *Email ID* *Alternate Email ID* *Phone number* *Alternte phone number* *DOB* *Years of experience* *Preferred work location* *Highest Qualification* 1 Austin austi@yahoo.com au@rediffmail.com 123456789 987654321 1/15/1975 10 Texas B.E (Electrical) 2 John john@yahoo.com jo@rediffmail.com 3333333333 5555555555 2/16/1989 6 Washington DC BSC 3 Russel r@yahoo.com r@rediffmail.com 777777777 99999999 3/8/1987 8 Seoul MSC
Lets say, in a view I want to show data from this table with a condition. Let the condition is "people who work in Texas".
I have now basic knowledge on views. Can somebody give me a step wise help , how to acheive this.
Regards Austin
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
nm lengthy discussion in the issues queue * Ryan LeTulle*
bayousoft <http://twitter.com/bayousoft> -twitter
On Thu, Apr 7, 2011 at 9:18 AM, Ryan LeTulle <bayousoft@gmail.com> wrote:
Anyone know if there is a Drupal 7 version planned or a promising looking equivalent? *
Ryan LeTulle*
bayousoft <http://twitter.com/bayousoft> -twitter
On Thu, Apr 7, 2011 at 9:10 AM, Steve Edwards <killshot91@gmail.com>wrote:
Yes, the Data module makes your table available in a view. In fact, it creates a view for you with all of your table columns visible, and you can modify it from there.
On Apr 7, 2011, at 4:25 AM, Austin Einter wrote:
Hi Victor Thanks for response.
The link you have given is for data module.
Does data module help to retreive the data from and show in *view*.
What I am looking at his how do we show the custom table data in view.
Regards Austin
On Thu, Apr 7, 2011 at 3:49 PM, Victor Kane <victorkane@gmail.com> wrote:
http://drupal.org/project/data
On Thu, Apr 7, 2011 at 7:03 AM, Austin Einter <austin.einter@gmail.com
wrote:
Hi All I have custom tables in mysql database. I want to have a view, where I want to show the data from custom tables in a tabular format with certain conditions.
Example: *UID* *Name* *Email ID* *Alternate Email ID* *Phone number* *Alternte phone number* *DOB* *Years of experience* *Preferred work location* *Highest Qualification* 1 Austin austi@yahoo.com au@rediffmail.com 123456789 987654321 1/15/1975 10 Texas B.E (Electrical) 2 John john@yahoo.com jo@rediffmail.com 3333333333 5555555555 2/16/1989 6 Washington DC BSC 3 Russel r@yahoo.com r@rediffmail.com 777777777 99999999 3/8/1987 8 Seoul MSC
Lets say, in a view I want to show data from this table with a condition. Let the condition is "people who work in Texas".
I have now basic knowledge on views. Can somebody give me a step wise help , how to acheive this.
Regards Austin
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
Hi All Thanks for great information. Now I have downloaded Data module and enabled all the related modules as mentioned below. 1. Schema , 2. Search, 3. Data, 4. Data Admin UI, 5. Data Node, 6. Data search and 7. Data Taxonomy (Do I need really those many modules, can I disable few from above) I am using Drupal 6.20. In my case, I have already tables created, data is entered through a form and saved into corresponding tables. So for table creation, deletion, storing data into table, deleting data from table is done by a custom module already developed. I am looking at Data module to scan through multiple tables with conditions (using JOIN, WHERE clause etc across tables) and show the filtered data in a view. But I am not able to locate the related documents that will guide me how to proceed further. On google search I found http://drupal.org/node/580650 provides some information, but probably not suffiecient. On further exploring, I went to Administer->Site Building->Data Tables. There I see a tab "Adopt tables". Under that I can see the tables created by my module (around 5 tables). Do I need to select those tables and adopt????? After doing adopt, if I select a particulr table I see multiple tabs such as " Edit schema, Edit title, Configure search, " etc, Do I need to alter any default thing here. And finally I saw the view creation page. I can see the tables those were created by my custom module. Looks I can select only one table at a time. I am looking for showing the records where a particular condition is met across multiple tables. Say show all the user records where user is 40 years old and working in Texas. How can I acheive it? Please bear with me for asking very basic questions. Regards Austin On Thu, Apr 7, 2011 at 7:50 PM, Ryan LeTulle <bayousoft@gmail.com> wrote:
nm lengthy discussion in the issues queue *
Ryan LeTulle*
bayousoft <http://twitter.com/bayousoft> -twitter
On Thu, Apr 7, 2011 at 9:18 AM, Ryan LeTulle <bayousoft@gmail.com> wrote:
Anyone know if there is a Drupal 7 version planned or a promising looking equivalent? *
Ryan LeTulle*
bayousoft <http://twitter.com/bayousoft> -twitter
On Thu, Apr 7, 2011 at 9:10 AM, Steve Edwards <killshot91@gmail.com>wrote:
Yes, the Data module makes your table available in a view. In fact, it creates a view for you with all of your table columns visible, and you can modify it from there.
On Apr 7, 2011, at 4:25 AM, Austin Einter wrote:
Hi Victor Thanks for response.
The link you have given is for data module.
Does data module help to retreive the data from and show in *view*.
What I am looking at his how do we show the custom table data in view.
Regards Austin
On Thu, Apr 7, 2011 at 3:49 PM, Victor Kane <victorkane@gmail.com>wrote:
http://drupal.org/project/data
On Thu, Apr 7, 2011 at 7:03 AM, Austin Einter < austin.einter@gmail.com> wrote:
Hi All I have custom tables in mysql database. I want to have a view, where I want to show the data from custom tables in a tabular format with certain conditions.
Example: *UID* *Name* *Email ID* *Alternate Email ID* *Phone number* *Alternte phone number* *DOB* *Years of experience* *Preferred work location* *Highest Qualification* 1 Austin austi@yahoo.com au@rediffmail.com 123456789 987654321 1/15/1975 10 Texas B.E (Electrical) 2 John john@yahoo.com jo@rediffmail.com 3333333333 5555555555 2/16/1989 6 Washington DC BSC 3 Russel r@yahoo.com r@rediffmail.com 777777777 99999999 3/8/1987 8 Seoul MSC
Lets say, in a view I want to show data from this table with a condition. Let the condition is "people who work in Texas".
I have now basic knowledge on views. Can somebody give me a step wise help , how to acheive this.
Regards Austin
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
Do you know how to program? Any chance of going to D7? If you can code a query and do a bit of PHP, I'd bet you can do this without any modules faster than unravelling all the modules. And it would be considerably easier with the new object form of queries in D7. But you get by the single table problem in Views by building relationships. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr. ________________________________ From: Austin Einter Now I have downloaded Data module and enabled all the related modules as mentioned below. 1. Schema , 2. Search, 3. Data, 4. Data Admin UI, 5. Data Node, 6. Data search and 7. Data Taxonomy (Do I need really those many modules, can I disable few from above) I am using Drupal 6.20. In my case, I have already tables created, data is entered through a form and saved into corresponding tables. So for table creation, deletion, storing data into table, deleting data from table is done by a custom module already developed. I am looking at Data module to scan through multiple tables with conditions (using JOIN, WHERE clause etc across tables) and show the filtered data in a view. But I am not able to locate the related documents that will guide me how to proceed further. On google search I found http://drupal.org/node/580650 provides some information, but probably not suffiecient. On further exploring, I went to Administer->Site Building->Data Tables. There I see a tab "Adopt tables". Under that I can see the tables created by my module (around 5 tables). Do I need to select those tables and adopt????? After doing adopt, if I select a particulr table I see multiple tabs such as " Edit schema, Edit title, Configure search, " etc, Do I need to alter any default thing here. And finally I saw the view creation page. I can see the tables those were created by my custom module. Looks I can select only one table at a time. I am looking for showing the records where a particular condition is met across multiple tables. Say show all the user records where user is 40 years old and working in Texas. How can I acheive it?
Thanks Nancy. D7, yes I need to move one day, but not now. In D6, I am trying either through available modules or through a custom module or PHP, want to show specific data in View. I have basic knowledge on PHP, SQL query (learnt recently - me from a different background C, assmbly -- etc), atleast a high level hint will help me to great extent. Best Regards Austin. On Fri, Apr 8, 2011 at 8:06 AM, nan wich <nan_wich@bellsouth.net> wrote:
Do you know how to program? Any chance of going to D7? If you can code a query and do a bit of PHP, I'd bet you can do this without any modules faster than unravelling all the modules. And it would be considerably easier with the new object form of queries in D7.
But you get by the single table problem in Views by building relationships.
*Nancy*
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
------------------------------ *From:* Austin Einter
Now I have downloaded Data module and enabled all the related modules as mentioned below. 1. Schema , 2. Search, 3. Data, 4. Data Admin UI, 5. Data Node, 6. Data search and 7. Data Taxonomy
(Do I need really those many modules, can I disable few from above)
I am using Drupal 6.20.
In my case, I have already tables created, data is entered through a form and saved into corresponding tables. So for table creation, deletion, storing data into table, deleting data from table is done by a custom module already developed.
I am looking at Data module to scan through multiple tables with conditions (using JOIN, WHERE clause etc across tables) and show the filtered data in a view.
But I am not able to locate the related documents that will guide me how to proceed further. On google search I found http://drupal.org/node/580650 provides some information, but probably not suffiecient.
On further exploring, I went to Administer->Site Building->Data Tables. There I see a tab "Adopt tables". Under that I can see the tables created by my module (around 5 tables). Do I need to select those tables and adopt?????
After doing adopt, if I select a particulr table I see multiple tabs such as " Edit schema, Edit title, Configure search, " etc, Do I need to alter any default thing here.
And finally I saw the view creation page. I can see the tables those were created by my custom module.
Looks I can select only one table at a time. I am looking for showing the records where a particular condition is met across multiple tables. Say show all the user records where user is 40 years old and working in Texas. How can I acheive it?
-- [ Drupal support list | http://lists.drupal.org/ ]
participants (5)
-
Austin Einter -
nan wich -
Ryan LeTulle -
Steve Edwards -
Victor Kane