Developer forum

Forum » Dynamicweb 10 » Unable to remove field value conversions in field definition

Unable to remove field value conversions in field definition

Barend Mosch
Reply

Hi there,

In the PIM on custom product fields you can define a field value conversion for decimal fields. Once selected, I can't select another, also its not possible to fully remove it.

Is this an intended restriction? (see the lock at the right).


Cheers!


Replies

 
Barend Mosch
Reply

Hi there, is there an update on this?

I am no longer seeing the lock on the right, but I am noticing odd behaviour when 'removing' the conversion definitions of the category fields.

See, when reassigning a certain category field value from a defined unit conversion to 'Nothing Selected':

Theres a pop-up saying 'Are you sure'? This works. But the unit conversion list is still visible at the product:

 

Also, the category field in the database still has a preset number on the category field table:

It also still shows the category field in the usage of the Field Value Conversions:


It seems that removing the conversion from the field is not altering the correct column in the database. Can this be looked into?

Kind regards,

Barend Mosch

 
Søren Jensen Dynamicweb Employee
Søren Jensen
Reply

Hi Barend,

The Conversions feature has changed so that it is now based on rules on fields.

This has changed the way information is stored in the database, and we are not removing the old settings stored on the field record.

What version are you running?

/Søren

 
Barend Mosch
Reply

Hi Søren,

The lock is visible on an environment running v10.19.14. The underneath screenshot is defined on a custom price field, which is odd on its own, but now I can't remove it. We can try updating the environment.


The second scenario is running on v10.22.15, I'm seeing the rules there now 

The environment was running on v10.22.14 last week, unsure if this was here on that version. I'll play around with the rules.

Thanks Søren.

 
Søren Jensen Dynamicweb Employee
Søren Jensen
Reply

Hi Barend,

Great idea to upgrade to newer version ..

But if you want to clear the Conversions on field "Price", you can use below sql example within Firehose  ..

update [EcomProductField] set [ProductFieldValueConversionPreset] = null where ProductFieldName = 'Price'

/Søren

 

 

You must be logged in to post in the forum