Changes for page DExTr Import Files

Last modified by Admin User on 2024/12/27 09:51
From version 4.1
edited by Admin
on 2022/09/19 12:40
Change comment: There is no comment for this version
To version 5.2
edited by Rayaan Ahmed
on 2024/12/27 03:28
Change comment: There is no comment for this version

Summary

Details

Page properties
Parent
... ... @@ -1,0 +1,1 @@
1 +How-To Info:
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.Admin
1 +XWiki.rayaan
Content
... ... @@ -10,694 +10,693 @@
10 10  
11 11  Typically data about the person, including NAME, ADDRESS, CITY, STATE, ZIP, JOB TITLE, E-MAIL, HAIR COLOR, ETC. If the system you are bringing the data in from contains a unique identifier, such as a user or customer ID, it is important to bring that data in so that it can be used for matching and de-duping records later. ONEcount can use ANY field to de-dupe, records, not just e-mail. Typically, records are de-duplicated across different fields depending on the source system (ie., records from your CRM system are de-duped based on the CRM ID, records from your e-mail system may be de-duped on the email system ID).
12 12  
13 -\\
14 14  
15 15  (% class="wrapped" %)
16 16  |(((
17 -(% style="color: rgb(0,51,102);" %)**ACCOUNT NUMBER**
16 +(% style="color:#003366" %)**ACCOUNT NUMBER**
18 18  )))|(((
19 -(% style="color: rgb(0,51,102);" %)**FIRST NAME**
18 +(% style="color:#003366" %)**FIRST NAME**
20 20  )))|(((
21 -(% style="color: rgb(0,51,102);" %)**LAST NAME**
20 +(% style="color:#003366" %)**LAST NAME**
22 22  )))|(((
23 -(% style="color: rgb(0,51,102);" %)**MIDDLE NAME**
22 +(% style="color:#003366" %)**MIDDLE NAME**
24 24  )))|(((
25 -(% style="color: rgb(0,51,102);" %)**TITLE**
24 +(% style="color:#003366" %)**TITLE**
26 26  )))|(((
27 -(% style="color: rgb(0,51,102);" %)**SUFFIX**
26 +(% style="color:#003366" %)**SUFFIX**
28 28  )))|(((
29 -(% style="color: rgb(0,51,102);" %)**COMPANY**
28 +(% style="color:#003366" %)**COMPANY**
30 30  )))|(((
31 -(% style="color: rgb(0,51,102);" %)**JOB TITLE**
30 +(% style="color:#003366" %)**JOB TITLE**
32 32  )))|(((
33 -(% style="color: rgb(0,51,102);" %)**ADDRESS1**
32 +(% style="color:#003366" %)**ADDRESS1**
34 34  )))|(((
35 -(% style="color: rgb(0,51,102);" %)**ADDRESS2**
34 +(% style="color:#003366" %)**ADDRESS2**
36 36  )))|(((
37 -(% style="color: rgb(0,51,102);" %)**CITY**
36 +(% style="color:#003366" %)**CITY**
38 38  )))|(((
39 -(% style="color: rgb(0,51,102);" %)**STATE**
38 +(% style="color:#003366" %)**STATE**
40 40  )))|(((
41 -(% style="color: rgb(0,51,102);" %)**ZIP**
40 +(% style="color:#003366" %)**ZIP**
42 42  )))|(((
43 -(% style="color: rgb(0,51,102);" %)**ZIP4**
42 +(% style="color:#003366" %)**ZIP4**
44 44  )))|(((
45 -(% style="color: rgb(0,51,102);" %)**COUNTRY**
44 +(% style="color:#003366" %)**COUNTRY**
46 46  )))|(((
47 -(% style="color: rgb(0,51,102);" %)**TELEPHONE NUMBER**
46 +(% style="color:#003366" %)**TELEPHONE NUMBER**
48 48  )))|(((
49 -(% style="color: rgb(0,51,102);" %)**FAX NUMBER**
48 +(% style="color:#003366" %)**FAX NUMBER**
50 50  )))|(((
51 -(% style="color: rgb(0,51,102);" %)**E-MAIL ADDRESS**
50 +(% style="color:#003366" %)**E-MAIL ADDRESS**
52 52  )))|(((
53 -(% style="color: rgb(0,51,102);" %)**E-MAIL CONTACT**
52 +(% style="color:#003366" %)**E-MAIL CONTACT**
54 54  )))|(((
55 -(% style="color: rgb(0,51,102);" %)**CUSTOM1**
54 +(% style="color:#003366" %)**CUSTOM1**
56 56  )))|(((
57 -(% style="color: rgb(0,51,102);" %)**CUSTOM2**
56 +(% style="color:#003366" %)**CUSTOM2**
58 58  )))|(((
59 -(% style="color: rgb(0,51,102);" %)**CUSTOM3**
58 +(% style="color:#003366" %)**CUSTOM3**
60 60  )))|(((
61 -(% style="color: rgb(0,51,102);" %)**LAST UPDATED**
60 +(% style="color:#003366" %)**LAST UPDATED**
62 62  )))|(((
63 -(% style="color: rgb(0,51,102);" %)**OCID**
62 +(% style="color:#003366" %)**OCID**
64 64  )))
65 65  |(((
66 -(% style="color: rgb(0,51,102);" %)**14010000431**
65 +(% style="color:#003366" %)**14010000431**
67 67  )))|(((
68 -(% style="color: rgb(0,51,102);" %)Graham
67 +(% style="color:#003366" %)Graham
69 69  )))|(((
70 -(% style="color: rgb(0,51,102);" %)O'Gorman
69 +(% style="color:#003366" %)O'Gorman
71 71  )))|(((
72 -\\
71 +
73 73  )))|(((
74 -\\
73 +
75 75  )))|(((
76 -\\
75 +
77 77  )))|(((
78 -(% style="color: rgb(0,51,102);" %)Graham O'Gorman Landscape
77 +(% style="color:#003366" %)Graham O'Gorman Landscape
79 79  )))|(((
80 -\\
79 +
81 81  )))|(((
82 -(% style="color: rgb(0,51,102);" %)192 Olmstead Hill Rd
81 +(% style="color:#003366" %)192 Olmstead Hill Rd
83 83  )))|(((
84 -\\
83 +
85 85  )))|(((
86 -(% style="color: rgb(0,51,102);" %)Wilton
85 +(% style="color:#003366" %)Wilton
87 87  )))|(((
88 -(% style="color: rgb(0,51,102);" %)CT
87 +(% style="color:#003366" %)CT
89 89  )))|(((
90 -(% style="color: rgb(0,51,102);" %)6897
89 +(% style="color:#003366" %)6897
91 91  )))|(((
92 -(% style="color: rgb(0,51,102);" %)1816
91 +(% style="color:#003366" %)1816
93 93  )))|(((
94 -(% style="color: rgb(0,51,102);" %)United States
93 +(% style="color:#003366" %)United States
95 95  )))|(((
96 -\\
95 +
97 97  )))|(((
98 -\\
97 +
99 99  )))|(((
100 -\\
99 +
101 101  )))|(((
102 -(% style="color: rgb(0,51,102);" %)N
101 +(% style="color:#003366" %)N
103 103  )))|(((
104 -\\
103 +
105 105  )))|(((
106 -\\
105 +
107 107  )))|(((
108 -\\
107 +
109 109  )))|(((
110 -(% style="color: rgb(0,51,102);" %)20141113211102
109 +(% style="color:#003366" %)20141113211102
111 111  )))|(((
112 -\\
111 +
113 113  )))
114 114  |(((
115 -(% style="color: rgb(0,51,102);" %)**14010000449**
114 +(% style="color:#003366" %)**14010000449**
116 116  )))|(((
117 -(% style="color: rgb(0,51,102);" %)Dale S
116 +(% style="color:#003366" %)Dale S
118 118  )))|(((
119 -(% style="color: rgb(0,51,102);" %)Galbo
118 +(% style="color:#003366" %)Galbo
120 120  )))|(((
121 -\\
120 +
122 122  )))|(((
123 -\\
122 +
124 124  )))|(((
125 -\\
124 +
126 126  )))|(((
127 -(% style="color: rgb(0,51,102);" %)Law Offices
126 +(% style="color:#003366" %)Law Offices
128 128  )))|(((
129 -(% style="color: rgb(0,51,102);" %)Owner
128 +(% style="color:#003366" %)Owner
130 130  )))|(((
131 -(% style="color: rgb(0,51,102);" %)15 W Hill Rd
130 +(% style="color:#003366" %)15 W Hill Rd
132 132  )))|(((
133 -\\
132 +
134 134  )))|(((
135 -(% style="color: rgb(0,51,102);" %)Bloomfield
134 +(% style="color:#003366" %)Bloomfield
136 136  )))|(((
137 -(% style="color: rgb(0,51,102);" %)CT
136 +(% style="color:#003366" %)CT
138 138  )))|(((
139 -(% style="color: rgb(0,51,102);" %)6002
138 +(% style="color:#003366" %)6002
140 140  )))|(((
141 -(% style="color: rgb(0,51,102);" %)5016
140 +(% style="color:#003366" %)5016
142 142  )))|(((
143 -(% style="color: rgb(0,51,102);" %)United States
142 +(% style="color:#003366" %)United States
144 144  )))|(((
145 -(% style="color: rgb(0,51,102);" %)2032709821
144 +(% style="color:#003366" %)2032709821
146 146  )))|(((
147 -\\
146 +
148 148  )))|(((
149 -\\
148 +
150 150  )))|(((
151 -(% style="color: rgb(0,51,102);" %)N
150 +(% style="color:#003366" %)N
152 152  )))|(((
153 -\\
152 +
154 154  )))|(((
155 -\\
154 +
156 156  )))|(((
157 -\\
156 +
158 158  )))|(((
159 -(% style="color: rgb(0,51,102);" %)20141113211111
158 +(% style="color:#003366" %)20141113211111
160 160  )))|(((
161 -\\
160 +
162 162  )))
163 163  |(((
164 -(% style="color: rgb(0,51,102);" %)**14010000648**
163 +(% style="color:#003366" %)**14010000648**
165 165  )))|(((
166 -(% style="color: rgb(0,51,102);" %)Patricia
165 +(% style="color:#003366" %)Patricia
167 167  )))|(((
168 -(% style="color: rgb(0,51,102);" %)Cannon
167 +(% style="color:#003366" %)Cannon
169 169  )))|(((
170 -\\
169 +
171 171  )))|(((
172 -\\
171 +
173 173  )))|(((
174 -\\
173 +
175 175  )))|(((
176 -(% style="color: rgb(0,51,102);" %)Employee Assistance Program
175 +(% style="color:#003366" %)Employee Assistance Program
177 177  )))|(((
178 -(% style="color: rgb(0,51,102);" %)Director
177 +(% style="color:#003366" %)Director
179 179  )))|(((
180 -(% style="color: rgb(0,51,102);" %)887 Bridgeport Ave Ste C
179 +(% style="color:#003366" %)887 Bridgeport Ave Ste C
181 181  )))|(((
182 -\\
181 +
183 183  )))|(((
184 -(% style="color: rgb(0,51,102);" %)Shelton
183 +(% style="color:#003366" %)Shelton
185 185  )))|(((
186 -(% style="color: rgb(0,51,102);" %)CT
185 +(% style="color:#003366" %)CT
187 187  )))|(((
188 -(% style="color: rgb(0,51,102);" %)6484
187 +(% style="color:#003366" %)6484
189 189  )))|(((
190 -(% style="color: rgb(0,51,102);" %)7602
189 +(% style="color:#003366" %)7602
191 191  )))|(((
192 -(% style="color: rgb(0,51,102);" %)United States
191 +(% style="color:#003366" %)United States
193 193  )))|(((
194 -(% style="color: rgb(0,51,102);" %)2039290681
193 +(% style="color:#003366" %)2039290681
195 195  )))|(((
196 -\\
195 +
197 197  )))|(((
198 -\\
197 +
199 199  )))|(((
200 -(% style="color: rgb(0,51,102);" %)N
199 +(% style="color:#003366" %)N
201 201  )))|(((
202 -\\
201 +
203 203  )))|(((
204 -\\
203 +
205 205  )))|(((
206 -\\
205 +
207 207  )))|(((
208 -(% style="color: rgb(0,51,102);" %)20141121163017
207 +(% style="color:#003366" %)20141121163017
209 209  )))|(((
210 -\\
209 +
211 211  )))
212 212  |(((
213 -(% style="color: rgb(0,51,102);" %)**14010001843**
212 +(% style="color:#003366" %)**14010001843**
214 214  )))|(((
215 -(% style="color: rgb(0,51,102);" %)Susan
214 +(% style="color:#003366" %)Susan
216 216  )))|(((
217 -(% style="color: rgb(0,51,102);" %)Kent
216 +(% style="color:#003366" %)Kent
218 218  )))|(((
219 -\\
218 +
220 220  )))|(((
221 -\\
220 +
222 222  )))|(((
223 -\\
222 +
224 224  )))|(((
225 -\\
224 +
226 226  )))|(((
227 -\\
226 +
228 228  )))|(((
229 -(% style="color: rgb(0,51,102);" %)38110 5th St E Apt 1
228 +(% style="color:#003366" %)38110 5th St E Apt 1
230 230  )))|(((
231 -\\
230 +
232 232  )))|(((
233 -(% style="color: rgb(0,51,102);" %)Los Angeles
232 +(% style="color:#003366" %)Los Angeles
234 234  )))|(((
235 -(% style="color: rgb(0,51,102);" %)CA
234 +(% style="color:#003366" %)CA
236 236  )))|(((
237 -(% style="color: rgb(0,51,102);" %)93550
236 +(% style="color:#003366" %)93550
238 238  )))|(((
239 -(% style="color: rgb(0,51,102);" %)2317
238 +(% style="color:#003366" %)2317
240 240  )))|(((
241 -(% style="color: rgb(0,51,102);" %)United States
240 +(% style="color:#003366" %)United States
242 242  )))|(((
243 -\\
242 +
244 244  )))|(((
245 -\\
244 +
246 246  )))|(((
247 -\\
246 +
248 248  )))|(((
249 -(% style="color: rgb(0,51,102);" %)N
248 +(% style="color:#003366" %)N
250 250  )))|(((
251 -\\
250 +
252 252  )))|(((
253 -\\
252 +
254 254  )))|(((
255 -\\
254 +
256 256  )))|(((
257 -(% style="color: rgb(0,51,102);" %)20141212210537
256 +(% style="color:#003366" %)20141212210537
258 258  )))|(((
259 -\\
258 +
260 260  )))
261 261  |(((
262 -(% style="color: rgb(0,51,102);" %)**14010001858**
261 +(% style="color:#003366" %)**14010001858**
263 263  )))|(((
264 -(% style="color: rgb(0,51,102);" %)Brendan
263 +(% style="color:#003366" %)Brendan
265 265  )))|(((
266 -(% style="color: rgb(0,51,102);" %)Eppley
265 +(% style="color:#003366" %)Eppley
267 267  )))|(((
268 -\\
267 +
269 269  )))|(((
270 -\\
269 +
271 271  )))|(((
272 -\\
271 +
273 273  )))|(((
274 -\\
273 +
275 275  )))|(((
276 -\\
275 +
277 277  )))|(((
278 -(% style="color: rgb(0,51,102);" %)20 Driftway Ln
277 +(% style="color:#003366" %)20 Driftway Ln
279 279  )))|(((
280 -\\
279 +
281 281  )))|(((
282 -(% style="color: rgb(0,51,102);" %)Darien
281 +(% style="color:#003366" %)Darien
283 283  )))|(((
284 -(% style="color: rgb(0,51,102);" %)CT
283 +(% style="color:#003366" %)CT
285 285  )))|(((
286 -(% style="color: rgb(0,51,102);" %)6820
285 +(% style="color:#003366" %)6820
287 287  )))|(((
288 -(% style="color: rgb(0,51,102);" %)6130
287 +(% style="color:#003366" %)6130
289 289  )))|(((
290 -(% style="color: rgb(0,51,102);" %)United States
289 +(% style="color:#003366" %)United States
291 291  )))|(((
292 -\\
291 +
293 293  )))|(((
294 -\\
293 +
295 295  )))|(((
296 -\\
295 +
297 297  )))|(((
298 -(% style="color: rgb(0,51,102);" %)N
297 +(% style="color:#003366" %)N
299 299  )))|(((
300 -\\
299 +
301 301  )))|(((
302 -\\
301 +
303 303  )))|(((
304 -\\
303 +
305 305  )))|(((
306 -(% style="color: rgb(0,51,102);" %)20141211230144
305 +(% style="color:#003366" %)20141211230144
307 307  )))|(((
308 -\\
307 +
309 309  )))
310 310  |(((
311 -(% style="color: rgb(0,51,102);" %)**14010001862**
310 +(% style="color:#003366" %)**14010001862**
312 312  )))|(((
313 -\\
312 +
314 314  )))|(((
315 -\\
314 +
316 316  )))|(((
317 -\\
316 +
318 318  )))|(((
319 -\\
318 +
320 320  )))|(((
321 -\\
320 +
322 322  )))|(((
323 -(% style="color: rgb(0,51,102);" %)Orchard Tree Care Llc
322 +(% style="color:#003366" %)Orchard Tree Care Llc
324 324  )))|(((
325 -\\
324 +
326 326  )))|(((
327 -(% style="color: rgb(0,51,102);" %)184 Ave
326 +(% style="color:#003366" %)184 Ave
328 328  )))|(((
329 -\\
328 +
330 330  )))|(((
331 -(% style="color: rgb(0,51,102);" %)Darien
330 +(% style="color:#003366" %)Darien
332 332  )))|(((
333 -(% style="color: rgb(0,51,102);" %)CT
332 +(% style="color:#003366" %)CT
334 334  )))|(((
335 -(% style="color: rgb(0,51,102);" %)6820
334 +(% style="color:#003366" %)6820
336 336  )))|(((
337 -\\
336 +
338 338  )))|(((
339 -(% style="color: rgb(0,51,102);" %)United States
338 +(% style="color:#003366" %)United States
340 340  )))|(((
341 -(% style="color: rgb(0,51,102);" %)2036550618
340 +(% style="color:#003366" %)2036550618
342 342  )))|(((
343 -\\
342 +
344 344  )))|(((
345 -\\
344 +
346 346  )))|(((
347 -(% style="color: rgb(0,51,102);" %)N
346 +(% style="color:#003366" %)N
348 348  )))|(((
349 -\\
348 +
350 350  )))|(((
351 -\\
350 +
352 352  )))|(((
353 -\\
352 +
354 354  )))|(((
355 -(% style="color: rgb(0,51,102);" %)20150211133156
354 +(% style="color:#003366" %)20150211133156
356 356  )))|(((
357 -\\
356 +
358 358  )))
359 359  |(((
360 -(% style="color: rgb(0,51,102);" %)**14010001870**
359 +(% style="color:#003366" %)**14010001870**
361 361  )))|(((
362 -(% style="color: rgb(0,51,102);" %)Avis Z
361 +(% style="color:#003366" %)Avis Z
363 363  )))|(((
364 -(% style="color: rgb(0,51,102);" %)Gray
363 +(% style="color:#003366" %)Gray
365 365  )))|(((
366 -\\
365 +
367 367  )))|(((
368 -\\
367 +
369 369  )))|(((
370 -\\
369 +
371 371  )))|(((
372 -(% style="color: rgb(0,51,102);" %)Designers 5 Incorporated
371 +(% style="color:#003366" %)Designers 5 Incorporated
373 373  )))|(((
374 -(% style="color: rgb(0,51,102);" %)President
373 +(% style="color:#003366" %)President
375 375  )))|(((
376 -(% style="color: rgb(0,51,102);" %)96 5 Mile River Rd
375 +(% style="color:#003366" %)96 5 Mile River Rd
377 377  )))|(((
378 -\\
377 +
379 379  )))|(((
380 -(% style="color: rgb(0,51,102);" %)Darien
379 +(% style="color:#003366" %)Darien
381 381  )))|(((
382 -(% style="color: rgb(0,51,102);" %)CT
381 +(% style="color:#003366" %)CT
383 383  )))|(((
384 -(% style="color: rgb(0,51,102);" %)6820
383 +(% style="color:#003366" %)6820
385 385  )))|(((
386 -(% style="color: rgb(0,51,102);" %)6234
385 +(% style="color:#003366" %)6234
387 387  )))|(((
388 -(% style="color: rgb(0,51,102);" %)United States
387 +(% style="color:#003366" %)United States
389 389  )))|(((
390 -(% style="color: rgb(0,51,102);" %)2036552033
389 +(% style="color:#003366" %)2036552033
391 391  )))|(((
392 -\\
391 +
393 393  )))|(((
394 -\\
393 +
395 395  )))|(((
396 -(% style="color: rgb(0,51,102);" %)N
395 +(% style="color:#003366" %)N
397 397  )))|(((
398 -\\
397 +
399 399  )))|(((
400 -\\
399 +
401 401  )))|(((
402 -\\
401 +
403 403  )))|(((
404 -(% style="color: rgb(0,51,102);" %)20150212210227
403 +(% style="color:#003366" %)20150212210227
405 405  )))|(((
406 -\\
405 +
407 407  )))
408 408  |(((
409 -(% style="color: rgb(0,51,102);" %)**14010001889**
408 +(% style="color:#003366" %)**14010001889**
410 410  )))|(((
411 -(% style="color: rgb(0,51,102);" %)John
410 +(% style="color:#003366" %)John
412 412  )))|(((
413 -(% style="color: rgb(0,51,102);" %)Hertz
412 +(% style="color:#003366" %)Hertz
414 414  )))|(((
415 -\\
414 +
416 416  )))|(((
417 -\\
416 +
418 418  )))|(((
419 -\\
418 +
420 420  )))|(((
421 -(% style="color: rgb(0,51,102);" %)Hertz Construction Co
420 +(% style="color:#003366" %)Hertz Construction Co
422 422  )))|(((
423 -(% style="color: rgb(0,51,102);" %)Partner
422 +(% style="color:#003366" %)Partner
424 424  )))|(((
425 -(% style="color: rgb(0,51,102);" %)12 Hillside Ave
424 +(% style="color:#003366" %)12 Hillside Ave
426 426  )))|(((
427 -\\
426 +
428 428  )))|(((
429 -(% style="color: rgb(0,51,102);" %)Darien
428 +(% style="color:#003366" %)Darien
430 430  )))|(((
431 -(% style="color: rgb(0,51,102);" %)CT
430 +(% style="color:#003366" %)CT
432 432  )))|(((
433 -(% style="color: rgb(0,51,102);" %)6820
432 +(% style="color:#003366" %)6820
434 434  )))|(((
435 -(% style="color: rgb(0,51,102);" %)5010
434 +(% style="color:#003366" %)5010
436 436  )))|(((
437 -(% style="color: rgb(0,51,102);" %)United States
436 +(% style="color:#003366" %)United States
438 438  )))|(((
439 -(% style="color: rgb(0,51,102);" %)2036564900
438 +(% style="color:#003366" %)2036564900
440 440  )))|(((
441 -\\
440 +
442 442  )))|(((
443 -\\
442 +
444 444  )))|(((
445 -(% style="color: rgb(0,51,102);" %)N
444 +(% style="color:#003366" %)N
446 446  )))|(((
447 -\\
446 +
448 448  )))|(((
449 -\\
448 +
450 450  )))|(((
451 -\\
450 +
452 452  )))|(((
453 -(% style="color: rgb(0,51,102);" %)20141121163018
452 +(% style="color:#003366" %)20141121163018
454 454  )))|(((
455 -\\
454 +
456 456  )))
457 457  |(((
458 -(% style="color: rgb(0,51,102);" %)**14010001891**
457 +(% style="color:#003366" %)**14010001891**
459 459  )))|(((
460 -\\
459 +
461 461  )))|(((
462 -\\
461 +
463 463  )))|(((
464 -\\
463 +
465 465  )))|(((
466 -\\
465 +
467 467  )))|(((
468 -\\
467 +
469 469  )))|(((
470 -(% style="color: rgb(0,51,102);" %)Niche Home Furnishings Ll
469 +(% style="color:#003366" %)Niche Home Furnishings Ll
471 471  )))|(((
472 -\\
471 +
473 473  )))|(((
474 -(% style="color: rgb(0,51,102);" %)25 Old Kings Hwy N Ste 17
473 +(% style="color:#003366" %)25 Old Kings Hwy N Ste 17
475 475  )))|(((
476 -\\
475 +
477 477  )))|(((
478 -(% style="color: rgb(0,51,102);" %)Darien
477 +(% style="color:#003366" %)Darien
479 479  )))|(((
480 -(% style="color: rgb(0,51,102);" %)CT
479 +(% style="color:#003366" %)CT
481 481  )))|(((
482 -(% style="color: rgb(0,51,102);" %)6820
481 +(% style="color:#003366" %)6820
483 483  )))|(((
484 -(% style="color: rgb(0,51,102);" %)4608
483 +(% style="color:#003366" %)4608
485 485  )))|(((
486 -(% style="color: rgb(0,51,102);" %)United States
485 +(% style="color:#003366" %)United States
487 487  )))|(((
488 -(% style="color: rgb(0,51,102);" %)2036566674
487 +(% style="color:#003366" %)2036566674
489 489  )))|(((
490 -\\
489 +
491 491  )))|(((
492 -\\
491 +
493 493  )))|(((
494 -(% style="color: rgb(0,51,102);" %)N
493 +(% style="color:#003366" %)N
495 495  )))|(((
496 -\\
495 +
497 497  )))|(((
498 -\\
497 +
499 499  )))|(((
500 -\\
499 +
501 501  )))|(((
502 -(% style="color: rgb(0,51,102);" %)20141121163018
501 +(% style="color:#003366" %)20141121163018
503 503  )))|(((
504 -\\
503 +
505 505  )))
506 506  |(((
507 -(% style="color: rgb(0,51,102);" %)**14010001901**
506 +(% style="color:#003366" %)**14010001901**
508 508  )))|(((
509 -(% style="color: rgb(0,51,102);" %)Wendy
508 +(% style="color:#003366" %)Wendy
510 510  )))|(((
511 -(% style="color: rgb(0,51,102);" %)Cole
510 +(% style="color:#003366" %)Cole
512 512  )))|(((
513 -\\
512 +
514 514  )))|(((
515 -(% style="color: rgb(0,51,102);" %)Ms.
514 +(% style="color:#003366" %)Ms.
516 516  )))|(((
517 -\\
516 +
518 518  )))|(((
519 -(% style="color: rgb(0,51,102);" %)Wendy C Cole Interiors
518 +(% style="color:#003366" %)Wendy C Cole Interiors
520 520  )))|(((
521 -(% style="color: rgb(0,51,102);" %)Principal
520 +(% style="color:#003366" %)Principal
522 522  )))|(((
523 -(% style="color: rgb(0,51,102);" %)3 Outlook Dr
522 +(% style="color:#003366" %)3 Outlook Dr
524 524  )))|(((
525 -\\
524 +
526 526  )))|(((
527 -(% style="color: rgb(0,51,102);" %)Darien
526 +(% style="color:#003366" %)Darien
528 528  )))|(((
529 -(% style="color: rgb(0,51,102);" %)CT
528 +(% style="color:#003366" %)CT
530 530  )))|(((
531 -(% style="color: rgb(0,51,102);" %)6820
530 +(% style="color:#003366" %)6820
532 532  )))|(((
533 -(% style="color: rgb(0,51,102);" %)5616
532 +(% style="color:#003366" %)5616
534 534  )))|(((
535 -(% style="color: rgb(0,51,102);" %)United States
534 +(% style="color:#003366" %)United States
536 536  )))|(((
537 -(% style="color: rgb(0,51,102);" %)2036552954
536 +(% style="color:#003366" %)2036552954
538 538  )))|(((
539 -\\
538 +
540 540  )))|(((
541 -\\
540 +
542 542  )))|(((
543 -(% style="color: rgb(0,51,102);" %)N
542 +(% style="color:#003366" %)N
544 544  )))|(((
545 -\\
544 +
546 546  )))|(((
547 -\\
546 +
548 548  )))|(((
549 -\\
548 +
550 550  )))|(((
551 -(% style="color: rgb(0,51,102);" %)20150212210227
550 +(% style="color:#003366" %)20150212210227
552 552  )))|(((
553 -\\
552 +
554 554  )))
555 555  |(((
556 -(% style="color: rgb(0,51,102);" %)**14010001917**
555 +(% style="color:#003366" %)**14010001917**
557 557  )))|(((
558 -(% style="color: rgb(0,51,102);" %)Frank
557 +(% style="color:#003366" %)Frank
559 559  )))|(((
560 -(% style="color: rgb(0,51,102);" %)Stone
559 +(% style="color:#003366" %)Stone
561 561  )))|(((
562 -\\
561 +
563 563  )))|(((
564 -\\
563 +
565 565  )))|(((
566 -\\
565 +
567 567  )))|(((
568 -(% style="color: rgb(0,51,102);" %)Stones Landscape
567 +(% style="color:#003366" %)Stones Landscape
569 569  )))|(((
570 -(% style="color: rgb(0,51,102);" %)Owner
569 +(% style="color:#003366" %)Owner
571 571  )))|(((
572 -(% style="color: rgb(0,51,102);" %)258 West Ave
571 +(% style="color:#003366" %)258 West Ave
573 573  )))|(((
574 -\\
573 +
575 575  )))|(((
576 -(% style="color: rgb(0,51,102);" %)Darien
575 +(% style="color:#003366" %)Darien
577 577  )))|(((
578 -(% style="color: rgb(0,51,102);" %)CT
577 +(% style="color:#003366" %)CT
579 579  )))|(((
580 -(% style="color: rgb(0,51,102);" %)6820
579 +(% style="color:#003366" %)6820
581 581  )))|(((
582 -(% style="color: rgb(0,51,102);" %)4111
581 +(% style="color:#003366" %)4111
583 583  )))|(((
584 -(% style="color: rgb(0,51,102);" %)United States
583 +(% style="color:#003366" %)United States
585 585  )))|(((
586 -(% style="color: rgb(0,51,102);" %)2036569674
585 +(% style="color:#003366" %)2036569674
587 587  )))|(((
588 -\\
587 +
589 589  )))|(((
590 -\\
589 +
591 591  )))|(((
592 -(% style="color: rgb(0,51,102);" %)N
591 +(% style="color:#003366" %)N
593 593  )))|(((
594 -\\
593 +
595 595  )))|(((
596 -\\
595 +
597 597  )))|(((
598 -\\
597 +
599 599  )))|(((
600 -(% style="color: rgb(0,51,102);" %)20150212210227
599 +(% style="color:#003366" %)20150212210227
601 601  )))|(((
602 -\\
601 +
603 603  )))
604 604  |(((
605 -(% style="color: rgb(0,51,102);" %)**14010002429**
604 +(% style="color:#003366" %)**14010002429**
606 606  )))|(((
607 -(% style="color: rgb(0,51,102);" %)Bruce
606 +(% style="color:#003366" %)Bruce
608 608  )))|(((
609 -(% style="color: rgb(0,51,102);" %)Pomerance
608 +(% style="color:#003366" %)Pomerance
610 610  )))|(((
611 -\\
610 +
612 612  )))|(((
613 -(% style="color: rgb(0,51,102);" %)Mr.
612 +(% style="color:#003366" %)Mr.
614 614  )))|(((
615 -\\
614 +
616 616  )))|(((
617 -(% style="color: rgb(0,51,102);" %)P L V Inc
616 +(% style="color:#003366" %)P L V Inc
618 618  )))|(((
619 -(% style="color: rgb(0,51,102);" %)President
618 +(% style="color:#003366" %)President
620 620  )))|(((
621 -(% style="color: rgb(0,51,102);" %)1076 Post Rd
620 +(% style="color:#003366" %)1076 Post Rd
622 622  )))|(((
623 -\\
622 +
624 624  )))|(((
625 -(% style="color: rgb(0,51,102);" %)Darien
624 +(% style="color:#003366" %)Darien
626 626  )))|(((
627 -(% style="color: rgb(0,51,102);" %)CT
626 +(% style="color:#003366" %)CT
628 628  )))|(((
629 -(% style="color: rgb(0,51,102);" %)6820
628 +(% style="color:#003366" %)6820
630 630  )))|(((
631 -(% style="color: rgb(0,51,102);" %)5414
630 +(% style="color:#003366" %)5414
632 632  )))|(((
633 -(% style="color: rgb(0,51,102);" %)United States
632 +(% style="color:#003366" %)United States
634 634  )))|(((
635 -(% style="color: rgb(0,51,102);" %)2036554668
634 +(% style="color:#003366" %)2036554668
636 636  )))|(((
637 -\\
636 +
638 638  )))|(((
639 -\\
638 +
640 640  )))|(((
641 -(% style="color: rgb(0,51,102);" %)N
640 +(% style="color:#003366" %)N
642 642  )))|(((
643 -\\
642 +
644 644  )))|(((
645 -\\
644 +
646 646  )))|(((
647 -\\
646 +
648 648  )))|(((
649 -(% style="color: rgb(0,51,102);" %)20150212210227
648 +(% style="color:#003366" %)20150212210227
650 650  )))|(((
651 -\\
650 +
652 652  )))
653 653  |(((
654 -(% style="color: rgb(0,51,102);" %)**14010002438**
653 +(% style="color:#003366" %)**14010002438**
655 655  )))|(((
656 -(% style="color: rgb(0,51,102);" %)Joanne
655 +(% style="color:#003366" %)Joanne
657 657  )))|(((
658 -(% style="color: rgb(0,51,102);" %)Salvatore
657 +(% style="color:#003366" %)Salvatore
659 659  )))|(((
660 -\\
659 +
661 661  )))|(((
662 -\\
661 +
663 663  )))|(((
664 -\\
663 +
665 665  )))|(((
666 -(% style="color: rgb(0,51,102);" %)Nassau Interests Llc
665 +(% style="color:#003366" %)Nassau Interests Llc
667 667  )))|(((
668 -(% style="color: rgb(0,51,102);" %)Member
667 +(% style="color:#003366" %)Member
669 669  )))|(((
670 -(% style="color: rgb(0,51,102);" %)42 N Meadows Ln
669 +(% style="color:#003366" %)42 N Meadows Ln
671 671  )))|(((
672 -\\
671 +
673 673  )))|(((
674 -(% style="color: rgb(0,51,102);" %)Stamford
673 +(% style="color:#003366" %)Stamford
675 675  )))|(((
676 -(% style="color: rgb(0,51,102);" %)CT
675 +(% style="color:#003366" %)CT
677 677  )))|(((
678 -(% style="color: rgb(0,51,102);" %)6903
677 +(% style="color:#003366" %)6903
679 679  )))|(((
680 -(% style="color: rgb(0,51,102);" %)5151
679 +(% style="color:#003366" %)5151
681 681  )))|(((
682 -(% style="color: rgb(0,51,102);" %)United States
681 +(% style="color:#003366" %)United States
683 683  )))|(((
684 -(% style="color: rgb(0,51,102);" %)2036550303
683 +(% style="color:#003366" %)2036550303
685 685  )))|(((
686 -\\
685 +
687 687  )))|(((
688 -(% style="color: rgb(0,51,102);" %)[[(% style="color: rgb(0,51,102);" %)__joannesal@aol.com__>>mailto:joannesal@aol.com||style="color: rgb(0,51,102);" shape="rect"]]
687 +(% style="color:#003366" %)[[(% style="color: rgb(0, 51, 102); color: rgb(0, 51, 102)" %)__joannesal@aol.com__>>mailto:joannesal@aol.com||shape="rect" style="color: rgb(0,51,102);"]]
689 689  )))|(((
690 -(% style="color: rgb(0,51,102);" %)Y
689 +(% style="color:#003366" %)Y
691 691  )))|(((
692 -\\
691 +
693 693  )))|(((
694 -\\
693 +
695 695  )))|(((
696 -\\
695 +
697 697  )))|(((
698 -(% style="color: rgb(0,51,102);" %)20141212210537
697 +(% style="color:#003366" %)20141212210537
699 699  )))|(((
700 -\\
699 +
701 701  )))
702 702  
703 703  NOTE: Dates need to be in YYYY-mm-dd format
... ... @@ -714,7 +714,7 @@
714 714  
715 715  Again, when you import Transaction Data, it is important to import whatever customer or account ID your remote system has for the user so transactions can be mapped appropriately.
716 716  
717 -When syncing ONEcount with a remote system like a fulfillment database or e-commerce system on a regular basis, say every day or every week, it is best to import and export both the remote system ID, and the ONEcount ID, or OCID. This will ensure new customers added by either system are handled appropriately.
716 +When syncing ONEcount with a remote system like a fulfillment database or e-commerce system on a regular basis (See FULFILLEMENT SAMPLE below), it is best to import and export both the remote system ID, and the ONEcount ID, or OCID. This will ensure new customers added by either system are handled appropriately.
718 718  
719 719  This will create the following work-flow:
720 720  
... ... @@ -751,8 +751,6 @@
751 751  User exists in both systems, update record with incoming data
752 752  )))
753 753  
754 -\\
755 -
756 756  === Transaction Data Sample: ===
757 757  
758 758  (% class="wrapped" %)
... ... @@ -790,9 +790,9 @@
790 790  )))|(((
791 791  15
792 792  )))|(((
793 -\\
790 +
794 794  )))|(((
795 -\\
792 +
796 796  )))
797 797  |(((
798 798  **14010114326**
... ... @@ -809,9 +809,9 @@
809 809  )))|(((
810 810  24.95
811 811  )))|(((
812 -\\
809 +
813 813  )))|(((
814 -\\
811 +
815 815  )))
816 816  |(((
817 817  **14010114326**
... ... @@ -828,9 +828,9 @@
828 828  )))|(((
829 829  13
830 830  )))|(((
831 -\\
828 +
832 832  )))|(((
833 -\\
830 +
834 834  )))
835 835  |(((
836 836  **14010116098**
... ... @@ -845,11 +845,11 @@
845 845  )))|(((
846 846  1
847 847  )))|(((
848 -\\
845 +
849 849  )))|(((
850 -\\
847 +
851 851  )))|(((
852 -\\
849 +
853 853  )))
854 854  
855 855  Transaction type must be one of the following values:
... ... @@ -864,12 +864,204 @@
864 864  
865 865  Status Code: This for subscriber status changes (Current Subscriber, Expired, Pended Add, etc.)
866 866  
867 -\\
864 +=== Fulfillment Sample: Advantage/Omeda/PCS/CDS ===
868 868  
866 +|(((
867 +**PUBCDE**
868 +)))|(((
869 +**CUSTNUMB**
870 +)))|(% colspan="1" %)(% colspan="1" %)
871 +(((
872 +OCID
873 +)))|(((
874 +**CRCSTS**
875 +)))|(((
876 +**FIRST**
877 +)))|(((
878 +**LAST**
879 +)))|(((
880 +**COMPANY**
881 +)))|(((
882 +**ADD1**
883 +)))|(((
884 +**ADD2**
885 +)))|(((
886 +**CITY**
887 +)))|(((
888 +**ZIPCDE**
889 +)))|(((
890 +**STATE**
891 +)))|(((
892 +**ADRCDE**
893 +)))|(((
894 +**KEYCDE**
895 +)))|(((
896 +**QUALSRC**
897 +)))|(((
898 +**EMAIL**
899 +)))|(((
900 +**CTMDTE**
901 +)))|(((
902 +**FINDTE**
903 +)))|(((
904 +**PHONE**
905 +)))|(((
906 +**LISTIND**
907 +)))|(((
908 +**County**
909 +)))|(((
910 +**COUNTRY**
911 +)))
912 +|(((
913 +**AAI**
914 +)))|(((
915 +404304
916 +)))|(% colspan="1" %)(% colspan="1" %)
917 +(((
918 +33675
919 +)))|(((
920 +E
921 +)))|(((
922 +FRED
923 +)))|(((
924 +SMITH
925 +)))|(((
926 +
927 +)))|(((
928 +57 CHURCH ST
929 +)))|(((
930 +
931 +)))|(((
932 +ROXBURY
933 +)))|(((
934 +67831704
935 +)))|(((
936 +CT
937 +)))|(((
938 +M
939 +)))|(((
940 +TREN68B
941 +)))|(((
942 +5F
943 +)))|(((
944 +
945 +)))|(((
946 +20161205
947 +)))|(((
948 +20190101
949 +)))|(((
950 +8005551234
951 +)))|(((
952 +NONACTIVE
953 +)))|(((
954 +LITCHFIELD
955 +)))|(((
956 +USA
957 +)))
958 +|(((
959 +**AIB**
960 +)))|(((
961 +445771
962 +)))|(% colspan="1" %)(% colspan="1" %)
963 +(((
964 +
965 +)))|(((
966 +Q
967 +)))|(((
968 +JOSEPH
969 +)))|(((
970 +JONES
971 +)))|(((
972 +JONES & CO
973 +)))|(((
974 +7632 WILDCAT PIKE
975 +)))|(((
976 +
977 +)))|(((
978 +NEW BLOOMINGTON
979 +)))|(((
980 +433419532
981 +)))|(((
982 +OH
983 +)))|(((
984 +M
985 +)))|(((
986 +E3CC1220
987 +)))|(((
988 +5F
989 +)))|(((
990 +[[__JMBUCKOHIO@AOL.COM__>>mailto:JMBUCKOHIO@AOL.COM||shape="rect"]]
991 +)))|(((
992 +20201201
993 +)))|(((
994 +20231201
995 +)))|(((
996 +9546783214
997 +)))|(((
998 +QUAL
999 +)))|(((
1000 +MARION
1001 +)))|(((
1002 +USA
1003 +)))
1004 +|(((
1005 +**AXW**
1006 +)))|(((
1007 +
1008 +)))|(% colspan="1" %)(% colspan="1" %)
1009 +(((
1010 +3324
1011 +)))|(((
1012 +G
1013 +)))|(((
1014 +MARK
1015 +)))|(((
1016 +ROBERTS
1017 +)))|(((
1018 +TRF Inc.
1019 +)))|(((
1020 +5201 WOODWARD AVE
1021 +)))|(((
1022 +
1023 +)))|(((
1024 +DETROIT
1025 +)))|(((
1026 +482024093
1027 +)))|(((
1028 +MI
1029 +)))|(((
1030 +M
1031 +)))|(((
1032 +RRT6GT
1033 +)))|(((
1034 +1A
1035 +)))|(((
1036 +
1037 +)))|(((
1038 +20201207
1039 +)))|(((
1040 +20210401
1041 +)))|(((
1042 +
1043 +)))|(((
1044 +PAID
1045 +)))|(((
1046 +WAYNE
1047 +)))|(((
1048 +USA
1049 +)))
1050 +
1051 +**PUBCODE maps to Package TERM**
1052 +
1053 +
869 869  === Engagement Data ===
870 870  
871 871  Engagement Data covers a broad range of activities, including banner views and clicks, e-mail opens and clicks, webinar attendance, video plays, etc. The key metric for ALL of these engagement data types is: the user who did it, the date/time of the engagement, and the engagement activity itself (open, click, view, etc.) Other data can be added to these records as well, including the name of the advertiser or banner campaign, the subject of the e-mail campaign, etc.  This data is important to each engagement and can be imported into ONEcount using DExTR.
872 872  
1058 +
1059 +**NOTE**: For e-mail engagement activity date, message id, recipient id, activity type, email click url 
1060 +
1061 +
873 873  Here are a couple of examples:
874 874  
875 875  ==== **E-Mail Engagement (combined, from Eloqua)** ====
... ... @@ -905,99 +905,96 @@
905 905  **VisitorId**
906 906  )))
907 907  |(((
908 -\\
1097 +
909 909  )))|(((
910 -\\
1099 +
911 911  )))|(((
912 -\\
1101 +
913 913  )))|(((
914 -\\
1103 +
915 915  )))|(((
916 -\\
1105 +
917 917  )))|(((
918 -\\
1107 +
919 919  )))|(((
920 -\\
1109 +
921 921  )))|(((
922 -\\
1111 +
923 923  )))|(((
924 -\\
1113 +
925 925  )))|(((
926 -\\
1115 +
927 927  )))|(((
928 -\\
1117 +
929 929  )))|(((
930 -\\
1119 +
931 931  )))|(((
932 -\\
1121 +
933 933  )))|(((
934 -\\
1123 +
935 935  )))
936 936  |(((
937 -**
938 -**
1126 +
939 939  )))|(((
940 -\\
1128 +
941 941  )))|(((
942 -\\
1130 +
943 943  )))|(((
944 -\\
1132 +
945 945  )))|(((
946 -\\
1134 +
947 947  )))|(((
948 -\\
1136 +
949 949  )))|(((
950 -\\
1138 +
951 951  )))|(((
952 -\\
1140 +
953 953  )))|(((
954 -\\
1142 +
955 955  )))|(((
956 -\\
1144 +
957 957  )))|(((
958 -\\
1146 +
959 959  )))|(((
960 -\\
1148 +
961 961  )))|(((
962 -\\
1150 +
963 963  )))|(((
964 -\\
1152 +
965 965  )))
966 966  |(((
967 -**
968 -**
1155 +
969 969  )))|(((
970 -\\
1157 +
971 971  )))|(((
972 -\\
1159 +
973 973  )))|(((
974 -\\
1161 +
975 975  )))|(((
976 -\\
1163 +
977 977  )))|(((
978 -\\
1165 +
979 979  )))|(((
980 -\\
1167 +
981 981  )))|(((
982 -\\
1169 +
983 983  )))|(((
984 -\\
1171 +
985 985  )))|(((
986 -\\
1173 +
987 987  )))|(((
988 -\\
1175 +
989 989  )))|(((
990 -\\
1177 +
991 991  )))|(((
992 -\\
1179 +
993 993  )))|(((
994 -\\
1181 +
995 995  )))
996 996  
997 997  **ContactID is an Eloqua-specific ID **
998 998  
999 -**VisitorID is a custom field in the e-mail system containing the user's GUID from the customer's internal data lake
1000 -**
1186 +**VisitorID is a custom field in the e-mail system containing the user's GUID from the customer's internal data lake**
1001 1001  
1002 1002  ==== **E-mail Engagement (Split Files)** ====
1003 1003  
... ... @@ -1032,31 +1032,31 @@
1032 1032  **clicked**
1033 1033  )))
1034 1034  |(((
1035 -\\
1221 +
1036 1036  )))|(((
1037 -\\
1223 +
1038 1038  )))|(((
1039 -\\
1225 +
1040 1040  )))|(((
1041 -\\
1227 +
1042 1042  )))|(((
1043 -\\
1229 +
1044 1044  )))|(((
1045 -\\
1231 +
1046 1046  )))|(((
1047 -\\
1233 +
1048 1048  )))|(((
1049 -\\
1235 +
1050 1050  )))|(((
1051 -\\
1237 +
1052 1052  )))|(((
1053 -\\
1239 +
1054 1054  )))|(((
1055 -\\
1241 +
1056 1056  )))|(((
1057 -\\
1243 +
1058 1058  )))|(((
1059 -\\
1245 +
1060 1060  )))
1061 1061  
1062 1062  **email-opens.csv**
... ... @@ -1080,21 +1080,21 @@
1080 1080  **OCID**
1081 1081  )))
1082 1082  |(((
1083 -\\
1269 +
1084 1084  )))|(((
1085 -\\
1271 +
1086 1086  )))|(((
1087 -\\
1273 +
1088 1088  )))|(((
1089 -\\
1275 +
1090 1090  )))|(((
1091 -\\
1277 +
1092 1092  )))|(((
1093 -\\
1279 +
1094 1094  )))|(((
1095 -\\
1281 +
1096 1096  )))|(((
1097 -\\
1283 +
1098 1098  )))
1099 1099  
1100 1100  **email-sends.csv**
... ... @@ -1118,27 +1118,27 @@
1118 1118  **OCID**
1119 1119  )))
1120 1120  |(((
1121 -\\
1307 +
1122 1122  )))|(((
1123 -\\
1309 +
1124 1124  )))|(((
1125 -\\
1311 +
1126 1126  )))|(((
1127 -\\
1313 +
1128 1128  )))|(((
1129 -\\
1315 +
1130 1130  )))|(((
1131 -\\
1317 +
1132 1132  )))|(((
1133 -\\
1319 +
1134 1134  )))|(((
1135 -\\
1321 +
1136 1136  )))
1137 1137  
1138 -\\
1139 1139  
1140 -=== LiveIntent Data Sample: ===
1325 +==== LiveIntent Data Sample: ====
1141 1141  
1327 +(% class="wrapped" %)
1142 1142  |(((
1143 1143  **Liveintentuserid**
1144 1144  )))|(((
... ... @@ -1302,7 +1302,6 @@
1302 1302  2021-03-10
1303 1303  )))
1304 1304  
1305 -\\
1306 1306  
1307 1307  ==== **BrightCove Data Sample:** ====
1308 1308  
... ... @@ -1361,11 +1361,11 @@
1361 1361  )))|(((
1362 1362  2021-02-11
1363 1363  )))|(((
1364 -\\
1549 +
1365 1365  )))|(((
1366 -\\
1551 +
1367 1367  )))|(((
1368 -\\
1553 +
1369 1369  )))|(((
1370 1370  5982181673007
1371 1371  )))|(((
... ... @@ -1394,11 +1394,11 @@
1394 1394  )))|(((
1395 1395  2021-01-25
1396 1396  )))|(((
1397 -\\
1582 +
1398 1398  )))|(((
1399 -\\
1584 +
1400 1400  )))|(((
1401 -\\
1586 +
1402 1402  )))|(((
1403 1403  6171615690004
1404 1404  )))|(((
... ... @@ -1427,11 +1427,11 @@
1427 1427  )))|(((
1428 1428  2021-01-29
1429 1429  )))|(((
1430 -\\
1615 +
1431 1431  )))|(((
1432 -\\
1617 +
1433 1433  )))|(((
1434 -\\
1619 +
1435 1435  )))|(((
1436 1436  6171615690003
1437 1437  )))|(((
... ... @@ -1460,11 +1460,11 @@
1460 1460  )))|(((
1461 1461  2021-02-12
1462 1462  )))|(((
1463 -\\
1648 +
1464 1464  )))|(((
1465 -\\
1650 +
1466 1466  )))|(((
1467 -\\
1652 +
1468 1468  )))|(((
1469 1469  6171632240005
1470 1470  )))|(((
... ... @@ -1574,7 +1574,6 @@
1574 1574  
1575 1575  **ContactID is a GUID assigned by the Customer's Internal Data Warehouse**
1576 1576  
1577 -\\
1578 1578  
1579 1579  ==== **Raw Web Impressions** ====
1580 1580  
... ... @@ -1601,7 +1601,7 @@
1601 1601  )))|(((
1602 1602  mobile
1603 1603  )))|(((
1604 -\\
1788 +
1605 1605  )))|(((
1606 1606  2407411196308715909161529690620210309
1607 1607  )))|(((
... ... @@ -1616,7 +1616,7 @@
1616 1616  )))|(((
1617 1617  tablet
1618 1618  )))|(((
1619 -\\
1803 +
1620 1620  )))|(((
1621 1621  2419995085411609985161503823320210306
1622 1622  )))|(((
... ... @@ -1631,7 +1631,7 @@
1631 1631  )))|(((
1632 1632  tablet
1633 1633  )))|(((
1634 -\\
1818 +
1635 1635  )))|(((
1636 1636  3663669472315156695161403488520210222
1637 1637  )))|(((
... ... @@ -1646,7 +1646,7 @@
1646 1646  )))|(((
1647 1647  mobile
1648 1648  )))|(((
1649 -\\
1833 +
1650 1650  )))|(((
1651 1651  2407411196308715909161529690620210309
1652 1652  )))|(((
... ... @@ -1661,7 +1661,7 @@
1661 1661  )))|(((
1662 1662  mobile
1663 1663  )))|(((
1664 -\\
1848 +
1665 1665  )))|(((
1666 1666  8233752448896666794161427278020210225
1667 1667  )))|(((
... ... @@ -1676,9 +1676,9 @@
1676 1676  )))|(((
1677 1677  desktop
1678 1678  )))|(((
1679 -\\
1863 +
1680 1680  )))|(((
1681 -\\
1865 +
1682 1682  )))|(((
1683 1683  __www.CUSTOMER.com__
1684 1684  )))|(((
... ... @@ -1686,3 +1686,470 @@
1686 1686  )))
1687 1687  
1688 1688  **VisitContactID is a GUID assigned by the Customer's Internal Data Warehouse**
1873 +
1874 +
1875 +==== **Swapcard (Webinar/Virtual Event Platform)** ====
1876 +
1877 +|(((
1878 +**Title**
1879 +)))|(((
1880 +**Start date**
1881 +)))|(((
1882 +**Format**
1883 +)))|(((
1884 +**Topics**
1885 +)))|(((
1886 +**Group**
1887 +)))|(((
1888 +**Email**
1889 +)))|(((
1890 +**First**
1891 +)))|(((
1892 +**Last**
1893 +)))|(((
1894 +**Title**
1895 +)))|(((
1896 +**Company**
1897 +)))
1898 +|(((
1899 +**Is COVID-19 FOR REAL?**
1900 +)))|(((
1901 +2-11-21 12:55 PM
1902 +)))|(((
1903 +PRE_RECORDED
1904 +)))|(((
1905 +Other, Human Health, Policy, Business
1906 +)))|(((
1907 +Premium Members
1908 +)))|(((
1909 +[[__ryan@2XXX.com__>>mailto:ryan@22creativegroup.com||shape="rect"]]
1910 +)))|(((
1911 +Ryan
1912 +)))|(((
1913 +Brown
1914 +)))|(((
1915 +
1916 +)))|(((
1917 +2XXX Group
1918 +)))
1919 +|(((
1920 +**BREAKING NEWS SESSION: Extreme **
1921 +)))|(((
1922 +2-17-21 1:15 PM
1923 +)))|(((
1924 +PRE_RECORDED
1925 +)))|(((
1926 +
1927 +)))|(((
1928 +Premium Members
1929 +)))|(((
1930 +[[__ryan@2XXX.com__>>mailto:ryan@22creativegroup.com||shape="rect"]]
1931 +)))|(((
1932 +Ryan
1933 +)))|(((
1934 +Brown
1935 +)))|(((
1936 +
1937 +)))|(((
1938 +2XXX Group
1939 +)))
1940 +
1941 +
1942 +==== **Trade Show Registration Data** ====
1943 +
1944 +|(((
1945 +**Event Series**
1946 +)))|(((
1947 +**Event Edition**
1948 +)))|(((
1949 +**Source System**
1950 +)))|(((
1951 +**Reg Number**
1952 +)))|(((
1953 +**First Name**
1954 +)))|(((
1955 +**Last Name**
1956 +)))|(((
1957 +**Title**
1958 +)))|(((
1959 +**Company 1**
1960 +)))|(((
1961 +**Address 1**
1962 +)))|(((
1963 +**Address 2**
1964 +)))|(((
1965 +**City**
1966 +)))|(((
1967 +**State**
1968 +)))|(((
1969 +**Zip Code**
1970 +)))|(((
1971 +**Country**
1972 +)))|(((
1973 +**Phone Number**
1974 +)))|(((
1975 +**Fax Number**
1976 +)))|(((
1977 +**Email Address**
1978 +)))|(((
1979 +**Internet Address 2**
1980 +)))|(((
1981 +**Phone Area Code**
1982 +)))|(((
1983 +**Phone Number Only**
1984 +)))|(((
1985 +**Reg Code**
1986 +)))|(((
1987 +**Membership Flag**
1988 +)))|(((
1989 +**Member ID**
1990 +)))|(((
1991 +**Reg Code 3**
1992 +)))|(((
1993 +**Text 1**
1994 +)))|(((
1995 +**Credential**
1996 +)))|(((
1997 +**Amount Paid**
1998 +)))|(((
1999 +**Amount Refunded**
2000 +)))|(((
2001 +**Reg Code 2**
2002 +)))|(((
2003 +**Source Code**
2004 +)))|(((
2005 +**Link Reg ID**
2006 +)))|(((
2007 +**Business type:  Check all that apply.**
2008 +)))|(((
2009 +**Age range**
2010 +)))|(((
2011 +**Primary business**
2012 +)))|(((
2013 +**Is this your first time to attend the Expo?**
2014 +)))|(((
2015 +**Please keep me up-to-date with the latest events and services**
2016 +)))|(((
2017 +**I would like to hear from  directly about products and services**
2018 +)))|(((
2019 +**What is your gender?**
2020 +)))|(((
2021 +**Buying decisions**
2022 +)))|(((
2023 +**Job function**
2024 +)))|(((
2025 +**Primary Market**
2026 +)))|(((
2027 +**What is your job title/function?**
2028 +)))|(((
2029 +**What is your company's primary media type?**
2030 +)))|(((
2031 +**Products/services**
2032 +)))|(((
2033 +**Do you want to receive a free subscription to PVV Magazine?**
2034 +)))|(((
2035 +**Do you want to receive a free subscription to RXY Magazine?**
2036 +)))|(((
2037 +**Sales Volume**
2038 +)))|(((
2039 +**Do you want to receive a free subscription to our e-newsletter?**
2040 +)))|(((
2041 +**What services does your company provide?**
2042 +)))
2043 +|(((
2044 +**Annual Trade Show**
2045 +)))|(((
2046 +EXPO 2022
2047 +)))|(((
2048 +CSI
2049 +)))|(((
2050 +1100339
2051 +)))|(((
2052 +Fred
2053 +)))|(((
2054 +Jones
2055 +)))|(((
2056 +Owner
2057 +)))|(((
2058 +Jones Construction Ent.
2059 +)))|(((
2060 +690 E Highway 90
2061 +)))|(((
2062 +690 e HWY 90
2063 +)))|(((
2064 +Tampa
2065 +)))|(((
2066 +FL
2067 +)))|(((
2068 +32425
2069 +)))|(((
2070 +
2071 +)))|(((
2072 +1  8505551001
2073 +)))|(((
2074 +
2075 +)))|(((
2076 +__fred@myaddress.com__
2077 +)))|(((
2078 +__officemgr@notmyaddress.com__
2079 +)))|(((
2080 +850
2081 +)))|(((
2082 +5471001
2083 +)))|(((
2084 +Conference Attendee
2085 +)))|(((
2086 +Y
2087 +)))|(((
2088 +412351
2089 +)))|(((
2090 +
2091 +)))|(((
2092 +
2093 +)))|(((
2094 +
2095 +)))|(((
2096 +396
2097 +)))|(((
2098 +
2099 +)))|(((
2100 +Super Pass
2101 +)))|(((
2102 +
2103 +)))|(((
2104 +1100002
2105 +)))|(((
2106 +Contractor
2107 +)))|(((
2108 +51-60
2109 +)))|(((
2110 +Contractor
2111 +)))|(((
2112 +No
2113 +)))|(((
2114 +Yes
2115 +)))|(((
2116 +
2117 +)))|(((
2118 +Male
2119 +)))|(((
2120 +Yes
2121 +)))|(((
2122 +Owner/CEO/President/Executive
2123 +)))|(((
2124 +Both
2125 +)))|(((
2126 +
2127 +)))|(((
2128 +
2129 +)))|(((
2130 +This, That, A little of the other, Something Else
2131 +)))|(((
2132 +Yes
2133 +)))|(((
2134 +Yes
2135 +)))|(((
2136 +$1,000,000-$4,999,999
2137 +)))|(((
2138 +Yes
2139 +)))|(((
2140 +Roofing, Pool Repair, Driveway Sealing, Electrical Contracting
2141 +)))
2142 +|(((
2143 +
2144 +)))|(((
2145 +
2146 +)))|(((
2147 +
2148 +)))|(((
2149 +
2150 +)))|(((
2151 +
2152 +)))|(((
2153 +
2154 +)))|(((
2155 +
2156 +)))|(((
2157 +
2158 +)))|(((
2159 +
2160 +)))|(((
2161 +
2162 +)))|(((
2163 +
2164 +)))|(((
2165 +
2166 +)))|(((
2167 +
2168 +)))|(((
2169 +
2170 +)))|(((
2171 +
2172 +)))|(((
2173 +
2174 +)))|(((
2175 +
2176 +)))|(((
2177 +
2178 +)))|(((
2179 +
2180 +)))|(((
2181 +
2182 +)))|(((
2183 +
2184 +)))|(((
2185 +
2186 +)))|(((
2187 +
2188 +)))|(((
2189 +
2190 +)))|(((
2191 +
2192 +)))|(((
2193 +
2194 +)))|(((
2195 +
2196 +)))|(((
2197 +
2198 +)))|(((
2199 +
2200 +)))|(((
2201 +
2202 +)))|(((
2203 +
2204 +)))|(((
2205 +
2206 +)))|(((
2207 +
2208 +)))|(((
2209 +
2210 +)))|(((
2211 +
2212 +)))|(((
2213 +
2214 +)))|(((
2215 +
2216 +)))|(((
2217 +
2218 +)))|(((
2219 +
2220 +)))|(((
2221 +
2222 +)))|(((
2223 +
2224 +)))|(((
2225 +
2226 +)))|(((
2227 +
2228 +)))|(((
2229 +
2230 +)))|(((
2231 +
2232 +)))|(((
2233 +
2234 +)))|(((
2235 +
2236 +)))|(((
2237 +
2238 +)))|(((
2239 +
2240 +)))
2241 +|(((
2242 +**Annual Trade Show**
2243 +)))|(((
2244 +EXPO 2022
2245 +)))|(((
2246 +CSI
2247 +)))|(((
2248 +1100005
2249 +)))|(((
2250 +Jim
2251 +)))|(((
2252 +Nordstrom
2253 +)))|(((
2254 +Spouse
2255 +)))|(((
2256 +Nordstrom Chain, LLC
2257 +)))|(((
2258 +690 E Highway 90
2259 +)))|(((
2260 +
2261 +)))|(((
2262 +Miami
2263 +)))|(((
2264 +FL
2265 +)))|(((
2266 +33736
2267 +)))|(((
2268 +
2269 +)))|(((
2270 +1  8502588247
2271 +)))|(((
2272 +
2273 +)))|(((
2274 +__jimnordstrom@something.com__
2275 +)))|(((
2276 +
2277 +)))|(((
2278 +850
2279 +)))|(((
2280 +3998247
2281 +)))|(((
2282 +Attendee Expo Only
2283 +)))|(((
2284 +N
2285 +)))|(((
2286 +
2287 +)))|(((
2288 +
2289 +)))|(((
2290 +
2291 +)))|(((
2292 +
2293 +)))|(((
2294 +66
2295 +)))|(((
2296 +
2297 +)))|(((
2298 +Expo Only
2299 +)))|(((
2300 +
2301 +)))|(((
2302 +1100002
2303 +)))|(((
2304 +No Response
2305 +)))|(((
2306 +41-50
2307 +)))|(((
2308 +Spouse/Guest
2309 +)))|(((
2310 +Yes
2311 +)))|(((
2312 +Yes
2313 +)))|(((
2314 +
2315 +)))|(((
2316 +Male
2317 +)))|(((
2318 +No Response
2319 +)))|(((
2320 +Spouse/Guest
2321 +)))|(((
2322 +
2323 +)))|(((
2324 +
2325 +)))|(((
2326 +
2327 +)))|(((
2328 +Rope, Twine, Chain
2329 +)))|(((
2330 +No
2331 +)))|(((
2332 +No
2333 +)))|(((
2334 +No Response
2335 +)))|(((
2336 +No
2337 +)))|(((
2338 +No Response [DB ONLY]
2339 +)))
demo-sample.csv
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +5.5 KB
Content
... ... @@ -1,0 +1,23 @@
1 +��"ACCOUNT NUMBER","FIRST NAME","LAST NAME","MIDDLE NAME","TITLE","SUFFIX","COMPANY","JOB TITLE","ADDRESS1","ADDRESS2","CITY","STATE","ZIP","ZIP4","COUNTRY","TELEPHONE NUMBER","FAX NUMBER","E-MAIL ADDRESS","E-MAIL CONTACT","CUSTOM1","CUSTOM2","CUSTOM3","LAST UPDATED","OCID"
2 +14010000431,"Graham","O'Gorman",,,,"Graham O'Gorman Landscape",,"192 Olmstead Hill Rd",,"Wilton","CT",6897,1816,"United States",,,,"N",,,,20141113211102,
3 +14010000449,"Dale S","Galbo",,,,"Law Offices","Owner","15 W Hill Rd",,"Bloomfield","CT",6002,5016,"United States",2032709821,,,"N",,,,20141113211111,
4 +14010000648,"Patricia","Cannon",,,,"Employee Assistance Program","Director","887 Bridgeport Ave Ste C",,"Shelton","CT",6484,7602,"United States",2039290681,,,"N",,,,20141121163017,
5 +14010001843,"Susan","Kent",,,,,,"38110 5th St E Apt 1",,"Los Angeles","CA",93550,2317,"United States",,,,"N",,,,20141212210537,
6 +14010001858,"Brendan","Eppley",,,,,,"20 Driftway Ln",,"Darien","CT",6820,6130,"United States",,,,"N",,,,20141211230144,
7 +14010001862,,,,,,"Orchard Tree Care Llc",,"184 Ave",,"Darien","CT",6820,,"United States",2036550618,,,"N",,,,20150211133156,
8 +14010001870,"Avis Z","Gray",,,,"Designers 5 Incorporated","President","96 5 Mile River Rd",,"Darien","CT",6820,6234,"United States",2036552033,,,"N",,,,20150212210227,
9 +14010001889,"John","Hertz",,,,"Hertz Construction Co","Partner","12 Hillside Ave",,"Darien","CT",6820,5010,"United States",2036564900,,,"N",,,,20141121163018,
10 +14010001891,,,,,,"Niche Home Furnishings Ll",,"25 Old Kings Hwy N Ste 17",,"Darien","CT",6820,4608,"United States",2036566674,,,"N",,,,20141121163018,
11 +14010001901,"Wendy","Cole",,"Ms.",,"Wendy C Cole Interiors","Principal","3 Outlook Dr",,"Darien","CT",6820,5616,"United States",2036552954,,,"N",,,,20150212210227,
12 +14010001917,"Frank","Stone",,,,"Stones Landscape","Owner","258 West Ave",,"Darien","CT",6820,4111,"United States",2036569674,,,"N",,,,20150212210227,
13 +14010002429,"Bruce","Pomerance",,"Mr.",,"P L V Inc","President","1076 Post Rd",,"Darien","CT",6820,5414,"United States",2036554668,,,"N",,,,20150212210227,
14 +14010002438,"Joanne","Salvatore",,,,"Nassau Interests Llc","Member","42 N Meadows Ln",,"Stamford","CT",6903,5151,"United States",2036550303,,"joannesal@aol.com","Y",,,,20141212210537,
15 +,,,,,,,,,,,,,,,,,,,,,,,
16 +,,,,,,,,,,,,,,,,,,,,,,,
17 +,,,,,,,,,,,,,,,,,,,,,,,
18 +,,,,,,,,,,,,,,,,,,,,,,,
19 +"Rules:","Dates need to be in YYYY-mm-dd format",,,,,,,,,,,,,,,,,,,,,,
20 +"OCID = ONEcount ID","send only when available",,,,,,,,,,,,,,,,,,,,,,
21 +"CUSTOM1, CUSTOM2.... are questions that are publisher specific questions which is other than the standard personal information question.",,,,,,,,,,,,,,,,,,,,,,,
22 +"When available, values of those questions can be sent in that column. If not available don't send those columns.",,,,,,,,,,,,,,,,,,,,,,,
23 +
Confluence.Code.ConfluencePageClass[0]
id
... ... @@ -1,1 +1,1 @@
1 -77496440
1 +77496432
url
... ... @@ -1,1 +1,1 @@
1 -https://info.onecount.net//wiki/spaces/OD/pages/77496440/DExTr Import Files
1 +https://info.onecount.net//wiki/spaces/OD/pages/77496432/DExTr Import Files