Print the articleGet a PDF version of this webpage

Updating Service Provider Members

How to update your Service Provider Member records. You must have the Service Provider Manager user role assigned to edit these records.

There are two ways of updating your Service Provider Member records, manually one-by-one, or in bulk via CSV import. You can update most information and even delete members using the CSV import.

To access the Service Provider Manager and update your members, the Service Provider Manager Add-on needs to be enabled by the account owner and you must have the Service Provider Manager user role assigned. If either of these are missing, Service Provider Manager will not appear in your Tools menu.

Updating Manually

To update one member manually:

1. Go to Tools > Service Provider Manager

2. Select Members from the left-hand menu

3. Use the search fields to find the member you want to update

4. Click View next to the member's name

2017-05-22_13-22-53.png

From here, use the left-hand menu to select the area you want to update, make any changes, and Save them. Select Back to Members List when you are finished to return to the list of Service Provider Members.

Updating via CSV Import

To update your members in bulk, you need to export your member list, make any changes, then import the changed list. There are options for deleting members when re-importing the list.

Export and Prepare Your CSV File

1. Go to Tools > Service Provider Manager

2. Select Members from the left-hand menu

3. Click Export Members

4. Save the file to your computer

5. Make any changes to the member’s profiles. If you want to delete any members, remove them from this CSV file.

6. Save your spreadsheet as a CSV file. For best results, use the CSV UTF-8 file type.

2017-05-22_11-48-05.png

Importing Your CSV File

Once your CSV file has been updated and ready for import:

1. Go to Tools > Service Provider Manager

2. Select Members from the left-hand menu

3. Click Update Members

4. Click Select CSV File

5. Select the saved file from your computer and click Open

6. Click Next

2017-05-22_11-51-32.png

The headings of your columns will be matched automatically with the appropriate fields in WhosOnLocation. If you have entered your information correctly then they will all match up.

7. Select a Unique Identifier. This will be used to match the records in your file with the records in WhosOnLocation. The most useful identifier to use when updating records is the WOL ID because it is created by the system and unique to every member.

2017-05-22_13-29-38.png

8. (Optional) If you are deleting any members, tick the Remove Missing Records checkbox

9. Click Next

Your members will update automatically and you will be notified how many were updated and/or removed.

2017-05-22_13-30-10.png

Have more questions? Submit a request