Dataset table formating issue

Asked by terencewp

Hi,

i tried to use dataset to format a table just like your example. The table output is incorrent as all color code gone just black text and white background.

i'm using win7 client 1.63, ie 11 and ubutn cms 1.63. i believed it may be issue on ie but tried from ie7 to ie11, all having same issue of no color.

also tried different color code from geen, blue to hex, rgb, all didn't work.

thanks a lot!

css code:
table.DataSetTable {
font-family:"Trebuchet MS", Arial, Helvetica, sans-serif;
width:100%;
border-collapse:collapse;
}

tr.HeaderRow {
font-size:1.1em;
text-align:center;
padding-top:5px;
padding-bottom:4px;
background-color:rgb(255,0,0);
color:rgb(255,255,0);
}

tr#row_1 {
color:#000000;
background-color:#EAF2D3;
}

td#col_1 {
color:#000000;
background-color:#EAF2D3;
}

td.DataSetColumn {
color:#000000;
background-color:#EAF2D3;
border:1px solid #98bf21
}

tr.DataSetRow {
text-align:center;
color:#000000;
background-color:#EAF2D3;
border:1px solid #98bf21
padding-top:5px;
padding-bottom:4px;
}

th.DataSetColumnHeaderCell {
font-size:1em;
border:1px solid #98bf21;
padding:3px 7px 2px 7px;
}

span#1_1 {

}

span.DataSetColumnSpan {

}

log session:
Message
7311 2014-08-23 18:18:28 module SELECT `Venue`, `Event`, `Start`, `End`, `Organizer` FROM ( SELECT `Venue`, `Event`, `Start`, `End`, `Organizer` , RowNumber FROM ( SELECT MAX(CASE WHEN DataSetColumnID = 1 THEN `Value` ELSE null END) AS 'Venue', MAX(CASE WHEN DataSetColumnID = 2 THEN `Value` ELSE null END) AS 'Event', MAX(CASE WHEN DataSetColumnID = 3 THEN `Value` ELSE null END) AS 'Start', MAX(CASE WHEN DataSetColumnID = 4 THEN `Value` ELSE null END) AS 'End', MAX(CASE WHEN DataSetColumnID = 5 THEN `Value` ELSE null END) AS 'Organizer', RowNumber FROM ( SELECT datasetcolumn.DataSetColumnID, datasetdata.RowNumber, datasetdata.`Value` FROM datasetdata INNER JOIN datasetcolumn ON datasetcolumn.DataSetColumnID = datasetdata.DataSetColumnID WHERE datasetcolumn.DataSetID = 1 ) datasetdatainner GROUP BY RowNumber ) datasetdata ) finalselect ORDER BY RowNumber
7310 2014-08-23 18:18:28 module GetOption rowsPerPage: Set - returning: 4
7309 2014-08-23 18:18:28 module GetOption showHeadings: Set - returning: 1
7308 2014-08-23 18:18:28 module GetOption columns: Set - returning: 1,2,3,4,5
7307 2014-08-23 18:18:28 module GetOption ordering: Set - returning:
7306 2014-08-23 18:18:28 module GetOption filter: Set - returning:
7305 2014-08-23 18:18:28 module GetOption lowerLimit: Set - returning: 0
7304 2014-08-23 18:18:28 module GetOption upperLimit: Set - returning: 0
7303 2014-08-23 18:18:28 module GetOption datasetid: Set - returning: 1
7302 2014-08-23 18:18:28 module GetOption rowsPerPage: Set - returning: 4
7301 2014-08-23 18:18:28 module SetMediaInformation Existing Assigned Media XML is: \n <?xml version="1.0"?>
<root><media id="f31edb079e1d42c0e555dfc92d6d2059" type="datasetview" duration="86400" lkid="" userId="1" schemaVersion="1">
<options><datasetid>1</datasetid><columns>1,2,3,4,5</columns><upperLimit>0</upperLimit><lowerLimit>0</lowerLimit><filter/><ordering/><showHeadings>1</showHeadings><duration>86400</duration><updateInterval>5</updateInterval><rowsPerPage>4</rowsPerPage></options>
<raw><styleSheet><![CDATA[table.DataSetTable {
font-family:"Trebuchet MS", Arial, Helvetica, sans-serif;
width:100%;
border-collapse:collapse;
}

tr.HeaderRow {
font-size:1.1em;
text-align:center;
padding-top:5px;
padding-bottom:4px;
background-color:rgb(255,0,0);
color:rgb(255,255,0);
}

tr#row_1 {
color:#000000;
background-color:#EAF2D3;
}

td#col_1 {
color:#000000;
background-color:#EAF2D3;
}

td.DataSetColumn {
color:#000000;
background-color:#EAF2D3;
border:1px solid #98bf21
}

tr.DataSetRow {
text-align:center;
color:#000000;
background-color:#EAF2D3;
border:1px solid #98bf21
padding-top:5px;
padding-bottom:4px;
}

th.DataSetColumnHeaderCell {
font-size:1em;
border:1px solid #98bf21;
padding:3px 7px 2px 7px;
}

span#1_1 {

}

span.DataSetColumnSpan {

}]]></styleSheet></raw>
</media></root>
7300 2014-08-23 18:18:28 Layout GetLayoutXml OUT
7299 2014-08-23 18:18:28 Layout GetLayoutXml IN
7298 2014-08-23 18:18:28 module Module created with MediaID: f31edb079e1d42c0e555dfc92d6d2059 LayoutID: 5 and RegionID: 53f84e1537b73
7297 2014-08-23 18:18:28 module Creating new module with MediaID: f31edb079e1d42c0e555dfc92d6d2059 LayoutID: 5 and RegionID: 53f84e1537b73
7296 2014-08-23 18:18:28 module SetMediaInformation Existing Assigned Media XML is: \n <?xml version="1.0"?>
<root><media id="f31edb079e1d42c0e555dfc92d6d2059" type="datasetview" duration="86400" lkid="" userId="1" schemaVersion="1">
<options><datasetid>1</datasetid><columns>1,2,3,4,5</columns><upperLimit>0</upperLimit><lowerLimit>0</lowerLimit><filter/><ordering/><showHeadings>1</showHeadings><duration>86400</duration><updateInterval>5</updateInterval><rowsPerPage>4</rowsPerPage></options>
<raw><styleSheet><![CDATA[table.DataSetTable {
font-family:"Trebuchet MS", Arial, Helvetica, sans-serif;
width:100%;
border-collapse:collapse;
}

tr.HeaderRow {
font-size:1.1em;
text-align:center;
padding-top:5px;
padding-bottom:4px;
background-color:rgb(255,0,0);
color:rgb(255,255,0);
}

tr#row_1 {
color:#000000;
background-color:#EAF2D3;
}

td#col_1 {
color:#000000;
background-color:#EAF2D3;
}

td.DataSetColumn {
color:#000000;
background-color:#EAF2D3;
border:1px solid #98bf21
}

tr.DataSetRow {
text-align:center;
color:#000000;
background-color:#EAF2D3;
border:1px solid #98bf21
padding-top:5px;
padding-bottom:4px;
}

th.DataSetColumnHeaderCell {
font-size:1em;
border:1px solid #98bf21;
padding:3px 7px 2px 7px;
}

span#1_1 {

}

span.DataSetColumnSpan {

}]]></styleSheet></raw>
</media></root>
7295 2014-08-23 18:18:28 Layout GetLayoutXml OUT
7294 2014-08-23 18:18:28 Layout GetLayoutXml IN
7293 2014-08-23 18:18:28 timeline Module created with MediaID: f31edb079e1d42c0e555dfc92d6d2059 LayoutID: 5 and RegionID: 53f84e1537b73
7292 2014-08-23 18:18:28 Layout GetLayoutXml OUT

Question information

Language:
English Edit question
Status:
Solved
For:
Xibo Edit question
Assignee:
No assignee Edit question
Solved by:
terencewp
Solved:
Last query:
Last reply:
Revision history for this message
Dan Garner (dangarner) said :
#1

Is the formatting incorrect in the CMS or in the client (or both) ?

Revision history for this message
terencewp (terencewp) said :
#2

The formatting is only incorrect on client side (i.e. Win 7), CMS preview is OK.

Revision history for this message
terencewp (terencewp) said :
#3

also tried andriod without any issue

Revision history for this message
Dan Garner (dangarner) said :
#4

Can you see if these registry settings have been applied correctly?

https://answers.launchpad.net/xibo/+faq/2246

Revision history for this message
terencewp (terencewp) said :
#5

Yes, I have applied the registry setting on both 32bit and 64-bit environment for IE11 as advised on your setting and MS web site before raising this question and it didn't solve my issue

Revision history for this message
Dan Garner (dangarner) said :
#6

I've just run a test here with that same CSS code you are using and it appears to work OK. Can you look in your client library for a called:

5_53f84e1537b73_f31edb079e1d42c0e555dfc92d6d2059.htm and put that somewhere we can download and see it?

Can you also try opening that file using Internet Explorer on the client PC?

Revision history for this message
terencewp (terencewp) said :
#7

sorry I don't know where to look for the client library, can you provide more detail information?

Revision history for this message
terencewp (terencewp) said :
#8

i've complied the ubuntu version and I'll use it instead of Win platform...thanks!