Skip to main content
Administration

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​

Object Type lists the kinds of records you can import:

GroupObject types
WorkProject, Task, Time entry, Notes, Folder, Workspace
MoneyActual expense, Invoice, Payment receipt
ClientsClient, Client sector, Vendor
Dimension membersContract 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​

  1. Choose the Object Type.

  2. Set the file options:

    OptionWhat it sets
    First row contains field namesYes if the first row holds the column names.
    Field delimiter (optional)The character between fields, if it isn't a comma.
    To assign country useWhether the file has Country code or Country name.
    Decimal separator, Thousand separatorThe separators your numbers use.
    Date formatThe date format of your file, such as mm/dd/yyyy.
    TaxesThe taxes to apply, such as VAT, for invoices and expenses.
  3. In Files, choose the CSV file. EVX Software loads its data for import.

  4. 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​

  1. Clients to check imported clients.
  2. Setting up dimensions for the dimension members your records use.
  3. System settings for the other firm-wide settings.
Previous: Event tickets settings