Greetings all! Long time listener, first time poster!
For my project, I am trying to transfer some data from an old external database to a Wix collection. The old data was related to members with a separate userId, that was created before moving the project to Wix (so no relation between old user Id and wix member id).
My initial thought to create this relation was to add a custom field to the Contact’s info, which would hold the old user Id. Once this column was filled in, I could export the data containing the relationship between Wix member id and old id, then swap ids before importing the data into a collection.
I have two challenges I wanted to ask the community here:
-
I added the custom field, but I don’t see it showing up in the members or contacts collections, so I don’t know where I could access it to export that relationship. Where does that custom contact data live? Is there a better place to put said old ids to get access to it in a collection?
-
It strikes me that there should be a better way to update said data, if I could access that relationship (new to old ids), but would require the ability to execute bulk operations on the data (sql statements over a whole table). Does this ability exist for wix collections?
Thank you so much! This would get me past a large hurdle!