Clarity

  • 1.  How to XOG-in project subPage

    Posted Jul 04, 2014 10:02 AM

    Hello all,

     

    I would like to XOG couple subPages from one environment to another. For test purpose I have run XOG property_view_read from dev. I searched for one subpage and delete everything, what I thouhgt is not neccesarry. This subPage is just training one so it doesn't contain anything. No sections, no fields. Here is what I want to XOG in:

    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_contentPack.xsd">
        <Header action="write" externalSource="NIKU" objectType="contentPack" version="13.3.0.286"/>
        <contentPack update="true">
            <views update="true">   
    <!--......1...... -->
                <property code="project.am_test2014" complete="false" componentId="projmgr" isCustomized="true" isSecure="false" isSystem="false"
                linkCode="project.am_test2014" objectCode="project" partitionCode="NIKU.ROOT" sequence="43" type="update">
                        <nls languageCode="cs" name="am test 0407"/>
                        <nls languageCode="da" name="am test 0407"/>
                        <nls languageCode="de" name="am test 0407"/>
                        <nls languageCode="en" name="am test 0407"/>
                        <nls languageCode="es" name="am test 0407"/>
                        <nls languageCode="fi" name="am test 0407"/>
                        <nls languageCode="fr" name="am test 0407"/>
                        <nls languageCode="hu" name="am test 0407"/>
                        <nls languageCode="it" name="am test 0407"/>
                        <nls languageCode="ja" name="am test 0407"/>
                        <nls languageCode="ko" name="am test 0407"/>
                        <nls languageCode="nl" name="am test 0407"/>
                        <nls languageCode="no" name="am test 0407"/>
                        <nls languageCode="pl" name="am test 0407"/>
                        <nls languageCode="pt" name="am test 0407"/>
                        <nls languageCode="ru" name="am test 0407"/>
                        <nls languageCode="sv" name="am test 0407"/>
                        <nls languageCode="tr" name="am test 0407"/>
                        <nls languageCode="zh" name="am test 0407"/>
                        <nls languageCode="zh_TW" name="am test 0407"/>
                </property>          
    <!--......2......project create -->          
                <propertySet objectCode="project" partitionCode="NIKU.ROOT">
                    <create code="projectCreate"/>
                        <update>
    <!--......3......view -->
                            <view code="project.am_test2014">
                                <nls languageCode="cs" name="am test 0407"/>
                                <nls languageCode="da" name="am test 0407"/>
                                <nls languageCode="de" name="am test 0407"/>
                                <nls languageCode="en" name="am test 0407"/>
                                <nls languageCode="es" name="am test 0407"/>
                                <nls languageCode="fi" name="am test 0407"/>
                                <nls languageCode="fr" name="am test 0407"/>
                                <nls languageCode="hu" name="am test 0407"/>
                                <nls languageCode="it" name="am test 0407"/>
                                <nls languageCode="ja" name="am test 0407"/>
                                <nls languageCode="ko" name="am test 0407"/>
                                <nls languageCode="nl" name="am test 0407"/>
                                <nls languageCode="no" name="am test 0407"/>
                                <nls languageCode="pl" name="am test 0407"/>
                                <nls languageCode="pt" name="am test 0407"/>
                                <nls languageCode="ru" name="am test 0407"/>
                                <nls languageCode="sv" name="am test 0407"/>
                                <nls languageCode="tr" name="am test 0407"/>
                                <nls languageCode="zh" name="am test 0407"/>
                                <nls languageCode="zh_TW" name="am test 0407"/>
                            </view>
                      <nls languageCode="en" name="xogExport"/>
                        </update>
                        <nls languageCode="en" name="xogExport"/>
                </propertySet>           
            </views>
    <!--......4...... -->
            <objects>
                <object code="project" entityCodeAttribute="entity" fiscalPeriodTypeAttribute="odf_period_type" pageInstanceType="SRM_PROJECTS"
                pageLayoutAttribute="page_layout" periodEndAttribute="odf_period_end" periodStartAttribute="odf_period_start" raiseEvents="true" source="niku.com" update="true">
                    <nls description="Objekt projektu" languageCode="cs" name="Projekt"/>
                    <nls description="Projektobjektet" languageCode="da" name="Projekt"/>
                    <nls description="Das Objekt 'Projekt'" languageCode="de" name="Projekt"/>
                    <nls description="The Project Object" languageCode="en" name="Project"/>
                    <nls description="El objeto de proyecto" languageCode="es" name="Proyecto"/>
                    <nls description="Projektin objekti" languageCode="fi" name="Projekti"/>
                    <nls description="Objet Projet" languageCode="fr" name="Projet"/>
                    <nls description="A projekt objektum" languageCode="hu" name="Projekt"/>
                    <nls description="Oggetto progetto" languageCode="it" name="Progetto"/>
                    <nls description="プロジェクト オブジェクト" languageCode="ja" name="プロジェクト"/>
                    <nls description="[ko: The Project Object]" languageCode="ko" name="[ko: Project]"/>
                    <nls description="Het projectobject" languageCode="nl" name="Project"/>
                    <nls description="Obiekt projektu" languageCode="pl" name="Projekt"/>
                    <nls description="O objeto Projeto" languageCode="pt" name="Projeto"/>
                    <nls description="Объект Проект" languageCode="ru" name="Проект"/>
                    <nls description="Projektobjektet" languageCode="sv" name="Projekt"/>
                    <nls description="Proje Nesnesi" languageCode="tr" name="Proje"/>
                    <nls description="项目对象" languageCode="zh" name="项目"/>
                    <nls description="專案物件" languageCode="zh_TW" name="專案"/>        
    <!--......5...... -->
                    <links objectCode="project">
                        <link action="SubPage.5302308.actionLink" active="true" code="project.am_test2014" isObjectInstanceLink="false" partitionCode="NIKU.ROOT"
                        partitionMode="PARTITION_ONLY" system="true">
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="cs" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="da" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="de" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="en" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="es" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="fi" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="fr" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="hu" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="it" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="ja" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="ko" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="nl" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="no" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="pl" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="pt" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="ru" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="sv" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="tr" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="zh" name="Project am test 0407 Link"/>
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="zh_TW" name="Project am test 0407 Link"/>
                                <linkParam dataRef="project" dataSource="static" paramCode="odf_code"/>
                                <linkParam dataRef="project.am_test2014" dataSource="static" paramCode="odf_view"/>
                                <linkParam dataRef="odf_pk" dataSource="data" paramCode="id"/>
                        </link>
                    </links>
                </object>
            </objects>
        </contentPack>
    </NikuDataBus>
    

     

    Clarity response is: Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("NIKU"."ODF_VIEWS"."CODE")


    In log I can see, that viewName is missing:

     

    Using input:

    {is_customized=1, viewName=, objectName=project, partitionCode=NIKU.ROOT, view_subtype=master, caption=xogExport, type=property, is_system=0, p_type=ADMINISTRATOR} sequences[ODF_VIEWS: 5335003]

     

    What am I missung in XOG?

     

    Thank you for your help.

     

    Andrej.



  • 2.  Re: How to XOG-in project subPage

    Posted Jul 04, 2014 11:05 AM

    Check the content_pack_write.xml

     

    NJ



  • 3.  Re: How to XOG-in project subPage

    Posted Jul 04, 2014 11:08 AM
      |   view attached

    I've attached the same for reference.

     

    NJ

    Attachment(s)



  • 4.  Re: How to XOG-in project subPage

    Broadcom Employee
    Posted Jul 07, 2014 11:08 AM

    Hello Endyno,

     

    Also, check article TEC482079: General Migration XOG Guidelines

     

    Thanks,

    Ruchika Israni

    Sr. Support Engineer

    CA Clarity



  • 5.  Re: How to XOG-in project subPage

    Posted Aug 06, 2014 08:08 AM

    Hello all,

     

    thank you for your responses. I checked what you recommend and I was able to XOG subpage. With kind of work-around.

     

    I used property_view to get XOG from environmet where are the subpages (env1) but didn't used all tags from code above.

     

    Steps:

    1. I didn't copy propertySet tag to my write xog.

     

    <propertySet objectCode="project" partitionCode="NIKU.ROOT"> 
                        <create code="projectCreate"/> 
                            <update> 
        <!--......3......view --> 
                                <view code="project.am_test2014"> 
                                    <nls languageCode="cs" name="am test 0407"/> 
                                    <nls languageCode="da" name="am test 0407"/> 
                                    <nls languageCode="de" name="am test 0407"/> 
                                    <nls languageCode="en" name="am test 0407"/> 
                                    <nls languageCode="es" name="am test 0407"/> 
                                    <nls languageCode="fi" name="am test 0407"/> 
                                    <nls languageCode="fr" name="am test 0407"/> 
                                    <nls languageCode="hu" name="am test 0407"/> 
                                    <nls languageCode="it" name="am test 0407"/> 
                                    <nls languageCode="ja" name="am test 0407"/> 
                                    <nls languageCode="ko" name="am test 0407"/> 
                                    <nls languageCode="nl" name="am test 0407"/> 
                                    <nls languageCode="no" name="am test 0407"/> 
                                    <nls languageCode="pl" name="am test 0407"/> 
                                    <nls languageCode="pt" name="am test 0407"/> 
                                    <nls languageCode="ru" name="am test 0407"/> 
                                    <nls languageCode="sv" name="am test 0407"/> 
                                    <nls languageCode="tr" name="am test 0407"/> 
                                    <nls languageCode="zh" name="am test 0407"/> 
                                    <nls languageCode="zh_TW" name="am test 0407"/> 
                                </view> 
                          <nls languageCode="en" name="xogExport"/> 
                            </update> 
                            <nls languageCode="en" name="xogExport"/> 
                    </propertySet>
    
    

     

    So in write xog I only used this part of code:

     

    
    
    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_contentPack.xsd">  
        <Header action="write" externalSource="NIKU" objectType="contentPack" version="13.3.0.286"/>  
        <contentPack update="true">  
            <views update="true">     
    <!--......1...... -->  
                <property code="project.am_test2014" complete="false" componentId="projmgr" isCustomized="true" isSecure="false" isSystem="false"  
                linkCode="project.am_test2014" objectCode="project" partitionCode="NIKU.ROOT" sequence="43" type="update">  
                        <nls languageCode="cs" name="am test 0407"/>  
                        <nls languageCode="da" name="am test 0407"/>  
                        <nls languageCode="de" name="am test 0407"/>  
                        <nls languageCode="en" name="am test 0407"/>  
                        <nls languageCode="es" name="am test 0407"/>  
                        <nls languageCode="fi" name="am test 0407"/>  
                        <nls languageCode="fr" name="am test 0407"/>  
                        <nls languageCode="hu" name="am test 0407"/>  
                        <nls languageCode="it" name="am test 0407"/>  
                        <nls languageCode="ja" name="am test 0407"/>  
                        <nls languageCode="ko" name="am test 0407"/>  
                        <nls languageCode="nl" name="am test 0407"/>  
                        <nls languageCode="no" name="am test 0407"/>  
                        <nls languageCode="pl" name="am test 0407"/>  
                        <nls languageCode="pt" name="am test 0407"/>  
                        <nls languageCode="ru" name="am test 0407"/>  
                        <nls languageCode="sv" name="am test 0407"/>  
                        <nls languageCode="tr" name="am test 0407"/>  
                        <nls languageCode="zh" name="am test 0407"/>  
                        <nls languageCode="zh_TW" name="am test 0407"/>  
                </property>            
    <!--......2......project create -->            
               
                 
            </views>  
    <!--......4...... -->  
            <objects>  
                <object code="project" entityCodeAttribute="entity" fiscalPeriodTypeAttribute="odf_period_type" pageInstanceType="SRM_PROJECTS"  
                pageLayoutAttribute="page_layout" periodEndAttribute="odf_period_end" periodStartAttribute="odf_period_start" raiseEvents="true" source="niku.com" update="true">  
                    <nls description="Objekt projektu" languageCode="cs" name="Projekt"/>  
                    <nls description="Projektobjektet" languageCode="da" name="Projekt"/>  
                    <nls description="Das Objekt 'Projekt'" languageCode="de" name="Projekt"/>  
                    <nls description="The Project Object" languageCode="en" name="Project"/>  
                    <nls description="El objeto de proyecto" languageCode="es" name="Proyecto"/>  
                    <nls description="Projektin objekti" languageCode="fi" name="Projekti"/>  
                    <nls description="Objet Projet" languageCode="fr" name="Projet"/>  
                    <nls description="A projekt objektum" languageCode="hu" name="Projekt"/>  
                    <nls description="Oggetto progetto" languageCode="it" name="Progetto"/>  
                    <nls description="プロジェクト オブジェクト" languageCode="ja" name="プロジェクト"/>  
                    <nls description="[ko: The Project Object]" languageCode="ko" name="[ko: Project]"/>  
                    <nls description="Het projectobject" languageCode="nl" name="Project"/>  
                    <nls description="Obiekt projektu" languageCode="pl" name="Projekt"/>  
                    <nls description="O objeto Projeto" languageCode="pt" name="Projeto"/>  
                    <nls description="Объект Проект" languageCode="ru" name="Проект"/>  
                    <nls description="Projektobjektet" languageCode="sv" name="Projekt"/>  
                    <nls description="Proje Nesnesi" languageCode="tr" name="Proje"/>  
                    <nls description="项目对象" languageCode="zh" name="项目"/>  
                    <nls description="專案物件" languageCode="zh_TW" name="專案"/>          
    <!--......5...... -->  
                    <links objectCode="project">  
                        <link action="SubPage.5302308.actionLink" active="true" code="project.am_test2014" isObjectInstanceLink="false" partitionCode="NIKU.ROOT"  
                        partitionMode="PARTITION_ONLY" system="true">  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="cs" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="da" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="de" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="en" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="es" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="fi" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="fr" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="hu" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="it" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="ja" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="ko" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="nl" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="no" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="pl" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="pt" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="ru" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="sv" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="tr" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="zh" name="Project am test 0407 Link"/>  
                                <nls description="Link to Project properties am test 0407 subpage" languageCode="zh_TW" name="Project am test 0407 Link"/>  
                                <linkParam dataRef="project" dataSource="static" paramCode="odf_code"/>  
                                <linkParam dataRef="project.am_test2014" dataSource="static" paramCode="odf_view"/>  
                                <linkParam dataRef="odf_pk" dataSource="data" paramCode="id"/>  
                        </link>  
                    </links>  
                </object>  
            </objects>  
        </contentPack>  
    </NikuDataBus>  
    
    
    
    

     

    2. I created all subpages in environment where I want to xog subpages (env2). Just name and ID.

     

    3. I run property_view in env2, in xog output searched for subpage link ID for every subpage: <link action="SubPage.5302308.actionLink"

    and changed it in my write xog. Because these ID didn't match.

     

    4. Then I run write xog which I created and all sections with their fields were xoged into subpages in env2

     

    Hope this should help somebody or maybe somebody write clear solution.

     

    Of course this simple subpage doesn't contain sections and fields so real xog will be longer with more tags.

     

    Endyno.



  • 6.  Re: How to XOG-in project subPage

    Posted Aug 11, 2014 12:16 PM

    Thanks for sharing this, Endyno

     

    NJ