schepp/grunt-spreadsheet-to-json

Takes a Google Spreadsheet with translations and generates multiple JSON files from the columns.

grunt-spreadsheet-to-json's Issues

Warning: Cannot read property 'filter' of undefined Use --force to continue.

Trying to use with the following config similar to the docs:

module.exports = function(grunt) {
  grunt.initConfig({
    spreadsheet_to_json: {
      options: {
          keyfile: 'MY-APP-KEY-d2400e48869d.json',
          spreadsheetId: '1eCvbblOwZ---MYSPREADSHEET----rl0KP4xc89I'
      },
      content: {
        dest: 'translations/'
      }
    }
  });
  grunt.loadNpmTasks('grunt-spreadsheet-to-json');
};

Then the following code of this extensions throws an error:

            var src = f.src.filter(function (filepath) {
                // Warn on and remove invalid source files (if nonull was set).
                if (!grunt.file.exists(filepath)) {
                    grunt.log.warn('Source file "' + filepath + '" not found.');
                    return false;
                } else {
                    return true;
                }
            }).map(function (filepath) {
                // Read file source.
                return grunt.file.read(filepath);
            }).join(grunt.util.normalizelf(options.separator));

Since f.src is undefined we get the following error:

Warning: Cannot read property 'filter' of undefined Use --force to continue.

What kind of source files are expected exactly? As far as I understand the source is the spreadsheet and we just have a target file?

Thanks

source to keyfile

I had a problem with linking to the keyfile because I thought it was relative to the module instead of grunt root.

Thanks to @LaurentGoderre for the help on that.

Thanks

No being able to use it

Hi,

I've spent a time trying to use the grunt-spreadsheet-to-json but I'm not sure if I'm doing something wrong, even had reviewed sometimes.. maybe I'm missing something..

#Confirm that it's installed#

#Gruntfile#

#Key file and grunt file are on the same level#

#Running grunt#

Any help, tip is welcome.

thanks

Warning: Cannot find module 'config/auth.json' Use --force to continue.

I'm continually getting this error – the script can't seem to pick up my json keyfile from Google. Relevant section of my Gruntfile is below, any suggestions would be awesome. Thanks!

grunt.initConfig({
        spreadsheet_to_json: {
            options: {
                keyfile: 'config/auth.json'
            },
            translations: {
                options: {
                    spreadsheetId: 'MY_SPREADSHEET_ID',
                    ignoreColumns: ['annotations']
                },
                dest: 'assets/json'
            },
        },
    });