Where is saved the custom code of a form?

Epicor ERP 10
,
1

Hello all,

We changed our e-mail server and I need to change it in all our applications where it is used. We mostly use it to send email in case of errors in the applications.
I went through all our .net apps. But now I am into changing in our customizations in Epicor.
Hell I do not remember everywhere I added emailing into them…

I was wandering if there is a easy way to find out ? Where are the customization xml code sitting? If it is in a table field somewhere ? Where I could just look for the ‘smtp’ word in a field? then which table and field ?

or it is files on the server ? then what location I could search the directory ?

That would same me a lot of time instead of opening every customization in debug mode to look…

Thanks for your input.

Pierre

2

Pierre, these values sit in the XXXDef table. This query should get you started. Key1 will be the customization name and Key2 will be the form that the customization is attached to.

SELECT XXXDef.Key1, XXXDef.Key2, XXXDef.Content FROM Ice.XXXDef WHERE TypeCode = 'Customization' AND Content LIKE '%smtp%';

4 Likes
3

Ross has taken care of you but imagine if all of your customizations were in an external source code repository that is easily searched. If you like that idea, vote for this one. :wink:

2 Likes
4

Are you planning just to find it, or automate the fix?

If automating, it’ll be a little more complex.

5

Thank you Ross, that is exactly what I needed. Did the trick.

Kevin… nope I will open them and make the change manually. (about 10 forms…only )
BUT
When we will get used to functions and transform our customizations to a kinetic web compatible layer…the needed change will only be at one place!

Thank you all…

And yes I will vote for that one too Mark!

Pierre

3 Likes
6

I was coming back here to point that out, but seems like you are on the ball :slight_smile: