You updated a default value on an existing column in a ROI table. When you’re trying to save it, you get an error about NULL values:
This is triggered because existing contacts in your database have no data (or NULL) in the field where you’re attempting to add a default value. Therefore, you cannot overwrite the existing NULL data with a default value.
1. Go to Data tab > Segments > Create New Segment
Add the needed table. Select only the ROI ID (or similar field to use as the deduplication key) and the field you wanted to add the new default value to.
Under Set Criteria, select the Table, the column where you want to add the default value, the operator “Equal To (=)”, and keep Criteria blank. Here's an example:
Save and Export the segment.
2. Open the exported file in Excel.
Add the needed default values in the blank column.(In the example below, the needed default value is “unknown”)
Change the column headers to only the column name. For example, “Contacts.Department” would become “Department”.
Save the file as a CSV.
Example of finished CSV:
3. Go to the Data Tab > Lists > Import Contacts
For Text Qualifier, select Double Quotes (“). Check “First row contains column names”. Choose the CSV file you just modified and import it.
Choose your destination table. Map the two fields to their appropriate destinations. Choose the deduplication key on the ID (or similar) field.
Choose an email. Click save.
4. After you get an email saying the list was successfully uploaded, go back to Data > Tables. Select the table and column you want to add the default value to.
Now add the default value and click save. It will successfully save without giving you the error.
By updating the existing NULL values in the table column to the default value you wanted to add, ROI is not trying to override old information. Instead it will just add the default value to any new records, since all old records are now updated.
Please contact support@rightoninteractive with any questions.