Wiki source code of Pre-Import Checklist

Last modified by steven@one-count_com on 2018/07/10 16:42
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 (% style="margin-left: 60.0px;" %)
67 [[Preparing for Data Import>>doc:Getting Started - Preparing for Data Import]]
68
69 (% style="margin-left: 60.0px;" %)
70
71
72 (% style="margin-left: 60.0px;" %)
73 [[How to Import a File>>doc:Import - How to Import a File]]
74
75 (% style="margin-left: 60.0px;" %)
76 [[How to Create an Import Mapping Template>>doc:Import - How to Create an Import Mapping Template]]
77
78 (% style="margin-left: 60.0px;" %)
79 [[How to Use an Import Mapping Template>>doc:Import - How to Use an Import Mapping Template]]
80
81 (% style="margin-left: 60.0px;" %)
82 [[Add Audience>>doc:Add Audience]]
83
84 (% style="margin-left: 30.0px;" %)
85 **Batch Operations**
86
87 (% style="margin-left: 60.0px;" %)
88 [[Bulk Operation - How to Perform a Batch Delete>>doc:Bulk Operation - How to Perform a Batch Delete]]
89
90 (% style="margin-left: 60.0px;" %)
91 [[Bulk Operation - How to Perform a Batch Product Change>>doc:Bulk Operation - How to Perform a Batch Product Change]]
92
93 (% style="margin-left: 60.0px;" %)
94 [[Bulk Operation - How to Perform a Batch Status Change>>doc:Bulk Operation - How to Perform a Batch Status Change]]
95
96 (% style="margin-left: 60.0px;" %)
97 [[Bulk Operation - How to Perform a Batch Suscribe>>doc:Bulk Operation - How to Perform a Batch Subscribe]]
98
99 (% style="margin-left: 60.0px;" %)
100 [[Bulk Operation - How to Perform a Batch Unsubscribe>>doc:Bulk Operation - How to Perform a Batch UnsubscribeKill]]
101
102 (% style="margin-left: 60.0px;" %)
103 [[Bulk Operation - How to Perform a Merge of Duplicate Users>>doc:Bulk Operation - How to Perform a Bulk Merge of Duplicate Users]]
104
105 (% style="margin-left: 30.0px;" %)
106 **Target Audience Segments**
107
108 (% style="margin-left: 60.0px;" %)
109 (% style="color: rgb(0,51,102);" %) [[ Target Engine >>doc:Segment Manager]]__
110 __
111
112
113
114
115 {{/expand}}
116 {{/panel}}
117
118
119
120
121
122
123
124
125 {{/layout-cell}}
126 {{/layout-section}}
127 {{/layout}}