Last modified by caterina on 2025/06/27 12:14

From version 6.1
edited by steven@one-count_com
on 2018/07/10 17:43
Change comment: There is no comment for this version
To version 4.1
edited by melanie@one-count_com
on 2016/12/08 11:52
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -Import - How to Create an Import Mapping Template
1 +Import - How to Create an Import Mapping Template (v12.x)
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.steven@one-count_com
1 +XWiki.melanie@one-count_com
Content
... ... @@ -8,13 +8,13 @@
8 8  
9 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 10  
11 -=== OPEN THE "IMPORT" WINDOW ===
11 +=== OPENING THE "IMPORT" WINDOW ===
12 12  
13 -**Select USER OPERATIONS from the Main Menu.**
13 +=== Select USER OPERATIONS from the Main Menu. ===
14 14  
15 15  [[image:attach:media_1444246643838.png||align="center"]]
16 16  
17 -**Click on "Import" in the sub-menu.**
17 +=== Click on "Import" in the sub-menu. ===
18 18  
19 19  [[image:attach:media_1444246682217.png||align="center"]]
20 20  
... ... @@ -22,9 +22,9 @@
22 22  
23 23  [[image:attach:media_1444246962281.png||align="center"]]
24 24  
25 -=== CREATE THE MAPPING TEMPLATE ===
25 +=== CREATING THE MAPPING TEMPLATE ===
26 26  
27 -**~1. In the Import window click on "Browse" (1), search for and select your import list, and select "Upload File" (2).**
27 +=== 1. In the Import window click on "Browse" (1), search for and select your import list, and select "Upload File" (2). ===
28 28  
29 29  [[image:attach:media_1444246725508.png||align="center"]]
30 30  
... ... @@ -34,22 +34,14 @@
34 34   (% 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.(%%)
35 35   (% 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.
36 36  
37 -{{panel}}
38 38  **Complete Step 2 only if you plan on continuing with the import after creating the import mapping template.**
39 -{{/panel}}
40 40  
41 -{{panel}}
42 -**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.**
39 +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.
43 43  
44 -**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.**
45 -{{/panel}}
41 +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.
46 46  
47 -
43 +=== 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). ===
48 48  
49 -
50 -
51 -**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).**
52 -
53 53  [[image:attach:media_1444246898428.png||align="center"]]
54 54  
55 55  You can select multiple products by holding down the CTRL (PC) or CMD (MAC) key when clicking on a product name.
... ... @@ -62,10 +62,8 @@
62 62  
63 63  To delete an existing template, select "Delete".
64 64  
65 -
57 +=== 3. Proceed to the mapping section and map your fields (either from scratch for a new template or by modfying an existing template). ===
66 66  
67 -**3. Proceed to the mapping section and map your fields (either from scratch for a new template or by modfying an existing template).**
68 -
69 69  [[image:attach:3._Proceed_to_the_mapping_section_and_map_your_fields__ei.png||align="center"]]
70 70  
71 71  To map fields:
... ... @@ -83,39 +83,30 @@
83 83  
84 84  (% 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.
85 85  
86 -**3a. Select fields to check duplicates against.**
76 +=== 3a. Select fields to check duplicates against. ===
87 87  
88 88  [[image:attach:3a.png||align="center"]]
89 89  
90 -{{error}}
91 -(% 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.**
92 -{{/error}}
80 +(% style="color: rgb(223,0,0);" %)**ALWAYS BE SURE TO CHECK FOR DUPLICATES. IF YOU DON'T, DUPLICATE RECORDS MAY BE ADDED TO THE ONECOUNT DATABASE.**
93 93  
94 -{{error}}
95 -(% 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.**
96 -{{/error}}
82 +(% 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.
97 97  
98 -(% style="color: rgb(223,0,0);" %)
84 +=== 3b. If proceeding with an import, set Request Date field, Expiration Date field, and Media Files fields (all optional). ===
99 99  
100 -
101 -**3b. If proceeding with an import, set Request Date field, Expiration Date field, and Media Files fields (all optional).**
102 -
103 103  [[image:attach:media_1444248302872.png||align="center"]]
104 104  
105 105  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).
106 106  
107 -=== SAVE THE MAPPING TEMPLATE ===
90 +=== SAVING THE MAPPING TEMPLATE ===
108 108  
109 -**4. Review mapping and selections, then click "Set" at the bottom of the page.**
92 +=== 4. Review mapping and selections, then click "Set" at the bottom of the page. ===
110 110  
111 111  [[image:attach:media_1444247300304.png||align="center"]]
112 112  
113 113  When "Set" is clicked on, the three buttons below will appear.
114 114  
115 -
98 +=== 5. Select "Save Mapping Template". ===
116 116  
117 -**5. Select "Save Mapping Template".**
118 -
119 119  [[image:attach:media_1444247323974.png||align="center"]]
120 120  
121 121  (% 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.**
... ... @@ -124,24 +124,18 @@
124 124  
125 125  To change the import mapping without importing, select "Reset" (3).
126 126  
127 -
108 +=== 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 128  
129 -**6. After selecting "Save Mapping", a pop-up window will appear. Give the template a title (1) and description (2), then click Save" (3).**
130 -
131 131  [[image:attach:6.__After_selecting_Save_Mapping__a_pop-up_window_will_ap.png||align="center"]]
132 132  
133 133  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.
134 134  
135 -
114 +=== 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 136  
137 -**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).**
138 -
139 139  [[image:attach:7.__When_you_select_Save__you_will_be_brought_back_to_the.png||align="center"]]
140 140  
141 -
118 +=== 8. You have successfully saved your import mapping template! ===
142 142  
143 -**8. You have successfully saved your import mapping template!**
144 -
145 145  If proceeding with an import, select "Import" below the mapping section (all of the mapping from creating the template will be in tact).
146 146  
147 147  To create a new import mapping template using the same import file, refresh your browser and follow steps 4-7 above.
... ... @@ -154,27 +154,25 @@
154 154  {{/layout-cell}}
155 155  
156 156  {{layout-cell}}
157 -{{panel title="Search All Documentation:"}}
132 +**Search all Documentation:**
158 158  
159 159  
135 +
160 160  {{livesearch/}}
161 -{{/panel}}
162 162  
163 -{{panel title="Search USER OPERATIONS Documentation:"}}
138 +
164 164  
140 +**Search USER OPERATIONS Documentation:**
165 165  
166 -{{pagetreesearch rootPage="User Operations - Managing Your Data"/}}
167 -{{/panel}}
168 168  
169 -{{panel title="On this page:"}}
170 170  
144 +{{pagetreesearch rootPage="User Operations - Managing Your Data"/}}
171 171  
172 -{{toc/}}
173 -{{/panel}}
146 +
174 174  
175 -{{panel title="More USER OPERATIONS Documentation"}}
176 -{{expand}}
177 - **Add Users
148 +{{expand title="More USER OPERATIONS Documentation"}}
149 +(% style="margin-left: 30.0px;" %)
150 +**Add Users
178 178  **
179 179  
180 180  (% style="margin-left: 60.0px;" %)
... ... @@ -181,49 +181,49 @@
181 181  
182 182  
183 183  (% style="margin-left: 60.0px;" %)
184 -[[Preparing for Data Import>>doc:Getting Started - Preparing for Data Import]]
157 +[[Preparing for Data Import>>doc:Getting Started - Preparing for Data Import (v12\.x)]]
185 185  
186 186  (% style="margin-left: 60.0px;" %)
187 -[[doc:Pre-Import Checklist]]
160 +[[Pre-Import Checklist>>doc:Pre-Import Checklist (v12\.x)]]
188 188  
189 189  (% style="margin-left: 60.0px;" %)
163 +[[How to Import a File>>doc:Import - How to Import a File (v12\.x)]]
190 190  
191 -
192 192  (% style="margin-left: 60.0px;" %)
193 193  
194 194  
195 195  (% style="margin-left: 60.0px;" %)
196 -[[How to Use an Import Mapping Template>>doc:Import - How to Use an Import Mapping Template]]
169 +[[How to Use an Import Mapping Template>>doc:Import - How to Use an Import Mapping Template (v12\.x)]]
197 197  
198 198  (% style="margin-left: 60.0px;" %)
199 -[[Add Audience>>doc:Add Audience]]
172 +[[Add Audience>>doc:Add Audience (v12\.x)]]
200 200  
201 201  (% style="margin-left: 30.0px;" %)
202 202  **Batch Operations**
203 203  
204 204  (% style="margin-left: 60.0px;" %)
205 -[[Bulk Operation - How to Perform a Batch Delete>>doc:Bulk Operation - How to Perform a Batch Delete]]
178 +[[Bulk Operation - How to Perform a Batch Delete>>doc:Bulk Operation - How to Perform a Batch Delete (v12\.x)]]
206 206  
207 207  (% style="margin-left: 60.0px;" %)
208 -[[Bulk Operation - How to Perform a Batch Product Change>>doc:Bulk Operation - How to Perform a Batch Product Change]]
181 +[[Bulk Operation - How to Perform a Batch Product Change>>doc:Bulk Operation - How to Perform a Batch Product Change (v12\.x)]]
209 209  
210 210  (% style="margin-left: 60.0px;" %)
211 -[[Bulk Operation - How to Perform a Batch Status Change>>doc:Bulk Operation - How to Perform a Batch Status Change]]
184 +[[Bulk Operation - How to Perform a Batch Status Change>>doc:Bulk Operation - How to Perform a Batch Status Change (v12\.x)]]
212 212  
213 213  (% style="margin-left: 60.0px;" %)
214 -[[Bulk Operation - How to Perform a Batch Suscribe>>doc:Bulk Operation - How to Perform a Batch Subscribe]]
187 +[[Bulk Operation - How to Perform a Batch Suscribe>>doc:Bulk Operation - How to Perform a Batch Subscribe (v12\.x)]]
215 215  
216 216  (% style="margin-left: 60.0px;" %)
217 -[[Bulk Operation - How to Perform a Batch Unsubscribe>>doc:Bulk Operation - How to Perform a Batch UnsubscribeKill]]
190 +[[Bulk Operation - How to Perform a Batch Unsubscribe>>doc:Bulk Operation - How to Perform a Batch UnsubscribeKill (v12\.x)]]
218 218  
219 219  (% style="margin-left: 60.0px;" %)
220 -[[Bulk Operation - How to Perform a Merge of Duplicate Users>>doc:Bulk Operation - How to Perform a Bulk Merge of Duplicate Users]]
193 +[[Bulk Operation - How to Perform a Merge of Duplicate Users>>doc:Bulk Operation - How to Perform a Bulk Merge of Duplicate Users (v12\.x)]]
221 221  
222 222  (% style="margin-left: 30.0px;" %)
223 223  **Target Audience Segments**
224 224  
225 225  (% style="margin-left: 60.0px;" %)
226 -(% style="color: rgb(0,51,102);" %) [[ Target Engine >>doc:Segment Manager]]__
199 +(% style="color: rgb(0,51,102);" %) [[ Target Engine >>doc:Utilities - Target Engine (v12\.x)]]__
227 227  __
228 228  
229 229  
... ... @@ -230,19 +230,6 @@
230 230  
231 231  
232 232  {{/expand}}
233 -{{/panel}}
234 -
235 -
236 -
237 -
238 -
239 -
240 -
241 -
242 -
243 -
244 -
245 -
246 246  {{/layout-cell}}
247 247  {{/layout-section}}
248 248  {{/layout}}
Confluence.Code.ConfluencePageClass[0]
id
... ... @@ -1,1 +1,1 @@
1 -54198399
1 +67538
url
... ... @@ -1,1 +1,1 @@
1 -https://info.onecount.net//wiki/spaces/OD/pages/54198399/Import - How to Create an Import Mapping Template
1 +https://info.onecount.net//wiki/spaces/OD/pages/67538/Import - How to Create an Import Mapping Template (v12.x)