| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | INSTRUCTIONS | ||||||
2 | 1. Do not overwrite this template, create a copy for your use. | ||||||
3 | 2. Name the document with your company name. Example: Mapping document for COMPANY A | ||||||
4 | 3. Generate custom fields within your system for potential use previously the import request. (Keep in mind that custom fields will impact all candidate profiles and job vacancies, so they should serve a purpose for future candidates and jobs creations in TT.) | ||||||
5 | |||||||
6 | 4. We anticipate having the relationships between candidates, jobs, and job applications with IDs. Please ensure that your data files include this information | ||||||
7 | 5. If your export files lack column letters, please use references such as "second column" or "third column" instead. | ||||||
8 | 6. The mapping document needs to be completed by the customer, as it certifies the expectations for our data import service. | ||||||
9 | ⚠️ All field names in the header need to be in English. | ||||||
10 | ⚠️ We cannot work with conditional logic information in fields. Please avoid these. | ||||||
11 | |||||||
12 | |||||||
13 | In Previous provider (CSV) | In Teamtailor | Notes | ||||
14 | File | Column Name in import document | Column Letter in import document | Type of Field in TT (Custom or Default) | Field Name in TT | ||
15 | Candidatelist.xls | ID Candidates | A | none | none | Candidate IDs for importing. | |
16 | Candidatelist.xls | Resume Name / CV Name | B | none | none | Relation between docs and candidate IDs - ⚠️ This column has to match exactly the characters, wording and spacing of the file names. | |
17 | cv.zip | None | None | Existing Default field | CV/Resume | Docs | |
18 | candidatesdetails.xls | Salary Dream | C | Candidate Custom Field (Field type: Number) | Salary Expectation | If necessary, write notes to make clear your expectation of data transfer on this field. | |
19 | candidatesdetails.xls | Linkedin URL | D | Existing Default field | |||
20 | moreinfocandidate.xls | HomeTown | B | Candidate Custom Field (Field type: Text) | Residence | ||
21 | moreinfocandidate.xls | Advisor | D | Candidate Custom Field (Field type: Text) | Referrer | ||
22 | moreinfocandidate.xls | Notes interviews | E | Existing Default field | Comments | ||
23 | moreinfocandidate.xls | Notes mail campaigns | F | Existing Default field | Comments | ||
24 | moreinfocandidate.xls | Tags | G | Existing Default field | Tags | ||
25 | joblist.xls | ID jobs | A | none | none | Job IDs for importing. | |
26 | joblist.xls | Job Name | B | none | none | Title for Jobs | |
27 | |||||||
28 | |||||||
29 | |||||||
30 | |||||||
31 | |||||||
32 | |||||||
33 | |||||||
34 | |||||||
35 | |||||||
36 | |||||||
37 | |||||||
38 | |||||||
39 | |||||||
40 | |||||||
41 | |||||||
42 | |||||||
43 | |||||||
44 | |||||||
45 | |||||||
46 | |||||||
47 | |||||||
48 | |||||||
49 | |||||||
50 | |||||||
51 | |||||||
52 | |||||||
53 | |||||||
54 | |||||||
55 | |||||||
56 | |||||||
57 | |||||||
58 | |||||||
59 | |||||||
60 | |||||||
61 | |||||||
62 | |||||||
63 | |||||||
64 | |||||||
65 | |||||||
66 | |||||||
67 | |||||||
68 | |||||||
69 | |||||||
70 | |||||||
71 | |||||||
72 | |||||||
73 | |||||||
74 | |||||||
75 | |||||||
76 | |||||||
77 | |||||||
78 | |||||||
79 | |||||||
80 | |||||||
81 | |||||||
82 | |||||||
83 | |||||||
84 | |||||||
85 | |||||||
86 | |||||||
87 | Fecha actualización TC | Custom field | Fecha actualización TC | Y | Candidatos-Muestra15 | ||
88 | |||||||
89 | |||||||
90 | |||||||
91 | |||||||
92 | |||||||
93 | |||||||
94 | |||||||
95 | |||||||
96 | |||||||
97 | |||||||
98 | |||||||
99 | |||||||
100 | |||||||