I have about 250 form entries that I'm exporting out to csv and there are 5 or so entries where the xml nodes aren't sorted properly. All the other entries come out just fine. Is there a way to trigger Contour to regenerate the XML for a given entry?
Thanks @TimGessens. Unfortunately that didn't regenerate the xml in the way I thought it would. The xml nodes are still out of order. In the past I edited the excel xslt and removed the sort by caption. This in most cases gave me the desired results, but I found that some were out of order. Now, after regenerating, the majority are out of order. I am running v1.1.13, so perhaps the xml node sorting thing has been fixed in a later version. But the webservice appeared to run okay.
I ended up just updating the xslt to make it sort by page first, then by fieldset, then by sort order. I'll post it here for the benefit of the community. I'd suggest updating this in future releases of Contour. I don't see any reason why you'd ever want to sort by the caption.
Regenerate Contour XML
Is there a way to regenerate the Contour XML?
I have about 250 form entries that I'm exporting out to csv and there are 5 or so entries where the xml nodes aren't sorted properly. All the other entries come out just fine. Is there a way to trigger Contour to regenerate the XML for a given entry?
Comment author was deleted
Yeah there is but don't know by heart,will check tomorrow morning
Comment author was deleted
Ah found it with google history
try to request /umbraco/plugins/umbracoContour/webservices/records.aspx?guid=[FORMGUID]&mode=debug_regen
need to be running at least v3.0.10
Comment author was deleted
And replace the [FORMGUID] with a valid id of course :)
Thanks @TimGessens. Unfortunately that didn't regenerate the xml in the way I thought it would. The xml nodes are still out of order. In the past I edited the excel xslt and removed the sort by caption. This in most cases gave me the desired results, but I found that some were out of order. Now, after regenerating, the majority are out of order. I am running
v1.1.13
, so perhaps the xml node sorting thing has been fixed in a later version. But the webservice appeared to run okay.I ended up just updating the xslt to make it sort by page first, then by fieldset, then by sort order. I'll post it here for the benefit of the community. I'd suggest updating this in future releases of Contour. I don't see any reason why you'd ever want to sort by the caption.
/umbraco/plugins/umbracoContour/xslt/excel.xslt:
is working on a reply...