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

Data loading from Postgress

  • October 20, 2023
  • 2 replies
  • 1002 views

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.
Best answer by ParthaSarathy

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

2 replies

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
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
    amit_21111
    amit_21111Author
    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?

    ParthaSarathy
    Community Advisor
    ParthaSarathyCommunity Advisor
    Community Advisor
    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.

     ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
      LakshmiPravallika
      Community Advisor
      LakshmiPravallikaCommunity Advisor
      Community Advisor
      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.

        Terms & ConditionsAccessibility statement

        Loading footer...