AwardFilePlus - How To Upload an Award File

Introduction

This article explains the process of uploading award files, how to create a template file and what happens after successfully uploading a file. The article also explains available communications types and the dispatch process for each. Use this article as a guide when working with award files.

Uploading Award Files

When it comes to sending awards en masse to your people, we know that it works best and makes the biggest impact when the process is swift and as seamless as possible.

That’s why we’ve made the Reward & Recognition file uploader self-service. It means clients can upload files directly, simplifying the file upload process and save precious time, making it quicker and smoother to send out bulk awards to employees.

How Does it Work?

It’s simple - from Reward Manager, just create a file template, upload the file containing the relevant data for the awards, and the awards will be sent out to your people according to your program set-up e.g., email, post, or onsite alert. Read through our step-by-step guide below for more details.

Note: In order for clients to upload their own files, they will need the RR Budget Holder permission in Reward Manager.

Step 1: Create an Award File Template

The first time you upload an award file, you will need to create a template.

A template does not create any awards that are sent to employees. Its purpose is to match the fields in your award file to the fields required in Reward Manager, so you can use the same blueprint to create awards more quickly in the future.

You don't need a full award file to create a template. All you need is to make sure the format follows these rules:

• Your file is in one of the supported formats, we recommend .csv
• All the required fields are listed in article AwardFilePlus Client Welcome Pack
• Every column has a heading
• At least one or two lines in your test file are filled. No blank cells, you can use dummy data
• All fields are in plain text format, with no formulas or filters

Read the instructions below and watch the video to see how to create a template:

1. Click Upload File in your AwardFilePlus program
2. Click Create a new template to begin the process
3. Give your template a unique name, so it's easier to recognize in the future
4. Select your file from your computer and click Continue
5. Match every column in your file to one of the required fields in the AwardFilePlus program.
   • Any fields that are not required in Reward Manager can be ignored
   • If a required field is missing or not mapped, you will not be able to create the template
6. Click Continue to create your template. As long as there are no errors or missing data, a success message will appear
7. Click Import Awards at the bottom left of the screen if you want to upload an award file using the template you just created

Going forward, the system will expect the same file structure every time you use this template. This means the columns in your award files will need to have the same columns, and be in the same order, every time.

At the end of the process you'll have the option to create more templates, if you plan to upload award files with columns that have different names or are in a different order.

If the communications type of your AwardFilePlus program changes, the fields required to upload an award file will also change, so you will need to create a new template before creating more awards.
 

Step 2: Upload Your Award File

Once you have created an award file template, you can reuse it again and again to upload more files that include the same data fields. These uploads will create awards that can be sent to employees in bulk.

Using an existing template will save you time, as you won't need to repeat the step of matching the columns in the award file to the fields required in Reward Manager.

Before uploading an award file, make sure the format follows these rules:

• Your file is in one of the supported formats, we recommend .csv
• Columns are in the exact order you have set up in the template
• All the required fields listed at the start of this article are included in the file
• All rows in your file are filled and there are no blank cells
• All fields are in plain text format, with no formulas or filters
• All employee IDs in the file correspond to eligible users in Reward Manager
• All the award import codes in the file match the award types you have created in Reward Manager
• For uploads greater than 2000 awards please consult Client Support or you Client Success Manager

Read the instructions below and watch the video to see how to use a template to upload an award file:

Important:  please check your communication settings before uploading your file because this will impact how your awards are dispatched. If your communication setting is Email Communications type then you awards will automatically be dispatched once you successfully complete your file upload, without you needing to press the dispatch button. If this is your communication type, please ensure you are happy for your awards to be dispatched before you complete the file upload.

1. Click Upload File in your AwardFilePlus program
2. Select an available template
3. Select your file from your computer and click Continue
4. The system will assess your file and highlight any errors that need correcting before moving forward.
5. If there are no errors or missing data, you will be able to click Complete Update to complete the upload, and a success message will appear

What Happens Once an Award File is Uploaded?

At the end of your file upload, click the Dispatch link at the end of the upload process. The button will lead straight to a page that lists all award batches in the program, the page is described in AwardFilePlus - How to Manage your Program. This is the page you should head to if you want to send out the awards you've created, as you can see in the video below.