Status:
Answered
Is there a way to access MS data in Views?
Is there a way to access MS data in Views?
It would be useful to expose membership start and end dates and maybe the membership status. I have two membership plans that are not handled by PayPal and it would be useful to combine lists.
Looking at this from another angle, I am not too clear what the manual membership creation within MS actually does. Could it manage manual postal subscriptions or does it still link back to PayPal?
I will definitely be including Views support in the next release, exposing Memberships and Membership Plans to views. I will also try and get Views support in for MS Core, exposing Order data to views.
The manual adding of a membership to a user was meant for situations like accepting Postal payments, since it doesn't 'speak' with PayPal at all.
Sincerely,
Leighton Whiting
Update on this, Views is now supported by Membership Suite and MS Core :)
Sincerely,
Leighton Whiting
I have been testing the views integration - which is most welcome!
A couple of comments -
When setting up filters in a view of type 'Membership', I need to set an exposed filter using the User-Roles field. The user-roles field is missing and also in the fields list.
It would also be useful to set a relationship to MS data in other views - this is missing.
I am testing this on a local WAMP setup - it does have a few errors so this could be caused by my local set-up - would be useful to know if it is?
Weiran,
I have added the User Roles filter and fields, I forgot that Drupal handles user roles with a separate table.
Can you expand a bit on the Relationships functionality you are after? I'm not really familiar with how Relationships work yet.
Sincerely,
Leighton Whiting
I would hope to be able to set a relationship to MS data in a View of type 'User' or Node' maybe. As I use Content Profile module to create profile fields as nodes, it could be useful to add MS fields to a node view.
It's not essential - what you have provided in MS 6.8 is very useful. I would be more interested in having reminders for PayPal recurring payments (see
http://www.moneyscripts.net/forums/support/2010/05/17/recurring-payments). I guess I can now set this up as a manual operation using Views Bulk Operations (not tried this yet).
I'll hold off on the Relationships for the time being, and add a +1 to the Recurring Payment notifications and [cancelLink] tokens.
Sincerely,
Leighton Whiting
Are you sure that views has the ability to interact with memberships? I have the latest version of views and ms_membership-6.x-6.10 and I can't access the information in views from the moneyscript membership suite.
Also will you consider doing a CSV export or is it possible to do a CSV export with a custom views report?
I had the same problem. I'm not sure why but you have to create a completely new view using the view type "Membership" or "Membership Plan". Wouldn't it make a lot more sense to incorporate the membership fields into the "User" view type?
I have added the Membership View type onto the Users View type which offers some limited access to the Membership objects of Users. You won't be able to access things like the Membership Plan name and other variables unless you use the Membership view type.
Sincerely,
Leighton Whiting
Weiran,
The only module which exposes it's data to views currently is File Downloads Suite. I have been meaning to do the same thing for Membership Suite and the others.
What data would you like to see exposed?
I am thinking I could make a new view type that will show Memberships, and all of their attributes, and another view type that will show Membership Plans.
Sincerely,
Leighton Whiting