Selesai

WinForm Application "iWclockUp" to Upload Excel Data to clockodo time tracking with REST-API

Proyek ini berhasil diselesaikan oleh sheikDev dengan harga €150 EUR dalam 3 hari.

Dapatkan penawaran gratis untuk proyek seperti ini
Pemberi kerja bekerja
Anggaran Proyek
€30 - €250 EUR
Diselesaikan Dalam
3 hari
Total Penawaran
10
Deskripsi Proyek

Want a winform app where user can enter/select excel file as well as a mapping.

A mapping refers excel column to clockodo field.

For proper upload with the REST-API there is needed IDs for certain fields, depending on the mapping.

The IDs can be retrieved with other REST-API

Before upload any record all entries must be checked for correct IDs and other correct data.

Only if all data is correct, the upload can be done.

REST-API documentation: from [url removed, login to view]

=> Sample "FixCustProj"

User must select Customer and Project from Combo

Blank lines can be ignored

The descriptional text is always at next line to the data line

Ignore the line with "Endsumme"

Col 1: Employee

Col 2: Date

Col 3: Time from

Col 4: Time to

Col 5: Break in min

Col 7: h

Col 8: Time Traveling

Col 9: km travelled

Col 10: expenses

Col 11: comments to expenses

POST entries with

customers_id => user selects

services_id => "Consulting" for normal entry, "Travelling" for travel col 8, "Car used" for col 9 entries, "Expenses" if col 10

billable => fix "1"

users_id => id of employee col 1

duration => col 7 (h), needs to translated to sec, only for normal entry

lumpSum => col 10

projects_id => user selects

text => normal entry: taken from next line col 2, expenses: col 11

time_since => col 3

time_until => col 4

=> Sample "FixCust"

User must select Customer from Combo

Blank lines can be ignored

Ignore the line with "Summe"

Col 1: Employee

Col 2: Date

Col 3: h

Col 4: Project

Col 5: Text

Col 6: Travelling indicator

Col 7: Hotel

Col 8: Info

POST entries with

customers_id => user selects

services_id => "Consulting" for normal entry, "Travelling" for travel col 6, "Expenses" if col 7

billable => fix "1"

users_id => id of employee col 1

duration => col 3 (h), needs to translated to sec, only for normal entry

lumpSum => col 7

projects_id => id of project col 4

text => normal entry: taken from next line col 8, expenses: "Hotel"

Ingin menghasilkan uang?

  • Atur anggaran Anda dan jangka waktunya
  • Uraikan proposal Anda
  • Dapatkan bayaran atas pekerjaan Anda

Pekerjakan para freelancer yang juga menawar di proyek ini

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online