XenCarta meets Google API tables

[Moses]

I've put together an Excel template which simplifies the process of inserting Google API tables into XenCarta. Still needs work, at this stage it's more a proof of concept and I'm hoping to get feedback to improve it and simplify the process for users.

You can download it from the demo page
http://www.greenandgoldrugby.com/community/wiki/google-table-test/

Thanks to Brogan for his help with Google API tables.

 

[Paul B]

Be aware that you can override the Google CSS, even though they don't explicitly explain how to do it.

Unfortunately, it has to be included in the page otherwise certain elements don't change.
It's a pain but it's better than having the Google washed out blue-grey style.

 

[Digital Doctor]

So this is a table in the Google Cloud and it will display in a xenforo page.
Is this the Google Tables you used ?
http://www.google.com/fusiontables/public/tour/index.html

 

[Paul B]

It's explained in more detail here: http://xenforo.com/community/thread...-bb-code-and-googles-visualization-api.11915/

 

[Moses]

So this is a table in the Google Cloud and it will display in a xenforo page.
Is this the Google Tables you used ?
http://www.google.com/fusiontables/public/tour/index.html

It'll display in a XenCarta page - to put it in a XenForo page you need to write the HTML, or modify the Excel template.

It's not using fusion tables, looks like they are for mapping

 

[Moses]

Be aware that you can override the Google CSS, even though they don't explicitly explain how to do it.

Unfortunately, it has to be included in the page otherwise certain elements don't change.
It's a pain but it's better than having the Google washed out blue-grey style.

Thanks Brogan,
I've been looking at how you achieved done this - passing the classes in the options tag. Noticed you wrote a function, think I'll just embed the CSS in the table call

 

[Moses]

Version 0.2 is now attached over here (no .xlsx attachments allowed on XF sorry).
http://www.greenandgoldrugby.com/community/wiki/google-table-test/

This version caters for 3, 4, 5, and 6 column tables.
There's now just one cell to copy / paste into XenCarta.
CSS has been applied with thanks to Brogan.

 

[Moses]

Brogan, or anyone else, how do I stop the tables taking so much width? Seems Google are inserting a style tag in the header with a hardcoded and massive pixel fixed size?? That massive fixed size seems dependant on my browser size when I load the page, here is the opening HTML rendered for two window sizes

<table class="google-visualization-table-table" cellspacing="0" style="width: 1113px; "><tbody><tr class="cta_table_row_header"><td class="cta_table_cell_header google-visualization-table-sorthdr">Year<span class="google-visualization-table-sortind">

<table class="google-visualization-table-table" cellspacing="0" style="width: 1522px; "><tbody><tr class="cta_table_row_header"><td class="cta_table_cell_header google-visualization-table-sorthdr">Year<span class="google-visualization-table-sortind">

 

[Moses]

I got it close by setting the width property in the options function, it's still 100% but at least it doesn't pop below the floated div to the bottom now

var options = {
'cssClassNames': css,
'allowHtml': true,
'width': 'auto'
};

 

[Moses]

Latest version avoids strings being terminated early by a ' by changing these to the smart quote equivalent.

Next version to handle dates....

 

[Andy.N]

Latest version avoids strings being terminated early by a ' by changing these to the smart quote equivalent.

Next version to handle dates....

Any new update?

 

[Moses]

Yeah, currently articles with lots of tables are causing the XenCarta template thingy to timeout... so I'm looking to port it into KingK's BBCode Manager