AC standard - Custom Resources publication

Avatar

Avatar
Boost 25
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct reply

5 solutions
Top badges earned
Boost 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile

Avatar
Boost 25
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct reply

5 solutions
Top badges earned
Boost 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile
eveline8
Level 3

15-02-2018

Hi everybody,

I have a question about publishing custom resources.

I created some custom resources (SKU, SKU2 with format floating number but I never use them as destination for the fields to update.

Now, I have to change the format in text for these custom resources but when I prepare to publish I have an error :

error_CRpublication.png

sqltab.png

My question is: if I proceed with the publication, do I lose only the values of these custom resources or all the values related to the customer profiles?

Thanks,

Eveline

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

15-02-2018

Hi Eveline,

As per the SQL script only the columns SKU1 and SKU2 are being dropped. Since the previous data type for them was floating point number a prefix 'f' was added to the names provided by you. At DB level the column names were fCusSKU and fCusSKU2.

Now since you are converting them to string the prefix will change to s. So old columns will be dropped and new columns will be created.

As you said, you never used the columns SKU and SKU2 for storing data against a profile, it should be fine to let the product drop those old columns.

Regards,
Vipul

Answers (1)

Answers (1)

Avatar

Avatar
Boost 25
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct reply

5 solutions
Top badges earned
Boost 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile

Avatar
Boost 25
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct reply

5 solutions
Top badges earned
Boost 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile
eveline8
Level 3

16-02-2018

Hi Vipul,

thank you! I tried to publish the custom resources with new format and it works like you said.

Thanks!

Eveline