Info | ||
---|---|---|
| ||
|
Warning |
---|
If you need to import from TimeMatters, Counsel Pro, Amicus, or Bulk upload documents contact support@actionstep.com to get the desktop importer. |
Importing Overview Video
Widget Connector | ||||||
---|---|---|---|---|---|---|
|
The Data Import Tool is a powerful and flexible utility for importing and updating data. The tool supports your data in XLSX (preferred), XLS, and CSV formats.
...
...
The Import data screen shows the various import types that can be used.
Matter import types
- Matters - matter information, matter billing settings, and custom data
- File Notes - file notes and system notes
- Multi-row Data - multi-row custom data for one or more matters
- Parties - add parties to matters
- Tasks - add or update matter-associated and non-matter-associated tasks
- Trust Accounts -add or update a Trust account for one or more matters
Contact import types
- Contacts - contacts and their accounting settings
- Contact Notes - system or file notes on a contact record
- Contact Relationships
- Default Contact Types - assign default contact types to a contact
Billing import types
- Time Entries - time entries for timesheets
- Disbursements/Expenses - disbursements/expenses for timesheets
- Quick-codes - add quick-codes and designate where they can be used in the system
- Accounts Receivable - Imports your outstanding debtor balances split for each Fee credit lawyer by fees and Disbursements
Custom data import types
- Dropdown Field Options - the options for a dropdown field in a custom data collection
Import order suggestions
The order below is what we would suggest that anyone performing all of the imports should do. This takes into account data that is dependent upon previous imports to establish a logical order.
This assumes the user has set up the items needed for each import to be successful. This includes setting up participant types, action types, rate labels, expense templates, and fee income accounts where necessary.
...
Contacts - no dependency
...
Contact notes - dependent upon contacts import
Contact relationships - dependent upon creating relationships
Default contact types - dependent upon setting up participant types
...
Matters - dependent upon contacts
File notes - dependent upon matters
Mult-row data - dependent upon matters(contacts, if Linked-participant data field is supported)
Trust accounts - dependent upon matters
...
Expenses/Disbursements - dependent upon matters/contacts
Parties - dependent upon matters/contacts
...
Dropdown fields - (potentially) dependent upon multi-row data
...
Quick-codes - no dependency
...
Tasks - dependent upon contacts, optionally matters, optionally quick-codes
...
Time entries - dependent upon contacts, optionally matters, optionally quick-codes
...
Accounts receivables - dependent upon matter/contacts/account setup
...
Collect your data
Data must be in XLSX, XLS, or CSV format.
Check your data
See Import Type Reference for acceptable data formats and a complete list of fields.
Useful Tips for Importing Data
- Try import 1 row of data first before attempting large files to make sure everything works as expected
- If you are worried about breaking your live system, consider signing up for a trial to test importing your data first, then run on your live system
- Use a Microsoft Excel (xls or xlsx) file instead of CSV. This removes some common issues like date formatting
- Review your data before importing by opening in excel and review a few lines to make sure there is no unusual data or poorly named columns
- Most importantly, take your time with the import and don't rush!
...
Info |
---|
A matter import is being used in this example, however the same principles apply in each import. See the reference section of your import type for specifics. |
Select “Start import” on your desired import
Upload file
- File to import
- Supported formats - XLSX (preferred), XLS, and CSV
- Import mode
- Insert new data - Add records
- Update existing data - Update records
- File type - format of the file to import
Select Next
...
Column header
Actionstep attempts to automatically match the column headers to a corresponding field in Actionstep.
Note |
---|
Field names/column headers in reference section will automatically be detected by Actionstep. |
Field in Actionstep
Here, you match your column to a specific field in Actionstep. ANY column can be mapped to ANY field. That is, the column headers can be Actionstep field names OR be named something else.
Info |
---|
Example If the matter type were entered in a column called “Matter Name,” Instead of changing the column name, you can map the Matter type field to that column. |
Your data format
This column allows you to specify the format of the data in your import.
Info |
---|
Example In the image above, we’re selecting a matter type on the import. Here, we can specify whether we are using the Matter type ID or the Matter type name to identify the matter type. |
Data
Mapping
Select Next
Map data
This screen will confirm that data is being mapped properly.
Info |
---|
Example
|
If the value is incorrect, it can be changed.
...
Confirm
...
To confirm the import, select the Begin import process button.
After import
A screen will be displayed with the status of the import.
If, for any reason, you need to undo the import, select “Attempt a rollback?”
Info |
---|
If any records on the import are rejected, they will be included in a downloadable failure file that provides the reasons for failure. |
...
After choosing to do a rollback, you will have to confirm the deletion of the previously imported data and select “Start rollback.”
...
If the rollback was unsuccessful, a CSV with the failed records and failure reason can be downloaded.
...
Info | ||
---|---|---|
| ||
Bottom of Admin > Import data |
Every import is recorded in the History section of the import screen.
Created
Can be selected to view import summary or attempt a rollback:
Import
Displays the type of import and file used
Status
Displays the status of the import. If an import is pending, it can be selected and finished.
Total
Number of records imported, updated, or rolled back.
Info |
---|
Use the trash icon to delete the record. This does not affect imported items, just the record of the import. |
...
Info |
---|
Required import fields are highlighted red. Fields required for updating data are highlighted yellow. |
...
title | Matters Import Reference |
---|
Matters Import Reference
Download Matters Import Reference.xlsx
...
41
...
Number
...
Info |
---|
The section below is used to assign participants on a matter the actual name of the column would be Participant - Client or Participant - Attorney. |
...
title | File Notes Import Reference |
---|
File Notes Import Reference
Download File Notes Import Template.xlsx
...
title | Multi-Row Data Import Reference |
---|
Multi-Row Data Import Reference
When importing multi-row custom data, you will be prompted to select the data collection into which you are importing.
Info |
---|
Your data will be dependent upon the field types in your data collection. Each column should be mapped to a specific field. Below are all supported field types. |
...
Option 2
...
title | Parties Import Reference |
---|
Parties Import Reference
Download Parties Import Template.xlsx
...
Info |
---|
Participant type custom data can also be imported. Data format is determined by the custom field type. |
...
title | Tasks Import Reference |
---|
Tasks Import Reference
Download Tasks Import Template.xlsx
...
title | Trust Accounts Import Reference |
---|
Trust Accounts Import Reference
The Trust Accounts import is used to add trust accounts to matter.
Download Trust Accounts Import Template.xlsx
...
title | Time Entries Import Reference |
---|
Time Entries Import Reference
Import billable and non-billable time.
Download Time Entries Import.xlsx
Info |
---|
Fields highlighted in green are required when the time entry is billable. |
...
Participant ID
...
European (dd/mm/yyyy hh:mm)
...
title | Disbursements/Expenses Import Reference |
---|
Disbursements/Expenses Import Reference
Download Disbursements - Expenses Import Template.xlsx
...
title | Quick-codes Import Reference |
---|
Quick-codes Import Reference
Download Quick-codes Import Template.xlsx
...
Expand | ||
---|---|---|
| ||
Contacts Import ReferenceDownload Contacts Import Template.xlsx |
Expand | ||
---|---|---|
| ||
Accounts Receivable Import ReferenceDownload Accounts Receivable Import Template.xlsxSee updated article in Actionstep Help Center: https://support.actionstep.com/hc/en-us/articles/360025846813-Data-Import |