Changes for page DExTr Import Files

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

Summary

Details

Page properties
Parent
... ... @@ -1,1 +1,0 @@
1 -How-To Info:
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.rayaan
1 +XWiki.Admin
Content
... ... @@ -10,693 +10,694 @@
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 +\\
13 13  
14 14  (% class="wrapped" %)
15 15  |(((
16 -(% style="color:#003366" %)**ACCOUNT NUMBER**
17 +(% style="color: rgb(0,51,102);" %)**ACCOUNT NUMBER**
17 17  )))|(((
18 -(% style="color:#003366" %)**FIRST NAME**
19 +(% style="color: rgb(0,51,102);" %)**FIRST NAME**
19 19  )))|(((
20 -(% style="color:#003366" %)**LAST NAME**
21 +(% style="color: rgb(0,51,102);" %)**LAST NAME**
21 21  )))|(((
22 -(% style="color:#003366" %)**MIDDLE NAME**
23 +(% style="color: rgb(0,51,102);" %)**MIDDLE NAME**
23 23  )))|(((
24 -(% style="color:#003366" %)**TITLE**
25 +(% style="color: rgb(0,51,102);" %)**TITLE**
25 25  )))|(((
26 -(% style="color:#003366" %)**SUFFIX**
27 +(% style="color: rgb(0,51,102);" %)**SUFFIX**
27 27  )))|(((
28 -(% style="color:#003366" %)**COMPANY**
29 +(% style="color: rgb(0,51,102);" %)**COMPANY**
29 29  )))|(((
30 -(% style="color:#003366" %)**JOB TITLE**
31 +(% style="color: rgb(0,51,102);" %)**JOB TITLE**
31 31  )))|(((
32 -(% style="color:#003366" %)**ADDRESS1**
33 +(% style="color: rgb(0,51,102);" %)**ADDRESS1**
33 33  )))|(((
34 -(% style="color:#003366" %)**ADDRESS2**
35 +(% style="color: rgb(0,51,102);" %)**ADDRESS2**
35 35  )))|(((
36 -(% style="color:#003366" %)**CITY**
37 +(% style="color: rgb(0,51,102);" %)**CITY**
37 37  )))|(((
38 -(% style="color:#003366" %)**STATE**
39 +(% style="color: rgb(0,51,102);" %)**STATE**
39 39  )))|(((
40 -(% style="color:#003366" %)**ZIP**
41 +(% style="color: rgb(0,51,102);" %)**ZIP**
41 41  )))|(((
42 -(% style="color:#003366" %)**ZIP4**
43 +(% style="color: rgb(0,51,102);" %)**ZIP4**
43 43  )))|(((
44 -(% style="color:#003366" %)**COUNTRY**
45 +(% style="color: rgb(0,51,102);" %)**COUNTRY**
45 45  )))|(((
46 -(% style="color:#003366" %)**TELEPHONE NUMBER**
47 +(% style="color: rgb(0,51,102);" %)**TELEPHONE NUMBER**
47 47  )))|(((
48 -(% style="color:#003366" %)**FAX NUMBER**
49 +(% style="color: rgb(0,51,102);" %)**FAX NUMBER**
49 49  )))|(((
50 -(% style="color:#003366" %)**E-MAIL ADDRESS**
51 +(% style="color: rgb(0,51,102);" %)**E-MAIL ADDRESS**
51 51  )))|(((
52 -(% style="color:#003366" %)**E-MAIL CONTACT**
53 +(% style="color: rgb(0,51,102);" %)**E-MAIL CONTACT**
53 53  )))|(((
54 -(% style="color:#003366" %)**CUSTOM1**
55 +(% style="color: rgb(0,51,102);" %)**CUSTOM1**
55 55  )))|(((
56 -(% style="color:#003366" %)**CUSTOM2**
57 +(% style="color: rgb(0,51,102);" %)**CUSTOM2**
57 57  )))|(((
58 -(% style="color:#003366" %)**CUSTOM3**
59 +(% style="color: rgb(0,51,102);" %)**CUSTOM3**
59 59  )))|(((
60 -(% style="color:#003366" %)**LAST UPDATED**
61 +(% style="color: rgb(0,51,102);" %)**LAST UPDATED**
61 61  )))|(((
62 -(% style="color:#003366" %)**OCID**
63 +(% style="color: rgb(0,51,102);" %)**OCID**
63 63  )))
64 64  |(((
65 -(% style="color:#003366" %)**14010000431**
66 +(% style="color: rgb(0,51,102);" %)**14010000431**
66 66  )))|(((
67 -(% style="color:#003366" %)Graham
68 +(% style="color: rgb(0,51,102);" %)Graham
68 68  )))|(((
69 -(% style="color:#003366" %)O'Gorman
70 +(% style="color: rgb(0,51,102);" %)O'Gorman
70 70  )))|(((
71 -
72 +\\
72 72  )))|(((
73 -
74 +\\
74 74  )))|(((
75 -
76 +\\
76 76  )))|(((
77 -(% style="color:#003366" %)Graham O'Gorman Landscape
78 +(% style="color: rgb(0,51,102);" %)Graham O'Gorman Landscape
78 78  )))|(((
79 -
80 +\\
80 80  )))|(((
81 -(% style="color:#003366" %)192 Olmstead Hill Rd
82 +(% style="color: rgb(0,51,102);" %)192 Olmstead Hill Rd
82 82  )))|(((
83 -
84 +\\
84 84  )))|(((
85 -(% style="color:#003366" %)Wilton
86 +(% style="color: rgb(0,51,102);" %)Wilton
86 86  )))|(((
87 -(% style="color:#003366" %)CT
88 +(% style="color: rgb(0,51,102);" %)CT
88 88  )))|(((
89 -(% style="color:#003366" %)6897
90 +(% style="color: rgb(0,51,102);" %)6897
90 90  )))|(((
91 -(% style="color:#003366" %)1816
92 +(% style="color: rgb(0,51,102);" %)1816
92 92  )))|(((
93 -(% style="color:#003366" %)United States
94 +(% style="color: rgb(0,51,102);" %)United States
94 94  )))|(((
95 -
96 +\\
96 96  )))|(((
97 -
98 +\\
98 98  )))|(((
99 -
100 +\\
100 100  )))|(((
101 -(% style="color:#003366" %)N
102 +(% style="color: rgb(0,51,102);" %)N
102 102  )))|(((
103 -
104 +\\
104 104  )))|(((
105 -
106 +\\
106 106  )))|(((
107 -
108 +\\
108 108  )))|(((
109 -(% style="color:#003366" %)20141113211102
110 +(% style="color: rgb(0,51,102);" %)20141113211102
110 110  )))|(((
111 -
112 +\\
112 112  )))
113 113  |(((
114 -(% style="color:#003366" %)**14010000449**
115 +(% style="color: rgb(0,51,102);" %)**14010000449**
115 115  )))|(((
116 -(% style="color:#003366" %)Dale S
117 +(% style="color: rgb(0,51,102);" %)Dale S
117 117  )))|(((
118 -(% style="color:#003366" %)Galbo
119 +(% style="color: rgb(0,51,102);" %)Galbo
119 119  )))|(((
120 -
121 +\\
121 121  )))|(((
122 -
123 +\\
123 123  )))|(((
124 -
125 +\\
125 125  )))|(((
126 -(% style="color:#003366" %)Law Offices
127 +(% style="color: rgb(0,51,102);" %)Law Offices
127 127  )))|(((
128 -(% style="color:#003366" %)Owner
129 +(% style="color: rgb(0,51,102);" %)Owner
129 129  )))|(((
130 -(% style="color:#003366" %)15 W Hill Rd
131 +(% style="color: rgb(0,51,102);" %)15 W Hill Rd
131 131  )))|(((
132 -
133 +\\
133 133  )))|(((
134 -(% style="color:#003366" %)Bloomfield
135 +(% style="color: rgb(0,51,102);" %)Bloomfield
135 135  )))|(((
136 -(% style="color:#003366" %)CT
137 +(% style="color: rgb(0,51,102);" %)CT
137 137  )))|(((
138 -(% style="color:#003366" %)6002
139 +(% style="color: rgb(0,51,102);" %)6002
139 139  )))|(((
140 -(% style="color:#003366" %)5016
141 +(% style="color: rgb(0,51,102);" %)5016
141 141  )))|(((
142 -(% style="color:#003366" %)United States
143 +(% style="color: rgb(0,51,102);" %)United States
143 143  )))|(((
144 -(% style="color:#003366" %)2032709821
145 +(% style="color: rgb(0,51,102);" %)2032709821
145 145  )))|(((
146 -
147 +\\
147 147  )))|(((
148 -
149 +\\
149 149  )))|(((
150 -(% style="color:#003366" %)N
151 +(% style="color: rgb(0,51,102);" %)N
151 151  )))|(((
152 -
153 +\\
153 153  )))|(((
154 -
155 +\\
155 155  )))|(((
156 -
157 +\\
157 157  )))|(((
158 -(% style="color:#003366" %)20141113211111
159 +(% style="color: rgb(0,51,102);" %)20141113211111
159 159  )))|(((
160 -
161 +\\
161 161  )))
162 162  |(((
163 -(% style="color:#003366" %)**14010000648**
164 +(% style="color: rgb(0,51,102);" %)**14010000648**
164 164  )))|(((
165 -(% style="color:#003366" %)Patricia
166 +(% style="color: rgb(0,51,102);" %)Patricia
166 166  )))|(((
167 -(% style="color:#003366" %)Cannon
168 +(% style="color: rgb(0,51,102);" %)Cannon
168 168  )))|(((
169 -
170 +\\
170 170  )))|(((
171 -
172 +\\
172 172  )))|(((
173 -
174 +\\
174 174  )))|(((
175 -(% style="color:#003366" %)Employee Assistance Program
176 +(% style="color: rgb(0,51,102);" %)Employee Assistance Program
176 176  )))|(((
177 -(% style="color:#003366" %)Director
178 +(% style="color: rgb(0,51,102);" %)Director
178 178  )))|(((
179 -(% style="color:#003366" %)887 Bridgeport Ave Ste C
180 +(% style="color: rgb(0,51,102);" %)887 Bridgeport Ave Ste C
180 180  )))|(((
181 -
182 +\\
182 182  )))|(((
183 -(% style="color:#003366" %)Shelton
184 +(% style="color: rgb(0,51,102);" %)Shelton
184 184  )))|(((
185 -(% style="color:#003366" %)CT
186 +(% style="color: rgb(0,51,102);" %)CT
186 186  )))|(((
187 -(% style="color:#003366" %)6484
188 +(% style="color: rgb(0,51,102);" %)6484
188 188  )))|(((
189 -(% style="color:#003366" %)7602
190 +(% style="color: rgb(0,51,102);" %)7602
190 190  )))|(((
191 -(% style="color:#003366" %)United States
192 +(% style="color: rgb(0,51,102);" %)United States
192 192  )))|(((
193 -(% style="color:#003366" %)2039290681
194 +(% style="color: rgb(0,51,102);" %)2039290681
194 194  )))|(((
195 -
196 +\\
196 196  )))|(((
197 -
198 +\\
198 198  )))|(((
199 -(% style="color:#003366" %)N
200 +(% style="color: rgb(0,51,102);" %)N
200 200  )))|(((
201 -
202 +\\
202 202  )))|(((
203 -
204 +\\
204 204  )))|(((
205 -
206 +\\
206 206  )))|(((
207 -(% style="color:#003366" %)20141121163017
208 +(% style="color: rgb(0,51,102);" %)20141121163017
208 208  )))|(((
209 -
210 +\\
210 210  )))
211 211  |(((
212 -(% style="color:#003366" %)**14010001843**
213 +(% style="color: rgb(0,51,102);" %)**14010001843**
213 213  )))|(((
214 -(% style="color:#003366" %)Susan
215 +(% style="color: rgb(0,51,102);" %)Susan
215 215  )))|(((
216 -(% style="color:#003366" %)Kent
217 +(% style="color: rgb(0,51,102);" %)Kent
217 217  )))|(((
218 -
219 +\\
219 219  )))|(((
220 -
221 +\\
221 221  )))|(((
222 -
223 +\\
223 223  )))|(((
224 -
225 +\\
225 225  )))|(((
226 -
227 +\\
227 227  )))|(((
228 -(% style="color:#003366" %)38110 5th St E Apt 1
229 +(% style="color: rgb(0,51,102);" %)38110 5th St E Apt 1
229 229  )))|(((
230 -
231 +\\
231 231  )))|(((
232 -(% style="color:#003366" %)Los Angeles
233 +(% style="color: rgb(0,51,102);" %)Los Angeles
233 233  )))|(((
234 -(% style="color:#003366" %)CA
235 +(% style="color: rgb(0,51,102);" %)CA
235 235  )))|(((
236 -(% style="color:#003366" %)93550
237 +(% style="color: rgb(0,51,102);" %)93550
237 237  )))|(((
238 -(% style="color:#003366" %)2317
239 +(% style="color: rgb(0,51,102);" %)2317
239 239  )))|(((
240 -(% style="color:#003366" %)United States
241 +(% style="color: rgb(0,51,102);" %)United States
241 241  )))|(((
242 -
243 +\\
243 243  )))|(((
244 -
245 +\\
245 245  )))|(((
246 -
247 +\\
247 247  )))|(((
248 -(% style="color:#003366" %)N
249 +(% style="color: rgb(0,51,102);" %)N
249 249  )))|(((
250 -
251 +\\
251 251  )))|(((
252 -
253 +\\
253 253  )))|(((
254 -
255 +\\
255 255  )))|(((
256 -(% style="color:#003366" %)20141212210537
257 +(% style="color: rgb(0,51,102);" %)20141212210537
257 257  )))|(((
258 -
259 +\\
259 259  )))
260 260  |(((
261 -(% style="color:#003366" %)**14010001858**
262 +(% style="color: rgb(0,51,102);" %)**14010001858**
262 262  )))|(((
263 -(% style="color:#003366" %)Brendan
264 +(% style="color: rgb(0,51,102);" %)Brendan
264 264  )))|(((
265 -(% style="color:#003366" %)Eppley
266 +(% style="color: rgb(0,51,102);" %)Eppley
266 266  )))|(((
267 -
268 +\\
268 268  )))|(((
269 -
270 +\\
270 270  )))|(((
271 -
272 +\\
272 272  )))|(((
273 -
274 +\\
274 274  )))|(((
275 -
276 +\\
276 276  )))|(((
277 -(% style="color:#003366" %)20 Driftway Ln
278 +(% style="color: rgb(0,51,102);" %)20 Driftway Ln
278 278  )))|(((
279 -
280 +\\
280 280  )))|(((
281 -(% style="color:#003366" %)Darien
282 +(% style="color: rgb(0,51,102);" %)Darien
282 282  )))|(((
283 -(% style="color:#003366" %)CT
284 +(% style="color: rgb(0,51,102);" %)CT
284 284  )))|(((
285 -(% style="color:#003366" %)6820
286 +(% style="color: rgb(0,51,102);" %)6820
286 286  )))|(((
287 -(% style="color:#003366" %)6130
288 +(% style="color: rgb(0,51,102);" %)6130
288 288  )))|(((
289 -(% style="color:#003366" %)United States
290 +(% style="color: rgb(0,51,102);" %)United States
290 290  )))|(((
291 -
292 +\\
292 292  )))|(((
293 -
294 +\\
294 294  )))|(((
295 -
296 +\\
296 296  )))|(((
297 -(% style="color:#003366" %)N
298 +(% style="color: rgb(0,51,102);" %)N
298 298  )))|(((
299 -
300 +\\
300 300  )))|(((
301 -
302 +\\
302 302  )))|(((
303 -
304 +\\
304 304  )))|(((
305 -(% style="color:#003366" %)20141211230144
306 +(% style="color: rgb(0,51,102);" %)20141211230144
306 306  )))|(((
307 -
308 +\\
308 308  )))
309 309  |(((
310 -(% style="color:#003366" %)**14010001862**
311 +(% style="color: rgb(0,51,102);" %)**14010001862**
311 311  )))|(((
312 -
313 +\\
313 313  )))|(((
314 -
315 +\\
315 315  )))|(((
316 -
317 +\\
317 317  )))|(((
318 -
319 +\\
319 319  )))|(((
320 -
321 +\\
321 321  )))|(((
322 -(% style="color:#003366" %)Orchard Tree Care Llc
323 +(% style="color: rgb(0,51,102);" %)Orchard Tree Care Llc
323 323  )))|(((
324 -
325 +\\
325 325  )))|(((
326 -(% style="color:#003366" %)184 Ave
327 +(% style="color: rgb(0,51,102);" %)184 Ave
327 327  )))|(((
328 -
329 +\\
329 329  )))|(((
330 -(% style="color:#003366" %)Darien
331 +(% style="color: rgb(0,51,102);" %)Darien
331 331  )))|(((
332 -(% style="color:#003366" %)CT
333 +(% style="color: rgb(0,51,102);" %)CT
333 333  )))|(((
334 -(% style="color:#003366" %)6820
335 +(% style="color: rgb(0,51,102);" %)6820
335 335  )))|(((
336 -
337 +\\
337 337  )))|(((
338 -(% style="color:#003366" %)United States
339 +(% style="color: rgb(0,51,102);" %)United States
339 339  )))|(((
340 -(% style="color:#003366" %)2036550618
341 +(% style="color: rgb(0,51,102);" %)2036550618
341 341  )))|(((
342 -
343 +\\
343 343  )))|(((
344 -
345 +\\
345 345  )))|(((
346 -(% style="color:#003366" %)N
347 +(% style="color: rgb(0,51,102);" %)N
347 347  )))|(((
348 -
349 +\\
349 349  )))|(((
350 -
351 +\\
351 351  )))|(((
352 -
353 +\\
353 353  )))|(((
354 -(% style="color:#003366" %)20150211133156
355 +(% style="color: rgb(0,51,102);" %)20150211133156
355 355  )))|(((
356 -
357 +\\
357 357  )))
358 358  |(((
359 -(% style="color:#003366" %)**14010001870**
360 +(% style="color: rgb(0,51,102);" %)**14010001870**
360 360  )))|(((
361 -(% style="color:#003366" %)Avis Z
362 +(% style="color: rgb(0,51,102);" %)Avis Z
362 362  )))|(((
363 -(% style="color:#003366" %)Gray
364 +(% style="color: rgb(0,51,102);" %)Gray
364 364  )))|(((
365 -
366 +\\
366 366  )))|(((
367 -
368 +\\
368 368  )))|(((
369 -
370 +\\
370 370  )))|(((
371 -(% style="color:#003366" %)Designers 5 Incorporated
372 +(% style="color: rgb(0,51,102);" %)Designers 5 Incorporated
372 372  )))|(((
373 -(% style="color:#003366" %)President
374 +(% style="color: rgb(0,51,102);" %)President
374 374  )))|(((
375 -(% style="color:#003366" %)96 5 Mile River Rd
376 +(% style="color: rgb(0,51,102);" %)96 5 Mile River Rd
376 376  )))|(((
377 -
378 +\\
378 378  )))|(((
379 -(% style="color:#003366" %)Darien
380 +(% style="color: rgb(0,51,102);" %)Darien
380 380  )))|(((
381 -(% style="color:#003366" %)CT
382 +(% style="color: rgb(0,51,102);" %)CT
382 382  )))|(((
383 -(% style="color:#003366" %)6820
384 +(% style="color: rgb(0,51,102);" %)6820
384 384  )))|(((
385 -(% style="color:#003366" %)6234
386 +(% style="color: rgb(0,51,102);" %)6234
386 386  )))|(((
387 -(% style="color:#003366" %)United States
388 +(% style="color: rgb(0,51,102);" %)United States
388 388  )))|(((
389 -(% style="color:#003366" %)2036552033
390 +(% style="color: rgb(0,51,102);" %)2036552033
390 390  )))|(((
391 -
392 +\\
392 392  )))|(((
393 -
394 +\\
394 394  )))|(((
395 -(% style="color:#003366" %)N
396 +(% style="color: rgb(0,51,102);" %)N
396 396  )))|(((
397 -
398 +\\
398 398  )))|(((
399 -
400 +\\
400 400  )))|(((
401 -
402 +\\
402 402  )))|(((
403 -(% style="color:#003366" %)20150212210227
404 +(% style="color: rgb(0,51,102);" %)20150212210227
404 404  )))|(((
405 -
406 +\\
406 406  )))
407 407  |(((
408 -(% style="color:#003366" %)**14010001889**
409 +(% style="color: rgb(0,51,102);" %)**14010001889**
409 409  )))|(((
410 -(% style="color:#003366" %)John
411 +(% style="color: rgb(0,51,102);" %)John
411 411  )))|(((
412 -(% style="color:#003366" %)Hertz
413 +(% style="color: rgb(0,51,102);" %)Hertz
413 413  )))|(((
414 -
415 +\\
415 415  )))|(((
416 -
417 +\\
417 417  )))|(((
418 -
419 +\\
419 419  )))|(((
420 -(% style="color:#003366" %)Hertz Construction Co
421 +(% style="color: rgb(0,51,102);" %)Hertz Construction Co
421 421  )))|(((
422 -(% style="color:#003366" %)Partner
423 +(% style="color: rgb(0,51,102);" %)Partner
423 423  )))|(((
424 -(% style="color:#003366" %)12 Hillside Ave
425 +(% style="color: rgb(0,51,102);" %)12 Hillside Ave
425 425  )))|(((
426 -
427 +\\
427 427  )))|(((
428 -(% style="color:#003366" %)Darien
429 +(% style="color: rgb(0,51,102);" %)Darien
429 429  )))|(((
430 -(% style="color:#003366" %)CT
431 +(% style="color: rgb(0,51,102);" %)CT
431 431  )))|(((
432 -(% style="color:#003366" %)6820
433 +(% style="color: rgb(0,51,102);" %)6820
433 433  )))|(((
434 -(% style="color:#003366" %)5010
435 +(% style="color: rgb(0,51,102);" %)5010
435 435  )))|(((
436 -(% style="color:#003366" %)United States
437 +(% style="color: rgb(0,51,102);" %)United States
437 437  )))|(((
438 -(% style="color:#003366" %)2036564900
439 +(% style="color: rgb(0,51,102);" %)2036564900
439 439  )))|(((
440 -
441 +\\
441 441  )))|(((
442 -
443 +\\
443 443  )))|(((
444 -(% style="color:#003366" %)N
445 +(% style="color: rgb(0,51,102);" %)N
445 445  )))|(((
446 -
447 +\\
447 447  )))|(((
448 -
449 +\\
449 449  )))|(((
450 -
451 +\\
451 451  )))|(((
452 -(% style="color:#003366" %)20141121163018
453 +(% style="color: rgb(0,51,102);" %)20141121163018
453 453  )))|(((
454 -
455 +\\
455 455  )))
456 456  |(((
457 -(% style="color:#003366" %)**14010001891**
458 +(% style="color: rgb(0,51,102);" %)**14010001891**
458 458  )))|(((
459 -
460 +\\
460 460  )))|(((
461 -
462 +\\
462 462  )))|(((
463 -
464 +\\
464 464  )))|(((
465 -
466 +\\
466 466  )))|(((
467 -
468 +\\
468 468  )))|(((
469 -(% style="color:#003366" %)Niche Home Furnishings Ll
470 +(% style="color: rgb(0,51,102);" %)Niche Home Furnishings Ll
470 470  )))|(((
471 -
472 +\\
472 472  )))|(((
473 -(% style="color:#003366" %)25 Old Kings Hwy N Ste 17
474 +(% style="color: rgb(0,51,102);" %)25 Old Kings Hwy N Ste 17
474 474  )))|(((
475 -
476 +\\
476 476  )))|(((
477 -(% style="color:#003366" %)Darien
478 +(% style="color: rgb(0,51,102);" %)Darien
478 478  )))|(((
479 -(% style="color:#003366" %)CT
480 +(% style="color: rgb(0,51,102);" %)CT
480 480  )))|(((
481 -(% style="color:#003366" %)6820
482 +(% style="color: rgb(0,51,102);" %)6820
482 482  )))|(((
483 -(% style="color:#003366" %)4608
484 +(% style="color: rgb(0,51,102);" %)4608
484 484  )))|(((
485 -(% style="color:#003366" %)United States
486 +(% style="color: rgb(0,51,102);" %)United States
486 486  )))|(((
487 -(% style="color:#003366" %)2036566674
488 +(% style="color: rgb(0,51,102);" %)2036566674
488 488  )))|(((
489 -
490 +\\
490 490  )))|(((
491 -
492 +\\
492 492  )))|(((
493 -(% style="color:#003366" %)N
494 +(% style="color: rgb(0,51,102);" %)N
494 494  )))|(((
495 -
496 +\\
496 496  )))|(((
497 -
498 +\\
498 498  )))|(((
499 -
500 +\\
500 500  )))|(((
501 -(% style="color:#003366" %)20141121163018
502 +(% style="color: rgb(0,51,102);" %)20141121163018
502 502  )))|(((
503 -
504 +\\
504 504  )))
505 505  |(((
506 -(% style="color:#003366" %)**14010001901**
507 +(% style="color: rgb(0,51,102);" %)**14010001901**
507 507  )))|(((
508 -(% style="color:#003366" %)Wendy
509 +(% style="color: rgb(0,51,102);" %)Wendy
509 509  )))|(((
510 -(% style="color:#003366" %)Cole
511 +(% style="color: rgb(0,51,102);" %)Cole
511 511  )))|(((
512 -
513 +\\
513 513  )))|(((
514 -(% style="color:#003366" %)Ms.
515 +(% style="color: rgb(0,51,102);" %)Ms.
515 515  )))|(((
516 -
517 +\\
517 517  )))|(((
518 -(% style="color:#003366" %)Wendy C Cole Interiors
519 +(% style="color: rgb(0,51,102);" %)Wendy C Cole Interiors
519 519  )))|(((
520 -(% style="color:#003366" %)Principal
521 +(% style="color: rgb(0,51,102);" %)Principal
521 521  )))|(((
522 -(% style="color:#003366" %)3 Outlook Dr
523 +(% style="color: rgb(0,51,102);" %)3 Outlook Dr
523 523  )))|(((
524 -
525 +\\
525 525  )))|(((
526 -(% style="color:#003366" %)Darien
527 +(% style="color: rgb(0,51,102);" %)Darien
527 527  )))|(((
528 -(% style="color:#003366" %)CT
529 +(% style="color: rgb(0,51,102);" %)CT
529 529  )))|(((
530 -(% style="color:#003366" %)6820
531 +(% style="color: rgb(0,51,102);" %)6820
531 531  )))|(((
532 -(% style="color:#003366" %)5616
533 +(% style="color: rgb(0,51,102);" %)5616
533 533  )))|(((
534 -(% style="color:#003366" %)United States
535 +(% style="color: rgb(0,51,102);" %)United States
535 535  )))|(((
536 -(% style="color:#003366" %)2036552954
537 +(% style="color: rgb(0,51,102);" %)2036552954
537 537  )))|(((
538 -
539 +\\
539 539  )))|(((
540 -
541 +\\
541 541  )))|(((
542 -(% style="color:#003366" %)N
543 +(% style="color: rgb(0,51,102);" %)N
543 543  )))|(((
544 -
545 +\\
545 545  )))|(((
546 -
547 +\\
547 547  )))|(((
548 -
549 +\\
549 549  )))|(((
550 -(% style="color:#003366" %)20150212210227
551 +(% style="color: rgb(0,51,102);" %)20150212210227
551 551  )))|(((
552 -
553 +\\
553 553  )))
554 554  |(((
555 -(% style="color:#003366" %)**14010001917**
556 +(% style="color: rgb(0,51,102);" %)**14010001917**
556 556  )))|(((
557 -(% style="color:#003366" %)Frank
558 +(% style="color: rgb(0,51,102);" %)Frank
558 558  )))|(((
559 -(% style="color:#003366" %)Stone
560 +(% style="color: rgb(0,51,102);" %)Stone
560 560  )))|(((
561 -
562 +\\
562 562  )))|(((
563 -
564 +\\
564 564  )))|(((
565 -
566 +\\
566 566  )))|(((
567 -(% style="color:#003366" %)Stones Landscape
568 +(% style="color: rgb(0,51,102);" %)Stones Landscape
568 568  )))|(((
569 -(% style="color:#003366" %)Owner
570 +(% style="color: rgb(0,51,102);" %)Owner
570 570  )))|(((
571 -(% style="color:#003366" %)258 West Ave
572 +(% style="color: rgb(0,51,102);" %)258 West Ave
572 572  )))|(((
573 -
574 +\\
574 574  )))|(((
575 -(% style="color:#003366" %)Darien
576 +(% style="color: rgb(0,51,102);" %)Darien
576 576  )))|(((
577 -(% style="color:#003366" %)CT
578 +(% style="color: rgb(0,51,102);" %)CT
578 578  )))|(((
579 -(% style="color:#003366" %)6820
580 +(% style="color: rgb(0,51,102);" %)6820
580 580  )))|(((
581 -(% style="color:#003366" %)4111
582 +(% style="color: rgb(0,51,102);" %)4111
582 582  )))|(((
583 -(% style="color:#003366" %)United States
584 +(% style="color: rgb(0,51,102);" %)United States
584 584  )))|(((
585 -(% style="color:#003366" %)2036569674
586 +(% style="color: rgb(0,51,102);" %)2036569674
586 586  )))|(((
587 -
588 +\\
588 588  )))|(((
589 -
590 +\\
590 590  )))|(((
591 -(% style="color:#003366" %)N
592 +(% style="color: rgb(0,51,102);" %)N
592 592  )))|(((
593 -
594 +\\
594 594  )))|(((
595 -
596 +\\
596 596  )))|(((
597 -
598 +\\
598 598  )))|(((
599 -(% style="color:#003366" %)20150212210227
600 +(% style="color: rgb(0,51,102);" %)20150212210227
600 600  )))|(((
601 -
602 +\\
602 602  )))
603 603  |(((
604 -(% style="color:#003366" %)**14010002429**
605 +(% style="color: rgb(0,51,102);" %)**14010002429**
605 605  )))|(((
606 -(% style="color:#003366" %)Bruce
607 +(% style="color: rgb(0,51,102);" %)Bruce
607 607  )))|(((
608 -(% style="color:#003366" %)Pomerance
609 +(% style="color: rgb(0,51,102);" %)Pomerance
609 609  )))|(((
610 -
611 +\\
611 611  )))|(((
612 -(% style="color:#003366" %)Mr.
613 +(% style="color: rgb(0,51,102);" %)Mr.
613 613  )))|(((
614 -
615 +\\
615 615  )))|(((
616 -(% style="color:#003366" %)P L V Inc
617 +(% style="color: rgb(0,51,102);" %)P L V Inc
617 617  )))|(((
618 -(% style="color:#003366" %)President
619 +(% style="color: rgb(0,51,102);" %)President
619 619  )))|(((
620 -(% style="color:#003366" %)1076 Post Rd
621 +(% style="color: rgb(0,51,102);" %)1076 Post Rd
621 621  )))|(((
622 -
623 +\\
623 623  )))|(((
624 -(% style="color:#003366" %)Darien
625 +(% style="color: rgb(0,51,102);" %)Darien
625 625  )))|(((
626 -(% style="color:#003366" %)CT
627 +(% style="color: rgb(0,51,102);" %)CT
627 627  )))|(((
628 -(% style="color:#003366" %)6820
629 +(% style="color: rgb(0,51,102);" %)6820
629 629  )))|(((
630 -(% style="color:#003366" %)5414
631 +(% style="color: rgb(0,51,102);" %)5414
631 631  )))|(((
632 -(% style="color:#003366" %)United States
633 +(% style="color: rgb(0,51,102);" %)United States
633 633  )))|(((
634 -(% style="color:#003366" %)2036554668
635 +(% style="color: rgb(0,51,102);" %)2036554668
635 635  )))|(((
636 -
637 +\\
637 637  )))|(((
638 -
639 +\\
639 639  )))|(((
640 -(% style="color:#003366" %)N
641 +(% style="color: rgb(0,51,102);" %)N
641 641  )))|(((
642 -
643 +\\
643 643  )))|(((
644 -
645 +\\
645 645  )))|(((
646 -
647 +\\
647 647  )))|(((
648 -(% style="color:#003366" %)20150212210227
649 +(% style="color: rgb(0,51,102);" %)20150212210227
649 649  )))|(((
650 -
651 +\\
651 651  )))
652 652  |(((
653 -(% style="color:#003366" %)**14010002438**
654 +(% style="color: rgb(0,51,102);" %)**14010002438**
654 654  )))|(((
655 -(% style="color:#003366" %)Joanne
656 +(% style="color: rgb(0,51,102);" %)Joanne
656 656  )))|(((
657 -(% style="color:#003366" %)Salvatore
658 +(% style="color: rgb(0,51,102);" %)Salvatore
658 658  )))|(((
659 -
660 +\\
660 660  )))|(((
661 -
662 +\\
662 662  )))|(((
663 -
664 +\\
664 664  )))|(((
665 -(% style="color:#003366" %)Nassau Interests Llc
666 +(% style="color: rgb(0,51,102);" %)Nassau Interests Llc
666 666  )))|(((
667 -(% style="color:#003366" %)Member
668 +(% style="color: rgb(0,51,102);" %)Member
668 668  )))|(((
669 -(% style="color:#003366" %)42 N Meadows Ln
670 +(% style="color: rgb(0,51,102);" %)42 N Meadows Ln
670 670  )))|(((
671 -
672 +\\
672 672  )))|(((
673 -(% style="color:#003366" %)Stamford
674 +(% style="color: rgb(0,51,102);" %)Stamford
674 674  )))|(((
675 -(% style="color:#003366" %)CT
676 +(% style="color: rgb(0,51,102);" %)CT
676 676  )))|(((
677 -(% style="color:#003366" %)6903
678 +(% style="color: rgb(0,51,102);" %)6903
678 678  )))|(((
679 -(% style="color:#003366" %)5151
680 +(% style="color: rgb(0,51,102);" %)5151
680 680  )))|(((
681 -(% style="color:#003366" %)United States
682 +(% style="color: rgb(0,51,102);" %)United States
682 682  )))|(((
683 -(% style="color:#003366" %)2036550303
684 +(% style="color: rgb(0,51,102);" %)2036550303
684 684  )))|(((
685 -
686 +\\
686 686  )))|(((
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);"]]
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"]]
688 688  )))|(((
689 -(% style="color:#003366" %)Y
690 +(% style="color: rgb(0,51,102);" %)Y
690 690  )))|(((
691 -
692 +\\
692 692  )))|(((
693 -
694 +\\
694 694  )))|(((
695 -
696 +\\
696 696  )))|(((
697 -(% style="color:#003366" %)20141212210537
698 +(% style="color: rgb(0,51,102);" %)20141212210537
698 698  )))|(((
699 -
700 +\\
700 700  )))
701 701  
702 702  NOTE: Dates need to be in YYYY-mm-dd format
... ... @@ -713,7 +713,7 @@
713 713  
714 714  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.
715 715  
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.
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.
717 717  
718 718  This will create the following work-flow:
719 719  
... ... @@ -750,6 +750,8 @@
750 750  User exists in both systems, update record with incoming data
751 751  )))
752 752  
754 +\\
755 +
753 753  === Transaction Data Sample: ===
754 754  
755 755  (% class="wrapped" %)
... ... @@ -787,9 +787,9 @@
787 787  )))|(((
788 788  15
789 789  )))|(((
790 -
793 +\\
791 791  )))|(((
792 -
795 +\\
793 793  )))
794 794  |(((
795 795  **14010114326**
... ... @@ -806,9 +806,9 @@
806 806  )))|(((
807 807  24.95
808 808  )))|(((
809 -
812 +\\
810 810  )))|(((
811 -
814 +\\
812 812  )))
813 813  |(((
814 814  **14010114326**
... ... @@ -825,9 +825,9 @@
825 825  )))|(((
826 826  13
827 827  )))|(((
828 -
831 +\\
829 829  )))|(((
830 -
833 +\\
831 831  )))
832 832  |(((
833 833  **14010116098**
... ... @@ -842,11 +842,11 @@
842 842  )))|(((
843 843  1
844 844  )))|(((
845 -
848 +\\
846 846  )))|(((
847 -
850 +\\
848 848  )))|(((
849 -
852 +\\
850 850  )))
851 851  
852 852  Transaction type must be one of the following values:
... ... @@ -861,204 +861,12 @@
861 861  
862 862  Status Code: This for subscriber status changes (Current Subscriber, Expired, Pended Add, etc.)
863 863  
864 -=== Fulfillment Sample: Advantage/Omeda/PCS/CDS ===
867 +\\
865 865  
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 -
1054 1054  === Engagement Data ===
1055 1055  
1056 1056  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.
1057 1057  
1058 -
1059 -**NOTE**: For e-mail engagement activity date, message id, recipient id, activity type, email click url 
1060 -
1061 -
1062 1062  Here are a couple of examples:
1063 1063  
1064 1064  ==== **E-Mail Engagement (combined, from Eloqua)** ====
... ... @@ -1094,96 +1094,99 @@
1094 1094  **VisitorId**
1095 1095  )))
1096 1096  |(((
1097 -
908 +\\
1098 1098  )))|(((
1099 -
910 +\\
1100 1100  )))|(((
1101 -
912 +\\
1102 1102  )))|(((
1103 -
914 +\\
1104 1104  )))|(((
1105 -
916 +\\
1106 1106  )))|(((
1107 -
918 +\\
1108 1108  )))|(((
1109 -
920 +\\
1110 1110  )))|(((
1111 -
922 +\\
1112 1112  )))|(((
1113 -
924 +\\
1114 1114  )))|(((
1115 -
926 +\\
1116 1116  )))|(((
1117 -
928 +\\
1118 1118  )))|(((
1119 -
930 +\\
1120 1120  )))|(((
1121 -
932 +\\
1122 1122  )))|(((
1123 -
934 +\\
1124 1124  )))
1125 1125  |(((
1126 -
937 +**
938 +**
1127 1127  )))|(((
1128 -
940 +\\
1129 1129  )))|(((
1130 -
942 +\\
1131 1131  )))|(((
1132 -
944 +\\
1133 1133  )))|(((
1134 -
946 +\\
1135 1135  )))|(((
1136 -
948 +\\
1137 1137  )))|(((
1138 -
950 +\\
1139 1139  )))|(((
1140 -
952 +\\
1141 1141  )))|(((
1142 -
954 +\\
1143 1143  )))|(((
1144 -
956 +\\
1145 1145  )))|(((
1146 -
958 +\\
1147 1147  )))|(((
1148 -
960 +\\
1149 1149  )))|(((
1150 -
962 +\\
1151 1151  )))|(((
1152 -
964 +\\
1153 1153  )))
1154 1154  |(((
1155 -
967 +**
968 +**
1156 1156  )))|(((
1157 -
970 +\\
1158 1158  )))|(((
1159 -
972 +\\
1160 1160  )))|(((
1161 -
974 +\\
1162 1162  )))|(((
1163 -
976 +\\
1164 1164  )))|(((
1165 -
978 +\\
1166 1166  )))|(((
1167 -
980 +\\
1168 1168  )))|(((
1169 -
982 +\\
1170 1170  )))|(((
1171 -
984 +\\
1172 1172  )))|(((
1173 -
986 +\\
1174 1174  )))|(((
1175 -
988 +\\
1176 1176  )))|(((
1177 -
990 +\\
1178 1178  )))|(((
1179 -
992 +\\
1180 1180  )))|(((
1181 -
994 +\\
1182 1182  )))
1183 1183  
1184 1184  **ContactID is an Eloqua-specific ID **
1185 1185  
1186 -**VisitorID is a custom field in the e-mail system containing the user's GUID from the customer's internal data lake**
999 +**VisitorID is a custom field in the e-mail system containing the user's GUID from the customer's internal data lake
1000 +**
1187 1187  
1188 1188  ==== **E-mail Engagement (Split Files)** ====
1189 1189  
... ... @@ -1218,31 +1218,31 @@
1218 1218  **clicked**
1219 1219  )))
1220 1220  |(((
1221 -
1035 +\\
1222 1222  )))|(((
1223 -
1037 +\\
1224 1224  )))|(((
1225 -
1039 +\\
1226 1226  )))|(((
1227 -
1041 +\\
1228 1228  )))|(((
1229 -
1043 +\\
1230 1230  )))|(((
1231 -
1045 +\\
1232 1232  )))|(((
1233 -
1047 +\\
1234 1234  )))|(((
1235 -
1049 +\\
1236 1236  )))|(((
1237 -
1051 +\\
1238 1238  )))|(((
1239 -
1053 +\\
1240 1240  )))|(((
1241 -
1055 +\\
1242 1242  )))|(((
1243 -
1057 +\\
1244 1244  )))|(((
1245 -
1059 +\\
1246 1246  )))
1247 1247  
1248 1248  **email-opens.csv**
... ... @@ -1266,21 +1266,21 @@
1266 1266  **OCID**
1267 1267  )))
1268 1268  |(((
1269 -
1083 +\\
1270 1270  )))|(((
1271 -
1085 +\\
1272 1272  )))|(((
1273 -
1087 +\\
1274 1274  )))|(((
1275 -
1089 +\\
1276 1276  )))|(((
1277 -
1091 +\\
1278 1278  )))|(((
1279 -
1093 +\\
1280 1280  )))|(((
1281 -
1095 +\\
1282 1282  )))|(((
1283 -
1097 +\\
1284 1284  )))
1285 1285  
1286 1286  **email-sends.csv**
... ... @@ -1304,27 +1304,27 @@
1304 1304  **OCID**
1305 1305  )))
1306 1306  |(((
1307 -
1121 +\\
1308 1308  )))|(((
1309 -
1123 +\\
1310 1310  )))|(((
1311 -
1125 +\\
1312 1312  )))|(((
1313 -
1127 +\\
1314 1314  )))|(((
1315 -
1129 +\\
1316 1316  )))|(((
1317 -
1131 +\\
1318 1318  )))|(((
1319 -
1133 +\\
1320 1320  )))|(((
1321 -
1135 +\\
1322 1322  )))
1323 1323  
1138 +\\
1324 1324  
1325 -==== LiveIntent Data Sample: ====
1140 +=== LiveIntent Data Sample: ===
1326 1326  
1327 -(% class="wrapped" %)
1328 1328  |(((
1329 1329  **Liveintentuserid**
1330 1330  )))|(((
... ... @@ -1488,6 +1488,7 @@
1488 1488  2021-03-10
1489 1489  )))
1490 1490  
1305 +\\
1491 1491  
1492 1492  ==== **BrightCove Data Sample:** ====
1493 1493  
... ... @@ -1546,11 +1546,11 @@
1546 1546  )))|(((
1547 1547  2021-02-11
1548 1548  )))|(((
1549 -
1364 +\\
1550 1550  )))|(((
1551 -
1366 +\\
1552 1552  )))|(((
1553 -
1368 +\\
1554 1554  )))|(((
1555 1555  5982181673007
1556 1556  )))|(((
... ... @@ -1579,11 +1579,11 @@
1579 1579  )))|(((
1580 1580  2021-01-25
1581 1581  )))|(((
1582 -
1397 +\\
1583 1583  )))|(((
1584 -
1399 +\\
1585 1585  )))|(((
1586 -
1401 +\\
1587 1587  )))|(((
1588 1588  6171615690004
1589 1589  )))|(((
... ... @@ -1612,11 +1612,11 @@
1612 1612  )))|(((
1613 1613  2021-01-29
1614 1614  )))|(((
1615 -
1430 +\\
1616 1616  )))|(((
1617 -
1432 +\\
1618 1618  )))|(((
1619 -
1434 +\\
1620 1620  )))|(((
1621 1621  6171615690003
1622 1622  )))|(((
... ... @@ -1645,11 +1645,11 @@
1645 1645  )))|(((
1646 1646  2021-02-12
1647 1647  )))|(((
1648 -
1463 +\\
1649 1649  )))|(((
1650 -
1465 +\\
1651 1651  )))|(((
1652 -
1467 +\\
1653 1653  )))|(((
1654 1654  6171632240005
1655 1655  )))|(((
... ... @@ -1759,6 +1759,7 @@
1759 1759  
1760 1760  **ContactID is a GUID assigned by the Customer's Internal Data Warehouse**
1761 1761  
1577 +\\
1762 1762  
1763 1763  ==== **Raw Web Impressions** ====
1764 1764  
... ... @@ -1785,7 +1785,7 @@
1785 1785  )))|(((
1786 1786  mobile
1787 1787  )))|(((
1788 -
1604 +\\
1789 1789  )))|(((
1790 1790  2407411196308715909161529690620210309
1791 1791  )))|(((
... ... @@ -1800,7 +1800,7 @@
1800 1800  )))|(((
1801 1801  tablet
1802 1802  )))|(((
1803 -
1619 +\\
1804 1804  )))|(((
1805 1805  2419995085411609985161503823320210306
1806 1806  )))|(((
... ... @@ -1815,7 +1815,7 @@
1815 1815  )))|(((
1816 1816  tablet
1817 1817  )))|(((
1818 -
1634 +\\
1819 1819  )))|(((
1820 1820  3663669472315156695161403488520210222
1821 1821  )))|(((
... ... @@ -1830,7 +1830,7 @@
1830 1830  )))|(((
1831 1831  mobile
1832 1832  )))|(((
1833 -
1649 +\\
1834 1834  )))|(((
1835 1835  2407411196308715909161529690620210309
1836 1836  )))|(((
... ... @@ -1845,7 +1845,7 @@
1845 1845  )))|(((
1846 1846  mobile
1847 1847  )))|(((
1848 -
1664 +\\
1849 1849  )))|(((
1850 1850  8233752448896666794161427278020210225
1851 1851  )))|(((
... ... @@ -1860,9 +1860,9 @@
1860 1860  )))|(((
1861 1861  desktop
1862 1862  )))|(((
1863 -
1679 +\\
1864 1864  )))|(((
1865 -
1681 +\\
1866 1866  )))|(((
1867 1867  __www.CUSTOMER.com__
1868 1868  )))|(((
... ... @@ -1870,470 +1870,3 @@
1870 1870  )))
1871 1871  
1872 1872  **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,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -5.5 KB
Content
... ... @@ -1,23 +1,0 @@
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 -77496432
1 +77496440
url
... ... @@ -1,1 +1,1 @@
1 -https://info.onecount.net//wiki/spaces/OD/pages/77496432/DExTr Import Files
1 +https://info.onecount.net//wiki/spaces/OD/pages/77496440/DExTr Import Files