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