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!
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.
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"/>
<Filter name="code" criteria="OR">ID of lookup A,ID of lookup B,ID of lookup C</Filter>
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.
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?
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.
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...
You will have to install the client once you upgrade to 13.x, they removed the web-based client in that version.
We're in 13.2 and Web Client still works fine ...
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
You are correct DK_Winmill.
This has been disabled starting v13.3
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
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.
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.
Senior Support Engineer
I have VPN access and I did try it that way.
How should the login command look?
I'm trying this:
and getting connection timeout java errors .
What am I doing wrong?
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.
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.
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.
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.
Should I be able to use my regular password or do I need to ask support for a special XOG password?
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.
Retrieving data ...