How to import and export data

It is important to know that you can import information regarding Client, Project, Person, Timesheet and Invoice.

Regarding the export, you can export all the information you have in your account (imported or added manually).

Tip: If your account is new and you don`t have any data yet, you can start an export company data job so you can see what information is supported by elapseit; you will also have a CSV template that you can use for import.

A. Create a CSV template

To import data, you have to create a CSV template first. You can configure templates based on the format of your CSV file.

  1. Go to Settings => CSV templates (import);
  2. Click on the add button (green button with a plus);
  3. Add a name and a format date for your template;
  4. Select template fields – for each category you have to add the mandatory information (marked with a * ), and other needed information if you want to;
  5. Click Save button.

Tip: When you create a CSV template, be aware of the Date format – the format in the CSV file must be the same as the one you choose for the template.

B. Import data using the created template

After you created the template based on your CSV files, you can import the data in elapseit.

  1. Go to Settings => Import;
  2. Click on the Start import job button;

First step in importing data

       3. Choose your template from the drop-down list and select the CSV file from your computer;

Import your CSV file

      4. After you selected the CSV file, if the created template match with your file, a view with the information will open and you just click on the Import button;

The CSV file for import is OK

       5. If the CSV file that you want to import does not match the created template, a notification will pop-up in the lower right side of your screen;

Import file is not matching

       6. After you started the import of the correct file, you need to click on the Refresh button, to see the status of the import (Started => In Progress => Success) – it will take a couple of minutes;

Import statusImport data in progressImport successfully done

       7.  When the Import is done, you have the options to rollback or to delete the operation.

Rollback or delete the operation

C. Export data

To export your data from elapseit is the simplest operation but you have to keep in mind that only the Administrator and the Owner can export all the company data.

  1. Go to Settings => Export => Start export company data job;

Export company data

2. A new view will open and you can choose what information you want to export, if you want media and if you are interested in a period of time. By not choosing a period of time, the export will contain all your company data you have in elapseit;

Choose data you want to export

3. After you started the exporting job, you have to click the refresh button, a couple of times, until the export is done and the download icon will be visible;

Export data refresh step

4. Click on the download icon and all the information will be downloaded on your computer as a zip file.

Export data is finished

Leave a Reply