Difference between revisions of "Import Workforce"

From YMwiki
Jump to navigationJump to search
Line 1: Line 1:
Follow the Import instructions on this page to import your workforce.  
+
Follow the Import instructions on this page to import your workforce. Pro users may include workforce data for all AAPs in one company in the same import file.  
  
[[File:ProTag.jpg]]  Pro users, please remember that you may include workforce data for all plans in one company in the same import file.
+
1) Open the company into which you wish to import.
  
1) Open the plan you wish to work in.
+
2) Click the '''Import''' icon.
 
 
2) Click the Import icon.
 
  
 
[[file:Import_Icon.png‎]]
 
[[file:Import_Icon.png‎]]
  
3) Click the Workforce File button if it is not selected.   
+
3) Click the '''Workforce''' button if it is not selected.   
  
4) If the correct file is not shown in the Import File path you may locate your file by typing the path where your file is stored; or by clicking the [[File:Browse.jpg]] button to locate and select your file.
+
4) 6) The '''Import File''' box displays the location of your '''company_import.xlsx''' file.  If your import file is not mapped correctly, click the [[File:Browse.jpg]] button to locate and select it.
  
 
[[file:Import_Wizard_WF.png‎]]
 
[[file:Import_Wizard_WF.png‎]]
  
5) After you select the file, its path will appear in the Import File box.  
+
5) After you select the file, its path will appear in the '''Import File''' box.  
  
6) Click Import.
+
6) Click '''Import'''.
  
7) When the following message appears click Yes if your file has a header row.
+
7) When the following message appears click '''Yes''' if your file has a header row.
  
 
[[file:HeaderRowMessage.png‎ ]]
 
[[file:HeaderRowMessage.png‎ ]]
  
[[File:ProTag.jpg]]  8) This step applies to the Pro version only. If your workforce import file has multiple plan or location codes and if you are not in all plans you will get the message shown below.
+
[[File:ProTag.jpg]]  8) Pro users may get the message shown below.
  
 
[[file:SinglePlanImportMessage.png‎]]
 
[[file:SinglePlanImportMessage.png‎]]
  
* Click No to import all plans and/or locations.
+
* Click '''No''' to import all plans and/or locations.
* Click Yes if you wish to import data for only the plan you have open.
+
* Click '''Yes''' if you wish to import data for only the plan you have open.
  
9) The software may ask you to clarify some information if it does not recognize the codes you used. You will need to read and respond to each window as it appears. An example is shown below.
+
9) The software may ask you to clarify some information such as race, EEO and gender codes. Read and respond to each '''Import Mapping''' window as it appears. An example is shown below.
  
 
[[file:ImportMapping-Race.png‎]]
 
[[file:ImportMapping-Race.png‎]]
Line 38: Line 36:
 
:c) Click OK.
 
:c) Click OK.
  
10) If the software asks you to clarify information that does not seem to correspond with the information shown at bottom, you will need to Cancel your import and correct your import file. For example, if “M” for “Male” is shown in the box at top, but race information is shown at bottom, the import file has race data in the gender column. After correcting your import file start the import process again.
+
10) If the software asks you to clarify information that does not seem to correlate to the information below it, you will need to cancel your import and correct your import file. For example, if “M” for “Male” is shown at top, but race information is shown at bottom, the import file has race data in the gender column. After correcting your import file, start the import process again.  
  
 
[[file:ImportMappingMismatchedRace&Gender.png‎]]
 
[[file:ImportMappingMismatchedRace&Gender.png‎]]
  
11) When the import is complete you will be taken to the Select A Plan window.
+
:a) Read the statement.
 +
:b) Select the appropriate entry in the category.
 +
:c) Click '''OK'''.  
  
[[File:ProTag.jpg]]  If you have small plans that need to be rolled into a larger plan we recommend performing the roll up at this time.
+
11) When the import is complete, the '''Select A Plan''' window will appear.
  
:a) Click Utilities and then Roll Up Plans.
+
[[File:ProTag.jpg]]  If you have small AAPs that need to be rolled into a larger plan we recommend performing the roll up at this time.
:b) Set Minimum plan size if you want a different threshold than 50.
+
 
:c) Click OK.
+
:a) Open an AAP or select '''Work with All Plans'''.
:d) Click Open Plan to confirm that all small plans were rolled up.
+
:b) Click '''Utilities''' and then '''Roll Up Plans'''.
:e) If employees remain in a small plan check the employee data for missing or incorrect supervisor information. Correct the supervisor information and follow steps 1-9.
+
:c) Set minimum plan size if you want a different threshold than 50.
 +
:d) Click '''OK'''.
 +
:e) Click '''Open Plan''' to confirm that all small plans were rolled up.
 +
:f) If employees remain in a small plan check the employee data for missing or incorrect supervisor information. Correct the supervisor information and follow steps 1-9.
  
 
Continue to:  [[Import Adverse Impact]]
 
Continue to:  [[Import Adverse Impact]]
  
 
© Copyright Yocom & McKee, Inc.
 
© Copyright Yocom & McKee, Inc.

Revision as of 17:20, 2 September 2011

Follow the Import instructions on this page to import your workforce. Pro users may include workforce data for all AAPs in one company in the same import file.

1) Open the company into which you wish to import.

2) Click the Import icon.

Import Icon.png

3) Click the Workforce button if it is not selected.

4) 6) The Import File box displays the location of your company_import.xlsx file. If your import file is not mapped correctly, click the Browse.jpg button to locate and select it.

Import Wizard WF.png

5) After you select the file, its path will appear in the Import File box.

6) Click Import.

7) When the following message appears click Yes if your file has a header row.

HeaderRowMessage.png

ProTag.jpg 8) Pro users may get the message shown below.

SinglePlanImportMessage.png

  • Click No to import all plans and/or locations.
  • Click Yes if you wish to import data for only the plan you have open.

9) The software may ask you to clarify some information such as race, EEO and gender codes. Read and respond to each Import Mapping window as it appears. An example is shown below.

ImportMapping-Race.png

a) Read the statement.
b) Select the appropriate entry in the category.
c) Click OK.

10) If the software asks you to clarify information that does not seem to correlate to the information below it, you will need to cancel your import and correct your import file. For example, if “M” for “Male” is shown at top, but race information is shown at bottom, the import file has race data in the gender column. After correcting your import file, start the import process again.

ImportMappingMismatchedRace&Gender.png

a) Read the statement.
b) Select the appropriate entry in the category.
c) Click OK.

11) When the import is complete, the Select A Plan window will appear.

ProTag.jpg If you have small AAPs that need to be rolled into a larger plan we recommend performing the roll up at this time.

a) Open an AAP or select Work with All Plans.
b) Click Utilities and then Roll Up Plans.
c) Set minimum plan size if you want a different threshold than 50.
d) Click OK.
e) Click Open Plan to confirm that all small plans were rolled up.
f) If employees remain in a small plan check the employee data for missing or incorrect supervisor information. Correct the supervisor information and follow steps 1-9.

Continue to: Import Adverse Impact

© Copyright Yocom & McKee, Inc.