Skip to content

Latest commit

 

History

History
64 lines (45 loc) · 2.49 KB

README.md

File metadata and controls

64 lines (45 loc) · 2.49 KB
Raw

Import time entries to mite. from CSV file.

Import time tracking data from CSV data source using RESTful Webservices provided by mite.api (wrapped by mite-rb - The official ruby library for interacting with the RESTful mite.api).

Features

  • auto create mite. project records - if not found by project name
  • auto create mite. customer records and project relation - if project name didn't exist
  • auto create mite. service records - if not found by service name
  • auto create mite. time entries - if tracked time greater than 0 minutes
  • display stats about created mite. records

Example Output

-------------------------------------------
          mite. API CSV Import            
-------------------------------------------
 - import to account 'YOUR MITE ACCOUNT'.
 - 5 rows processed.
 - 3 customer(s) created.
 - 5 project(s) created.
 - 1 service(s) created.
 - 5 time entries created.
-------------------------------------------

Prerequisites

  • Ruby (tested with ruby 1.9.2p290)

Setup

Install required gems (see Gemfile) - preferably using Bundler:

bundle install

Usage

Provide CSV file - have a look at example.csv file for format reference.

Rename configuration.yml.dist to configuration.yml and adjust to your needs.

Notes

  • Make sure your CSV file is valid, e.g. proper use of text delimiter, etc.
  • Don't forget to provide proper column header mapping!

Execute importer

ruby importer.rb

Development Environment