Skip to main content
To homepage To homepage

Dear All,

 

We have a “Dynamics Business Central (NAV)” data source with multiple adapters (multiple ERPs).

 

We recently needed to “synchronize” the object to get the last BC evolution (new fields, ...). Unfortunately, the “Display name” of some tables/fields changed. 😒

 

Ex:

-“Lot”

“Lot No_ Information” table is now named “Lot No. Information”

 

-“Demand Forecast”

“Production Forecast Entry” table is now named “Demand Forecast Entry”

 

Our default was to use “Display Name” (instead of Database Name) in the data selection and staging deployment.

 

Our main concern is our significant number of sql views associated to these selected tables/fields with “hardcoded” name.

 

We know that is recommended to use parameters to avoid problem with renaming but we didn’t implement the params in this case missing time and practicality with the sql code. 😥

 

Do we have an alternative solution without significant adjustments in our tables/fields selections and associated staging sql custom views ?

 

TXT version: OnPremise 20.10.43.64

 

Thanks for your help.

Hi ​@matthieu.carrat 

Unfortunately I think that the only solution now post-synchronization is to manually rename the fields in the views.

A potential workaround would be to restore the repository database, to before the synchronization took place, and then add field parameters to the views and then synchronize again. Please ensure to backup the existing TimeXtender repository database before making any changes.

Hi ​@Christian Hauggaard 

Thank you for your reply. 

Indeed, we are manually adjusting the views (constraints to add parameters for some views regarding the number of fields.

Have a nice evening.

Reply


Terms and ConditionsCookie settings