Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

What is the "Adobe Campaign Default" during data loading?

Avatar

Avatar
Validate 1
Level 1
noogi1207
Level 1

Like

1 like

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
noogi1207
Level 1

Like

1 like

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
noogi1207
Level 1

22-09-2016

Hi all,

I am using the Adobe Campaign Manager V6.

Currently I am trying to update a data loading process and wanted some clarification.

In a given workflow using the Data Loading Object, the first step is to label the object and load a sample file for formatting. When I click on the "Click here to change the file format..." link, I can change the data type and loading processes for this step. This is great. My questions are in regards to the "Allow NULLs" header - there are 3 options

1. Adobe Campaign default

2. Empty value allowed

3. Always populated

- What is the adobe campaign default in regards to null values?

- If I choose "Empty values allowed", am I allowing values that are NULL and = '' or just one of these cases?

- If the above is just allowing NULL values, does the "Always populated" option consider a value = '' populated?

Thank you!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 5
Level 2
cbvmg
Level 2

Likes

5 likes

Total Posts

10 posts

Correct Reply

3 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Applaud 5
Affirm 3
View profile

Avatar
Boost 5
Level 2
cbvmg
Level 2

Likes

5 likes

Total Posts

10 posts

Correct Reply

3 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Applaud 5
Affirm 3
View profile
cbvmg
Level 2

30-09-2016

Hi Noogi,

Please see my answers to your question, hope it helps.

- What is the adobe campaign default in regards to null values?

Adobe Campaign default would use values that's set up within the data schema, if an attribute is specified as 'not null', it will be used as 'not null' and vice versa.

- If I choose "Empty values allowed", am I allowing values that are NULL and = '' or just one of these cases?

Yes, you are allowing both.

- If the above is just allowing NULL values, does the "Always populated" option consider a value = '' populated?

Always populated means it should contain a value for that field.

As an alternative to this you may also consider formatting the fields within the 'update' object. The advantage of this approach is that you can control the logic a bit more and need not change the settings everytime a new field is added to your file format. But yes, it's done using expression and may not be as intuitive as the wizard during the file format set up .

Have fun !

Thanks,
Madhan

Answers (0)