Import tool
The import tool loads records into EVX Software from a CSV file: clients, projects, tasks, time entries, expenses, invoices, dimension members, and more. Use it when you start, to bring in what you already have, or later for a large batch of records. Prepare the file well, import a few rows first, and check the result before you import the rest. Super Administrators run imports, and so can users whose group allows them to manage configuration.
SettingsData import
Match the separators and the date format to your file.
Jump to:
- What you can import
- Prepare the file
- Run the import
- Check the result
- Example: bringing in active projects
What you can import
Object Type lists the kinds of records you can import:
| Group | Object types |
|---|---|
| Work | Project, Task, Time entry, Notes, Folder, Workspace |
| Money | Actual expense, Invoice, Payment receipt |
| Clients | Client, Client sector, Vendor |
| Dimension members | Contract Stage, Document type, Expense category, Job phase, Labor category, Location, Project manager, Project type, Rate schedule, Timesheet Status |
To import contacts, use Contacts › Import / Export. See Contacts and companies.
Prepare the file
- Save it as CSV, one record per row.
- Put the field names in the first row, and keep First row contains field names at Yes.
- Use one date format and one decimal separator throughout.
- Import in order: dimension members and clients first, then projects, then tasks, then time and expenses, so each record finds what it belongs to.
- Use names exactly as they are in EVX Software, such as a client's or a labor category's name.
Run the import
-
Choose the Object Type.
-
Set the file options:
Option What it sets First row contains field names Yes if the first row holds the column names. Field delimiter (optional) The character between fields, if it isn't a comma. To assign country use Whether the file has Country code or Country name. Decimal separator, Thousand separator The separators your numbers use. Date format The date format of your file, such as mm/dd/yyyy. Taxes The taxes to apply, such as VAT, for invoices and expenses. -
In Files, choose the CSV file. EVX Software loads its data for import.
-
Follow the steps on screen to match the file's columns to fields, and import.
Check the result
- Open a few imported records and compare them with the file.
- Filter the lists by the imported client or project, and check the totals.
- If something is wrong, fix the records in EVX Software, or fix the file and import the corrected rows.
Example: bringing in active projects
A firm moving to EVX Software exports its active projects to a spreadsheet. The administrator imports its labor categories and clients first, then a file of five projects to check the result. The projects show the right client and contract amount, so she imports the other 120.
What you can do next
- Clients to check imported clients.
- Setting up dimensions for the dimension members your records use.
- System settings for the other firm-wide settings.