Developer forum

Forum » Integration » Length of order fields

Length of order fields

Tomas Gomez
Reply

Hi,

We have an issue integrating the order fields from DW to BC. Some DW fields have a length that is too long to be integrated at BC.

What is the best solution to solve this issue? Truncating the fields before sending them to BC? Truncating the fields afterwards at BC? in any case, what woulds be the procedure?

regards,
Tomas


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Tomas,
it is needed to know more details on what is going on to advise you something. Are you using standard fields from BC or totally custom, can you give some examples? Where is that used: Live integration calculate/create orders requests or is it Batch order export or is it Data integraion OdataProvider that is used?
BR, Dmitrij

 
John Cristian Villamar Cueva
Reply

I have the same issue the xml to integrate send a column "OrderDeliveryAddress2", that allows to enter more than 50 characters. That column integrates into the field  "Ship-to Address 2", which is a standard field from table 36 - Sales Header, which is only assigned 50 characters.

This issue causes live integration to return an error due to the length of the data I am trying to insert. And it does not integrate it into Business Central.

I think that if it is a direct DW integration, the BC standard should be respected.

In the image you can see the indicated field

 
Morten Bengtson Dynamicweb Employee
Morten Bengtson
Reply

Truncating the data should be avoided, since you will end up storing incorrect information in BC.
It might be illegal as well, since you are creating an order transaction where user supplied information has been manipulated.

If address information is provided by the user during checkout then you could configure some validation rules with max length in Dynamicweb.
You need to add the validation group to the shopping cart app and ensure that the templates will display validation errors to the user.

 
Tomas Gomez
Reply

Hi Morten,

Thanks for the imformation!

Regards,
Tomas

 
John Cristian Villamar Cueva
Reply

Is there something similar to limit or configure product fields?

 
Tomas Gomez
Reply

Hi Morten,

I configured the address conditions at a validation group but it is not working, probably because we use a custom template. The address data is taken from the user data automatically but is not validated.

What is needed on the template to force the validation conditions?

Regards,
Tomas

 

 

You must be logged in to post in the forum