Changes for page Utilities - DExTr

Last modified by rayaan@one-count_com on 2023/11/09 10:38

From version 8.1
edited by melanie@one-count_com
on 2016/12/13 14:12
Change comment: There is no comment for this version
To version 3.1
edited by melanie@one-count_com
on 2016/12/13 12:34
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,6 +4,3 @@
1 -{{layout}}
2 -{{layout-section ac:type="two_right_sidebar"}}
3 -{{layout-cell}}
4 4  
5 5  
6 6  {{id name="Start ScreenSteps Content"/}}
... ... @@ -24,7 +24,7 @@
24 24  
25 25  **Third-party activity headers currently can't be mapped via an uploaded layout file. They must be mapped manually in the Activity Mapping Area.**
26 26  
27 -== **OPEN THE MAPPING WINDOW** ==
24 +=== OPENING THE MAPPING WINDOW ===
28 28  
29 29  === Select UTILTIES from the main menu. ===
30 30  
... ... @@ -36,7 +36,7 @@
36 36  
37 37  This will open the Manage Mapping Listing Page, as shown below.
38 38  
39 -== **CREATE A NEW DATA MAPPING** ==
36 +=== CREATE A NEW DATA MAPPING ===
40 40  
41 41  [[image:attach:media_1467388147151.png||align="center"]]
42 42  
... ... @@ -45,7 +45,7 @@
45 45  To edit an existing mapping, select the Edit icon.
46 46   To delete an existing mapping, select the Delete icon.
47 47  
48 -=== **1 – INFORMATION AND DEMOGRAPHIC MAPPING** ===
45 +=== 1 – INFORMATION AND DEMOGRAPHIC MAPPING ===
49 49  
50 50  [[image:attach:media_1468252151743.png||align="center"]]
51 51  
... ... @@ -57,162 +57,101 @@
57 57  
58 58  See below for detail on each part.
59 59  
60 -==== (% style="color: rgb(128,0,0);" %)__Information__(%%) ====
57 +=== INFORMATION ===
61 61  
62 -(% style="margin-left: 30.0px;" %)
63 63  **Name:** Give the mapping a name (required)
64 64  
65 -(% style="margin-left: 30.0px;" %)
66 66  **Description:** Provide a description of the mapping (optional)
67 67  
68 -(% style="margin-left: 30.0px;" %)
69 69  **Select whether you want to map transactions and/or activity:** You can create a mapping for demographic questions only, or map any combination of demographics, transactions, and actions.
70 70  
71 -(% style="margin-left: 30.0px;" %)
72 72  **Upload Layout:** Uploading a layout document is optional. You may opt to manually enter demographic and transactional questions and values to be mapped to ONEcount questions and values. Or, you may use a combination of both uploading a layout and manual entry.
73 73  
74 -(% style="margin-left: 30.0px;" %)
75 75  (% style="text-decoration: underline;" %)//**To Upload a Layout File**//(%%)
76 76   Click on the "Browse" button, locate the file on your computer, then click on "Upload File".
77 77  
78 -(% style="margin-left: 30.0px;" %)
79 79  When you upload an external layout, the Demographic and Transacton Mapping Areas will be automatically pre-populated with each question/data field and values for that field. (See screenshotbelow)
80 80  
81 -(% style="margin-left: 30.0px;" %)
82 82  See screenshots of pre-population and layout formatting rules below.
83 83  
84 -(% style="margin-left: 60.0px;text-align: center;" %)
85 -**
86 -**
74 +=== Layout File Format ===
87 87  
88 88  [[image:attach:media_1468252886176.png||align="center"]]
89 89  
90 -(% style="margin-left: 60.0px;" %)
91 91  _(% style="text-decoration: underline;" %)**Layout File Format**(%%) _
92 92   The layout file must be in .csv format and include markers for demographic questions (~#~##demographics), products (~#~##products~#~##), subscription type(~#~##subscriptionType~#~##), and product status (optional) (~#~##productStatus~#~##).
93 93  
94 -(% style="margin-left: 60.0px;" %)
95 95  (% style="text-decoration: underline;" %)//Demographic Mapping//
96 96  
97 -*
98 -**
99 -*** For Demographic Questions: Question text must be in Column A, response values for multiple response-type questions* in Column B, and response text values in Column C.
83 +* For Demographic Questions: Question text must be in Column A, response values for multiple response-type questions* in Column B, and response text values in Column C.
100 100   *Note that text-response type questions, e.g. last name, don't require values in Column B or C.
101 101  
102 -(% style="margin-left: 60.0px;" %)
103 103  (% style="text-decoration: underline;" %)//Transaction Mapping//
104 104  
105 -*
106 -**
107 -*** For Products: Product ID must be in Column A and Product name in Column B.
108 -*** For Subscription Type: Sub Type ID/value is in Column A and subscription type name in Column B.
109 -*** For Product Status: Status ID must be in Column A and Status name in Column B.
110 -\\
88 +* For Products: Product ID must be in Column A and Product name in Column B.
89 +* For Subscription Type: Sub Type ID/value is in Column A and subscription type name in Column B.
90 +* For Product Status: Status ID must be in Column A and Status name in Column B.
111 111  
112 -(% style="text-align: center;" %)
113 -//**Screenshot: Pre-Populated Demographic Questions/Data Fields - Uploaded Layout**//
92 +=== Screenshot: Pre-Populated Demographic Questions/Data Fields - Uploaded Layout ===
114 114  
115 115  [[image:attach:media_1467396172019.png||align="center"]]
116 116  
117 -
96 +=== Screenshot: Pre-populated Question Responses - Uploaded Layout ===
118 118  
119 -(% style="text-align: center;" %)
120 -**//Screenshot: Pre-populated Question Responses - Uploaded Layout//**
121 -
122 122  [[image:attach:media_1467391080266.png||align="center"]]
123 123  
124 -
100 +=== Screenshot: Pre-Populated Transaction Mapping - Uploaded Layout ===
125 125  
126 -(% style="text-align: center;" %)
127 -**//Screenshot: Pre-Populated Transaction Mapping - Uploaded Layout//**
128 -
129 129  [[image:attach:media_1467391409099.png||align="center"]]
130 130  
131 -==== (% style="color: rgb(128,0,0);" %)__Map Third-Party Questions__(%%) ====
104 +=== MAPPING AREA ===
132 132  
133 133  [[image:attach:media_1467397686498.png||align="center"]]
134 134  
135 -(% style="margin-left: 30.0px;" %)
136 136  Prior to uploading a layout file, or if you opt to create the mapping on the fly (without uploading a layout file), the Mapping Area will be empty.
137 137  
138 -(% style="margin-left: 30.0px;" %)
139 139  The mapping area consists of three columns: **Third Party Questions, ONEcount Questions, and Validations.**
140 140  
141 -*
142 -** **Third Party Questions** shows questions/data fields your, or a third party's, data file.
143 -** **ONEcount Questions** shows the corresponding ONEcount question to be mapped to the Third Party Question.
144 -** **Validations** allows you to select validations for the mapped question, i.e., Required, Email, Number and Text, Text Only.
112 +* **Third Party Questions** shows questions/data fields your, or a third party's, data file.
113 +* **ONEcount Questions** shows the corresponding ONEcount question to be mapped to the Third Party Question.
114 +* **Validations** allows you to select validations for the mapped question, i.e., Required, Email, Number and Text, Text Only.
145 145  
146 -(% style="margin-left: 30.0px;" %)
147 -===== Manually Add Third-Party Questions =====
116 +=== Manually Add Third-Party Questions ===
148 148  
149 -(% style="margin-left: 30.0px;" %)
150 150  [[image:attach:media_1467398286154.png||align="center"]]
151 151  
152 -(% style="margin-left: 30.0px;" %)
153 153  When you click on the "Add Questions" button, you'll be presented with a pop-up to create a new question/data field to be mapped to an existing ONEcount question.
154 154  
155 -(% style="margin-left: 30.0px;" %)
156 156  Be sure to select "Yes" if it is a question with selectable responses, i.e. radio button/select/checkbox-type. Click Save.
157 157  
158 -==== (% style="color: rgb(128,0,0);" %)__Map Third-Party to ONEcount Questions and Responses
159 -__(%%) ====
124 +=== Map Questions and Responses ===
160 160  
161 -(% style="color: rgb(128,0,0);" %)__ __
162 -
163 -(% style="margin-left: 60.0px;" %)
164 -//YOU MUST FIRST MAP THE THIRD-PARTY QUESTION TO THE CORRESPONDING ONEcount QUESTION BY DRAGGING AND DROPPING THE CORRESPONDING ONEcount QUESTION FROM THE ONEcount Questions SECTION INTO THE ONEcount Questions Column BEFORE YOU CAN MAP RESPONSES.//
165 -
166 -(% style="color: rgb(128,0,0);" %)__ __
167 -
168 -(% style="margin-left: 60.0px;" %)
169 -//THIS APPLIES TO BOTH MANUALLY ADDED QUESTIONS AND QUESTIONS PRE-POPULATED BY UPLOAD OF AN IMPORT.//
170 -
171 -(% style="color: rgb(128,0,0);" %)__ __
172 -
173 -(% style="margin-left: 60.0px;" %)
174 -//ONEcount QUESTIONS AND RESPONSE VALUES MUST BE CREATED PRIOR TO PERFORMING MAPPING.//
175 -
176 -(% style="color: rgb(128,0,0);" %)__
177 -__
178 -
179 -(% style="margin-left: 30.0px;" %)
180 180  [[image:attach:media_1467398257338.png||align="center"]]
181 181  
182 -(% style="margin-left: 30.0px;" %)
183 183  If the question is a radio button/select/checkbox-type question, a button will be presented which will allow you to map responses and values. (See "Upgrade Checkbox" question above.)
129 + If it's a text-type response, you won't need to map responses and values.
184 184  
185 -(% style="margin-left: 30.0px;" %)
131 +**YOU MUST FIRST MAP THE QUESTION TO THE CORRESPONDING ONECOUNT QUESTION BY DRAGGING AND DROPPING THE CORRESPONDING ONECOUNT QUESTION FROM THE ONEcount Questions SECTION INTO THE ONEcount Questions Column BEFORE YOU CAN MAP RESPONSES. THIS APPLIES TO BOTH MANUALLY ADDED QUESTIONS AND QUESTIONS PRE-POPULATED BY UPLOAD OF AN IMPORT.**
186 186  
187 -If it's a text-type response, you won't need to map responses and values.
133 +**ONEcount QUESTIONS AND RESPONSE VALUES MUST BE CREATED PRIOR TO PERFORMING MAPPING.**
188 188  
189 -
190 -
191 -(% style="margin-left: 30.0px;" %)
192 192  [[image:attach:media_1467398730892.png||align="center"]]
193 193  
194 -(% style="margin-left: 30.0px;" %)
195 195  Simply drag and drop ONEcount questions from the question pool into the appropriate cell in the mapping table.
196 196  
197 -(% style="margin-left: 30.0px;" %)
198 198  Note the Search function at the top of the list of ONEcount questions. Just begin typing in the question name, and the list will be filtered for you. (See screenshot below.)
199 199  
200 -(% style="margin-left: 30.0px;" %)
201 201  [[image:attach:media_1467398948360.png||align="center"]]
202 202  
203 -(% style="margin-left: 30.0px;" %)
204 204  Once Questions are mapped, you can add validations and/or map responses for radio/select/checkbox-type questions.
205 205  
206 -(% style="margin-left: 30.0px;" %)
207 207  To add validations, click in the empty "Validations" box for the corresponding question and select from the drop-down list the validation(s) you want to apply to the question, i.e. Required, Email, Number and Text, Text Only. (See screenshot below.
208 208  
209 -(% style="text-align: center;" %)
210 -//**Screenshot – Mapped Questions with Validations**//
147 +=== Screenshot – Mapped Questions with Validations ===
211 211  
212 212  [[image:attach:media_1467399198566.png||align="center"]]
213 213  
214 -(% style="margin-left: 30.0px;" %)
215 -===== Map Question Responses =====
151 +=== Map Question Responses ===
216 216  
217 217  [[image:attach:media_1467391237758.png||align="center"]]
218 218  
... ... @@ -299,7 +299,7 @@
299 299  
300 300  When finished mapping, click the "Next" button.
301 301  
302 -== **SAVE MAPPING** ==
238 +=== Save Mapping ===
303 303  
304 304  When done with mapping(s), click "Next".
305 305  
... ... @@ -312,63 +312,3 @@
312 312  
313 313  
314 314  {{id name="End ScreenSteps Content"/}}
315 -{{/layout-cell}}
316 -
317 -{{layout-cell}}
318 -{{panel borderStyle="solid" title="Search all Documentation:"}}
319 -
320 -
321 -{{livesearch/}}
322 -{{/panel}}
323 -
324 -{{panel borderStyle="solid" title="Search System UTILITIES:"}}
325 -
326 -
327 -{{pagetreesearch rootPage="System Utilities"/}}
328 -{{/panel}}
329 -
330 -{{panel title="More System UTILITIES"}}
331 -{{expand title="Expand"}}
332 -
333 -
334 -(% style="margin-left: 30.0px;" %)
335 -[[Job List>>doc:Utilities - Job List (v12\.x)]]
336 -
337 -(% style="margin-left: 30.0px;" %)
338 -[[Backend User Permissions>>doc:Utilities - Backend Users and Permissions (v12\.x)]]
339 -
340 -(% style="margin-left: 30.0px;" %)
341 -[[Email Engine Sender Score>>doc:Email Engine and Sender Score]]
342 -
343 -(% style="margin-left: 30.0px;" %)
344 -[[Email Engine>>doc:Utilities - Email Engine (v12\.x)]]
345 -
346 -(% style="margin-left: 30.0px;" %)
347 -Action Manager
348 -
349 -(% style="margin-left: 30.0px;" %)
350 -[[Configuration Manager>>doc:Utilities - Configuration Manager (v12\.x)]]
351 -
352 -(% style="margin-left: 30.0px;" %)
353 -Backend Activity Log
354 -
355 -(% style="margin-left: 30.0px;" %)
356 -IVT Mitigator
357 -
358 -(% style="margin-left: 30.0px;" %)
359 -[[Widget Builder>>doc:Utilities - Widget Builder (v12\.x)]]
360 -
361 -(% style="margin-left: 30.0px;" %)
362 -
363 -
364 -(% style="margin-left: 30.0px;" %)
365 -Import/Export Tool
366 -{{/expand}}
367 -{{/panel}}
368 -
369 -
370 -
371 -
372 -{{/layout-cell}}
373 -{{/layout-section}}
374 -{{/layout}}
Confluence.Code.ConfluencePageClass[0]
id
... ... @@ -1,1 +1,1 @@
1 -67665
1 +67341
url
... ... @@ -1,1 +1,1 @@
1 -https://info.onecount.net//wiki/spaces/OD/pages/67665/Utilities - Mapper (v12.x)
1 +https://info.onecount.net//wiki/spaces/OD/pages/67341/Utilities - Mapper (v12.x)