Clarity

 View Only
Expand all | Collapse all

XOG newby... can someone help me xog out a lookup

Jump to Best Answer
  • 1.  XOG newby... can someone help me xog out a lookup

    Posted Oct 24, 2014 01:51 PM

    I have some lookups I'd like to save out of DEV and XOG back into PROD without retyping all the values.. can this be done? (I thought I'd heard that it could).

    If so, can someone provide an example?

     

    thanks in advance!

     

     

    Brad



  • 2.  Re: XOG newby... can someone help me xog out a lookup
    Best Answer

    Posted Oct 25, 2014 03:35 AM

    Hi Brad,

     

    Of course you can do this via XOG. Please use the content_pack_read.xml file in your XOG\xml folder. You will see the below lines in the file where you can replace SEC_OBJECT_TYPE with the id of the lookup you want to xog out of DEV. If there are multiple lookups which you want to xog out, make the criteria below as OR instead of EQUALS  and give the codes of all the lookups separated by comma.

    Untitled.png

    It will be easier if you just take out these lines from the content pack read xml file and make your own lookups_read.xml which will help you in future too. It should be looking like this as shown below. This is from Clarity v13.0.

     

    <?xml version="1.0" encoding="UTF-8"?>

    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">

        <Header version="8.0" action="read" objectType="contentPack" externalSource="NIKU"/>

          <LookupQuery>

               <Filter name="code" criteria="OR">ID of lookup A,ID of lookup B,ID of lookup C</Filter>

          </LookupQuery>

    </NikuDataBus>

     

    Xogging in the output of this XOG read to Prod will make these lookups available in Prod environment. Refer to XML Open Gateway Developer Guide PDF if you have any more doubts on this.

     

    Regards,

    Georgy



  • 3.  Re: XOG newby... can someone help me xog out a lookup

    Posted Oct 27, 2014 08:35 AM

    Thanks very much, that was exactly what I needed.

     

    I wonder if there's a library of XOG examples like this?

    We're a SAAS user and can't get to the file you mentioned (content_pack_read.xm) to see examples... any thoughts on that?

     

    Thanks again!

     

    Brad



  • 4.  Re: XOG newby... can someone help me xog out a lookup

    Posted Oct 27, 2014 08:51 AM

    Dear Brad,

     

    This file should be available in the xml folder once you install the XOG client.

     

    You can download xog client for your version directly from Clarity. Please navigate to Administration > General Settings > Client Downloads and

    download client suitable for your OS.

     

    If you do not see the Administration Tab, please request Administration rights for the application and then the tab will appear.

     

     

    Regards

    Nitin



  • 5.  Re: XOG newby... can someone help me xog out a lookup

    Posted Oct 27, 2014 08:54 AM

    I'm not using the client, I can never get it to connect to my server correctly... I use the web based XOG interface.

    I guess I could install the client and go get that file though...



  • 6.  Re: XOG newby... can someone help me xog out a lookup

    Posted Oct 27, 2014 09:07 AM

    You will have to install the client once you upgrade to 13.x, they removed the web-based client in that version.



  • 7.  Re: XOG newby... can someone help me xog out a lookup

    Posted Oct 27, 2014 09:12 AM

    We're in 13.2 and Web Client still works fine ...

     

    https://yourSAASserverURL/niku/nu#action:xog.client



  • 8.  Re: XOG newby... can someone help me xog out a lookup

    Posted Oct 27, 2014 09:23 AM

    Well that is news to me.  I guess they just disabled it in 13.x and you can re-enable it.

     

    Make the XOG client URL back again



  • 9.  Re: XOG newby... can someone help me xog out a lookup

    Posted Oct 27, 2014 09:29 AM

    You are correct DK_Winmill.

    This has been disabled starting v13.3

     

    Regards

    Nitin



  • 10.  Re: XOG newby... can someone help me xog out a lookup

    Posted Oct 27, 2014 09:28 AM

    You should be able to access your environment via the XOG client.

    If you face any issues for the same , I request you to reach out to CA Support.

    The reason being , as also , DK_Windmill said, starting v13.3 , the UI inteface is disabled.

     

    but to get the file , you are correct , you can download and install the client and you should have all the sample XOG files

     

    Regards

    Nitin



  • 11.  Re: XOG newby... can someone help me xog out a lookup

    Posted Oct 27, 2014 09:31 AM

    That's not good news. The XOG client is difficult to set up and use.

    This may be a good reason for me to hold back on upgrading.



  • 12.  Re: XOG newby... can someone help me xog out a lookup

    Broadcom Employee
    Posted Oct 27, 2014 10:10 AM

    Hi Brad,

     

    On Demand Customers who are behind the portal need to get vpn access in order to connect to their systems via the xog client.  If you do not have vpn access or if you need help getting this to work, please open a support case.

     

    Sincerely yours,

     

    Jeanne Gaskill

    Senior Support Engineer

    Clarity



  • 13.  Re: XOG newby... can someone help me xog out a lookup

    Posted Oct 27, 2014 10:21 AM

    Hi Jeanne,

     

    I have VPN access and I did try it that way.

     

    How should the login command look?

     

    I'm trying this: 

     

    Login username/password@cppm8008.ondemand.ca.com

     

    and getting connection timeout java errors .

    What am I doing wrong?



  • 14.  Re: XOG newby... can someone help me xog out a lookup

    Broadcom Employee
    Posted Oct 27, 2014 10:37 AM

    Hi Brad,

     

    How are you trying to log into the vpn?  Are you using a vpn client?

     

    Did you request vpn access from the On Demand team?  They should have given you access to the vpn and instructions on how to install a vpn client along with a username and password.

     

    Jeanne



  • 15.  Re: XOG newby... can someone help me xog out a lookup

    Posted Oct 27, 2014 10:40 AM

    Yes, I've had VPN access for years.

    I use it to run queries and to do Crystal reports uploads to our environment.

    In fact, I think you've renewed it for me once or twice!

     

    I login to the VPN either by using the CA web page for VPN, or using the Cisco ANYCONNECT Client. That works without issue, but I can't login to XOG via the client.



  • 16.  Re: XOG newby... can someone help me xog out a lookup

    Broadcom Employee
    Posted Oct 27, 2014 11:00 AM

    HI Brad,

     

    Please open a case with support.  One of us will be happy to help you.

     

    I am not sure I understand exactly what is happening without a lot more detail.

     

    Jeanne



  • 17.  Re: XOG newby... can someone help me xog out a lookup

    Broadcom Employee
    Posted Oct 27, 2014 10:42 AM

    Also, fyi, the xog.client page is an unsupported page that was intended for use by people internal to CA.  The code for this is not kept up the way the xog client code is.  So any problems you have with xogging on the xog.client page would not be supported.

     

    In general my experience with that page is that it works for short xogs.  But, it is unreliable if you are xogging large amounts of data.

     

    Jeanne



  • 18.  Re: XOG newby... can someone help me xog out a lookup

    Posted Oct 27, 2014 10:46 AM

    Should I be able to use my regular password or do I need to ask support for a special XOG password?



  • 19.  Re: XOG newby... can someone help me xog out a lookup

    Broadcom Employee
    Posted Oct 27, 2014 11:22 AM

    Hi Brad,

     

    In general yes.  Check your account under Resources on the Admin side.  Make sure the External Authentication button at the bottom of the page is checked.  This will allow you to use the same password you use to log into Clarity (assuming you are behind the portal).

     

    But, you may have something else going on based on your description of the java timeouts.

     

    Jeanne