- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-16-2016 11:47 AM
Hello all!!
We moved update sets from dev to prod. Something went wrong and 2 of the views of a particular custom table don't reflect the dev instance. They are working perfectly in the Dev and that's the only issue, so we thought of migrating them to Prod independently using xml export and import.
This is what I did:
I exported the two view records (from UI views table) as xml.
I went to the prod instance, opened the Views table and clicked 'Import xml' from the header menu. And chose these two xml files and uploaded.
But there's no change in the views in Prod. What am I doing wrong? Is this not how it's supposed to be done? Please help!
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-16-2016 12:04 PM
There are many records that make up a view.
You also need to get the corresponding "section" table entries from sys_ui_section. These are represented as related lists on the View form. It's a bit like getting a group with no members. You've got the 'shell' of the view definition, but not the content.
The easiest way to find your section is by table name.
You may also want to get the appropriate entry from sys_ui_form (by table.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-16-2016 03:18 PM
It didn't work Chuck. I figured out what the problem. The sys_id for one of the views is different from dev. Don't know how that happened. May be someone deleted it and recreated. But fixed now. Although there's something I wanted to ask.
When I was trying to fix it, I gave this process a try: I created an update set, made a simple change to the form layout and moved it to prod, in the hopes that change would capture the whole view and everything and bring it to Prod and I'd be able to accept the layout it brings if there's a collision. But that didn't happen. (This is for the view that has the correct sys_id) Am I wrong to presume that?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-16-2016 03:21 PM
What does the xml in your update set look like?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-16-2016 03:33 PM
It's pretty big. I see info about view as well and a whole lot of text.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-19-2016 04:43 AM
Can you share what the update set contents look like. It's a bit difficult to answer your question with only vague descriptions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-19-2016 10:00 AM
I'm sending one part of it since it's about 67000 characters long. Here it is -
<?xml version="1.0" encoding="UTF-8"?>
<unload unload_date="2016-09-16 22:31:03">
<sys_remote_update_set action="INSERT_OR_UPDATE">
<application display_value="Global">global</application>
<application_name>Global</application_name>
<application_scope>global</application_scope>
<application_version/>
<collisions/>
<commit_date/>
<deleted/>
<description/>
<inserted/>
<name>Re-do PR views 5</name>
<origin_sys_id/>
<release_date/>
<remote_sys_id>f10e355f13bde600611ab027d144b012</remote_sys_id>
<state>loaded</state>
<summary/>
<sys_created_by>vkotha@admin</sys_created_by>
<sys_created_on>2016-09-16 22:31:03</sys_created_on>
<sys_id>67005ed713fde600611ab027d144b0eb</sys_id>
<sys_mod_count>0</sys_mod_count>
<sys_updated_by>vkotha@admin</sys_updated_by>
<sys_updated_on>2016-09-16 22:31:03</sys_updated_on>
<update_set display_value=""/>
<update_source display_value=""/>
<updated/>
</sys_remote_update_set>
<sys_update_xml action="INSERT_OR_UPDATE">
<action>INSERT_OR_UPDATE</action>
<application display_value="Global">global</application>
<category>retrieved</category>
<comments/>
<name>sys_ui_section_4112bf6f1385ea004b095d346144b04f</name>
<payload><![CDATA[<?xml version="1.0" encoding="UTF-8"?><record_update><sys_ui_section caption="Builds" section_id="4112bf6f1385ea004b095d346144b04f" sys_domain="global" table="u_production_request" version="3" view="specifications"><sys_ui_element action="INSERT_OR_UPDATE"><element>u_encoding</element><position>0</position><sys_created_by>jlammy@admin</sys_created_by><sys_created_on>2016-09-16 21:09:30</sys_created_on><sys_id>4d6d35d313b5ea004b095d346144b0b8</sys_id><sys_mod_count>0</sys_mod_count><sys_ui_formatter/><sys_ui_section caption="Builds" display_value="Builds" name="u_production_request" sys_domain="global" view="473f23e71385ea004b095d346144b0d9">4112bf6f1385ea004b095d346144b04f</sys_ui_section><sys_updated_by>jlammy@admin</sys_updated_by><sys_updated_on>2016-09-16 21:09:30</sys_updated_on><sys_user/><type/></sys_ui_element><sys_ui_element action="INSERT_OR_UPDATE"><element>u_builds</element><position>1</position><sys_created_by>jlammy@admin</sys_created_by><sys_created_on>2016-09-16 21:09:30</sys_created_on><sys_id>8d6d35d313b5ea004b095d346144b0b8</sys_id><sys_mod_count>0</sys_mod_count><sys_ui_formatter/><sys_ui_section caption="Builds" display_value="Builds" name="u_production_request" sys_domain="global" view="473f23e71385ea004b095d346144b0d9">4112bf6f1385ea004b095d346144b04f</sys_ui_section><sys_updated_by>jlammy@admin</sys_updated_by><sys_updated_on>2016-09-16 21:09:30</sys_updated_on><sys_user/><type/></sys_ui_element><sys_ui_section action="INSERT_OR_UPDATE"><caption>Builds</caption><header>false</header><name>u_production_request</name><roles/><sys_class_name>sys_ui_section</sys_class_name><sys_created_by>a-asoldo@admin</sys_created_by><sys_created_on>2016-08-11 17:30:43</sys_created_on><sys_customer_update>true</sys_customer_update><sys_domain>global</sys_domain><sys_domain_path>/</sys_domain_path><sys_id>4112bf6f1385ea004b095d346144b04f</sys_id><sys_mod_count>1</sys_mod_count><sys_name>Builds</sys_name><sys_overrides/><sys_package display_value="Global" source="global">global</sys_package><sys_policy/><sys_replace_on_upgrade>false</sys_replace_on_upgrade><sys_scope display_value="Global">global</sys_scope><sys_update_name>sys_ui_section_4112bf6f1385ea004b095d346144b04f</sys_update_name><sys_updated_by>vkotha@admin</sys_updated_by><sys_updated_on>2016-08-15 18:18:19</sys_updated_on><sys_user/><title>false</title><view display_value="Specifications" name="specifications">473f23e71385ea004b095d346144b0d9</view><view_name/></sys_ui_section></sys_ui_section></record_update>]]></payload>