Importing Survey Data WWW WATSONWYATT COM Importing Survey

Importing Survey Data WWW. WATSONWYATT. COM

Importing Survey Vendor Data l Choose your surveys – l Preparing data – – l Formatting guidelines and tips Converting to text and FTP Importing data – – 176 Prepare ahead; master lists REWARD Steps 1 -6 Common errors

Preparing the Spreadsheet l Refer to the Preparing and Importing Survey Data guidelines and Survey Formatting Checklist l Tips – – There can be no hidden columns or rows in your spreadsheet Annual data should be represented as thousands l – – Do not use quotes or $ signs when preparing data Do not use commas in numeric columns The last column of data must have values or labels in it Delete data you don’t need l 177 E. g. $275. 0 from survey should be entered as $275000 in import file E. g. , if you don’t intend to upload survey job description or a level description, delete these columns from your spreadsheet

Is Data Ready for Import? 178 l Save your finished spreadsheet to a tab delimited text file l Upload the tab delimited text file to your FTP

Survey Imports in REWARD l The process: – – – From Tools menu, select Import/Export data Choose Import Salary Survey Data Follow steps 1 -6 for import 1. 2. 3. 4. 5. 6. 179 Specify the survey source Describe the survey Identify the file (from list of FTP’d text files) Map which columns to import Select which cuts (scopes) to import Select which jobs to import

Step 1: Specify the survey source Note: Once you enter in a survey source it is available the next time you import. 180

Step 2: Describe the survey Recommended naming convention: Year, Vendor Name, Survey Title Ex: 2003 Radford Benchmark Report 181

Step 3: Identify the file 182

Step 4: Map which columns to import 183

Step 5: Select which cuts (scopes) to import 184

Step 6: Select which jobs to import 185

Completed Survey Import Screen 186