Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Retain column definitions when updating file structure

Avatar

Avatar
Shape 1
Level 4
eeidbgsu
Level 4

Likes

81 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Shape 1
Shape 10
Boost 50
Boost 5
Boost 3
View profile

Avatar
Shape 1
Level 4
eeidbgsu
Level 4

Likes

81 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Shape 1
Shape 10
Boost 50
Boost 5
Boost 3
View profile
eeidbgsu
Level 4

15-02-2019

When editing the Load File step of a workflow, if you turn on the "Detect structure from a new file" option, then upload a new file, all of the columns on the Column Definition are reset to the Text data type and lengths of 255 characters.

This is inconvenient when the new file structure is similar to the old file structure, perhaps different only in the additional of a couple of columns.  All of the previous changes to data types, lengths, value mappings, etc. have to be recreated.

If Campaign detects that a column in the newly uploaded file has the same name and data type as an existing column definition, then it should not change the data type, length, value mapping, etc.  This will reduce the rework needed when deriving the structure from a new file.

3 Comments

Avatar

Avatar
Validate 1
MVP
bobbyjss
MVP

Likes

77 likes

Total Posts

107 posts

Correct Reply

14 solutions
Top badges earned
Validate 1
Contributor
Shape 1
Give Back 25
Give Back 10
View profile

Avatar
Validate 1
MVP
bobbyjss
MVP

Likes

77 likes

Total Posts

107 posts

Correct Reply

14 solutions
Top badges earned
Validate 1
Contributor
Shape 1
Give Back 25
Give Back 10
View profile
bobbyjss
MVP

15-02-2019

Seconded. We are forever updating the Column definition tab to ensure email addresses go in without spaces and as lowercase. If we could set this as the default in the template and not have to update it each time that would be ideal.

Avatar

Avatar
Establish
Employee
Perrininho
Employee

Likes

0 likes

Total Posts

42 posts

Correct Reply

0 solutions
Top badges earned
Establish
View profile

Avatar
Establish
Employee
Perrininho
Employee

Likes

0 likes

Total Posts

42 posts

Correct Reply

0 solutions
Top badges earned
Establish
View profile
Perrininho
Employee

10-06-2019

This is a good idea. We will add this into our backlog and work on this as soon as we have an opportunity. For the moment, this is not prioritized. (CAMP-34597)

Avatar

Avatar
Validate 500
Employee
Sukrity_Wadhwa
Employee

Likes

133 likes

Total Posts

807 posts

Correct Reply

35 solutions
Top badges earned
Validate 500
Validate 250
Validate 100
Validate 25
Validate 50
View profile

Avatar
Validate 500
Employee
Sukrity_Wadhwa
Employee

Likes

133 likes

Total Posts

807 posts

Correct Reply

35 solutions
Top badges earned
Validate 500
Validate 250
Validate 100
Validate 25
Validate 50
View profile
Sukrity_Wadhwa
Employee

03-02-2021

This is in our backlog and would be updated here once delivered.

Status changed to: Accepted