Nav developer: Dynamics NAV 5.0 and Style Sheet issues, issue with '/' character in customer(vendor) name

[Blog bot]

When running forms like Customer (Vendor) Ledger Entries and Apply Customer(Vendor) Ledger Entries, and selecting: send-to Excel, the following error occurs if customer (vendor) name contains character '/':


Problems came up in the following areas during load:


Workbook setting ....


To correct this issue, open the style sheet file in notepad, default file is NavisionFormToExcel, placed in Stylesheet folder of the Client folder. Browse to the following section and replace the marked line :


<xsl:template match="Control[@type='TableBox']">
<Worksheet xmlns="urn:schemas-microsoft-comffice:spreadsheet">
<xsl:attribute name="ss:Name">
<xsl:variable name="TableBoxCaption">
<xsl:value-of select="//Object/@caption"/>
</xsl:variable>



with


<xsl:value-of select="translate(//Object/@caption,'/:*?>|','')"/>






Then browse to the following section and replace the section:


<xsl:template match="Control[@type='Frame']">
<Worksheet xmlns="urn:schemas-microsoft-comffice:spreadsheet">
<xsl:attribute name="ss:Name">
<xsl:value-of select="@caption"/>
<xsl:if test="@caption = ''">
<xsl:variable name="TableBoxCaption">
<xsl:value-of select="//Object/@caption"/>
</xsl:variable>





with:





<xsl:template match="Control[@type='Frame']">
<Worksheet xmlns="urn:schemas-microsoft-comffice:spreadsheet">
<xsl:attribute name="ss:Name">
<xsl:value-of select="translate(@caption,'/:*?>|','')"/>
<xsl:if test="@caption = ''">
<xsl:variable name="TableBoxCaption">
<xsl:value-of select="translate(//Object/@caption,'/:*?>|','')"/>
</xsl:variable>





Jasminka Vukovic


Microsoft Dynamics NO



Microsoft Customer Service and Support (CSS) EMEA


These postings are provided "AS IS" with no warranties and confer no rights. You assume all risk for your use.



Читать дальше