go to post Thembelani Mlalazi · Jan 15, 2018 I am supposed to use the EnsLib.MsgRouter.VDocRoutingEngine on the process and use the following syntax to get to the property level/Document.{Property.Property} this works
go to post Thembelani Mlalazi · Jan 15, 2018 @Jeffrey.Drumn Assuming I got this right He is trying to get to reference a property from a record mapper that will work just fine here is an exampleTestEnvironment.Record being my record mapper class and the Document.wardAge being my property (WARDAGE)
go to post Thembelani Mlalazi · Jan 15, 2018 On the condition I would like to do something like this but I do not get the opportunity to actual get to the schema that I would like to reference to get to that. Message will be the root of my xml document Header an element with attribute Action @Robert.Cemper
go to post Thembelani Mlalazi · Jan 15, 2018 @David Foard In your Rule on the when condition select the (Document.RecordMapper.Property) make show you are referencing a record mapper on the constraint of the rule
go to post Thembelani Mlalazi · Jan 5, 2018 I have changed it to class method and still same error@Eduard Lebedyuk
go to post Thembelani Mlalazi · Jan 5, 2018 that's is the only way I could do it have any suggestion on how I can Improve that thank you@Robert.Cemper
go to post Thembelani Mlalazi · Jan 4, 2018 so far when I run my code in cache I get this error <INVALID OREF>zXmlToJSONnode+3^SharpJSONToXML.1 and I would like to know the equivalent in cache for that method if you look at it@Robert.Cemper
go to post Thembelani Mlalazi · Dec 20, 2017 @eduard.lebeduk I am not using %XML.Reader hence the reason I need to find the alternative of reading the record open and close element I am trying to do away with creating object classes
go to post Thembelani Mlalazi · Dec 20, 2017 @Fabian.Haupt I need help if Xpath will achieve what I am trying to do so be it what I want is something generic for any XML to be processed if Xpath Has a generic way fine
go to post Thembelani Mlalazi · Dec 14, 2017 @Eduard Lebedyukyes that the expected results even if you can not move the last two elements to be last just making something similar might help
go to post Thembelani Mlalazi · Dec 14, 2017 @Eduard Lebedyuksorry man given the above XLT how can I get the following Json {"Body" : [{"Code" : "HOT","Name" : "SIDE","Type" : "AADULT","Sec" : "MSec","ardge" : "Adult","Nder" : "F","TBC" : "21","BO" : "14","DBOC" : "0","LBC" : "5","AB" : "2"},{"Code" : "HOT","Name" : "DARS","Type" : "AADULT","Sec" : "MSec","ardge" : "OADULT","Nder" : "U","TBC" : "20","BO" : "16","DBOC" : "0","LBC" : "2","AB" : "2"}]"Code" : "HOT","Date" : "2017-12-08 11:22:34.658",}
go to post Thembelani Mlalazi · Dec 8, 2017 Thanks for the advice have changed my code but come to a problem while reading my stream as there seems to an error with the XSLT XML Transformer Error: SAXParseException I do not seems to see what the problem is as I tested my XLT with the XLT Transform Wizard and it all worked fine could you please have a look at the xml and the XLT and see if you can spot where I am going wrong thanks in advance XML <Message><Header><Code>HOT</Code><Date>2017-12-08 11:22:34.658</Date></Header><Body><Code>HOT</Code><Name>SIDE</Name><Type>AADULT</Type><Sec>MSec</Sec><ardge>Adult</ardge><Nder>F</Nder><TBC>21</TBC><BO>14</BO><DBOC>0</DBOC><LBC>5</LBC><AB>2</AB></Body><Body><Code>HOT</Code><Name>DARS</Name><Type>AADULT</Type><Sec>MSec</Sec><ardge>OADULT</ardge><Nder>U</Nder><TBC>20</TBC><BO>16</BO><DBOC>0</DBOC><LBC>2</LBC><AB>2</AB></Body><Body><Code>HOT</Code><Name>ENTLE</Name><Type>AADULT</Type><Sec>MSec</Sec><ardge>Adult</ardge><Nder>M</Nder><TBC>22</TBC><BO>18</BO><DBOC>0</DBOC><LBC>3</LBC><AB>1</AB></Body><Body><Code>HOT</Code><Name>ROOXED</Name><Type>AADULT</Type><Sec>MSec</Sec><ardge>OADULT</ardge><Nder>U</Nder><TBC>17</TBC><BO>7</BO><DBOC>0</DBOC><LBC/><AB>9</AB></Body><Body><Code>HOT</Code><Name>DUK</Name><Type>AADULT</Type><Sec>MSec</Sec><ardge>Adult</ardge><Nder>F</Nder><TBC>20</TBC><BO>17</BO><DBOC>0</DBOC><LBC>1</LBC><AB>2</AB></Body><Body><Code>HOT</Code><Name>DALE</Name><Type>AADULT</Type><Sec>MSec</Sec><ardge>Adult</ardge><Nder>M</Nder><TBC>18</TBC><BO>15</BO><DBOC>0</DBOC><LBC>2</LBC><AB/></Body><Body><Code>HOT</Code><Name>DAN</Name><Type>AADULT</Type><Sec>MSec</Sec><ardge>OADULT</ardge><Nder>U</Nder><TBC>16</TBC><BO>8</BO><DBOC>0</DBOC><LBC/><AB>8</AB></Body><Body><Code>HOT</Code><Name>DUN</Name><Type>AADULT</Type><Sec>MSec</Sec><ardge>Adult</ardge><Nder>U</Nder><TBC>2</TBC><BO>0</BO><DBOC>0</DBOC><LBC>1</LBC><AB>1</AB></Body><Body><Code>HOT</Code><Name>DUW</Name><Type>AADULT</Type><Sec>MSec</Sec><ardge>Adult</ardge><Nder>U</Nder><TBC>3</TBC><BO>2</BO><DBOC>0</DBOC><LBC>1</LBC><AB/></Body><Body><Code>HOT</Code><Name>DUM</Name><Type>AADULT</Type><Sec>MSec</Sec><ardge>OADULT</ardge><Nder>U</Nder><TBC>22</TBC><BO>18</BO><DBOC>0</DBOC><LBC>2</LBC><AB>2</AB></Body><Body><Code>HOT</Code><Name>DUR</Name><Type>AADULT</Type><Sec>MSec</Sec><ardge>Adult</ardge><Nder>U</Nder><TBC>16</TBC><BO>13</BO><DBOC>0</DBOC><LBC>2</LBC><AB/></Body></Message> XSLT <?xml version="1.0"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="text" indent="yes"/> <xsl:template match="/*[node()]"> <xsl:text>{</xsl:text><xsl:text>
</xsl:text> <xsl:apply-templates select="." mode="detect" /> <xsl:text>
</xsl:text> <xsl:text>}</xsl:text> </xsl:template> <xsl:template match="*" mode="detect"> <xsl:choose> <xsl:when test="name(preceding-sibling::*[1]) = name(current()) and name(following-sibling::*[1]) != name(current())"> <xsl:apply-templates select="." mode="obj-content" /> <xsl:text>
</xsl:text> <xsl:text>]</xsl:text> <xsl:if test="count(following-sibling::*[name() != name(current())]) > 0">, </xsl:if> </xsl:when> <xsl:when test="name(preceding-sibling::*[1]) = name(current())"> <xsl:apply-templates select="." mode="obj-content" /> <xsl:if test="name(following-sibling::*) = name(current())">, </xsl:if> </xsl:when> <xsl:when test="following-sibling::*[1][name() = name(current())]"> <xsl:text>"</xsl:text><xsl:value-of select="name()"/><xsl:text>" : [</xsl:text> <xsl:text>
</xsl:text> <xsl:apply-templates select="." mode="obj-content" /><xsl:text>, </xsl:text> <xsl:text>
</xsl:text> </xsl:when> <xsl:when test="count(./child::*) > 0 or count(@*) > 0"> <xsl:text>"</xsl:text><xsl:value-of select="name()"/>" : <xsl:apply-templates select="." mode="obj-content" /> <xsl:if test="count(following-sibling::*) > 0">, </xsl:if> </xsl:when> <xsl:when test="count(./child::*) = 0"> <xsl:text>"</xsl:text><xsl:value-of select="name()"/>" : "<xsl:apply-templates select="."/><xsl:text>"</xsl:text> <xsl:if test="count(following-sibling::*) > 0">, </xsl:if> <xsl:text>
</xsl:text> </xsl:when> </xsl:choose> </xsl:template> <xsl:template match="*" mode="obj-content"> <xsl:text>
</xsl:text> <xsl:text>{</xsl:text> <xsl:text>
</xsl:text> <xsl:apply-templates select="@*" mode="attr" /> <xsl:if test="count(@*) > 0 and (count(child::*) > 0 or text())">, </xsl:if> <xsl:apply-templates select="./*" mode="detect" /> <xsl:if test="count(child::*) = 0 and text() and not(@*)"> <xsl:text>"</xsl:text><xsl:value-of select="name()"/>" : "<xsl:value-of select="text()"/><xsl:text>"</xsl:text> </xsl:if> <xsl:if test="count(child::*) = 0 and text() and @*"> <xsl:text>"text" : "</xsl:text><xsl:value-of select="text()"/><xsl:text>"</xsl:text> </xsl:if> <xsl:text>}</xsl:text> <xsl:if test="position() < last()">, </xsl:if> </xsl:template> <xsl:template match="@*" mode="attr"> <xsl:text>"</xsl:text><xsl:value-of select="name()"/>" : "<xsl:value-of select="."/><xsl:text>"</xsl:text> <xsl:if test="position() < last()">,</xsl:if> </xsl:template> <xsl:template match="node/@TEXT | text()" name="removeBreaks"> <xsl:param name="pText" select="normalize-space(.)"/> <xsl:choose> <xsl:when test="not(contains($pText, '
'))"><xsl:copy-of select="$pText"/></xsl:when> <xsl:otherwise> <xsl:value-of select="concat(substring-before($pText, '
'), ' ')"/> <xsl:call-template name="removeBreaks"> <xsl:with-param name="pText" select="substring-after($pText, '
')"/> </xsl:call-template> </xsl:otherwise> </xsl:choose> </xsl:template> </xsl:stylesheet>
go to post Thembelani Mlalazi · Dec 4, 2017 that works wonders with the use of the following class http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GXML_xslt
go to post Thembelani Mlalazi · Nov 15, 2017 @Marc Mundt I have read around the topic but still cannot figure out how to read an xml to %ZEN.proxyObject would mind please giving us an example to work with I am still new to this thank you
go to post Thembelani Mlalazi · Nov 14, 2017 @Robert.Cemper thank you but I am trying to avoid using the object classes to create this as I will be processing a lot of different files and will end up with a lot of classes
go to post Thembelani Mlalazi · Nov 9, 2017 [@ vitaliy.Serdtsev] have change my code as per your suggestion still not writing to a file I get <PARAMETER>zWrite^%Stream.FileBinary.1
