Is it possible to allow Null Values in numeric fields in Camapign? | Community
Skip to main content
srikanthr646926
Level 2
Oct 18, 2017 1:59 PM UTC
Solved

Is it possible to allow Null Values in numeric fields in Camapign?

Just like any other database when adding columns to a huge table we are having issues if number fields is defaulted to zeros, because it is trying to update the existing records. Please let me now how we can enforce the nulls to numeric fields instead of default property. 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
florentlb
florentlbAccepted solution
Level 10
Nov 16, 2017 4:10 PM UTC

Ok,

So it appears that on the database level there is a "NOT NULL" constraint for numeric fields. So in Campaign NULL values are not authorized for numeric fields, hence defaulting to 0 instead.

Florent

View reply

8 replies

LiviaD1
LiviaD1
Level 3
Aug 26, 2019 12:55 PM UTC

Hi florentlb,

are NULL values still not authorized for numeric fields in Campaign (Standard)?

In Load File activity there is "Insert NULL in the corresponding field" option for "Empty value management".

Is this option not applicable to numeric fields? I'm not able to find any information about in online support.

Is there a different way to manage empty values in numeric fields? Or have you any suggestions about?

Thanks,

Livia

Translate
florentlb
florentlbAccepted solution
Level 10
Nov 16, 2017 4:10 PM UTC

Ok,

So it appears that on the database level there is a "NOT NULL" constraint for numeric fields. So in Campaign NULL values are not authorized for numeric fields, hence defaulting to 0 instead.

Florent

Translate
srikanthr646926Author
Level 2
Nov 16, 2017 3:59 PM UTC

Hi florent,

We are having postgres as backend, the default property of the database is zero for any numeric field atleast that is how it was setup in our environemnt , please forget about the import , I am strictly talking about database here. when we add new numeric fields to a large table .. it is trying to update existing records with default value zero So instead we want the database to allow Null value, that way not updates required. It is something to do with either campaign tool which is causing the issue.

Translate
florentlb
florentlb
Level 10
Nov 16, 2017 3:53 PM UTC

Hi,

I'm not sure I understand. Do you want to have NULL or 0 as default when the column is empty during the import?

Have you tried playing with the column format options? For example:

You have a description of how it works here: https://docs.campaign.adobe.com/doc/AC/en/WKF_Repository_of_activities_Action_activities.html#Defining_the_file_format

Hope this helps,

Florent

Translate
ShrawanSaxena-1
ShrawanSaxena-1
Employee
Nov 15, 2017 3:54 AM UTC

HI Srikant,

Do you mean to say when you are adding a field to schema through console number fields is defaulted to zeros which you don't want to happen.

Translate
srikanthr646926Author
Level 2
Nov 14, 2017 4:34 PM UTC

This is in v7 .We want to enforce When adding the field to schema to null value.  While doing import workflow we will insert or update to default value of zero when not coming from source. So my question is how to  avoid defaulting to zero when adding a new numeric field to schema

Translate
florentlb
florentlb
Level 10
Nov 13, 2017 8:21 AM UTC

Hi,

Do you have any update on your issue?

Let me know,

Florent

Translate
florentlb
florentlb
Level 10
Oct 31, 2017 7:47 AM UTC

Hi,

Sorry I missed your question. Are you using Campaign Classic (6 or 7), or Campaign Standard?

At which moment do you want the values of the new column to be set? Is it when adding the column to the table, or later when importing/updating data through a workflow?

Let me know,

Florent

Translate
Terms & ConditionsAccessibility statement

Loading footer...