Data loading from Postgress

[amit_21111]

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?

[ParthaSarathy · Accepted solution]

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".

[amit_21111]

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?

[ParthaSarathy]

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.

[LakshmiPravallika]

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.

Regards,

Pravallika.