String length in Adobe campaign classic

[KD1]

Hi @ParthaSarathy 

Need your help for understanding below points in Adobe campaign classic.

1.Can we define a string length greater than 255 characters while creating a schema or configuring during data loading activity?

2.if we are using a predefined filter, incase if there is a change in targeting dimensions will the predefined filter work?

3.What is a delivery variable?

4. In data loading loading activity what is the necessity of sample file and upload a file from the local machine? what error we can encounter if either of it is worng?

[ParthaSarathy · Accepted solution]

Hi @KD1 ,

1) You can define length="<value>" in attribute definition in schema

Example, <attribute name="firstName" length="300" type="string"/>

Yes, you can define length in data loading activity > click here to change the file format

2) You can able to use predefined filters of same targeting dimension only.

3) Refer here to know more about delivery variables

4) To process the uploading file, we need to define the data loading activity by uploading a sample file of same format as original file, and configure all the values - Say is the file is csv or txt file, how the columns are separated, what is the data type of all columns, etc. 

[KD1]

Hi @ParthaSarathy 

Thank you for the explanation.

Regarding point 1- So we can add length greater than 255 as per our necessity correct?

[ParthaSarathy]

Yes, but make sure to update the database structure after modifying length value in schema.