Import - Revision history

Joel at 19:26, 11 July 2024

2024-07-11T19:26:14Z

2024-07-11T19:20:42Z

2023-12-18T20:36:20Z

2023-12-18T20:35:43Z

2023-12-18T20:29:35Z

2023-12-18T20:27:21Z

2023-06-28T16:26:26Z

2021-12-29T18:42:09Z

2021-12-29T18:41:38Z

2019-01-07T22:29:51Z

@@ Line 21: / Line 21: @@
 ! Import Type
 ! Filename / sheet name Identifier
 |-
@@ Line 37: / Line 33: @@
 | [[Accrual Date Entitlements Import|Accrual Date Entitlements (Configuration)]]
 | Accrual Date
 |-
@@ Line 69: / Line 69: @@
 | [[Labor Levels Import|Labor Levels]]
 | Labor Level name, e.g. Department
 |-
@@ Line 83: / Line 79: @@
 |-
-| [[Raw Punch Import|Raw Punch]]
+| [[Pay Date Comment Import|Pay Date Comment]]
-| Raw Punch
+| Pay Date Comment
 |-
 | [[Punch Import|Punch]]
 | Punch
 |-

@@ Line 69: / Line 69: @@
 | [[Labor Levels Import|Labor Levels]]
 | Labor Level name, e.g. Department
 |-
@@ Line 97: / Line 93: @@
 | [[Schedule Import|Schedule]]
 | Schedule
 |-

@@ Line 23: / Line 23: @@
 |-
-| [[Employee Annual Entitlement Overrides Import|Employee Entitlement Overrides (Employee)]]
+| [[Employee Annual Entitlement Overrides Import|Accrual Entitlement Overrides (Employee)]]
 | Employee Entitlement

@@ Line 23: / Line 23: @@
 |-
-| [[Accrual Annual Entitlement Import|Employee Entitlement (Employee)]]
+| [[Employee Annual Entitlement Overrides Import|Employee Entitlement Overrides (Employee)]]
 | Employee Entitlement

@@ Line 23: / Line 23: @@
 |-
-| [[Accrual Annual Entitlement Import (Employee)|Employee Entitlement]]
+| [[Accrual Annual Entitlement Import|Employee Entitlement (Employee)]]
 | Employee Entitlement
 |-
-| [[Accrual Adjustment Import (Employee)|Accrual Adjustment]]
+| [[Accrual Adjustment Import|Accrual Adjustment (Employee)]]
 | Accrual Adjustment
 |-
-| [[Accrual Balances Import (Employee)|Accrual Balances]]
+| [[Accrual Balances Import|Accrual Balances (Employee)]]
 | Accrual Balances
 |-
-| [[Accrual Date Entitlements Import (Configuration)|Accrual Date Entitlements]]
+| [[Accrual Date Entitlements Import|Accrual Date Entitlements (Configuration)]]
 | Accrual Date
 |-
-| [[Accrual Year End Adjustments Import (Employee)|Accrual Year End Adjustments]]
+| [[Accrual Year End Adjustments Import|Accrual Year End Adjustments (Employee)]]
 | Accrual Year End

@@ Line 7: / Line 7: @@
 The information provided in the import file identifies the data. The file name, sheet names (Excel only) and column headers (the first row) identify the information. There is not a fixed column format. Specifically:
-* Spaces and case are ignored so "Pay Rule" and "pay rule" identify the same data.
+* Spaces and case are ignored so "Pay Rule", "pay rule", and "payrule" identify the same data.
 * The name of the file can identify the import type for all sheets in the file, e.g. if the name of the file contains "employee," then all information in the file will be assumed to be employee information.
 * The sheet names can identify the import type. This allows one Excel file to contain different types of information, e.g. both employee and planned absence information.

@@ Line 39: / Line 39: @@
 |-
-| [[Base Schedule Import|Base Schedule]]
+| [[Base Schedule Import|Base Schedules]]
 | Base Schedules

@@ Line 3: / Line 3: @@
 The software supports the import of information from an Excel file (xls – Excel 97-2003 format and xlsx Excel 2007-2010 format) or from a comma separated values file (csv). The extension on the filename must be csv if using a comma separated values file. Otherwise, the import will open the file as an Excel file.
-The import will read data from multiple sheets within one Excel file. The sheet name takes precedence over the filename in identifying the import type. Each import has a different behavior regarding the adding, replacing or updating of data. An import may only add data to the software, update existing data, remove existing data and replace it, or both add and update data.
+The import will read data from multiple sheets within one Excel file. The filename takes precedence over the sheetname in identifying the import type. Each import has a different behavior regarding the adding, replacing or updating of data. An import may only add data to the software, update existing data, remove existing data and replace it, or both add and update data.
 The information provided in the import file identifies the data. The file name, sheet names (Excel only) and column headers (the first row) identify the information. There is not a fixed column format. Specifically: