Table in Noventri Suite doesn't match Excel file

Using Excel,SQL,Oracle, and other ODBC Compliant Databases
Post Reply
sirluke34
Regular Contributor
Regular Contributor
Posts: 9
Joined: Thu Feb 16, 2012 5:58 pm

Table in Noventri Suite doesn't match Excel file

Post by sirluke34 »

Hello,
I have a few pages in a Noventri project that are pulling "databased" text fields from an Excel file. Each page will have text objects that reference different Excel "sheets/tabs" by column/row. A couple of my pages are working correctly, meaning pulling data and updating properly.

One page however, doesn't match the Excel file. When I link up the Excel file to the text file, I can see data in any tab using the advanced properties of the text box, except for this one. I do actually see data, but all data is 0.00, not populated like it is in Excel. I have tried recreating the page and the text fields in Noventri.

Below are some pics for reference. Is there anything I've overlooked?

Image
Image
User avatar
Trent S
Noventri Digital Signage Expert
Noventri Digital Signage Expert
Posts: 71
Joined: Thu Dec 10, 2009 1:51 pm
Location: Maryland, USA
Contact:

Re: Table in Noventri Suite doesn't match Excel file

Post by Trent S »

Hello sirluke34,

This may be caused by the format that the cells containing those dollar values are in.

What format is your top row (containing column header names) in, and what format are your other cells (containing dollar values) currently in?

Kind Regards,
Trent Semler
Art Director
Specialized Communications Corp. / Noventri
20940 Twin Springs Dr.
Smithsburg, MD 21783-1510 USA
301-790-0103
Digital Information Display
Menu Display
Flight Board
sirluke34
Regular Contributor
Regular Contributor
Posts: 9
Joined: Thu Feb 16, 2012 5:58 pm

Re: Table in Noventri Suite doesn't match Excel file

Post by sirluke34 »

Thanks Trent - this seemed to be the culprit. They were all formatted as a number/currency. I changed the top header row to text and the rest as a number and it worked just fine.

Thanks for the quick response.
Post Reply