Copying Private Member Database Images to Another Database

Ask the community
, ,
1

I was needing some help figuring out if I am able to copy the profile image file from our site members in the Wix Private Member Database to another database that has a full roster of our organization’s members. We have a public page that will show the officers of our organization and then we have a private site member area that shows all of the members in a roster.

Originally, I had both databases linked to show the profile image from the site member’s Private Member Database along side member info from the 2nd Full Member roster database. These were linked by the user email. However, I discovered 2 things that became issues with this: 1) The only way for the profile images to show were if those viewing the pages were approved site members otherwise no image would be shown and 2) it did not always show images even to other approved site members which I can only guess is related to permissions associated with the Wix Private Member Database.

I am thinking that the ideal way to fix this would be to copy the site member’s profile image directly to the 2nd full roster database via a On Click Event or Data Hook however I am not having much luck with acquiring the actual image file. Any help or suggestions would be appreciated.

1 Like
2

Have you seen the Corvid page for Members/PrivateMembersData collection from the Wix Members app itself?
https://support.wix.com/en/article/corvid-wix-members-privatemembersdata-collection-fields

Also, you can get around these permissions if you use Wix Data Options.
https://www.wix.com/corvid/reference/wix-data.html#WixDataOptions

You might also want to make your own members profile pages as like in this tutorial here.
https://support.wix.com/en/article/corvid-tutorial-building-your-own-members-area

3

@givemeawhisky i too facing the same issue.

As per the link:

  1. The PrivateMembersData collection has the following permissions:
    Read: Site member author
    Create: None
    Update: None
    Delete: None

I am having a page , as a winner dash board, where i need to show the pictures of the site members.As the page is a public one , the images are not displaying properly. Only the author can see his image and rest everything is blank.I have used the default Sign up option including the social media login for my site. So almost all the contacts are having profile pic. Can you just point out how to use that images ?

4

Hello,

I also facing the same issue. I do also need private member data to display in the home page. Have you solved this issue or how did you accomplished for your use case?

5

@contactbattlevisa I also have the same issue. Did you found any solution?

6

Did you found any solution?

7

GOS, thanks for the links. I had come across those but I still could not get the action I needed from it. Granted, I am only an intermediate at this and still learning. In my situation, after thinking through the process and what was needed, I ended up determining that utilizing the Private Member Database (PMD) was actually not a beneficial solution for my needs.

For those asking…

In our case, we had a detailed membership roster that we needed to display internally to members only but then we needed to display certain members for any public visitor to see because they were leaders within the organization and those displayed had to be easily modified when the filled position was changed with a new member each year without editing every public page manually.

Two of the main issues I came across with using the PMD was: 1) only actual members who were signed in could see the pictures and info while visitors could not in the public spaces of the website. 2) Only a small number of our members were going to the website to register and upload their information so there was not a significant amount of listings. In addition to this, our leaders (who would not have dashboard / back-end access) needed to have a way to update certain information for each member along with updating a photo of them manually when needed.

So for my solution, I ended up creating 2 databases for members. The 1st database consisted of importing data from our main membership CSV file that we get from the corporate side of things. I used our member ID as the actual _ID key within the database collection since they are unique. This imported data would just override any information previously listed in the collection because of a variety of changes that could occur from the corp end.

The 2nd database created was for the “additional member data” which consisted of the picture, leadership positions, and some other pieces of changeable info. For this one, I only imported 3 pieces of info from the original CSV file (I have an excel macro tool that I created to help separate and export the info in the format needed) but unlike the 1st one, this imports by only copying new members based on their _ID key and not overriding the original data.

I have a member update form on the front end that Leaders have access to where they can go in and update the info needed in the 2nd database. With this done, the member ID / ID key in both databases allow me to link them to together easily when needed to pull info out to display in both the members only pages and also the public view pages.