Plan: Not Available: Intermediate, Pro Available: Elite
Users: Not Available: All users Available: FYI Admins or User Group permissions
Practice Management Source: Not Available: Xero Practice Manager, APS, Iris, MYOB AE & AO, CCH, MYOB Practice Management (formerly GreatSoft) Available: FYI
This example details how to use a Custom Automation Process to import data from a CSV file to create chargeable time entries against a job in FYI.
This process uses the following:
- The CSV Data Import filter.
- The Create Time Automation Step.
Note: This process is not recommended for Capacity-Reducing or Non-Productive time entries, as these Time Types are not assigned to a client. Since the CSV Import requires a client to be specified, it should be used for importing Chargeable time only.
Creating the CSV File
The CSV File contains all the data to be imported into FYI for each time entry. Refer to CSV Columns below for details on the columns that can be added to the file, including mandatory columns.
The following example shows a CSV file used to create chargeable time entries in FYI.
CSV Columns
The following columns can be added to the file and imported into FYI. Fields marked as Required are mandatory fields in FYI.
Note: The Status cannot be imported and must be selected within the Create Time step. This means the same Status will apply to all imported entries, for example, Draft.
When configuring the Automation Filter in FYI, ensure you select the correct Filter Type.
| Field | Required | Type |
|---|---|---|
| Date |
Required Data in the CSV file must be formatted using dd/mm/yyyy |
Date |
| User |
Required Name must match the name of a user in FYI. |
User |
| Job Number |
Required for Chargeable Time. This column is used to match the client and job. For Job Numbers that start with a 0, an apostrophe must be added to the field first to ensure the cell is recognised as Text, and the leading zero is not removed. |
Job Number |
| Time |
Required Time must be entered in minutes, for example, "75" for 1:15. Decimals will be rounded up to the next whole number; for example, 7.5 will be rounded up to 8 minutes. |
Numeric |
| Notes | Optional | String |
| Custom Fields |
Optional Custom Fields must be active in the FYI platform and applied to Time and Disbursements. |
String, Date, Numeric, or Toggle depending on the Custom Field. Numeric Custom Fields containing a decimal will be rounded to the next whole value. |
Using Custom Fields
Each Custom Field must have a separate column in the CSV file, with each row containing the Custom Field option relevant to that time entry.
Ensure you select the correct Type for each Custom Field in the Automation Process Filter.
When a Custom Field is selected in the Create Time step, the Custom Field is added as another field to the Drawer.
Enter the value for the Custom Field, or click the Merge Field icon to insert data from the CSV Import File.
When selecting the Trigger Data from the Merge Field Editor, only columns with a Process Filter Type relevant to the Custom Field Type will be displayed. Date fields will display columns with a "Date" Process Filter Type, while "Drop-down" Custom Fields will display "String" Process Filter Type columns.
If there are no columns in the CSV Import File with a matching "Type", a warning will be displayed: "No compatible merge fields available for target field".
Creating the Custom Process
Before creating the Custom Process, confirm the following:
- Ensure the CSV file has been saved in CSV UTF-8 format and uploaded into FYI.
- A CSV Document view has been configured, displaying the required CSV file. This view will be selected in the Automation Filter window.
- Confirm that a Job Number has been provided in the CSV file.
- Review your Custom Field columns to confirm they match the fields in FYI.
The following is an example of a Custom Process used to create time. For detailed instructions, refer to Process Filter Details - CSV Data Import and Setting up Custom Processes.
Configure the CSV Import Filter
The following is an example of the CSV Import filter. Refer to CSV Columns above for details on the Type required to be selected for each of the columns from your Import File.
The Match Jobs During Validation option is used to search for an existing job in FYI. If a matching job cannot be found, the data will not be imported, and an Error Report will be generated.
To select the job in the Create Time step, use the Trigger Data field for the Job Number in the CSV.
When updating the Process Filter to select column Types, you can select the Job Number, State, Category, and Template. This will ensure that the column is only displayed for the relevant field.
Add the Create Time Step
When using the Create Time step, fields can be updated in multiple ways:
- Automatically, using Merge Fields to insert the data from the imported CSV file.
- Manually, by selecting from the field options or inserting the data directly.
Using Merge Fields to select Columns
Merge Fields are used to select the CSV column to be used for each field in the Process Step.
Click the Merge Fields icon to display the list of available Merge Fields.
Column headings are displayed in the Trigger Data section of the Merge Fields window. Click the relevant Merge Field and press Save. The Merge Field will be displayed in the Step for the relevant field.
Additional Field Considerations
Configure the following fields as required for the practice.
The Status of the time entry cannot be imported from the CSV file and must be selected within the Create Time step. The same Status will apply to all imported entries.
If required, create separate CSV Import files for Draft and Submitted time.
When adding time to the CSV Import file, enter the values in minutes, for example, enter "75" for 1:15.
Decimals will be rounded up to the next whole number, for example, 7.5 will be rounded up to 8 minutes.
If importing time entries for the same staff member, select the user from the drop-down list. All rates assigned to the user will be available to select in the Rate drop-down.
Where the CSV Import contains multiple users, you will need to use a Merge Field to select the imported data. Only columns with a Type of User in the CSV Import Filter will be displayed.
When using Merge Fields to import the user on the Create Time step, only the user's default rate can be selected. Rates cannot be imported.
The Client can be set to Current Client, or a specific client, by typing in the name of the client. If selecting a client, all imported entries will be assigned to that client.
When using Current Client, time will be assigned to the client matched from the imported data, as per the selected Client Type column in the CSV Import filter.
The Date field on the Create Time step can be set to either the Current Date, Month End, or by selecting a specific date from the calendar. To use a date from the CSV Import, click the Merge Field icon to select the relevant column from the Trigger Data section.
Previewing and Running the Process
The Custom Process can be run from Automations - Processes by an FYI Admin, or a user in a User Group with permissions enabled for Automations.
Data will only be imported into FYI when the Automation Process is tested (a single entry only) or when the process is run (all CSV files in the selected Document View, up to a total of 10,000 rows).
A preview of the import will be available when testing and running the Automation process. If any of the rows contain invalid data, click the link to download the Error Report. Update the CSV file to correct the data as required before running the import.
Review the Process History
When a Process has been run, you can review the status and check what was processed. The Process can be reviewed by opening the process and clicking the History tab. Refer to Automation History.