cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Connecting to Windchill via XML using Business Objects(WeBI)

Highlighted
Aquamarine

Connecting to Windchill via XML using Business Objects(WeBI)

We run a query via XML that performs a project search and translates the results using XSL.

We have the Query-Objects xml & xsd file on the server.

The result is an XML that shows projects & attributes.

The problem is in this output, the COLLECTION & INSTANCE is listed in a manner that Business Objects does not understand. When this is generated, Windchill adds the "wc:" in front of COLLECTION & INSTANCE. If we remove this, Business Objects can create the connection OK.

Does anyone know if we can modify this output to remove the "wc:"?

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

<wc:COLLECTION xmlns:wc="http://www.ptc.com/infoengine/1.0"> -<com.amcorrigid.AM_PROJECT STATUS="0" TYPE="Object" NAME="output">

<wc:INSTANCE>

<AM_PROJ_SEGMENT>xxxxxxxxxxxx</AM_PROJ_SEGMENT>

<AM_PROJ_DESCRIPTION>xxxxxxxxxx</AM_PROJ_DESCRIPTION>

<AM_PROJ_NAME>xxxxxxxxxxxxxx</AM_PROJ_NAME>

<AM_CREATED>01/04/2010</AM_CREATED>

<AM_PROJ_TYPE>xxxxxxxxxxxxx</AM_PROJ_TYPE>

<AM_PROJ_NUMBER>xxxxxxxxxxx</AM_PROJ_NUMBER>

<AM_PROJ_STATE>COMPLETED</AM_PROJ_STATE>

<obid>OR:wt.projmgmt.admin.Project2:336391:590620213-1382658489836-1091773784-228-4-144-10@plm.amcorrigid.com</obid>

<class>WCTYPE|wt.projmgmt.admin.Project2|com.amcorrigid.AM_PROJECT</class>

</wc:INSTANCE>

Tags (2)