Ansel/Treasury Data Migration Method?
We are migrating an older client site (currently EE4 using Ansel/Treasury) from a multi-channel site with hundreds of content creators, to a new EE4 site with a single channel (“Combined” site) in an effort to streamline content entry for clients.
The Ansel field uses Treasury locations (AWS backed) and contain a significant amount of images using 2 buckets - “Originals” and “Edited” (for the cropped versions). These same locations will be used in the exact configuration for the “Combined” site.
Both sites utilize the Ansel field for this gallery function.
We are using Datagrab to migrate the entries, however need to identify the best way for the new entries on the “Combined” site to have Ansel/Treasury awareness of the existing content and correlated correctly with original article.
Is this possible, and what might be the best way to go about this?
Alright, so here’s the high overview of the data structure:
- Ansel has one row for each image in a field
- That row contains the entry ID, field ID (and possibly row ID and column ID for Grid/Bloqs)
- The row also contains the file IDs of the images needed for that row. This includes the original (source) file ID, the generated file ID, and the thumbnail file ID.
- For its part, Treasury has a row for each image. Since you’re images are all on AWS all you need is for the locations on your new combined site to be set up correctly, and bring the rows for those images over and associate them with the correct location(s) you set up in Treasury.
- Then you should be able to insert Ansel’s rows and associate them with the correct entry IDs and field IDs.
The tricky part is all associations are based on primary key, which may be different depending on how you get that data into your new site’s database. But there should be ways of importing those rows that retain the previous primary key.
Does any of that make sense? :)
April 16, 2018, 10:50 am
It sure does, and clarifies that we will either need Datagrab to be aware of this architecture (not just see it as a single field), or utilize another migration method. Thanks!
April 16, 2018, 11:33 am
Your account with the old support system does not carry over to the new support system. The new system is all tied together and connected with your account for purchasing and licenses. If you have a license, you have an account and you can log in with that email address and password. If you have not set a new password yet, you can do so with the forgot password link. Very sorry for any inconvenience.