Difference between revisions of "Import Workforce"

From YMwiki
Jump to navigationJump to search
Line 3: Line 3:
 
1) Open the company into which you wish to import.
 
1) Open the company into which you wish to import.
  
2) Click the '''Import''' icon.
+
[[File:ProTag.jpg]] 2) Pro users must also open an AAP or must click on '''Work with All Plans''', which required fewer steps.
 +
 
 +
3) Click the '''Import''' icon.
  
 
[[file:Import_Icon.png‎]]
 
[[file:Import_Icon.png‎]]
  
3) Click the '''Workforce''' button if it is not selected.   
+
4) 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 [[File:Browse.jpg]] button to locate and select it.
+
5) 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:New Imprt Wizard -Workforce Template.png‎]]
 
[[File:New Imprt Wizard -Workforce Template.png‎]]
  
5) After you select the file, its path will appear in the '''Import File''' box.
+
6) 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.
 
  
[[file:HeaderRowMessage.png‎ ]]
+
7) Click '''Import'''.
  
[[File:ProTag.jpg]] 8) Pro users may get the message shown below.
+
[[File:ProTag.jpg]] 8) Pro users may get the message shown below.
  
 
[[file:SinglePlanImportMessage.png‎]]
 
[[file:SinglePlanImportMessage.png‎]]
Line 34: Line 32:
 
:a) Read the statement.
 
:a) Read the statement.
 
:b) Select the appropriate entry in the category.
 
:b) Select the appropriate entry in the category.
:c) Click OK.
+
: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.  
 
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.  
Line 44: Line 42:
 
:c) Click '''OK'''.  
 
:c) Click '''OK'''.  
  
11) When the import is complete, the '''Select A Plan''' window will appear.
+
11) When the import is complete, the '''Select A Plan''' window will appear. If you are not using the Pro version please proceed to [[Import Adverse Impact]] or to [[Edit Your Data]] if you have no adverse impact data to import.  
  
[[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.
+
[[File:ProTag.jpg]] 13) 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'''.
 
:a) Open an AAP or select '''Work with All Plans'''.
Line 55: Line 53:
 
: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.
 
: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]] or to [[Edit Your Data]] if you have no adverse impact data to import.
  
 
© Copyright Yocom & McKee, Inc.
 
© Copyright Yocom & McKee, Inc.

Revision as of 16:56, 17 August 2012

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.

ProTag.jpg 2) Pro users must also open an AAP or must click on Work with All Plans, which required fewer steps.

3) Click the Import icon.

Import Icon.png

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

5) 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.

New Imprt Wizard -Workforce Template.png

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

7) Click Import.

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. If you are not using the Pro version please proceed to Import Adverse Impact or to Edit Your Data if you have no adverse impact data to import.

ProTag.jpg 13) 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 or to Edit Your Data if you have no adverse impact data to import.

© Copyright Yocom & McKee, Inc.