Importing rate cards – procedure and template
- Damian Rozmiarkowski (Unlicensed)
- Damian Rozmiarkowski
IMPORTANT!
The tool described in this article is no longer supported since XTM v.13.6!
Guidelines
Before reading this article, we recommend that you find out about standard, “manual" way to create rate cards for users. If so, see the following article: How to create a rate card for a linguist. |
|---|
The whole process of importing and implementation takes place on the XTM International Support team side. When requesting such an action, you should create a .csv file and provide it to them.
Find attached the template file.
A provided file can contain the IDs of multiple user/LSPs for whom rate cards need to be added.
IMPORTANT!
When creating a file with multiple user/LSP IDs, separate them with a comma!
Also, you might sometimes incorporate rate cards that have the same language combination, same workflow steps and same subject matter. Keep in mind that this will not work because the rate cards are duplicated and either need different subject matters or workflow steps.
A specific version of this kind of file needs to be created.
DATA FROM THE TEMPLATE:
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
EXPLANATION:
First line → This is a primary header: do not change it.
IMPORTANT!
There should only be one header at the top! Copying this header for each rate card is incorrect.
1 |
|
|---|
Second line → Either enter LSP IDs or USER IDs , but not both! Note that the Client field is required, as it is referenced as the company name to which the rate card is being imported.
Example (user):
2 |
|
|---|
Example (LSP):
2 |
|
|---|
Third line → This is a general header: do not change it.
3 |
|
|---|
The headers above point to this part of the rate card:
Fourth line → Breaking line that should not be changed. It might seem empty, but when you edit the file in Excel/OpenOffice Calc/Notepad++, it really is.
For example, if you want to add a Minimum Charge, you need to add it to the line below, which is row 5, not row 4. This is what it looks like in the CSV file:
4 |
|
|---|
Fifth line → Identifies the rate card data that is being created as it matches the headers from line 3.
To specify the language combination, use this format: target_languageCode-source_languageCode, e.g. en_GB-pl_PL. Language codes can be found in the XTM Cloud manual.
The format should be en_US-de_DE
When adding more than one language combination, separate them with separated by commas without spaces, e.g. en_GB-pl_PL,en_GB-ar_AA.
5 |
|
|---|
Sixth line → Headers for the next part of the rate card.
6 |
|
|---|
7th, 8th line, and so on → Indicate the data per workflow step ("Translate" and "Correct" ).
7 |
|
8 |
|
9 |
|