Form section record on sys_ui_section table cannot be imported into another instance, import XML doesn't work

Jason Niu · ‎12-17-2018

Hi All,

I'm trying to import one form section record (sys_ui_section) from UAT instance to Dev or other instances through Import XML. It doesn't work. No errors as well.

Seps, 1, find the record (sys_ui_section ) in UAT instance and export xml.

2. get to the sys_ui_section table in dev instance and import xml.

Result: the new record still isn't in dev instance.

Any help would be appreciated, thanks guys.

siva_ · ‎12-18-2018

cool , once you come back i thought to tell you the same as i did the same in the past . Anyways as your issue is already resolved. Please mark an answer as correct so that thread can be marked answered and can be removed from the unanswered tag.

Thanks,

Siva

View solution in original post

siva_ · ‎12-17-2018

Hello Jason,

Form Sections(sys_ui_section) has two related lists again. Section Elements (sys_ui_element) and form sections(sys_ui_form_section). Make sure that you are importing those as well .Also make sure the view is correct on the record you are importing where you want to make this form section available.

Thanks,

Siva

Mark this answer as correct/helpful if that really helps.

Jason Niu · ‎12-17-2018

Hi Siva,

Thanks for the prompt reply, this time I tried import the related records both in sys_ui_form_section table and sys_ui_element table, these data was successfully imported to dev instance, then I tried to import the record in sys_ui_section table. Nothing imported.

This is really confusing. Is there any hidden rules which prevent me from importing data to sys_ui_section table? or is there a place I can check for the errors? I checked system logs, nothing there.

Thanks again Siva

siva_ · ‎12-17-2018

First import the form section and then the related lists . and also check in the form sections if the imported record is present in dev . Also check in the system logs immediately to check if there is any error or warning logged in to the system.

Thanks,

Siva.

Mark this answer as correct/Helpful if that really helps.

Jason Niu · ‎12-18-2018

Thanks Siva,

I think it's caused by duplicated UI form sections with same Caption or something. I'm not sure why, since they have different sys IDs. I deleted all duplicated records and re-imported the one I want, and it works.

Thanks again for you help

Cheers,

Jason