Skip to Content

Wiki source code of Pre-Import Checklist

Last modified by Admin User on 2026/05/23 17:40
Show last authors
1 {{layout}}
2 {{layout-section ac:type="two_right_sidebar"}}
3 {{layout-cell}}
4
5
6 {{id name="Start ScreenSteps Content"/}}
7
8 === CHECK IMPORT FILE ===
9
10 ~_~__ Import file saved in comma, quote delimited .csv format
11
12 ~_~__ Remove duplicate records from the file – ONEcount does not identify duplicates within the import file itself.
13
14 ~_~__ Remove empty/blank columns
15
16 ~_~__ No column is labeled "ocid" (use oc_id or ONEcount ID or something similar)
17
18 ~_~__ Leading zeroes are in postal codes and any other fields that require them
19
20 ~_~__ Dates formatted in standardized date format (e.g. mm/dd/yy ) and are not text fields - especially Request/Qualification/Verification and/or Expire Date
21
22 ~_~__ If updating records already in ONEcount, Request/Qualification/Verification dates in the import file are more recent than the most recent transaction date in ONEcount
23
24 ~_~__ All values for select-type, radio button, and checkbox-type questions in the import file match corresponding values in ONEcount
25
26 ~_~__ Multiple responses/values for checkbox-type questions are in one field in your import file, separated by commas with no spaces and enclosed by double quotation marks. For example: "253,254,255"
27
28 ~_~__ If you wish to blank out existing data in the ONEcount database, the request date for the import is more recent than the request date associated with the most recent data in ONEcount and "Null" is inserted into the corresponding fields in the import file.
29
30 === CHECK ONEcount ===
31
32 ~_~__ Questions/data fields and response values for all columns to be imported are present in ONEcount
33
34 ~_~__ Appropriate Source Codes have been created to track each file and identify name and qualification source – a Source Code must be applied at time of import.
35
36 ~_~__ Appropriate Product Statuses have been created – a Product Status must be applied at time of import.
37
38 ~_~__ Product(s) to which users will be "subscribed" has(ve) been created – you must "subscribe" the import file to a product(s).
39
40
41
42 {{id name="End ScreenSteps Content"/}}
43 {{/layout-cell}}
44
45 {{layout-cell}}
46 {{panel title="Search All Documentation:"}}
47
48
49 {{livesearch/}}
50 {{/panel}}
51
52 {{panel title="Search USER OPERATIONS Documentation:"}}
53
54
55 {{pagetreesearch rootPage="User Operations - Managing Your Data"/}}
56 {{/panel}}
57
58 {{panel title="More USER OPERATIONS Documentation"}}
59 {{expand}}
60 **Add Users
61 **
62
63 (% style="margin-left: 60.0px;" %)
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78 (% style="margin-left: 60.0px;" %)
79 [[Preparing for Data Import>>doc:OD.How-To and Cookbooks.Getting Started - Preparing for Data Import]]
80
81 (% style="margin-left: 60.0px;" %)
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96 (% style="margin-left: 60.0px;" %)
97 [[How to Import a File>>doc:OD.Data Import, Export and Mapping.Import - How to Import a File]]
98
99 (% style="margin-left: 60.0px;" %)
100 [[How to Create an Import Mapping Template>>doc:_Archive.Import - How to Create an Import Mapping Template]]
101
102 (% style="margin-left: 60.0px;" %)
103 [[How to Use an Import Mapping Template>>doc:_Archive.Import - How to Use an Import Mapping Template]]
104
105 (% style="margin-left: 60.0px;" %)
106 [[Add Audience>>doc:OD.Data Import, Export and Mapping.Add Audience]]
107
108 (% style="margin-left: 30.0px;" %)
109 **Batch Operations**
110
111 (% style="margin-left: 60.0px;" %)
112 [[Bulk Operation - How to Perform a Batch Delete>>doc:OD.Bulk Operations.Bulk Operation - How to Perform a Batch Delete]]
113
114 (% style="margin-left: 60.0px;" %)
115 [[Bulk Operation - How to Perform a Batch Product Change>>doc:OD.Bulk Operations.Bulk Operation - How to Perform a Batch Product Change]]
116
117 (% style="margin-left: 60.0px;" %)
118 [[Bulk Operation - How to Perform a Batch Status Change>>doc:OD.Bulk Operations.Bulk Operation - How to Perform a Batch Status Change]]
119
120 (% style="margin-left: 60.0px;" %)
121 [[Bulk Operation - How to Perform a Batch Suscribe>>doc:OD.Bulk Operations.Bulk Operation - How to Perform a Batch Subscribe]]
122
123 (% style="margin-left: 60.0px;" %)
124 [[Bulk Operation - How to Perform a Batch Unsubscribe>>doc:OD.Bulk Operations.Bulk Operation - How to Perform a Batch UnsubscribeKill]]
125
126 (% style="margin-left: 60.0px;" %)
127 [[Bulk Operation - How to Perform a Merge of Duplicate Users>>doc:OD.Bulk Operations.Bulk Operation - How to Perform a Bulk Merge of Duplicate Users]]
128
129 (% style="margin-left: 30.0px;" %)
130 **Target Audience Segments**
131
132 (% style="margin-left: 60.0px;" %)
133 (% style="color: rgb(0,51,102);" %) [[ Target Engine >>doc:OD.Segment Manager]]__
134 __
135
136
137
138
139 {{/expand}}
140 {{/panel}}
141
142
143
144
145
146
147
148
149 {{/layout-cell}}
150 {{/layout-section}}
151 {{/layout}}