This is a Google Sheets add-on. By using this add-on, you can import time tracking data in Toggl to your Redmine as time entries.

Toggl2Rm has the following features,

• Get detail report from Toggl, and write them to active sheet.
• Add time entries to Redmine from active sheet.

1. Clone this repository

   $ git clone https://github.com/HeRoMo/toggl2rm.git
   $ cd toggl2rm

2. Install packages

   $ yarn install

3. Login to Google.

   $ yarn login

4. Turn ON your Google Apps Script API
   Access to https://script.google.com/home/usersettings and turn on Google Apps Script API. If already ON, skip this step.
5. Create Google Apps Script for toggl2rm

   $ yarn create_gas

   The script file named 'taggl2rm' is created in your Google Apps Script.
6. Upload files to Google Apps Script.

   $ yarn deploy

7. Run as test.
   see Test an Add-on
   • Non-published add-on can be executed as only test.

1. Setting Toggl and Redmine properties
   Open Setting Dialog by Menu Add-on > Toggl2Rm > 設定
   Set the following properties,
   • Toggl API TOKEN
   • Redmine Server
   • Redmine API KEY
   • BASIC Authorization (Optional)
     • User Name
     • Password
2. Open sidebar
   You can open sidebar by menu Add-on > Toggl2Rm > サイドバーを開く
3. Select Workspace and 年月, which you want to get report.
4. Select which all data or ticket data.
5. Push 読み出し button.
   Notice: Active sheet will be overwritten by add-on.

1. Push 時間を登録 Button
   All rows in active sheet send to your Redmine server.

   Notice: only data that has ticketId are sent to Redmine.

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.