Create a record in custom database using the data from PrivateMembersData

Ask the community
,
1

Hi there,

Does anyone know how I can insert a record in a custom database with the information in the PrivateMembersData. Basically the PrivateMembersData is read only and I want to link the login email record on that database into a custom database collection that I can use for extended records and that a user can maintain.

2

Hi there,

You can always query the PrivateMembersData collection and insert a specific field into the new database.

Depending on how you’re registering new members you might be able to use data hooks to automatically insert records into the new collection after it has been inserted into your PrivateMembersData collection.

As alternative, you can also export your data from the members’ collection by field and import into the new collection, however, this is less practical.

Hope this helped.

Best regards,

3

Thanks Miguel,

As I am new to WiX, any recommendation as to which hooks do I use?

4

Hey,

If you are going to use data hooks then afterInsert() would probably work best for what you are trying to set up.

Hope this helps!

Dara | Corvid Team