Hi Mark,Thank you for the script. This was a solution that I was looking for.I updated the values for the variables:declare @project_id project_id = 'JP_BOUWMANAGEMENT' -- Your project name , @project_vrs_id project_vrs_id = '6.9' -- Your project version , @platform platform = 1 -- Windows (1 = Web, 2 = Mobile) , @appl_lang_id appl_lang_id = 'NL-BE' -- Language But the strange thing is that all the results contained ‘NL’ instead of the specified ‘NL-BE’:EXEC sync_transl_full 'JP_BOUWMANAGEMENT', '6.9', 'NL', '0, afmeldingsverzoek', null, null, 'Afmeldingsverzoek', 'Afmeldingsverzoeken', null, nullApart from the wrong value for ‘appl_lang_id’, I think that the parameter 'type_of_object’ should be of type integer (int) so I removed the quote (‘) in front of the value. And I added a quote (‘) in front of the value for 'transl_object_id’ CONCLUSION:The problems seems to be in the SP get_gui_transl_full. Since we are passing the value ‘NL-BE’ to the pa
Hi Mark, Yes, Here it is and it seems correct: ALTER procedure [dbo].[get_gui_transl_nav]( @usr_id usr_id , @gui_appl_id id , @platform platform , @appl_lang_id appl_lang_id )asbegin -- Do not count affected rows for performance SET NOCOUNT ON --control_proc_id: sf_gui_proc_get_gui_procedures --template_id: declare_local --prog_object_item_id: get_gui_transl_nav_declare_local --template_desc: declare @local_usr_id usr_id = @usr_id declare @local_gui_appl_id id = @gui_appl_id declare @local_platform platform = @platform declare @local_appl_lang_id appl_lang_id = @appl_lang_id --control_proc_id: sf_gui_proc_get_gui_procedures --template_id: sf_proc_get_gui_procedures_select --prog_object_item_id: get_gui_transl_nav_select --template_desc: Control procedure for generating all get gui procedures select
Hi, I checked the view in IAM and TSF and they both have same definition. But what I also see is that I have different definition for this view in MOD database. Let me share both below:TSF and IAM: /* Create view gui_transl_nav. */create view [dbo].[gui_transl_nav]( "usr_id", "project_id", "project_vrs_id", "gui_appl_id", "platform", "appl_lang_id", "type_of_object", "transl_object_id", "transl_form", "transl_grid", "transl", "transl_plural", "tooltip_text", "help_text")as --control_proc_id: sf_gui_view_get_gui_views --template_id: without_rights --prog_object_item_id: body_gui_transl_nav --template_desc: Get-gui view without role tables to check the rights select u.usr_id ,v.project_id ,v.project_vrs_id ,v.gui_appl_id ,t2.platform ,t.appl_lang_id ,t.type_of_object ,t.transl_object_id ,t.transl_form ,t.transl_grid ,t.transl ,t.transl_plural
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.