Forum Discussion

sandeepr's avatar
sandeepr
New Contributor II
3 years ago

Moving data from one member to another.

HI All,

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?

Thanks,

Sandeep

Admin
Finance
  • jrk's avatar
    jrk
    New Contributor III
    3 years ago

    1. What will happen if I rename Member A to Member B, is this work ? I mean data move from MemberA to Member B?

    This option works, renaming member a to member b will move the data as well

  • Cosimo's avatar
    Cosimo
    Contributor II
    3 years ago

    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. 

  • jrk's avatar
    jrk
    New Contributor III
    3 years ago

    That's what happens technically at the background,

    Putting it in a simple way its nothing but Member A data will be displayed for Member B going forward after the rename