Versions Compared

Old Version 11

changes.mady.by.user Mercedes Rothwell

Saved on

compared with

New Version Current

changes.mady.by.user Mercedes Rothwell

Saved on

Key

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

...

Rw ui steps macro
Rw step

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

Rw step

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

Warning

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

Image RemovedImage Added

Select Rep Codes to Edit

Rw step

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

Note

(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 ButtonImage RemovedExport Fields ButtonImage Added

Export Fields Button

Rw step

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

Rw step

Change the file extension from .CSV to .RCG.

Tip

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

Rw step

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

Rw step

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

Administration> Reports> Load Report

Definitions: Columns

Process:

# of items to be processed from the load

Load ReportImage Added

Load Report

Errors:

# of errors (Did not process)

Warnings:

# of warnings (Processed with caution(s))

Inserted:

# of records added

Updated:

# of records replaced

Deleted:

# of records removed

Execute:

Time to process the request

Load ReportImage RemovedLoad Report