Last modified by caterina on 2021/12/28 14:34
Show last authors
1 {{layout}}
2 {{layout-section ac:type="two_right_sidebar"}}
3 {{layout-cell}}
4
5
6 {{id name="Start ScreenSteps Content"/}}
7 This lesson describes how to create an mapping template to be used during the import process. Detailed instructions on importing a file into the ONEcount system are found in the "How to Import a File" lesson.
8
9 Please refer to the User Operations Quick Start Guide for important information about basic concepts and rules relating to imports and bulk operations.
10
11 === OPEN THE "DATA MANAGEMENT" WINDOW ===
12
13 [[image:attach:Screen Shot 2021-10-09 at 4.33.36 PM (2) copy 3.png||thumbnail="true" height="250"]]
14
15 **Click on "Import Tool" in the sub-menu.**
16
17 [[image:attach:Screen Shot 2021-10-09 at 4.33.36 PM (2) copy 4.png||thumbnail="true" height="250"]]
18
19 This will open the Import window, as shown below.
20
21 [[image:attach:media_1444246962281.png||align="center"]]
22
23 === CREATE THE MAPPING TEMPLATE ===
24
25 **~1. In the Import window click on "Browse" (1), search for and select your import list, and select "Upload File" (2).**
26
27 [[image:attach:media_1444246725508.png||align="center"]]
28
29 (% style="color: rgb(0,0,0);" %)You have three options when creating a template:
30
31 (% style="color: rgb(0,0,0);" %)1. Create Mapping then Import List - Create a template and continue with the import.(%%)
32 (% style="color: rgb(0,0,0);" %)2. Create Mapping Only - Use the same import list to create mapping template(s) without continuing with an actual import.(%%)
33 (% style="color: rgb(0,0,0);" %)3. Create Mapping Only - Use different list(s) with different fields to create template(s) without continuing with an actual import.
34
35 {{panel}}
36 **Complete Step 2 only if you plan on continuing with the import after creating the import mapping template.**
37 {{/panel}}
38
39 {{panel}}
40 **If you plan on using the same import list to create multiple templates without proceeding with actual imports as you complete each template, complete Step 1 then move on to Step 3.**
41
42 **If you plan on using a different list(s) with different fields to create multiple templates without proceeding with imports as you complete each template, complete Step 1 then move on to Step 3.**
43 {{/panel}}
44
45 \\
46
47 \\
48
49 **2. If you plan to proceed with an import after creating the import template, give your import an Import Title (1), Import Description (2), select a Source Code if using one (3), select the product(s) from the Product List (4), and select a Product Status (5).**
50
51 [[image:attach:media_1444246898428.png||align="center"]]
52
53 You can select multiple products by holding down the CTRL (PC) or CMD (MAC) key when clicking on a product name.
54
55 Below the Product List, you will see a list of any existing Import Mappings (templates), if any.
56
57 [[image:attach:media_1444247218690.png||align="center"]]
58
59 To modify an existing template, select "Use". The Template Description should provide you with a description of the template.
60
61 To delete an existing template, select "Delete".
62
63 \\
64
65 **3. Proceed to the mapping section and map your fields (either from scratch for a new template or by modfying an existing template).**
66
67 [[image:attach:3._Proceed_to_the_mapping_section_and_map_your_fields__ei.png||align="center"]]
68
69 To map fields:
70
71 * Select data fields/questions to map from the ONEcount database (1) then select "Activate" (2). Selected questions/data fields will appear in the "Active Question Headers" column (3). (Move from left to right.)
72 * Select the data fields/columns to map from the CSV import file (4) then select "Activate" (5). Selected data fields/columns will appear in the "Active CSV Headers" column (6). (Move from right to left.)
73
74 To move more than one field at a time into the "Active Header" box, select multiple fields then click on "Activate".
75
76 To remove a field from the Active column, select the field and click on "Deactivate". Be sure to remove the same field from the other Active column.
77
78 When mapping fields, Active Question Headers and Active CSV Headers must match, ie the fields must bbe in the same order. (See purple arrows in screenshot above.)
79
80 Question Header and CSV Header field names don't need to be identical, e.g. a Question Header may be "Email Address" and CSV Header "Email".
81
82 (% style="color: rgb(255,0,0);" %)If you plan on completing an import after creating the template, select field(s) against which to check for duplicates.
83
84 **3a. Select fields to check duplicates against.**
85
86 [[image:attach:3a.png||align="center"]]
87
88 {{error}}
89 (% style="color: rgb(0,0,0);" %)**ALWAYS BE SURE TO CHECK FOR DUPLICATES. IF YOU DON'T, DUPLICATE RECORDS WILL BE ADDED TO THE ONECOUNT DATABASE.**
90 {{/error}}
91
92 {{error}}
93 (% style="color: rgb(0,0,0);" %)**When saving a mapping template, only the Active Headers will be saved. Fields to check for duplicates WILL NOT be saved.**
94 {{/error}}
95
96 (% style="color: rgb(223,0,0);" %)
97
98
99 **3b. If proceeding with an import, set Request Date field, Expiration Date field, and Media Files fields (all optional).**
100
101 [[image:attach:media_1444248302872.png||align="center"]]
102
103 Select the column in your import file to set the Request Date (1), select expiration date field to specify expiration date (2), select the column with media file filenames/paths to link media files (3).
104
105 === SAVE THE MAPPING TEMPLATE ===
106
107 **4. Review mapping and selections, then click "Set" at the bottom of the page.**
108
109 [[image:attach:media_1444247300304.png||align="center"]]
110
111 When "Set" is clicked on, the three buttons below will appear.
112
113 \\
114
115 **5. Select "Save Mapping Template".**
116
117 [[image:attach:media_1444247323974.png||align="center"]]
118
119 (% style="color: rgb(223,0,0);" %)**When saving a mapping template, only the Active Headers will be saved. Fields to check for duplicates WILL NOT be saved.**
120
121 To proceed with the import without saving the mapping template, select "Import" (2).
122
123 To change the import mapping without importing, select "Reset" (3).
124
125 \\
126
127 **6. After selecting "Save Mapping", a pop-up window will appear. Give the template a title (1) and description (2), then click Save" (3).**
128
129 [[image:attach:6.__After_selecting_Save_Mapping__a_pop-up_window_will_ap.png||align="center"]]
130
131 In order to easily identify templates, especially if you have multiple templates, it is a good idea to be as descriptive as possible with the template title and description.
132
133 \\
134
135 **7. When you select "Save", you will be brought back to the mapping screen where you will see your new template at the bottom of the list of existing Import Mappings (Templates).**
136
137 [[image:attach:7.__When_you_select_Save__you_will_be_brought_back_to_the.png||align="center"]]
138
139 \\
140
141 **8. You have successfully saved your import mapping template!**
142
143 If proceeding with an import, select "Import" below the mapping section (all of the mapping from creating the template will be in tact).
144
145 To create a new import mapping template using the same import file, refresh your browser and follow steps 4-7 above.
146
147 To create a new import mapping template using an import file with different fields, follow steps 1-7 above.
148
149
150
151 {{id name="End ScreenSteps Content"/}}
152 {{/layout-cell}}
153
154 {{layout-cell}}
155 {{panel title="Search All Documentation:"}}
156
157
158 {{livesearch/}}
159 {{/panel}}
160
161 {{panel title="Search USER OPERATIONS Documentation:"}}
162
163
164 {{pagetreesearch rootPage="User Operations - Managing Your Data"/}}
165 {{/panel}}
166
167 {{panel title="On this page:"}}
168
169
170 {{toc/}}
171 {{/panel}}
172
173 {{panel title="More USER OPERATIONS Documentation"}}
174 {{expand}}
175 **Add Users
176 **
177
178 (% style="margin-left: 60.0px;" %)
179
180
181 (% style="margin-left: 60.0px;" %)
182 [[Preparing for Data Import>>doc:Getting Started - Preparing for Data Import]]
183
184 (% style="margin-left: 60.0px;" %)
185 [[doc:Pre-Import Checklist]]
186
187 (% style="margin-left: 60.0px;" %)
188
189
190 (% style="margin-left: 60.0px;" %)
191
192
193 (% style="margin-left: 60.0px;" %)
194 [[How to Use an Import Mapping Template>>doc:Import - How to Use an Import Mapping Template]]
195
196 (% style="margin-left: 60.0px;" %)
197 [[doc:Add Audience]]
198
199 (% style="margin-left: 30.0px;" %)
200 **Batch Operations**
201
202 (% style="margin-left: 60.0px;" %)
203 [[doc:Bulk Operation - How to Perform a Batch Delete]]
204
205 (% style="margin-left: 60.0px;" %)
206 [[doc:Bulk Operation - How to Perform a Batch Product Change]]
207
208 (% style="margin-left: 60.0px;" %)
209 [[doc:Bulk Operation - How to Perform a Batch Status Change]]
210
211 (% style="margin-left: 60.0px;" %)
212 [[Bulk Operation - How to Perform a Batch Suscribe>>doc:Bulk Operation - How to Perform a Batch Subscribe]]
213
214 (% style="margin-left: 60.0px;" %)
215 [[Bulk Operation - How to Perform a Batch Unsubscribe>>doc:Bulk Operation - How to Perform a Batch UnsubscribeKill]]
216
217 (% style="margin-left: 60.0px;" %)
218 [[Bulk Operation - How to Perform a Merge of Duplicate Users>>doc:Bulk Operation - How to Perform a Bulk Merge of Duplicate Users]]
219
220 (% style="margin-left: 30.0px;" %)
221 **Target Audience Segments**
222
223 (% style="margin-left: 60.0px;" %)
224 (% style="color: rgb(0,51,102);" %) [[ Target Engine >>doc:Segment Manager]]__
225 __
226
227 \\
228
229 \\
230 {{/expand}}
231 {{/panel}}
232
233 \\
234
235 \\
236
237 \\
238
239 \\
240
241 \\
242
243 \\
244 {{/layout-cell}}
245 {{/layout-section}}
246 {{/layout}}