☰

Littlefield Exporter

Formats for given Excel spreadsheet

// ==UserScript==
// @name         Littlefield Exporter
// @namespace    http://your.homepage/
// @version      0.1
// @description  Formats for given Excel spreadsheet
// @author       You
// @match        http://sim.responsive.net/Littlefield/CheckAccess
// @grant        none
// ==/UserScript==

// a function that loads jQuery and calls a callback function when jQuery has finished loading
function addJQuery(callback) {
    var script = document.createElement("script");
    script.setAttribute("src", "//ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js");
    script.addEventListener('load', function() {
        var script = document.createElement("script");
        script.textContent = "window.jQ=jQuery.noConflict(true);(" + callback.toString() + ")();";
        document.body.appendChild(script);
    }, false);
    document.body.appendChild(script);
}

// the guts of this userscript
function main() {

    var transpose = function (a) {

        // Calculate the width and height of the Array
        var w = a.length ? a.length : 0,
            h = a[0] instanceof Array ? a[0].length : 0;

        // In case it is a zero matrix, no transpose routine needed.
        if(h === 0 || w === 0) { return []; }

        /**
   * @var {Number} i Counter
   * @var {Number} j Counter
   * @var {Array} t Transposed data is stored in this array.
   */
        var i, j, t = [];

        // Loop through every item in the outer array (height)
        for(i=0; i<h; i++) {

            // Insert a new row (array)
            t[i] = [];

            // Loop through every item per item in outer array (width)
            for(j=0; j<w; j++) {

                // Save transposed data.
                t[i][j] = a[j][i];
            }
        }

        return t;
    };



    var downloadPlot = function(plotName) {

        var data = jQ.ajax({
            async:false,
            method: "POST",
            url: "Plot1",
            data: { data: plotName, download: "download" }
        }).responseText.trim()
        return jQ.map(data.split("\n"), function(a) {
            return a.replace(/^.+	/,'').replace(',','')
        })
    }
    // Note, jQ replaces $ to avoid conflicts.
    var col = ["JOBIN","S1UTIL","S2UTIL","S3UTIL","S1Q","S2Q","S3Q","JOBOUT","JOBT","JOBREV"];
    var data = []
    jQ.each(col,function(i,column) {
        var downloaded = downloadPlot(column)
        data.push(downloaded)
    })
            
    var csvContent = "data:text/csv;charset=utf-8,";


data = transpose(data)
    data.forEach(function(infoArray, index){

        dataString = infoArray.join(",");
        csvContent += index < data.length ? dataString+ "\n" : dataString;

    }); 
    var encodedUri = encodeURI(csvContent);
    window.open(encodedUri); 
}

// load jQuery and execute the main function
addJQuery(main);