AC standard - Custom Resources publication

Avatar

Avatar

eveline8

Avatar

eveline8

eveline8

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

Vapsy

Employee

Avatar

Vapsy

Employee

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

eveline8

Avatar

eveline8

eveline8

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