Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Data loading from Postgress

Avatar

Level 1

Hi While loading the data from FDA connector Postgress the fields which are defined as character varying in Postgress are trimmed while loading to Campaign classic.

What could be the reason for this?

 

 

 

 

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @amit_21111 ,

Check what is the character length defined in database for that particular field. 

Consider, for a field if varchar length is 300 in DB, then in Adobe campaign classic Schema definition, define length as 300 for the field.

 

<attribute label="Field 1" name="field1" length="300" type="string"/>

 

If you don't define length in <attribute/> for string type, it will consider default length as 255. So in DB for that string field if the length is 300, in ACC you can see only 255 characters. So we need to defined length="300".

View solution in original post

4 Replies

Avatar

Correct answer by
Community Advisor

Hi @amit_21111 ,

Check what is the character length defined in database for that particular field. 

Consider, for a field if varchar length is 300 in DB, then in Adobe campaign classic Schema definition, define length as 300 for the field.

 

<attribute label="Field 1" name="field1" length="300" type="string"/>

 

If you don't define length in <attribute/> for string type, it will consider default length as 255. So in DB for that string field if the length is 300, in ACC you can see only 255 characters. So we need to defined length="300".

Avatar

Level 1

Hi Partha,

 

As of now we are only viewing the data and the fields while are trimmed are defined with character varying.

 

So we need to define the length?

Avatar

Community Advisor

Yes, character length defined in adobe campaign should be same (or more) as character length in DB. Or else it will get trimmed in ACC view.
Navigate to Data schema > open your schema > open the documentation tab > here you can see the length defined for each string fields.

Cross verify the string length of Adobe campaign classic with string length defined in database.

If string length of DB is greater than length defined in ACC, this is the reason for trim when you view the data in ACC.

Avatar

Community Advisor

Hi @amit_21111 ,

 

Please check the Character lengths for all the fields in the FDA Connector Database and you need to manually define the length attribute for all the Character fields in ACM also.

 

If no length is defined in ACM for any attributes, it takes the default length of 255 Characters, so if any of the attributes is having length > 255 Characters in External database and if it's length is not defined in Adobe Campaign, then the length gets trimmed to 255 Characters.

 

You can cross check the length Values in the Documentation tab of the Schema in ACM to compare easily with External Database.

 

LakshmiPravallika_0-1697796599118.png

 

Regards,

Pravallika.