Data loading from Postgress | Community
Skip to main content
amit_21111
amit_21111
New Participant
October 20, 2023
Solved

Data loading from Postgress

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?

 

 

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
ParthaSarathy
ParthaSarathyAccepted solution
New Participant
October 20, 2023

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

 ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
View reply

4 replies

LakshmiPravallika
LakshmiPravallika
New Participant
October 20, 2023

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.

Translate
    ParthaSarathy
    ParthaSarathyAccepted solution
    New Participant
    October 20, 2023

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

    Translate
     ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
      amit_21111
      amit_21111Author
      New Participant
      October 20, 2023

      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?

      Translate
      ParthaSarathy
      ParthaSarathy
      New Participant
      October 20, 2023

      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.

      Translate
       ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
        Terms & ConditionsAccessibility statement

        Loading footer...