• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Google Table Generator 0.91

No permission to download

Moses

Well-known member
#1
Moses submitted a new resource:

Google Table Generator (version 0.9) - Excel template that creates BBcode to insert google API tables in your forum

This plugin allows you to create great looking sortable tables in your forums with no coding knowledge.

Installation
1. Install King Kovifor's BBCode Manager http://xenforo.com/community/resources/custom-bb-code-manager.173/
2. Upload the custom BBCode's included in the zip
3. Add the CSS in extra.css to your theme's extra.css

Usage
1. Open the BBCode generator in Excel (tested on 2010)
2. Choose the worksheet with the correct number of columns
3. Follow the...
Read more about this resource...
 

Brogan

XenForo moderator
Staff member
#3
The .zip is also missing the Google table script.

This is essentially just a repost of my table BB Code so I would drop the Google from the title.
 

Moses

Well-known member
#4
Nice work.
But the table with 6 columns is not working.
can you email me the .xlsx - PC sent

This is essentially just a repost of my table BB Code so I would drop the Google from the title.
Either I'm confused or we're on different pages here - I thought you had two table implementations - one using custom BBCode that pumped out static HTML tables, and the other that required hand-crafted HTML for someone familiar with HTML, CSS and JS?

This application uses Excel to generate custom BBCode which displays tables using the Google Visualisation API.
 
#8
This is not generating a table at all for me, this is what I get :
Code:
[gtable_top=500][/gtable_top][gtable_add_row_count]8[/gtable_add_row_count][gtable_add_col=string][gtable_add_col=integer]Names[/gtable_add_col][/gtable_add_col][gtable_add_col=number][gtable_add_col=integer]Post Sart[/gtable_add_col][/gtable_add_col][gtable_add_col=number][gtable_add_col=integer]Post end[/gtable_add_col][/gtable_add_col][gtable_add_col=number][gtable_add_col=integer]Pred Corr[/gtable_add_col][/gtable_add_col][gtable_add_col=number][gtable_add_col=integer]Pred Wrng[/gtable_add_col][/gtable_add_col][gtable_add_col=number][gtable_add_col=integer]Total[/gtable_add_col][/gtable_add_col][gtable_add_data=0, 0]'Jack'[/gtable_add_data][gtable_add_data=0, 1]1100[/gtable_add_data][gtable_add_data=0, 2]3007[/gtable_add_data][gtable_add_data=0, 3]121[/gtable_add_data][gtable_add_data=0, 4]136[/gtable_add_data][gtable_add_data=0, 5]417.7[/gtable_add_data][gtable_add_data=1, 0]'Robbo'[/gtable_add_data][gtable_add_data=1, 1]433[/gtable_add_data][gtable_add_data=1, 2]877[/gtable_add_data][gtable_add_data=1, 3]83[/gtable_add_data][gtable_add_data=1, 4]72[/gtable_add_data][gtable_add_data=1, 5]221.4[/gtable_add_data][gtable_add_data=2, 0]'RJH'[/gtable_add_data][gtable_add_data=2, 1]0[/gtable_add_data][gtable_add_data=2, 2]199[/gtable_add_data][gtable_add_data=2, 3]38[/gtable_add_data][gtable_add_data=2, 4]34[/gtable_add_data][gtable_add_data=2, 5]99.9[/gtable_add_data][gtable_add_data=3, 0]'Lim'[/gtable_add_data][gtable_add_data=3, 1]170[/gtable_add_data][gtable_add_data=3, 2]1092[/gtable_add_data][gtable_add_data=3, 3]93[/gtable_add_data][gtable_add_data=3, 4]101[/gtable_add_data][gtable_add_data=3, 5]270.2[/gtable_add_data][gtable_add_data=4, 0]'ReddevilinAZ'[/gtable_add_data][gtable_add_data=4, 1]58[/gtable_add_data][gtable_add_data=4, 2]656[/gtable_add_data][gtable_add_data=4, 3]82[/gtable_add_data][gtable_add_data=4, 4]91[/gtable_add_data][gtable_add_data=4, 5]214.8[/gtable_add_data][gtable_add_data=5, 0]'Famous Uj'[/gtable_add_data][gtable_add_data=5, 1]407[/gtable_add_data][gtable_add_data=5, 2]446[/gtable_add_data][gtable_add_data=5, 3]5[/gtable_add_data][gtable_add_data=5, 4]5[/gtable_add_data][gtable_add_data=5, 5]13.9[/gtable_add_data][gtable_add_data=6, 0]'ErogenousOwen'[/gtable_add_data][gtable_add_data=6, 1]0[/gtable_add_data][gtable_add_data=6, 2]67[/gtable_add_data][gtable_add_data=6, 3]3[/gtable_add_data][gtable_add_data=6, 4]6[/gtable_add_data][gtable_add_data=6, 5]9.7[/gtable_add_data][gtable_add_data=7, 0]'Tindris'[/gtable_add_data][gtable_add_data=7, 1]0[/gtable_add_data][gtable_add_data=7, 2]19[/gtable_add_data][gtable_add_data=7, 3]4[/gtable_add_data][gtable_add_data=7, 4]5[/gtable_add_data][gtable_add_data=7, 5]8.9[/gtable_add_data][gtable_end=table_name_6col]table_name_6col[/gtable_end]
this is what I am trying to display :


Post Start Post End Pred corr Pred Wrng Total
Jack 1100 3007 121 136 417.7
Robbo 433 877 83 72 221.4
RJH 0 199 38 34 99.9
Lim 170 1092 93 101 270.2
ReddevilinAZ 58 656 82 91 214.8
Famous Uj 407 446 5 5 13.9
ErogenousOwen 0 67 3 6 9.7
Tindris 0 19 4 5 8.9
 
#9
This is not generating a table at all for me, this is what I get :
Code:
[gtable_top=500][/gtable_top][gtable_add_row_count]8[/gtable_add_row_count][gtable_add_col=string][gtable_add_col=integer]Names[/gtable_add_col][/gtable_add_col][gtable_add_col=number][gtable_add_col=integer]Post Sart[/gtable_add_col][/gtable_add_col][gtable_add_col=number][gtable_add_col=integer]Post end[/gtable_add_col][/gtable_add_col][gtable_add_col=number][gtable_add_col=integer]Pred Corr[/gtable_add_col][/gtable_add_col][gtable_add_col=number][gtable_add_col=integer]Pred Wrng[/gtable_add_col][/gtable_add_col][gtable_add_col=number][gtable_add_col=integer]Total[/gtable_add_col][/gtable_add_col][gtable_add_data=0, 0]'Jack'[/gtable_add_data][gtable_add_data=0, 1]1100[/gtable_add_data][gtable_add_data=0, 2]3007[/gtable_add_data][gtable_add_data=0, 3]121[/gtable_add_data][gtable_add_data=0, 4]136[/gtable_add_data][gtable_add_data=0, 5]417.7[/gtable_add_data][gtable_add_data=1, 0]'Robbo'[/gtable_add_data][gtable_add_data=1, 1]433[/gtable_add_data][gtable_add_data=1, 2]877[/gtable_add_data][gtable_add_data=1, 3]83[/gtable_add_data][gtable_add_data=1, 4]72[/gtable_add_data][gtable_add_data=1, 5]221.4[/gtable_add_data][gtable_add_data=2, 0]'RJH'[/gtable_add_data][gtable_add_data=2, 1]0[/gtable_add_data][gtable_add_data=2, 2]199[/gtable_add_data][gtable_add_data=2, 3]38[/gtable_add_data][gtable_add_data=2, 4]34[/gtable_add_data][gtable_add_data=2, 5]99.9[/gtable_add_data][gtable_add_data=3, 0]'Lim'[/gtable_add_data][gtable_add_data=3, 1]170[/gtable_add_data][gtable_add_data=3, 2]1092[/gtable_add_data][gtable_add_data=3, 3]93[/gtable_add_data][gtable_add_data=3, 4]101[/gtable_add_data][gtable_add_data=3, 5]270.2[/gtable_add_data][gtable_add_data=4, 0]'ReddevilinAZ'[/gtable_add_data][gtable_add_data=4, 1]58[/gtable_add_data][gtable_add_data=4, 2]656[/gtable_add_data][gtable_add_data=4, 3]82[/gtable_add_data][gtable_add_data=4, 4]91[/gtable_add_data][gtable_add_data=4, 5]214.8[/gtable_add_data][gtable_add_data=5, 0]'Famous Uj'[/gtable_add_data][gtable_add_data=5, 1]407[/gtable_add_data][gtable_add_data=5, 2]446[/gtable_add_data][gtable_add_data=5, 3]5[/gtable_add_data][gtable_add_data=5, 4]5[/gtable_add_data][gtable_add_data=5, 5]13.9[/gtable_add_data][gtable_add_data=6, 0]'ErogenousOwen'[/gtable_add_data][gtable_add_data=6, 1]0[/gtable_add_data][gtable_add_data=6, 2]67[/gtable_add_data][gtable_add_data=6, 3]3[/gtable_add_data][gtable_add_data=6, 4]6[/gtable_add_data][gtable_add_data=6, 5]9.7[/gtable_add_data][gtable_add_data=7, 0]'Tindris'[/gtable_add_data][gtable_add_data=7, 1]0[/gtable_add_data][gtable_add_data=7, 2]19[/gtable_add_data][gtable_add_data=7, 3]4[/gtable_add_data][gtable_add_data=7, 4]5[/gtable_add_data][gtable_add_data=7, 5]8.9[/gtable_add_data][gtable_end=table_name_6col]table_name_6col[/gtable_end]
this is what I am trying to display :


Post Start Post End Pred corr Pred Wrng Total
Jack 1100 3007 121 136 417.7
Robbo 433 877 83 72 221.4
RJH 0 199 38 34 99.9
Lim 170 1092 93 101 270.2
ReddevilinAZ 58 656 82 91 214.8
Famous Uj 407 446 5 5 13.9
ErogenousOwen 0 67 3 6 9.7
Tindris 0 19 4 5 8.9

Apologies, this is now working fine, I was being too impatient, you have to wait a few moments, I find I have to refresh my browser then the table appears
 

Moses

Well-known member
#10
Apologies, this is now working fine, I was being too impatient, you have to wait a few moments, I find I have to refresh my browser then the table appears
I find the same thing - while normal posts will appear with AJAX when you click post, this requires the javascript to load with the page for it to show.
 
#11
How would I do this:

Currently this will parse HTML, so there's a potential security hole there. If you don't want HTML to be parsed, change it in the gtable_top BBCode.
I don't see an option in the BBCode manager to "disable HTML parsing" :(
 

Moses

Well-known member
#12
The start replacement in gtable_top needs to be edited

If you want to disable HTML in tables, change it from this
Code:
<script type='text/javascript' src='https://www.google.com/jsapi'></script>    <script type='text/javascript'>      google.load('visualization', '1', {packages:['table']});      google.setOnLoadCallback(drawTable);      function drawTable() {        var css = {'headerRow': 'cta_table_row_header','tableRow': 'cta_table_row','oddTableRow': 'cta_table_row_odd','selectedTableRow': 'cta_table_row_selected','hoverTableRow': 'cta_table_row_hover','headerCell': 'cta_table_cell_header','tableCell': 'cta_table_cell','rowNumberCell': 'cta_table_cell_number' };  var options = {'cssClassNames': css,'allowHtml': true,'width': '%spx'};
to this
Code:
<script type='text/javascript' src='https://www.google.com/jsapi'></script>    <script type='text/javascript'>      google.load('visualization', '1', {packages:['table']});      google.setOnLoadCallback(drawTable);      function drawTable() {        var css = {'headerRow': 'cta_table_row_header','tableRow': 'cta_table_row','oddTableRow': 'cta_table_row_odd','selectedTableRow': 'cta_table_row_selected','hoverTableRow': 'cta_table_row_hover','headerCell': 'cta_table_cell_header','tableCell': 'cta_table_cell','rowNumberCell': 'cta_table_cell_number' };  var options = {'cssClassNames': css,'allowHtml': false,'width': '%spx'};
 

Moses

Well-known member
#14
I don't seem to be achieving the same fancy styling as yours :

http://www.manutdreds.net/threads/league-table.1/

Is this because of my theme ?
Yep, it's based off the colours in your theme,
to switch them around you can edit the piece in extra.css
Which bit did you want to change?

I reckon it looks pretty good on your site with one change - the text colour in the column headings changed to white. To achieve this, edit extra.css and change the color attribute in .cta_table_cell_header to #ffffff

ie:
.cta_table_cell_header {color: #ffffff;}
 

tajhay

Well-known member
#19
This is an old addon and should be deleted.

Waindigo has an addon that generates tables. Search for it. Either that or start using BBCodes for it. Brogan has a resource containing bbcodes to create tables.