CA SDM export incidents to excel

[faizal80]

hello all,

how do i export incidents to excel using servlet ?
can you guys help me on this?

thanks in advance

------------------------------
Senior Application Consultant
Feiran Technology Sdn Bhd
------------------------------

[Jussi Valkonen]

You login to SDM, go to Search > Incidents.... craft a filter that shows the incidents you want to export and then hit to "Export" button on the list view

If this is not what you wanted to know then you'll have to rephrase your question.

[faizal80]

thanks for your reply @Jussi Valkonen

currently i did go to export and its not working. seems the function not enable and i dont know how to enable it. so any other chance to use other method or i have to enable this export function only to export incidents to excel?

thanks in advance​

------------------------------
Senior Application Consultant
Feiran Technology Sdn Bhd
------------------------------

[Jussi Valkonen]

When you say seems the function not enable what do you mean? Is the Export button not enabled or visible, or is there nothing happening when you click on it? In any case, that's how you use the export servlet to pull out data. You might be able to construct a call to get data out directly but first you'll need to make the out-of-the-box way work. If you're connecting through a load balancer, verify you have direct connectivity to the actual server on port 8080.

[faizal80]

nothing happens when i click export button. yes i try open with  http://ca-sdm.feiran.com.my:8080/   and the page lead me to http://ca-sdm.feiran.com.my/CAisd/pdmweb.exe

------------------------------
Senior Application Consultant
Feiran Technology Sdn Bhd
------------------------------

[Jussi Valkonen]

Looks like you have a redirect from the Tomcat root to the IIS version. If you try to access http://ca-sdm.feiran.com.my:8080/axis/ do you get something like this?

If yes, you need to debug in your browser if the request ever goes through and what is the response.

[faizal80]

yes i got below message




Apache-AXIS

Language: [en] [ja]

Hello! Welcome to Apache-Axis.

What do you want to do today?

• List - View the list of deployed Web services
• Call - Call a local endpoint that list's the caller's http headers (or see its WSDL).
• Visit - Visit the Apache-Axis Home Page
• Administer Axis - [disabled by default for security reasons]
• SOAPMonitor - [disabled by default for security reasons]

To enable the disabled features, uncomment the appropriate declarations in WEB-INF/web.xml in the webapplication and restart it.

Validating Axis

If the "happyaxis" validation page displays an exception instead of a status page, the likely cause is that you have multiple XML parsers in your classpath. Clean up your classpath by eliminating extraneous parsers.

If you have problems getting Axis to work, consult the Axis Wiki and then try the Axis user mailing list.

------------------------------
Senior Application Consultant
Feiran Technology Sdn Bhd
------------------------------

[Paul Coccimiglio]

What is the value for the SERVLET_URL variable in the NX.ENV file?

Did the export function ever work before?

------------------------------
Paul Coccimiglio
Principal Support Engineer
Broadcom Inc.
------------------------------