Skip to content

Latest commit

 

History

History
66 lines (54 loc) · 2.55 KB

README.md

File metadata and controls

66 lines (54 loc) · 2.55 KB

First run

  • Go to the site with documentation and click on the "Enable the Google Sheets API" button. Then download the file credentials.json and move it to the root folder of the project.
  • Run the code / binary. The program will ask you to log in using your Google account. Then insert the token into the console. Arguments at the first start of the program: google update

Run

Run the program with the run argument

Config file

Env

Name Description Is Required? Default
spreadsheet_id ID of the Google Spreadsheet + -
starting_time Unix-time from which time to collect issue - 0 (collects issues of any date)
tmpl_sheet_id ID of the Google sheet where the table will be copied from. This is convenient if your table has a layout - If omitted, the table is created
services List of the control version systems (cvs) when this script will collect data + -
services.* Service name. This is a special key that cannot be changed after the first launch + -
services.type Type of API the script will use. Currently only gitlab is available + -
services.url API address + -
services.available Availability level. external - the script will collect all issues, internal - the script will collect issues with only only created by you or assigned on you - external
services.token Token of the user who will collect issues from cvs + -
members List of members that the script will navigate by if availability is internal - -
members.* Members name. This is a special key that cannot be changed after the first launch + -
name First/Last name + -
members.services List of cvs that users are connected to by key-value type. The key is the name of the cvs that you described above, and the value is the user's username in this system + -

Example:

spreadsheet_id: 'code'

starting_time: 0
tmpl_sheet_id: 0

services:
  test-internal:
    type: 'gitlab'
    url: 'http://gitlab.com/api/v4'
    available: 'internal'
    token: '1234456789qwerty'

  test-external:
    type: 'gitlab'
    url: 'http://self-hosted-gitlab.com/api/v4'
    available: 'external'
    token: '1234456789qwerty'

members:
  discore:
    name: 'Nikita'
    services:
      - test-external: 'discore'
      - test-internal: 'discoreme'
  alexey:
    name: 'Alexey'
    services:
      - test-internal: 'alexey'

Dev:

  • go get github.com/mattn/go-sqlite3 (which requires gcc)