Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Steps to Merging

Table of Contents
minLevel1
maxLevel2
style


Related Helpguide Pages

Panel
panelIconIdatlassian-note
panelIcon:note:
panelIconText:note:
bgColor#DEEBFF

Learn how to combine multiple records together with a merge

When you have duplicate records in your platform, such as the same person listed as a User two or more times, it can quickly become tricky to search through, sort, use, and report on your information. The merge functionality in your accessplanit platform resolves these problems! Merging consolidates two or more separate records into a single one, to eliminate duplicate data and ensure your data is easier to keep up to date within your platform.

Merge option

Merging is available in your platform for:

  • Users

  • Accounts

  • Course Templates

  • Courses

  • Awards

  • Job Roles

Follow this page to learn the steps for merging records together.

Note

Please Note
Once a merge has been completed , this CANNOT it cannot be reversed, we recommend that you take your time with every merge that you complete.


✏️ How to merge Users

Panel
panelIconId17657261-765d-4027-b044-d86a9501c52f
panelIcon:accessplaniticon:
panelIconText:accessplaniticon:
bgColor#DEEBFF

This step will take you through the steps on how to merge two or more duplicate User records into one

Expand
titleMerging Users
  1. Open the ‘Users’ DataGrid from your main navigation menu on the left

    Main navigation menu Users selected

  2. This will take you to the Users DataGrid

    Users DataGrid

  3. Find the User that you wish to Merge by applying filters and/or searching the User’s DataGrid

    Search bar and filters users datagrid

  4. Select the duplicate records by clicking on them so that they have a blue-background

    Both users highlighted

  5. Click the mass action drop down at the top left of your DataGrid and click the ‘Merge’ option

    Mass action Merge option selected

  6. The ‘Merge Users’ pop up window will appear, click the ‘Select’ button to choose which User will act as your primary User to keep

    Merge Users pop up box

  7. From the new pop-over DataGrid, your selected Users will appear, we advise adding in the ‘User ID' column so you can ensure you are keeping the correct record
    Visit our dedicated page on adding a new column to your DataGrid

    both users within datagrid

  8. Select the User record you wish to keep by ticking the Checkbox and highlighting that User
    The User you select here determines what information will be kept where there is a clash, for example if the Users that are being merged all have a different Email Address, following the merge the Email Address that will be kept is the one assigned to your ‘Record to keep’ User.

    selected User account to keep within datagrid

  9. Click the ‘OK’ button

    OK button

  10. This will add the Record into the ‘Record To Keep’ selector

    User to keep now showing in field

  11. Click the ‘Merge’ button to merge the records

    Merge button

  12. A pop up will appear asking you to confirm that you want to merge the Selected Users into one, click the ‘Yes’ button to confirm

    Information pop up

  13. Your User records have now been merged

    single User record now showing in DataGrid

Please Note
When merging users, features like User Awards and Past Courses are combined. However, DataGrid Filters, such as those for the Class Courses DataGrid, get replaced. Only the filters from the user record chosen as the one to 'keep' remain. This works the same way for user information like Email Address and Billing Address, where the details from the chosen 'keep' record overwrite those of the other record.


📁 How to merge Accounts

Panel
panelIconId17657261-765d-4027-b044-d86a9501c52f
panelIcon:accessplaniticon:
panelIconText:accessplaniticon:
bgColor#DEEBFF

This step will take you through the steps on how to merge two or more duplicate User records into one

Expand
titleMerging Accounts
  1. Open the ‘Accounts’ DataGrid from your main navigation menu on the left

    Main navigation menu - Accounts selected

  2. This will take you to the Accounts DataGrid

    accounts datagrid

  3. Find the Account that you wish to merge by applying filters and/or searching the Account’s DataGrid

    filters and search bar on datagrid

  4. Select the duplicate records by clicking on them so that they have a blue-background

    both accounts highlighted

  5. Click the mass action drop down at the top left of your DataGrid and click the ‘Merge’ option

    mass action - merge option selected

  6. The ‘Merge Accounts’ pop up window will appear, click the ‘Select’ button on the ‘Record to Keep’ option

    Merge accounts pop up

  7. Your selected Account records will appear, we advise adding in the ‘Account ID' column so you can ensure you are keeping the correct record
    Visit our dedicated page on adding a new column to your DataGrid

    both accounts showing within datagrid

  8. Select the Account record you wish to keep by ticking the Checkbox and highlighting that Account
    The Account you select here determines what information will be kept where there is a clash, for example if the Accounts that are being merged all have a different Name, following the merge the Name that will be kept is the one assigned to your ‘Record to keep’ Account.

    record to keep highlighted

  9. Click the ‘OK’ button

    OK button

  10. This will add the Record into the ‘Record To Keep’ selector

    record selected now showing in field

  11. Click the ‘Merge’ button to merge the records

    Merge button

  12. A pop up will appear asking you to confirm that you want to merge the Selected Account’s, click the ‘Yes’ button to confirm

    confirmation pop up

  13. Your Account records have now been merged

    single account now showing in datagrid


📖 How to merge Course Templates

Panel
panelIconId17657261-765d-4027-b044-d86a9501c52f
panelIcon:accessplaniticon:
panelIconText:accessplaniticon:
bgColor#DEEBFF

This step will take you through the steps on how to merge two or more duplicate Course Templates records into one

Expand
titleMerging Course Templates
  1. Open the ‘Course Templates’ DataGrid from your main navigation menu on the left

    Main navigation menu Course Templates selected

  2. This will open the Course Template DataGrid

    course templates datagrid

  3. Find the Course Templates that you wish to merge by applying filters and/or searching the Course Template DataGrid

    filters and search bar within datagrid

  4. Select the duplicate records by clicking on them so that they have a blue-background

    both templates highlighted within datagrid

  5. Click the mass action drop down at the top left of your DataGrid and click the ‘Merge’ option

    mass action merge option selected

  6. The Merge Course Template pop up box will appear, click the ‘Select’ button to choose which Course Template will act as your primary Course Template to keep

    Merge course templates pop up box

  7. Both Course Template’s will appear, we advise adding in the ‘Course Template ID' column so you can ensure you are keeping the correct record
    Visit our dedicated page on adding a new column to your DataGrid

    both templates showing within datagrid

  8. Select the Course Template you wish to keep by ticking the Checkbox and highlighting that Template
    The Course Template you select here determines what information will be kept where there is a clash, for example if the Course Templates that are being merged all have a different cost and cost type, following the merge the cost and cost type that will be kept is the one assigned to your ‘Record to keep’ Course Template.

    record to keep highlighted

  9. Click the ‘OK’ button

    OK button

  10. This will add the Template into the ‘Record To Keep’ selector

    record to keep added to field

  11. Click the ‘Merge’ button to merge the records

    merge button

  12. A pop up will appear asking you to confirm that you want to Merge the Selected Course Template’s, click the ‘Yes’ button to confirm

    confirmation pop up box

  13. Your Course Templates have now been merged

    single course template showing


🗓️ How to merge Courses

Panel
panelIconId17657261-765d-4027-b044-d86a9501c52f
panelIcon:accessplaniticon:
panelIconText:accessplaniticon:
bgColor#DEEBFF

This step will take you through the steps on how to merge two or more duplicate Courses records into one

Expand
titleMerging Course Dates
  1. Open the ‘Class’ or ‘Web’ Courses DataGrid from your main navigation menu on the left

    Main navigation menu - courses option

  2. This will open the Course DataGrid

    course datagrid

  3. Find the Courses that you wish to Merge by applying filters and/or searching the Course’s DataGrid

    filters and search bar showing within datagrid

  4. Select the duplicate records by clicking on them so that they have a blue-background

    course dates highlighted

  5. Click the mass action drop down at the top left of your DataGrid and click the ‘Merge’ option

    mass action merge selected

  6. The ‘Merge Courses’ pop up box will appear, click the ‘Select’ button to choose which Course will act as your primary Course to keep

    merge courses pop up box

  7. Your selected Courses will appear, we advise adding in the ‘ID' column so you can ensure you are keeping the correct record
    Visit our dedicated page on adding a new column to your DataGrid

    both course dates showing withing datagrid

  8. Select the Course you wish to keep by checking the Checkbox and highlighting that Course
    The Course you select here determines what information will be kept where there is a clash, for example if the Courses that are being merged all have a different end time, following the merge the end time that will be kept is the one assigned to your ‘Record to keep’ Course.

    record to keep selected

  9. Click the ‘OK’ button

    OK button

  10. This will add your selected Course into the ‘Record To Keep’ selector

    record to keep showing in field

  11. Click the ‘Merge’ button to merge the records

    Merge button

  12. A pop up will appear asking you to confirm that you want to Merge the Selected Course, click the ‘Yes’ button to confirm

    confirmation pop up box

  13. Your Courses have now been merged

    single course date showing within datagrid


🏆 How to merge Awards

Panel
panelIconId17657261-765d-4027-b044-d86a9501c52f
panelIcon:accessplaniticon:
panelIconText:accessplaniticon:
bgColor#DEEBFF

This step will take you through the steps on how to merge two or more duplicate Awards records into one

Expand
titleMerging Awards
  1. Open the ‘Administration’ menu from the Profile options at the top-right of your platform

    Profile - Administration

  2. This will open the Administration menu

    administration menu

  3. Open the ‘Awards’ menu option to access the page where you can view and manage your Awards
    The administration menu is in alphabetical order

    awards option

  4. This will open the ‘Awards’ DataGrid

    awards datagrid

  5. Find the Awards that you wish to merge by applying filters and/or searching the Award’s DataGrid

    filters and search bar within datagrid

  6. Select the duplicate records by clicking on them so that they have a blue-background

    both awards selected within datagrid

  7. Click the mass action drop down at the top left of your Awards DataGrid and click the ‘Merge’ option

    mass action merge selected

  8. The ‘Merge Awards’ pop up window will appear, click the ‘Select’ button

    merge awards pop up box

  9. Both Awards will appear, we advise adding in the ‘ID' column so you can ensure you are keeping the correct record
    Visit our dedicated page on adding a new column to your DataGrid

    both awards showing within datagrid

  10. Select the Award you wish to keep by ticking the Checkbox and highlighting that Award
    The Award you select here determines what information will be kept where there is a clash, for example if the Awards that are being merged all have a different lifetime, following the merge the lifetime that will be kept is the one assigned to your ‘Record to keep’ Award.

    record to keep highlighted

  11. Click the ‘OK’ button

    OK button

  12. This will add the Award into the ‘Record To Keep’ selector

    award now showing in field

  13. Click the ‘Merge’ button to merge the records

    Merge button

  14. A pop up will appear asking you to confirm that you want to Merge the Selected Award’s, click the ‘Yes’ button to confirm

    confirmation pop up box

  15. Your Awards have now been merged

    single award now showing in datagrid


💻 How to merge Job Roles

Panel
panelIconId17657261-765d-4027-b044-d86a9501c52f
panelIcon:accessplaniticon:
panelIconText:accessplaniticon:
bgColor#DEEBFF

This step will take you through the steps on how to merge two or more duplicate Job Roles records into one

Expand
titleMerging Job Roles
  1. Open the ‘Administration’ menu from the Profile options at the top-right of your platform

    Profile - Administration

  2. This will open the Administration menu

    administration menu

  3. From the Administration menu, click ‘Job Roles'
    The administration menu is in alphabetical order

    Job roles option

  4. This will open the ‘Job Role’ DataGrid

    Job Roles datagrid

  5. Find the Job Roles that you wish to Merge by applying filters and/or searching the Job Roles DataGrid

    Filters and search bar shwing in datagrid

  6. Select the duplicate records by clicking on them so that they have a blue-background

    both job roles highlighted within datagrid

  7. Click the mass action drop down at the top left of your DataGrid and click the ‘Merge’ option

    mass action Merge selected

  8. The ‘Merge Job Roles’ pop up box will appear, click the ‘Select’ button

    Merge Job Role pop up box

  9. Both Job Roles will appear, we advise adding in the ‘ID' column so you can ensure you are keeping the correct record
    Visit our dedicated page on adding a new column to your DataGrid

    both job roles showing within datagrid

  10. Select the Job Role you wish to keep by ticking the Checkbox and highlighting that Job Role
    The Job Role you select here determines what information will be kept where there is a clash, for example if the Job Roles that are being merged all have a different Label, following the merge the Label that will be kept is the one assigned to your ‘Record to keep’ Job Role.

  11. Click the ‘OK’ button

    OK Button

  12. This will add the Job Role into the ‘Record To Keep’ selector

    record to keep now added to field

  13. Click the ‘Merge’ button to merge the records

    Merge button

  14. A pop up will appear asking you to confirm that you want to Merge the Selected Job Roles, click the ‘Yes’ button to confirm

    confirmation pop up box

  15. Your Job Roles have now been merged into one

    single job role now showing within DataGrid