Version 4.1 by melanie@one-count_com on 2016/12/08 11:52
Hide last authors
melanie@one-count_com 4.1 1 {{layout}}
2 {{layout-section ac:type="two_right_sidebar"}}
3 {{layout-cell}}
melanie@one-count_com 3.1 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 === OPENING THE "IMPORT" WINDOW ===
12
13 === Select USER OPERATIONS from the Main Menu. ===
14
15 [[image:attach:media_1444246643838.png||align="center"]]
16
17 === Click on "Import" in the sub-menu. ===
18
19 [[image:attach:media_1444246682217.png||align="center"]]
20
21 This will open the Import window, as shown below.
22
23 [[image:attach:media_1444246962281.png||align="center"]]
24
25 === CREATING THE MAPPING TEMPLATE ===
26
27 === 1. In the Import window click on "Browse" (1), search for and select your import list, and select "Upload File" (2). ===
28
29 [[image:attach:media_1444246725508.png||align="center"]]
30
31 (% style="color: rgb(0,0,0);" %)You have three options when creating a template:
32
33 (% style="color: rgb(0,0,0);" %)1. Create Mapping then Import List - Create a template and continue with the import.(%%)
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 (% 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
37 **Complete Step 2 only if you plan on continuing with the import after creating the import mapping template.**
38
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.
40
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.
42
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). ===
44
45 [[image:attach:media_1444246898428.png||align="center"]]
46
47 You can select multiple products by holding down the CTRL (PC) or CMD (MAC) key when clicking on a product name.
48
49 Below the Product List, you will see a list of any existing Import Mappings (templates), if any.
50
51 [[image:attach:media_1444247218690.png||align="center"]]
52
53 To modify an existing template, select "Use". The Template Description should provide you with a description of the template.
54
55 To delete an existing template, select "Delete".
56
57 === 3. Proceed to the mapping section and map your fields (either from scratch for a new template or by modfying an existing template). ===
58
59 [[image:attach:3._Proceed_to_the_mapping_section_and_map_your_fields__ei.png||align="center"]]
60
61 To map fields:
62
63 * 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.)
64 * 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.)
65
66 To move more than one field at a time into the "Active Header" box, select multiple fields then click on "Activate".
67
68 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.
69
70 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.)
71
72 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".
73
74 (% 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.
75
76 === 3a. Select fields to check duplicates against. ===
77
78 [[image:attach:3a.png||align="center"]]
79
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.**
81
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.
83
84 === 3b. If proceeding with an import, set Request Date field, Expiration Date field, and Media Files fields (all optional). ===
85
86 [[image:attach:media_1444248302872.png||align="center"]]
87
88 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).
89
90 === SAVING THE MAPPING TEMPLATE ===
91
92 === 4. Review mapping and selections, then click "Set" at the bottom of the page. ===
93
94 [[image:attach:media_1444247300304.png||align="center"]]
95
96 When "Set" is clicked on, the three buttons below will appear.
97
98 === 5. Select "Save Mapping Template". ===
99
100 [[image:attach:media_1444247323974.png||align="center"]]
101
102 (% 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.**
103
104 To proceed with the import without saving the mapping template, select "Import" (2).
105
106 To change the import mapping without importing, select "Reset" (3).
107
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). ===
109
110 [[image:attach:6.__After_selecting_Save_Mapping__a_pop-up_window_will_ap.png||align="center"]]
111
112 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.
113
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). ===
115
116 [[image:attach:7.__When_you_select_Save__you_will_be_brought_back_to_the.png||align="center"]]
117
118 === 8. You have successfully saved your import mapping template! ===
119
120 If proceeding with an import, select "Import" below the mapping section (all of the mapping from creating the template will be in tact).
121
122 To create a new import mapping template using the same import file, refresh your browser and follow steps 4-7 above.
123
124 To create a new import mapping template using an import file with different fields, follow steps 1-7 above.
125
126
127
128 {{id name="End ScreenSteps Content"/}}
melanie@one-count_com 4.1 129 {{/layout-cell}}
130
131 {{layout-cell}}
132 **Search all Documentation:**
133
134
135
136 {{livesearch/}}
137
138
139
140 **Search USER OPERATIONS Documentation:**
141
142
143
144 {{pagetreesearch rootPage="User Operations - Managing Your Data"/}}
145
146
147
148 {{expand title="More USER OPERATIONS Documentation"}}
149 (% style="margin-left: 30.0px;" %)
150 **Add Users
151 **
152
153 (% style="margin-left: 60.0px;" %)
154
155
156 (% style="margin-left: 60.0px;" %)
157 [[Preparing for Data Import>>doc:Getting Started - Preparing for Data Import (v12\.x)]]
158
159 (% style="margin-left: 60.0px;" %)
160 [[Pre-Import Checklist>>doc:Pre-Import Checklist (v12\.x)]]
161
162 (% style="margin-left: 60.0px;" %)
163 [[How to Import a File>>doc:Import - How to Import a File (v12\.x)]]
164
165 (% style="margin-left: 60.0px;" %)
166
167
168 (% style="margin-left: 60.0px;" %)
169 [[How to Use an Import Mapping Template>>doc:Import - How to Use an Import Mapping Template (v12\.x)]]
170
171 (% style="margin-left: 60.0px;" %)
172 [[Add Audience>>doc:Add Audience (v12\.x)]]
173
174 (% style="margin-left: 30.0px;" %)
175 **Batch Operations**
176
177 (% style="margin-left: 60.0px;" %)
178 [[Bulk Operation - How to Perform a Batch Delete>>doc:Bulk Operation - How to Perform a Batch Delete (v12\.x)]]
179
180 (% style="margin-left: 60.0px;" %)
181 [[Bulk Operation - How to Perform a Batch Product Change>>doc:Bulk Operation - How to Perform a Batch Product Change (v12\.x)]]
182
183 (% style="margin-left: 60.0px;" %)
184 [[Bulk Operation - How to Perform a Batch Status Change>>doc:Bulk Operation - How to Perform a Batch Status Change (v12\.x)]]
185
186 (% style="margin-left: 60.0px;" %)
187 [[Bulk Operation - How to Perform a Batch Suscribe>>doc:Bulk Operation - How to Perform a Batch Subscribe (v12\.x)]]
188
189 (% style="margin-left: 60.0px;" %)
190 [[Bulk Operation - How to Perform a Batch Unsubscribe>>doc:Bulk Operation - How to Perform a Batch UnsubscribeKill (v12\.x)]]
191
192 (% style="margin-left: 60.0px;" %)
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)]]
194
195 (% style="margin-left: 30.0px;" %)
196 **Target Audience Segments**
197
198 (% style="margin-left: 60.0px;" %)
199 (% style="color: rgb(0,51,102);" %) [[ Target Engine >>doc:Utilities - Target Engine (v12\.x)]]__
200 __
201
202
203
204
205 {{/expand}}
206 {{/layout-cell}}
207 {{/layout-section}}
208 {{/layout}}