Skip to content

About

No description, website, or topics provided.

Resources

Stars

0 stars

Watchers

4 watching

Forks

Latest commit

 

History

19 Commits

Folders and files

Repository files navigation

ImportScripts

This is a Google Apps script that can be uploaded to Google Sheets via 'Script Editor'.

The purpose of this script is to upload external data sets to the RefugeeProjects.com database. External data sources can either be included as a URL or within a specified Google Drive folder.

Add a data set as an to sources for it to be included in the import:

var sources = {
  'source-name': {
    pathUrl: 'http://...',
    type: sourceType.urlSpreadSheet,
    translateFrom: 'language here',
    mappings: [
      [sourceColumnIndex, destinationColumnIndex],
      [1,1],
      [0,5],
      [6,2]
    ]
  }
};

You can also add a helper file to source-mappings and name it according to the name of the data set. The structure of source-mappings is as follows:

---
Name: Source Name
Subsheet: False
URL: 'https://docs.google.com/spreadsheets/d/#YOUR-ID-HERE',
Date: <date>
---

[columnID] - [columnName]

[0] - Name
[1] - Organization Name
[2] - Organization Category
[3] - Problem
[4] - Solution
[5] - Facebook URL
[6] - Website
[7] - Email
[8] - Notes

Alternatively, the header may contain something like the following:

Subsheet: True
Sheet GID: <number>
Sheet Index: <number>

Please make a new branch if you'd like to add any data sources to the ImportData.js script for import to the RefugeeProjects.com database.

About

No description, website, or topics provided.

Resources

Stars

0 stars

Watchers

4 watching

Forks

Releases

Packages

Contributors

Languages