Import

Import

Introduction

Abraxio has mass import capabilities for the following data :
  1. Imports of “Repository” data (mainly used during environment initialisation)
    1. Suppliers
    2. Contacts for your suppliers
    3. Contracts from your suppliers
    4. Contract deadlines for your suppliers
    5. Projects and activities
    6. Budgets (budget lines)
    7. Users
  2. Recurring imports
    1. Invoices ( Mass import of invoices and time spent (abraxio.com) )
    2. Internal and external times ( Mass import of invoices and times spent (abraxio.com) )
These import features will allow you to save time when initializing your Abraxio environment you have a large volume of data and you have relatively well-structured data files.

Principles

The import features work according to the following principles :
  1. Some imports are generally carried out only once to initialise the data repository (Suppliers, Users, Projects and Activities, etc.) and may be supplemented by other imports to enhance the data created.
  2. Other imports are carried out on a recurring basis (invoices, time spent).
  3. For "Repository" data imports: imports work on a creation/enrichment basis: you can therefore carry out successive imports when "re-importing" existing data.
  1. For these “Repositories” imports, only empty fields will be updated.
  2. For recurring imports (invoices and past times) it is not useful to update the fields (deletion then reimport.
  1. The import formats are fed by the configuration of your environment : for example, if you create analytical dimensions, these will be taken into account in the import formats downloaded from Abraxio
    1. Example: supplier import file before and after customization of the environment, the import format is adapted as well as the choice lists in the file.

Initial import format delivered with the default Abraxio configuration


Import format after customizing the analytical axes on suppliers:


  1. the Abraxio Dashboard : click on (1) then Import (2)
  1. the modules concerned :


After clicking on the "Import" or "Import ...." menu, select the type of data you want to import and click on "Next step" :



Depending on the imports, two options are available:
  1. Download Import Template : This allows you to download the Abraxio import template file

  1. For invoices and times , another option is available: this allows you to carry out imports from your file (exported from your ERP or other) by downloading your file then carrying out a data mapping

Accepted file formats

Two types of files are accepted:
  1. CSV files:
  1. .csv extension
  1. Field separator: comma "," or semicolon ";"
  1. Date: DD/MM/YYYY or YYYY/MM/DD, DD-MM-YYYY or YYYY-MM-DD, DD.MM.YYYY or YYYY.MM.DD
  1. Excel files:
  1. Extension .xlsx, .xlsm
  1. Taking into account the tab named "Data", failing which taking into account the 1st tab

Description of import models

The import files consit of 3 tabs:
  1. Instructions: presents the instructions for using the file and the data dictionary (list of columns in the file with their group, name, type, format and whether they are mandatory or not)
  2. Data: template of data to be entered with choice lists and configured formats
  3. References: list of choices from the Abraxio environment, taking into account the personalized lists (analytical dimensions) of your environment.

Data import strategy

Depending on your Abraxio environment, two strategies are possible to import data :
  1. Strategy 1 - Import from the standard environment configuration :
    1. It is possible to extract the import formats from a blank environment and import from these files. In this case the import formats will inherit the default configuration proposed.
    2. You can then personalize your environment and then complete the fields with “enrichment” type imports after having re-extracted the personalized import models.
  2. Strategy 2 - Import from a custom configuration:
    1. At first, you can download the import templates to understand the required format and the list of data you can import.
    2. Then, we advise you to start creating some objects in your environment and to create / update the analytical dimensions corresponding to your context.
    3. Once these analytical dimensions have been created and updated, you will be able to download the import models again, they will benefit from the modifications that you have made on the analytical dimensions (lists of values and analytical dimensions).
    4. You will be able to carry out imports by directly integrating the customization elements of your environment.

Data import order - Import prerequisites and dependencies

Some imports work independently, others require certain prerequisites before they can be performed.
Import dependencies and prerequisites are described below according to the following legend:
  1. Import of suppliers and contacts:
There are no prerequisites before importing suppliers.
If you wish, you can customize 3 analytical dimensions.
For your suppliers' contacts, the supplier to which they are attached must be created beforehand.
  1. Importing users
There are no prerequisites before importing users.
If you wish to activate employee management in the Management module ( Collaborator management (abraxio.com) ) and import information relating to your employees, you can first:
- create managed teams in the Management module,
- create/import your suppliers in order to define a supplier for users corresponding to “External service provider” type collaborators,
- update the profiles allowing you to qualify your employee with a job profile specific to your organization.
  1. When importing an External Contractor category Collaborator, the Contractor supplier is mandatory.
  2. If the supplier is not filled in, Abraxio imports the user as an "internal profile".
  1. Importing contracts and contract deadlines:
Two prerequisites are necessary before importing contracts:
- Have created the supplier to which the contract is attached
- Have created the user who will be defined as the Contract Manager (to be created manually or by import) --> This user is by default the administrator of the Abraxio envrionment.
If you wish, you can define 2 analytical dimensions  on contracts in the environement.
In the same way, as deadlines are attached to a contract, they can only be imported if the contract has been created first.
  1. Importing projects and activities
There are no prerequisites for importing projects and activities.
If you wish, you can first:
- Create/Import users in order to inform Project Managers and Sponsors about projects (if the field is not filled in, it will be empty after import)
- Create Portfolios adapted to your organization: if you have a large volume of projects/activities and you wish to create specific portfolios, it is preferable to create them before importing, this will allow you to fill in this field directly and will avoid having to having to modify it on each project after import
- Create and/or update Project analytical dimensions adapted to your context in order to take the values directly from the import file.
By default, if you do not create a portfolio, projects and activities will be stored in Abraxio default portfolios.

For Activities, you can specify the type of Sub-budget to create (RUN or BUILD).  It is not mandatory. If it is not filled in, the Activity sub-budget type will be RUN by standard. For projects, the sub-budget type is mandatory BUILD, regardless of the value entered in the file.

- Update project analytical dimensions : as for portfolios, if you wish to personalize the analytical dimension, it is preferable to do so before import, you will then be able to enter the dimensions in the import file and avoid returning to each Project /Activity manually.

  1. Importing budgets
Three prerequisites are essential before importing budget lines:
- the creation of Projects and Activities (and consequently associated sub-budgets)
- the creation of the target budget year for the import and the transition of this year to the "In preparation" or "Active" state
- the presence of sub-budgets in the Finance module : if the sub-budgets were not created via the Finance module but by the creation of Projects/Activities from the Portfolio module, it is necessary to "pin" them here in the Finance module in order to see them appear in the sub-budget list in the Global View screen. To do this, you can click on and select the existing sub-budgets in order to pin them in the budget exercise.

If you wish, you can:
- Create and/or update Finance analytical dimensions adapted to your context in order to take the values directly from the import file (Accounting Ref, Business Service, etc.)
- Create your suppliers so that you can inform them about each import budget line.
  1. Importing invoices
Two prerequisites are necessary before importing invoices:
- the creation of the supplier
- the creation of the target budget year for the import and the transition of this year to the “ Active ” or “Closing” state

If you wish, you can:
- define the Finance analytical dimensions in order to qualify the invoices on the same dimensions
- create projects and activities in order to enter their descriptions on the imported invoice lines
- create users to assign invoices to a manager.
Invoices can be imported without a Budget line, but cannot be charged to the budget.
The mass import of invoices is detailed in the article Mass import of invoices and time spent (abraxio.com) .
  1. Import past tenses
Two prerequisites are necessary before importing past times:
- the creation of the supplier
- the creation of the managed employee to whom the time spent is allocated.

If you wish, you can:
- define the Finance analytical dimensions in order to qualify the time spent on the same dimensions
- create projects and activities in order to enter their labels on the imported times
Time can be imported without a Budget line, but cannot be charged to the budget.
The mass import of past times is detailed in the article Mass import of invoices and past times (abraxio.com) .

Budgetary approach

If you want to start by managing your budget:
  1. Import your Suppliers (and possibly Contacts, Contracts, Deadlines)
  2. Create your Budget exercise in the Finance module and complete the Finance module parameters
  3. Change your import target fiscal year to “In preparation”
  4. Import your projects and activities and pin your sub-budgets in the Finance module OR directly create your sub-budgets in the Finance module
  5. Create/Update your Finance analytical dimensions by creating some data manually
  6. Export the budget import template and complete it
  7. Import your Budget
  8. Change your Budget to “Active” state
  9. Import the consumption: Invoices (time, €), Time spent

Approach Portfolios Projects

If you want to start by managing your Project portfolio:
  1. Create your portfolios
  2. Create/ Update the Projects & Activities analytical dimensions
  3. Create your budget exercise
  4. Import users intended to be Project Managers or Sponsors
  5. Download the Projects & Activities import format and fill in the template
  6. Import your Projects and Activities

Implementation of data imports

Step 1: Download the import template
Step 2: Read the file format and data dictionary to understand the required format and the list of data you can import
    1. Identify mandatory/optional information
    2. Identify the different types of lists: data referenced in Abraxio (Portfolio, Projects/Activities, etc.), lists of non-modifiable Abraxio values (State, Sub-budget type, Expenditure category, etc.), lists values equivalent to analytical dimensions (lists of values can be modified and most dimensions can be configured)
Step 3: If necessary, update the “List” in Abraxio by creating data or configuring the analytical dimensions.
Step 4: Download the import template again: it will be updated with the lists created.
Step 5: Complete the import model.
Step 6: Test the import of 1 or 2 lines (so that you can easily delete them if necessary).
Step 7: Check that the import result is as expected.
Step 8: If this is the case, import all the data once the file is completed, otherwise make the necessary modifications, after deleting the imported test data.

    • Related Articles

    • Mass import of invoices and time spent

      How it works Abraxio offers a mass import system for invoices and internal times to industrialize your budget consumption tracking. The main steps of the process are: Upstream creation of an Excel or CSV file containing internal invoice or time ...

    • Mass import of orders

      How it works This system works in 2 steps: Step1 : Importing order data from an .xlsx or .csv file into a batch of orders to be processed. Step 2: Processing and integration of the lines in an imported order batch You can use your own file (extracted ...

    • Abraxio APIs - Management

      Preamble APIs allow you to interface your IS with Abraxio to automate processes, retrieve data from Abraxio or integrate data into Abraxio. API calls are secured using the OAuth2 protocol. Presentation of the scopes When creating your API accesses, ...

    • How do I initialize the management of planned absences?

      Introduction Abraxio allows you to manage your collaborator's planned absences in order to meet two objectives: Pre-populate timesheets and avoid double entry of absences for teams. Integrate future absences for a more accurate and accurate ...

    • Team building: Management and managed teams

      To manage your employees and their assignments, timesheets, etc. you need to create teams and define their managers. They will be responsible for managing employees' capacities, their arrival and departure dates, validating their timesheets, etc. In ...