Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Problem in Export to Excel in Nav5.0

187 views
Skip to first unread message

Mun@discussions.microsoft.com Cecilia Mun

unread,
Oct 15, 2008, 6:16:06 AM10/15/08
to
I tried to export posted sales invoices (listing) but i received this error
when i clicked on Nav 5.0 toolbar's "Export to Excel" icon.
Problems During Load
Problems came up in the following areas during load:
Table
This file cannot be opened because of errors. Errors are listed in:
C:\Docume~1\leemei\locals~1\tempor~1\content.mso\fccfca28.log

The log file created shows the following errors:-
XML ERROR in Table
REASON: Bad Value
FILE: C:\Documents and Settings\leemei\Local Settings\Temp\Posted Sales
Invoices.xml
GROUP: Cell
TAG: Data
VALUE: 2096


Can anyone please assist?

Soren Nielsen

unread,
Oct 15, 2008, 9:58:08 PM10/15/08
to

This is due to an error in the xslt (stylesheet) file, where it does not
recognize a value as a text, but mistakes it for a numerical value.

I would guess you have a value in there like "555.555.5555". This confuses
Excel, as it was expecting a numerical value.

I know there are fixes out there for the stylesheets. You can take a look at
this excellent blog post:
http://blogs.msdn.com/nav_developer/archive/2008/04/22/dynamics-nav-5-0-and-style-sheet-issues.aspx

backr...@gmail.com

unread,
Oct 16, 2008, 9:54:18 AM10/16/08
to
Hi All,

The error shows bad value. This will occur only when we are trying to
pump in other data type Values. For Example putting a text value in
place of integer.


Rgds,
Raveendran.

On Oct 16, 6:58 am, Soren Nielsen


<SorenNiel...@discussions.microsoft.com> wrote:
> This is due to an error in the xslt (stylesheet) file, where it does not
> recognize a value as a text, but mistakes it for a numerical value.
>
> I would guess you have a value in there like "555.555.5555". This confuses
> Excel, as it was expecting a numerical value.
>
> I know there are fixes out there for the stylesheets. You can take a look at

> this excellent blog post:http://blogs.msdn.com/nav_developer/archive/2008/04/22/dynamics-nav-5...


>
>
>
> "Cecilia Mun" wrote:
> > I tried to export posted sales invoices (listing) but i received this error
> > when i clicked on Nav 5.0 toolbar's "Export to Excel" icon.
> > Problems During Load
> > Problems came up in the following areas during load:
> > Table
> > This file cannot be opened because of errors. Errors are listed in:
> > C:\Docume~1\leemei\locals~1\tempor~1\content.mso\fccfca28.log
>
> > The log file created shows the following errors:-
> > XML ERROR in Table
> > REASON:    Bad Value
> > FILE:      C:\Documents and Settings\leemei\Local Settings\Temp\Posted Sales
> > Invoices.xml
> > GROUP:     Cell
> > TAG:       Data
> > VALUE:     2096
>

> > Can anyone please assist?- Hide quoted text -
>
> - Show quoted text -

0 new messages