Extending Maximum Length of System Metafields on Business Foundat

Extending Maximum Length of System Metafields on Business Foundation Objects

Vote:

Hi,

We're currently on version (8.11) of EPiServer Commerce.

Is there a way to update the Maximum Length of System MetaFields on Business Foundation Objects?

We've got quite a few fields on the Address BF Object such as Organization, Fullname, Firstname, Lastname, etc thare are being truncated at 64 characters.

Cheers,

Damien

#133375

Sep 03, 2015 9:19

Quan Mai

Vote:

Of course you can.

There are two thing you'll need to do:

- Manually adjust the columns (should be in cls_Address table)

- run this code to update the business object definition:

            using (MetaClassManagerEditScope scope = DataContext.Current.MetaModel.BeginEdit(MetaClassManagerEditScope.SystemOwner, AccessLevel.System))
            {
                MetaClassManager manager = DataContext.Current.MetaModel;
                MetaFieldCollection fields = DataContext.Current.MetaModel.MetaClasses[AddressEntity.ClassName].Fields;
                fields["Email"].Attributes[McDataTypeAttribute.StringMaxLength] = <new length>;
                fields["Name"].Attributes[McDataTypeAttribute.StringMaxLength] = <new length>;
//other fields
                scope.SaveChanges();
            }

Just make sure you back up databases and every thing before doing this.

Regards,

#133394

Sep 03, 2015 12:24

Vote:

Quan,

As always, your quick replies are a lifesaver.

Thankyou.

#133415

Sep 03, 2015 23:59

Sushant Chandan

Vote:

@Quan: Thanks for the information. Can you please tell me where to execute the above code to update the business object definition.

I am using the following

Episerver Version

Commerce 10.2.2

Commerce Core 10.2.2

Commerce.UI 10.2.2

Looking forward for your earliest response.

Thanks in advance.

#175823

Mar 03, 2017 8:35

Quan Mai

Vote:

@Sushant: that code should be executed once, so your best place should be in an InitializationModule

#175824

Mar 03, 2017 8:42

Giedrius Tamulevicius

Vote:

I have the same problem

This doesnt seem to work correctly. I seee that metadata is updated, however the actual sql table are not updated, and remains of original length.
At that time this sinchronisattion is supposed to happen?

Maybe I need to force it somehow manualy?

Edit: I'm using Commerce 9.24.1

Regards,

Giedrius

#178708

Edited, May 18, 2017 11:37