Gruntfile.js

/*global module:false*/

var request = require('request');
var fs = require('fs');
// var tabletop = require('tabletop');
var papaparse = require('papaparse');
// File URL
var file = './Infancia.csv';
var content = fs.readFileSync(file, "utf8");
// var file = 'https://docs.google.com/spreadsheets/d/1osA88sQDYy6Q-Aw4oNbyYaMbAnQAI6t66Iv_6GLRNvA/edit?usp=sharing';
// var public_spreadsheet_url = 'https://docs.google.com/spreadsheets/d/1ccdoL4b3sxboLIj-BkOCjfRJMLVcDQcwtlv8fFCLoxQ/edit?usp=sharing';
// var public_spreadsheet_url = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vR9m-_WZjM9_jM8nXK0EPxnUaSlugsIQ65N2faj5KmcHLa1_EFyfMncBL4TwmDjcU4d_fvVI1AS0wqD/pub?gid=1823583981&single=true&output=csv';


var current_branch = 'gh-pages';

function functiontofindIndexByKeyValue(arraytosearch, key, valuetosearch) {
    for (var i = 0; i < arraytosearch.length; i++) {

        if (arraytosearch[i][key] == valuetosearch) {
        return i;
        }
    }
    return -1;
}

module.exports = function(grunt) {
  grunt.loadNpmTasks('grunt-git');
  // Project configuration.
  grunt.initConfig({
    gitcommit: {
        data: {
         options: {
             'allowEmpty': true
          },
          files: [
            {
              src: ["_data/categories_by_macro.json","_data/data_categories.json", "_data/macro_areas.json",  "_data/totales.json"],
              expand: true,
            }
          ]
        },
      },
    gitadd: {
        task: {
          options: {
            force: true
          },
          files: {
              src: ["_data/categories_by_macro.json","_data/data_categories.json", "_data/macro_areas.json",  "_data/totales.json"],
          }
        }
      },
    gitpush: {
        data: {
            options: {
                "remote": "origin",
                'branch': current_branch,
                "force": true
          }
        }
      },
    gitpull: {
        data: {
            options: {
                "remote": "origin",
                "branch": current_branch
            }
        }
    }
  });

  // These plugins provide necessary tasks.

  // Default task.
    grunt.registerTask('UpdateData', 'Va a buscar las cosas a google docs y las deja en un json', function() {
      console.log("log1")
        var done = this.async();
      console.log("log2")
//        function showInfo(data, tabletop){console.log(tabletop.models.promesas.elements)}
console.log(papaparse)
        console.log("log3")
        // var i = tabletop.init({key: public_spreadsheet_url, callback: function(data, tabletop){
        var i = papaparse.parse(content,{complete: function(results){
          console.log("log4")
          console.log(results)
             data = results.data;
             var all_promises = data;
             var totales = []

            /**
            Get Totales
            **/
            var totales_counter = 1;
            for (var i=0; i < all_promises.length; i++){
                if(functiontofindIndexByKeyValue(totales, "macro_area", all_promises[i].macro_area) == -1){

                    totales.push({
                        "id": totales_counter,
                        "macro_area": all_promises[i].macro_area,
                        "quality_macro_area": all_promises[i].quality_macro_area,
                        "fulfillment_macro_area": Number((all_promises[i].fulfillment_macro_area * 100).toFixed(1))
                    })
                    totales_counter++;
                }

            }
            grunt.file.write("_data/totales.json", JSON.stringify(totales, null, 4))

            /**
            Get Macro Areas
            **/

            var macro_areas = []
            var macro_areas_counter = 0;
            for (var i=0; i < all_promises.length; i++){
                if(functiontofindIndexByKeyValue(macro_areas, "macro_area", all_promises[i].macro_area) == -1){
                    macro_areas.push({
                        "id":macro_areas_counter,
                        "macro_area": all_promises[i].macro_area,
                        "quality_macro_area": all_promises[i].quality_macro_area,
                        "fulfillment_macro_area": Number((all_promises[i].fulfillment_macro_area * 100).toFixed(1))
                    })
                    macro_areas_counter++;
                }
            }
            var data_string = JSON.stringify(macro_areas, null, 4);
            grunt.file.write("_data/macro_areas.json", data_string)

            /**
            Get Categories and promises
            **/
            var macro_areas = []
            var datas = all_promises
            var macro_categories = {};
            var data_categories = {};
            for(var i=0; i < datas.length; i ++){
                var promise = datas[i];
                if(Object.keys(macro_categories).indexOf(promise.macro_area) == -1){
                    macro_categories[promise.macro_area] = []
                }
                if(Object.keys(data_categories).indexOf(promise.category) == -1){
                    data_categories[promise.category] = []
                }
                if(functiontofindIndexByKeyValue(macro_categories[promise.macro_area], "category", promise.category) == -1){
                    macro_categories[promise.macro_area].push({"category": promise.category})
                }
                data_categories[promise.category].push(promise)

            }
            var data_categories_as_string = JSON.stringify(data_categories, null, 4);
            var data_string = JSON.stringify(macro_categories, null, 4);
            grunt.file.write("_data/categories_by_macro.json", data_string)
            grunt.file.write("_data/data_categories.json", data_categories_as_string)

            done()
        }
        , download: false, header: true, delimiter: ",", skipEmptyLines: true})
console.log("nada")


    });
    grunt.registerTask("UpdateEverything", ['gitadd', 'gitcommit', 'gitpull', 'gitpush'])

};

/** Temporalmente está borrado 'UpdateData' del registerTask de grunt para que suba sólo los json  **/