Reading in large datasources
Hi,
I'm in the process of testing a service operation that has a large number of tags in the request - several hundred.
Our current process is to read into the XML request from an Excel spreadsheet.
The first problem I'm facing is that Excel itself doesn't allow that many columns.
My current solution has been to spread the tags across two tabs, and reading in from both of them.
Is there a better solution?
Secondly, when I'm parameterising the Request XML, right-clicking and selecting the Get Data option, I am unable to select all of the values from the displayed list, as it stretches beyond that which the screen can fit.
Obviously I can manually enter the parameter in question, however is there a way I can scroll through this displayed list? Or if not at present is this a change that may be made in the future?
Any help would be greatly appreciated
Geoff
I'm in the process of testing a service operation that has a large number of tags in the request - several hundred.
Our current process is to read into the XML request from an Excel spreadsheet.
The first problem I'm facing is that Excel itself doesn't allow that many columns.
My current solution has been to spread the tags across two tabs, and reading in from both of them.
Is there a better solution?
Secondly, when I'm parameterising the Request XML, right-clicking and selecting the Get Data option, I am unable to select all of the values from the displayed list, as it stretches beyond that which the screen can fit.
Obviously I can manually enter the parameter in question, however is there a way I can scroll through this displayed list? Or if not at present is this a change that may be made in the future?
Any help would be greatly appreciated
Geoff
