Time Entry Fixed length flexible import

I am unable to do a Time Entry import for a group of employees with my fixed length .txt file.

• Munis Version 2019.1 and higher

• Time Entry Import

• Custom Templates

1. Go to Time Entry Import. (Human Resources/Payroll>Payroll>Payroll Processing>Time Entry Processing>Time Entry. Verify Current Active Payroll prompt. Click Yes. Click on Import in the Menu.)

2. Click Custom Templates in the menu.

3. Click Create Template in the menu. 

4. New Template prompt will display. Define Name, File delimiter is None, click Browse and select Input file. 

   1. Check First line contains headers if necessary.

      1. If using headers, click checkbox for Attempt field matching based on headers. (this is not applicable with a fixed length file)

      2. Note - a Fixed length file should be saved in .TXT format. (Not .CSV or Excel) 

5. Click Upload.

6. Choose first column file name by clicking the drop down arrow under Line Field.

   1. A dark line will appear on the right side of the highlighted column. Click and drag the line to the right for the number of characters for that field. (example: Employee Number, drag 6 characters) 

   2. At the top the Begins At and Ends At fields will display the number of the fixed length characters. 

   3. Do step 6 for all fields. 

7. Click Save. 

8. Go back to Time Entry Import. Click Define in the toolbar.

9. Select template by clicking the drop down arrow. 

10. Click the magnifying glass icon next to the File field to browse for the import .txt file. 

11. Check the Skip First Line checkbox if first line contains headers. 

12. Click Accept. 

13. Define Time Entry Batch information. Click Accept. 

14. View the Time Entry Import Proof. Click Yes to Import Records? prompt that reads, Import Time Entry Records?

A template was not created for the import file.

Connect 2018 - Utilizing Flexible Imports and Exports