Skip to Content
0
Former Member
Apr 07, 2009 at 03:58 PM

Moving Xcelcius Documents across Environments

34 Views

All

We have three environments ( DEV, TEST, PROD). We developed a Project using Xcelcius and we really liked the tool. The only draw back we see using this product is Its not easy to move the Xcelcius documents from one environment to another. Using the query as web service wizard I created two webservice. One in DEV and another one in TEST. Both returns the same result.

In DEV:

WSDL http://DEVBOX:8080/dswsbobje/qaawsservices/DevWebService?WSDL

Web Service URL : http://DEVBOX:8080/dswsbobje/qaawsservices/queryasaservice

IN TEST:

WSDL : http://TESTBOX:8080/dswsbobje/qaawsservices/TestWebservice?WSDL

Web Service URL : http://TESTBOX:8080/dswsbobje/qaawsservices/queryasaservice

I developed a Xcelcius document using the WSDL from DEV BOX.

Here is my problem. As soon as i change the WSDL reference to TEST all the reference that i have already made to the cells on EXCEL sheet are gone. I want a seemless migration from DEV Box to TEST BOX

so that i dont need to remap the mappings to EXCEL sheet again.

I see this as a big drawback in using this tool. Has anyone faced this problem before. If so can you please suggest me a good solution so that i dont need to remap the mappings while migrating from one environment to another.

Thanks

-Prabu