Forums

I'm setting up what is intended to just be a table of data, pulled from user profiles
I just want to show their avatar, first and last name, and a description (from their profile)
and I'm not getting any errors, but nothing is populating

I'm pulling data from a table created by Membership Pro

I have read and reread, and recreated the view, function and event, and I can't seem to figure out why this isn't working

any help in resolving this would be appreaciated

Hi tmonsta ,
​
It's not possible to say much from the info here. What do you see if you enable the CC Debugger? Does the query shown there work correctly if you test it in PHPMyAdmin?
​
Bob

is there good documentation somewhere? i read through the FAQs the 3 tutorial documents, but they focus on pulling articles.

as for the debugging... i didn't know chrono connect had a debugger. where would i turn that on at.

sorry for the newb questions. i'm very experienced with joomla, but the lack of documentation on this one is making getting started a bit difficult.

I have some of the fields populating. i'm having some issues with the custom fields from membership pro, and i think that has something to do with how it stores the data

there's a table called osm-membershipfields and then it stores them by field id, which in this case is 23.
is there a way I need to set up that function

Hi tmonsta,
​
Connectivity works well and easily with horizontal tables, when a table is connected to another using a foreign key, but some tables store the data virtually, like the Joomla profile fields table for example and this makes managing the data harder.
​
if this is how the data is stored in your case then you will need to post some screenshots of the tables here and I will try to let you know how you can manage the steup in Connectivity.
​
Best regards

Here is an example

thanks so much for your help

Hi Max
​
Hadn't heard back for how to display this data in combination with the profile fields. I tried a couple of things, but nothing so far has worked.

the data I want to display is in the orange circled field.

It's field_id 23. I haven't seen any documentation for chronoconnectivity 6 on how to filter results
​
Thanks

I know exactly what the SQL query should be, but cant figure out how to set it up in the plugin.

Hi tmonsta,
​
You have a vertical table and reading the data will not be straight forward, you will need to retrieve each user's profile fields values using a an associated model and set the relation type to "Multiple records", and set the relation conditions to associate the tables using the "subscriber_id" field, this should retrieve the user profile fields values but in order to display them in the the table in the user's row you will need to modify the data structure before its used in the table using PHP, I can help you with that, but please set up the "Read data" first and add a debugger after the "Read data" then post the debugger output here to make sure the data is setup correctly.
​
Best regards