Manage Custom Import Definitions
Import definitions allows users to create a custom format for importing items into the application. Use this function for routine imports such as soft cost expenses.
Add a Custom Import Definition
To add a custom import definition:
- From the left navigation panel, click Setup.
- In the Setup gray left navigation, click Import Definitions.
- From the toolbar atop the Import Definitions screen, click Add.
- On the Import Definition screen, in the Name field, name the import definition based on the device from which the data you will import the data, or the data type you will import. For example, postage or Lexmark, or printer, etc.
- In the Description field, enter a description, if desired.
- From the Delimiter field’s drop-down, click the delimiter. The delimiter indicates what separates the export data fields from each other, whether Comma, Pipe, Tab, or Whitespace.
- In the Data Has Header field’s drop-down, click Yes or No to indicate whether the export file includes a header row.
- From the Available Fields section’s column, click an export file field applicable to the import, and then click the double right arrows to move the field to the Selected Ordered Fields section’s column.
- The Select Ordered Fields column must be an exact match, top to bottom, with your import file’s columns. Drag and drop fields to re-order them as needed.
- If a column exists in your import file for which we do not have a field, or your import file contains fields you want to skip, highlight the field, and then click Ignore >.
The Ignore command prompts the system to skip the column in that position. - In the lower right corner, click Save.
The system saves your import definition.
To apply your import definition, see Custom Import Your Soft Cost Expenses.
Edit a Custom Import Definition
To edit a custom import definition:
- From the left navigation panel, click Setup.
- In the Setup gray left navigation, click Import Definitions.
- On the Import Definitions screen, single-click the import definition to highlight it.
- From the toolbar, click Edit.
- On the Import Definitions screen, make your edits.
- In the lower right corner, click Save.
The system saves your edits.
Activate/Deactivate a Custom Import Definition
You may want to deactivate an import definition but retain its settings for future use.
To deactivate or activate a custom import definition:
- From the left navigation panel, click Setup.
- In the Setup gray left navigation, click Import Definitions.
- On the Import Definitions screen, single-click the import definition to highlight it.
- From the toolbar, click Edit.
- In the lower left corner of the Import Definition screen, uncheck or check the Active checkbox, as applicable.
- In the lower right corner, click Save.
The system deactivates or activates the import definition.
Delete a Custom Import Definition
To deactivate or activate a custom import definition:
- From the left navigation panel, click Setup.
- In the Setup gray left navigation, click Import Definitions.
- On the Import Definitions screen, single-click the import definition to highlight it.
- From the toolbar, click Delete.
The Delete Import Definition message box reads: Are you sure you want to delete selected import definition? - Click Yes.
The system deletes the import definition.
Export a Custom Import Definition
To export a custom import definition:
- From the left navigation panel, click Setup.
- In the Setup gray left navigation, click Import Definitions.
- On the Import Definitions screen, single-click the import definition to highlight it.
- From the toolbar, click Export.
- On the Export Grid, use the radio buttons, drop-down, and entry fields to enter your criteria.
- Click Export.
The system downloads the import definition in your designated format to your default location.
Sample Custom Import Definition File
Client-Matter, Date, User, Quantity, Printer, Rate, Cost Code, GL Code, Description
19855,07/22/2022,RJ,10,2,10,ph,2100,Copies from Russ1, 19855,07/22/2022,RJ,10,2,10,ph2,2100,Copies from Russ2, |
Export Client-Matter
To export matter list from the application:
- From the left navigation, click Matters.
- From the tabs atop the Matters screen, click Export.
- On the Export Grid that opens, from the pages drop-down, select Custom.
- In the next field, enter the From and To page numbers that you wish to export.
- From the Export format drop-down, select CSV(.csv), and click Export.
- Open the CSV file and remove all the columns except CLIENT NAME, MATTER NAME, MATTER FILE#, CLIENT ID.
- Move this file to the designated folder required by your printing tool.