cordpub.js

A javascript library for making formatted tables using data from Google Sheets.

Requirements

• d3.js: http://d3js.org/d3.v3.js
• Google Visualization API: http://www.google.com/jsapi

Usage

Create table in Google Sheets

Sheet should have a header row with column labels and then rows of data. See https://docs.google.com/spreadsheets/d/1hkE7P_fHrtiIFAx53xDyUl3gNOp4MSIYLrEwZIJWcaw as an example.

Includes

Include d3 and google jsapi in the html header

<script type="text/javascript" src="http://d3js.org/d3.v3.js" charset="utf-8"></script>
<script type="text/javascript" src="http://www.google.com/jsapi" charset="utf-8"></script>
<script type="text/javascript" src="cordpub.js" charset="utf-8"></script>

Initialize

Create templates json

formats = {
            "Patent": '<div class="row"><div class="type_count col">[P%%Counter%%]</div><div class="citation col">%%Authors%%, %%Title%%, %%Misc_Description%%, %%Month%% %%Year%%.</div></div>',
            "Conference": '<div class="row"><div class="type_count col">[C%%Counter%%]</div><div class="citation col">%%Authors%%, "%%Title%%," in <i>Proc. %%Venue%%</i>, pp. %%Pages%%, %%Location%%, %%Month%% %%Year%%.<br>[<a href="https://scholar.google.com/scholar?cites=%%Google_ID%%">cites</a>]</div></div>',
            "Journal": '<div class="row"><div class="type_count col">[J%%Counter%%]</div><div class="citation col">%%Authors%%, "%%Title%%," <i>%%Venue%%</i>, vol. %%Volume%%, no. %%Number%%, pp. %%Pages%%, %%Month%% %%Year%%.<br>[<a href="https://scholar.google.com/scholar?cites=%%Google_ID%%">cites</a>]</div></div>',
            "Thesis": '<div class="row"><div class="type_count col">[T%%Counter%%]</div><div class="citation col">%%Authors%%, <i>%%Title%%</i>, %%Misc_Description%%, %%Month%% %%Year%%.</div></div>'
        };

Add div for each json key

  <div id="Journal"></div>
  <div id="Conference"></div>
  <div id="Patent"></div>
  <div id="Thesis"></div>

Add div for author list and chord plot

  <div id="chord_vis"></div>
  <div id="author_list"></div>

Start cord-pub

var cord = new cordpub.cordpub({
    "key":'1hkE7P_fHrtiIFAx53xDyUl3gNOp4MSIYLrEwZIJWcaw',
    "formats": formats,
    "author_list_div": "author_list",
    "cord_plot_div": "chord_vis",
    "colorRange": d3.scale.category20c(),
    "print_headers": true,
    "sort_clause": "order by %%Year%% asc, %%Month%% asc"
});
cord.init();

Examples

See the example/ folder.