creating Parse Classes from Google Spreadsheets

Just as in parse.com - nosql database for VBA, you'll probably want to load up some test data from a Google Spreadsheet to a Parse.com class.  You'll find some test data in this workbook - it's same data as we used from Excel.

Here's the code you'll need (after making a reference to your parseCom script as described in parse.com - noSQL database for GAS), to create 2 new classes in your parse.com database.

function testPopulate() {
  populateFromName ("gasParseCustomers");
  populateFromName ("gasParseData");
}
function populateFromName (sheetName) {
   parseCom.populateFromSheetValues(SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName).getDataRange().getValues(), sheetName);
}

In the Examples code in the parseCom library you copied there is some code that knows how to populate parse.com from spreadsheet data.

For more on this see parse.com - noSQL database for GAS.
For help and more information join our forumfollow the blogfollow me on twitter

You want to learn Google Apps Script?

Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, All formats are available from O'ReillyAmazon and all good bookshops. You can also read a preview on O'Reilly

If you prefer Video style learning I also have two courses available. also published by O'Reilly.
Google Apps Script for Developers and Google Apps Script for Beginners.

Comments