Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

Click on Images to Expand Them
This section provides instructions on reassigning reps to different clients in bulk.

1

Navigate to one of the Change rep domains.

  • Administration> List Domains> Change Rep – Account Process Level

  • Administration> List Domains> Change Rep – Client Process Level

Change Rep Domains

2

Select the rep code, or rep codes you would like to edit.

Are you missing required report columns?

  1. Process Level (Client or Account)

  2. Client Last Name

  3. Client SSN

  4. Account (Only Applicable when running by Account Level)

  5. Current Rep

  6. Rep Code To Process (New Rep Code to Add or Replace, Same to Remove)

  7. 0rocess Type (Add, Remove, or Replace)

Rep Code Domain Page

Select Rep Codes to Edit

3

Click the Export menu and select (XLS)-Current Fields from the drop-down list.

UNKNOWN ATTACHMENT

(XLS) All Fields: If you select (XLS)-All Fields, you MUST remove rows that you DO NOT want to process.

Open the spreadsheet in Excel and update the remaining rows with any changes.

Add any new line items.

In the Process Type column, enter either “Add,” “Remove,” or “Replace.”

  • Add- This process type tells the system to add the information in the row as a new entry.

  • Remove-This process type tells the system to remove the information in the row.

  • Replace-This process tells the system to replace the existing information with an update.

Export Fields Button

Export Fields Button

4

Save the file as a .CSV, NOT as an .XLS file and close Excel.

Saving the File as a .CSV

Saving the file as a .CSV

5

Change the file extension from .CSV to .RCG.

Changing File Extensions

Windows Users

  1. Launch File Explorer.

  2. Click the View tab at the top of the window.

  3. Make sure File name extensions is checked on.

  4. Locate your file.

  5. Right-click and select to Rename.

  6. Change .CSV to .RCG.

  7. Hit the Enter key to save your changes.

Mac Users

  1. Launch Finder.

  2. Locate your file.

  3. Click on the file name twice (slower than a double-click)

  4. Change .CSV to .RCG.

  5. An alert will appear. Click Use .RCG to confirm the change.

Changing the File Extension

Changing the File Extension

6

Click on New.

Select Upload File from the dropdown list.

Click on Add File(s).

Select the file you want to upload.

Click Start Upload. Rep reassignments will be processed.

SSN/TIN:  If the SSN/TIN does not match what is already in the system, then the requested changes will be ignored.

Uploading Files

Uploading Files

7

Navigate to the load report to check that all changes were successful.

Administration> Reports> Load Report

Definitions: Columns

  1. Process:

    1. # of items to be processed from the load

  2. Errors:

    1. # of errors (Did not process)

  3. Warnings:

    1. # of warnings (Processed with caution(s))

  4. Inserted:

    1. # of records added

  5. Updated:

    1. # of records replaced

  6. Deleted:

    1. # of records removed

  7. Execute:

    1. Time to process the request

Load Report

Load Report

  • No labels