I am working on script to copy data from one channel member A to channel member B (New member), requirement here is to copy Actual, planning and forecast data. After data copy Member A become parent and Member B become children for Member A.
As per my knowledge this can be achieved with below mentioned options.
1. Right custom script copy data from Member A to Member B.
2. Export data from Member A and load back into Member B.
apart from this are there other ways like mentioned below.
1. What will happen if I rename Member A to Member B, is this work ? I mean data move from MemberA to Member B?
2. Post creating member B, is there any workaround to map Member A data to Member B by changing reference back end tables?
Technically speaking, renaming a member doesn't move data from old member to new. All data records will use Member IDs to reference cell intersections. As you rename a member, you're only updating the member name to an existing member ID.
Renaming a member from A to B and then creating a new Member A as a parent to B is the quickest way to achieve what you're looking for.