Hi,
I have a Drupal7 site that shares a database with another application.. I would like to use views to publish data from the applications tables to users..
Anyone have any ideas how to do this??
I have searched the internet but not found anything.. Certainly nothing for D7..
TIA
You would have to write a views integration module to do this (expose the data) to your module. Normally I'd point you to the views 3 api documentation, but that doesn't appear to have been written yet. If you're interested in this approach you might try filing a support request asking how different the views 3 api is from the views 2 api which is documented.
You might also take a look at project forena, which is written as a more general report writing engine.
FULL DISCLOSURE: I'm the maintainer of the forena module.
________________________________
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Wipe_Out Sent: Friday, October 21, 2011 3:33 PM To: support@drupal.org Subject: [support] Accessing non-drupal tables with Views?
Hi,
I have a Drupal7 site that shares a database with another application.. I would like to use views to publish data from the applications tables to users..
Anyone have any ideas how to do this??
I have searched the internet but not found anything.. Certainly nothing for D7..
TIA
On 22 October 2011 00:04, Metzler, David metzlerd@evergreen.edu wrote:
**
You would have to write a views integration module to do this (expose the data) to your module. Normally I’d point you to the views 3 api documentation, but that doesn’t appear to have been written yet. If you’re interested in this approach you might try filing a support request asking how different the views 3 api is from the views 2 api which is documented.
You might also take a look at project forena, which is written as a more general report writing engine. ****
FULL DISCLOSURE: I’m the maintainer of the forena module. ****
Installed forena to have a look at.. Where do I find the "my reports" page
mentioned in the README?
There is documentation for views 3 (sort of) in the advanced help. But if you don't want to implement that module there's a copy on line, the page you are looking for is at http://views-help.doc.logrus.com/help/views/api-tables which helped but is a bit confusing (and possibly not complete), but when supplemented by this issue, http://drupal.org/node/370013, especially the PATCH in it, I was able to get something working using hook_views_data.
Gregg
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Metzler, David Sent: Friday, October 21, 2011 5:04 PM To: support@drupal.org Subject: Re: [support] Accessing non-drupal tables with Views?
You would have to write a views integration module to do this (expose the data) to your module. Normally I'd point you to the views 3 api documentation, but that doesn't appear to have been written yet. If you're interested in this approach you might try filing a support request asking how different the views 3 api is from the views 2 api which is documented.
You might also take a look at project forena, which is written as a more general report writing engine.
FULL DISCLOSURE: I'm the maintainer of the forena module.
_____
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Wipe_Out Sent: Friday, October 21, 2011 3:33 PM To: support@drupal.org Subject: [support] Accessing non-drupal tables with Views?
Hi,
I have a Drupal7 site that shares a database with another application.. I would like to use views to publish data from the applications tables to users..
Anyone have any ideas how to do this??
I have searched the internet but not found anything.. Certainly nothing for D7..
TIA
On 23 October 2011 04:00, Gregg Marshall mimlist@repconnection.com wrote:
There is documentation for views 3 (sort of) in the advanced help. But if you don't want to implement that module there's a copy on line, the page you are looking for is at http://views-help.doc.logrus.com/help/views/api-tables which helped but is a bit confusing (and possibly not complete), but when supplemented by this issue, http://drupal.org/node/370013, especially the PATCH in it, I was able to get something working using hook_views_data.****
Gregg****
Thanks Gregg.. Looks like I have some work to do (I'm not really a coder)..
Kind of wish there was a module to enable access to other tables.. Maybe one day.. :)
Take a look at Table Wizard (http://drupal.org/project/tw). Assuming your tables have been defined with a schema it does a reasonable job letting you expose a table to views. I started with that until I wanted to relate to a node. In theory you can define the node table and then do a relation, but in practice when I did it so confused views that you couldn't create a node view any more, it had replaced node views with array (pretty sure it was a bug, but I didn't feel like finding/fixing it). If you don't need a relationship to nodes, Table Wizard might be what you want.
Gregg
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Wipe_Out Sent: Sunday, October 23, 2011 3:43 AM To: support@drupal.org Subject: Re: [support] Accessing non-drupal tables with Views?
On 23 October 2011 04:00, Gregg Marshall mimlist@repconnection.com wrote:
There is documentation for views 3 (sort of) in the advanced help. But if you don't want to implement that module there's a copy on line, the page you are looking for is at http://views-help.doc.logrus.com/help/views/api-tables which helped but is a bit confusing (and possibly not complete), but when supplemented by this issue, http://drupal.org/node/370013, especially the PATCH in it, I was able to get something working using hook_views_data.
Gregg
Thanks Gregg.. Looks like I have some work to do (I'm not really a coder)..
Kind of wish there was a module to enable access to other tables.. Maybe one day.. :)
On Fri, Oct 21, 2011 at 11:32 PM, Wipe_Out wipe_out@users.sourceforge.netwrote:
Hi,
I have a Drupal7 site that shares a database with another application.. I would like to use views to publish data from the applications tables to users..
Anyone have any ideas how to do this??
Your best bet would be the data module. Check it out.
On 23 October 2011 19:39, Kayode Odeyemi dreyemi@gmail.com wrote:
On Fri, Oct 21, 2011 at 11:32 PM, Wipe_Out <wipe_out@users.sourceforge.net
wrote:
Hi,
I have a Drupal7 site that shares a database with another application.. I would like to use views to publish data from the applications tables to users..
Anyone have any ideas how to do this??
Your best bet would be the data module. Check it out.
Unfortunately I am on D7 and there doesn't appear to be a D7 version
available yet..
-
Gregg Marshall -
Kayode Odeyemi -
Metzler, David -
Wipe_Out