commandreporter XML inconsistency
We are running SIMS commandreporter successfully to generate csv data out of SIMS.
However, we are aware that it would be better to export the data in XML (not least as a spurious comma in some student data recently caused a minor hiccup).
XML is a [relatively] new venture for us for this kind of thing (CSV has worked till now so we have not fixed it), but it seems that Python is adept at handling it and so progress drags us forward (another spinning plate).
A [test] report has been created to list the classes of students. (see attached pdf, slide 1)
Commandreporter generates the xml shown in slide 2 - note the attribute 'multiple IDs' and the 'x0020' in the middle of the attribute labels (hex for the space in the field name in SIMS?)
When run manually from SIMS it generates the XML shown in slide 3. No multiple IDs and no 'x0020' in the middle of attribute names. However in the schema the attributes have a 'caption' of the field name.
The question is a)why the difference? and b) is the x0020 consistent or might it change (if it is derived from something other than my guess)
[would be better/simpler for coding if we can get commandreporter to generate the simpler 'manual' xml]
OK that was 2 questions. [No one expects the Spanish Inquisition.]
Any constructive help/advice gratefully received, even if only to confirm this is expected behaviour and we have to live with it (should others have come across this also).
We did try to generate a paramdef file in case that is relevant, but it did not make much sense to us (other than date fields referred to in other posts).
If it helps our cmd file for comandreporter is as follows:
"\\server\c$\Program Files (x86)\SIMS\SIMS .net\commandreporter.exe" /USER:username /PASSWORD:**** /SERVER:server /DATABASE:dbase /REPORT:"_xxxx_StudentClassesx(xx)" /OUTPUT:"\\server2\m$\xxxx\xxxxx\StudentClassesx.xm l"
(comparable syntax works fine for CSV files and when run from CLI)
Have not found specific reference to this question in other posts here.