Home Portal

Skip to end of metadata
Go to start of metadata

About importing

What is data import?

Importing data into XTRF is simply putting the data from an external source into XTRF using IMPORT option.

What can be imported?

It is possible to import data in the following modules, with the subsequent specifics:

Clients

  • Profiles
  • Contact persons
  • Individual rates
  • Rates for the shared price lists

Vendors

  • Profiles
  • Contact persons
  • Individual rates
  • Rates for the shared price lists

CRM

  • Memo

  • E-mail

  • Call
  • Task
  • Event

To organize this content, there is a special XTRF Import Template with proper columns and bookmarks. Below it is described how to fill it properly.

How to work on the import template?

Configuring the system.

Before starting the importing process it is highly recommended to configure the system. All default values should be selected properly and all additional system values (such as languages or job types) added to the system. Configuration should be performed or overlooked by XTRF Team.

Download the Import Template.

The Import Template should be sent by XTRF Project Manager, or can be downloaded via link below.

Get the import template here.


Some fields are mandatory. They are marked in red. Read below for details.The mandatory fields.

Clients and Vendors

Clients and Vendors templates are technically the same, because of close similarity of both modules. This is the reason why these are described together. Obviously, the filled templates must be imported later in proper module.

 There are 3 mandatory fields for Clients and Vendors:

  • Name
    is used inside XTRF to identify clients or Vendors - it has to be unique. It is not possible to have more than one Client (or Vendor) with the same Name. This one will not be displayed in any documents or e-mail notifications.
  • Legal name
    contains the full name of the company, used in the legal documentation. In XTRF it appears in documents and notifications. It is also displayed in Customer Portal. This value does not have to be unique, so there can be multiple Clients/Vendors with the same Legal Name .
  • E-mail address
    is used in XTRF to communicate with the Clients and Vendors. It is very important to provide valid address. If this field does not have proper address, it would not be possible to communicate using XTRF and the Client would not be able to login into his Customer Portal. In case the email address is unknown, this field should also be filled by temporary value such as email@missing or simply your own company address.

Contact persons

Contact Persons for Clients and Vendors share the same mandatory fields:

  • Customer/Vendor Name
    is the Name of your Vendor or Client.
  • First Name
    is the name of the Contact Person. It will be displayed in the notifications. Surname is not mandatory.
  • E-mail address
    is used in XTRF to communicate with the Clients and Vendors. It is very important to provide valid address. If this field does not have proper address, it would not be possible to communicate using XTRF and the Client would not be able to login into his Customer Portal. In case the email address is unknown, this field should also be filled by temporary value such as email@missing or simply your own company address.

General Price Lists

Mandatory fields:

  • Source language
  • Target language
  • Job Type
  • Calculation unit
  • Rate value

The only difference between General Price List and Individual Rates sheets is the lack of Name column. Those records can be later found in Price Lists tab in Clients (or Vendors) module.

Individual rates

These sheet contains rates for both Customers and Vendors, which can be found later in one's profile, in Rates tab (in case of the Clients) or in Competencies and Rates tab in case of Vendors.

The Currency is set automatically to the default one.

Mandatory fields:

  • Client/Vendor name
    is used to match provided rate with specific partner profile. It should match exactly the Name of a Client or a Vendor.
  • Source language and Target language
    these fields contains the language combination. These are the System Values and MUST match the ones from System Values:Advanced -> Languages.
  • Job type
    is the kind of job for which the rates are specified. System Value.
  • Specialisation
    is the specialisation of a job. System Value.
  • Calculation unit
    is a piece of work for which the rates are specified. System Value.
  • Rate value
    is an amount of money per specific job and unit. No currency sign needed.

CRM

So far there is no CRM Import Template. For more information contacting XTRF Specialist is advised.

System Values

What are these?

XTRF is a closed system operating on an interior, pre-defined merits, called System Values. These comes in two versions: Basic and Advanced. Both can be added, deleted, edited and changed. All those operations can be done in XTRF-> Configuration-> System Values.

IMPORTANT! All non-default System Values must be first added to XTRF before the import starts.

 

All system values can be found in XTRF -> Configuration -> System Values: Basic and System Values: Advanced.

Below there are described some fields which contains the System Values. Each time they are mentioned, check the integrity between values in the template and the XTRF Configuration!

Filling fields based on the System Values

XTRF is designed to manage the translation process, so those values are simplified and unified for such usage.

To correctly fill the System Values fields, the data from it MUST match the value from XTRF's Configuration! Each time you fill fields listed below, make sure that both records are exactly the same.

Particular careful is strongly advised while filling these ones. Otherwise, the system would not connect two types of records nor import it.

Below, there is a full list of columns containing the System Values.

Clients and Vendors

 Click here to expand...
  • State/Province
  • Country
  • Project Manager
  • Sales Person Responsible
  • Branch
  • Category
  • Industries
  • Lead Source
  • Preferred Language
  • Custom Fields

Contact Persons

 Click here to expand...
  • Position
  • Department
  • State/Province
  • Country
  • Contact Language(s)
  • Mother Tongue(s)

Individual Rates

 Click here to expand...
  • Source Language
  • Target Language
  • Specialisations
  • Job Type
  • Calculation Unit

General Price Lists

 Click here to expand...
  • Source Language
  • Target Language
  • Specialisations
  • Job Type
  • Calculation Unit

 

 

There are also the non-mandatory fields, all listed below.

Client and Vendor profile

 Click here to expand...
  • Individual (Customers only)
  • Industries (Customers only)
  • Lead Source (Customers only)
  • Sales Notes (Customers only)
  • HR Notes (providers only)
  • Recruitment Source (providers only)
  • Status
  • Address Lines (1&2)
  • Postal Code
  • City
  • Correspondence Address (if left empty, the data from Address Lines would fill up)
  • Phone Numbers (1&2)
  • Mobile Phone Number
  • Fax
  • E-mail addresses 2&3
  • Disallow CRM mails
  • Website (1&2)
  • Bank Account
  • Bank Name
  • Account Number
  • Tax
  • Tax n. 2
  • Contact Number (internal system number)
  • (Social Media) Account Name
  • Notes
  • Prefered Language

Contact Persons

 Click here to expand...

  • Last Name
  • Initials
  • Gender
  • Position
  • Department
  • Use Partner Adress
  • Address Line 1&2
  • Postal Code
  • City
  • State / Province
  • Country
  • Phone
  • Phone 2&3
  • Mobile Phone
  • Fax
  • Email Address 2&3
  • Disallow CRM E-mails
  • Website 1&2
  • Contact Language(s)
  • Mother Language(s)
  • Social Medium
  • Account Name
  • Notes
  • Custom Fields (up to 10)

Individual Rates

 Click here to expand...
  • Partner Name
  • Currency
  • Source Language
  • Target Language
  • Also for Reverse Combination
  • Specialisations
  • Job Type
  • Calculation Unit
  • Rate Value
  • Minimum Charge

General Price Lists

 Click here to expand...
  • Currency
  • Source Language
  • Target Language
  • Also for Reverse Combination
  • Specialisations
  • Job Type
  • Calculation Unit
  • Rate Value
  • Minimum Charge

Importing data yourself

Step 1

Fill the Import Template. Make sure all data is correct and matches its column properly.

Step 2

Remove rows 1-4. Do not delete row 5!

Step 3

Save file as the .csv (comma separated values).

Import template vs .csv file

These two files differ in a format. Import template, to make it easier to edit, is saved as .xls file, which refers to the Microsoft Excel only. It is, as mentioned, easy to edit, but XTRF does not understand a file in such format. The .csv (which is the abbreviation of comma separated values) contains text only, and is much more likely to cooperate with XTRF.

Microsoft Excel defautly saves .csv files in Win-1250 encoding and with a comma as a separator. It also can be changed in Tools->Web Options->Encoding.

Step 4

Open your XTRF. Go to the proper module and find Import button.

Where to find proper import place?

In XTRF Template there are 8 different sheets.


When the process of converting to .csv is done, one template file would make 8 different .csv files. Not all of them are imported from the same place in a system.

 

Below there is a list of exact places where specific files should be imported:


Vendors

 Click here to expand...
Vendors are imported from the Vendors module.

Vendor Contacts

 Click here to expand...

Vendor contact persons are imported from the Vendors module, from the Contacts tab.

Vendor General Price List

 Click here to expand...

Vendor's price lists are imported from the Vendors module, from the Price Lists tab.

It is needed to add a new Price List with a specified name and currency. When it is done, move to the edit section by clicking on a proper icon on the right-side.

Then, there is an Import button which opens an importing menu, where the Vendor General Price List file should be uploaded.

Vendors Individual Rates

 Click here to expand...

Vendors Individual Rates are imported from the Vendors module.

Clients

 Click here to expand...

Clients are imported the same way as Vendors, but obviously from the Customers module.

Client Contacts

 Click here to expand...

Client contacts are imported from Customers module, and Contacts tab.

Client General Price List

 Click here to expand...

Client General Price List is imported from the Customers module, and Price Lists tab. Then it is needed to add a price list (by clicking a proper button) or edit the existing one. This operation is mandatory because the currency must be chosen.

When the currency is specified, inside the specific price profile there is an Import button.

Clients Individual Rates

 Click here to expand...

Client Rates are imported from the Customers module.

Then upload the .csv into the destined space.

Step 5

Match the file settings with the XTRF reading. XTRF provides a wide range of settings to make sure that data matches. 

 

To quickly check the data integrity there is a Live Preview section below.

Correct display

 

 

Not-correct display

  1. Wrong separator
  2. Wrong encoding

Clicking NEXT moves to the matching fields menu.

Step 6

Matching the fields.

Now it is time to connect the columns from the .csv file with a proper place in the database .   There are two sections: Columns is used for matching with fields in the database. Live Preview shows whether how your data will be imported.

In the Columns section, there are two columns. The first of them, Column Name is read directly from the first row of the .csv (this is why you do not delete this one from the import template!) The second, XTRF Field is filled with links to the proper places in the database. In the English localization the values from the first column should match the ones from the second. When using any other language, these must be found manually.

The XTRF Import Template is prepared in such a way that each column name matches a value from the XTRF Field.

 

 

If your data is formatted incorrectly (does not fit into a field), it is indicated in the Preview. In such case, the records in a file should be changed.

 

When the columns are matched, the data is ready to be imported. Click Next to start importing.

Step No.7

Depending on the number of records, importing process may take a while. There is a progress bar.

What if something goes wrong?

When it is finished, the import will be summarized. If any items have not been imported, a log file can be downloaded. It explains reasons for failed import.

The file only lists items that have not been imported. Reason is given in an extra column at the end. It automatically adds another column with a reason of incompatibility, to help with editing it.

When all lines are corrected, an Import Again button below takes you back to the start of the process.

All settings regarding encoding and fields matching are remembered and set like the last time.

 

 

  • No labels

3 Comments

  1. screenshoty musisz poobcinać z osobistych informacji i swoich okien

  2. In order to help you with this process we have prepared the import template. - tu ma być link?

  3. Customer Portal

    Vendor Portal

     

    wszędzie wielkimi