Get Jitbit-Tickets via WebService-API and display result as Table on Website, Excel-Download

Selesai Dipasang Dec 9, 2015 Dibayar saat pengiriman
Selesai Dibayar saat pengiriman

Intro:

We are using a hostet Jitbit ticket system for our company ([login to view URL]). We need a way to view and export *all* existing tickets. To do so, we might give access rights to all users (which is something we do not want, because Jitbit does not differ write read rights). As alternative, we want you to program a HTML page getting all ticket data via API and show it as table.

Write PHP code:

1) Read all "non-custom" field values for all existing tickets via Jitbit Webservice API ([login to view URL]) plus Custom Field values ([login to view URL]): e.g. function "JSON to array"

2) Enrich all returned IDs (e.g. UserID) with real values (e.g. xyz[at][login to view URL]), e.g. function "[user|category|..]-ID to value"

3) Convert time stamps to a format that can be used for calculations in XLS when copy & paste table (or export, see 5)

4) Display result as HTML table: e.g. function "array to table"

5) Offer option to download values to XLS: e.g. function "array to XLS"

6) Easy to change config section (e.g. user & pwd-section, all used URLs for API calls, ..)

7) Documentation - put documentation as comments in source code..

8) Make table nice (text wrap, ..)

Challenges:

1) List of standard fields my vary/ change over time, so code must work even with changing field number & field names.

2) Same fields must be displayed in same column in output table; e.g.: some tickets may contain a field "option1", others not. Column number for a specific field my vary from ticket to ticket.

What we provide:

1) access to our ticket system, containing user & password for Webservice API Calls

2) Lets discuss, not sure yet: SSH access to Linux system incl right to install required modules (?)

Timeline:

Approx 4 weeks. We will agree due date. Estimated target date: middle of January.

Others?

Lets discuss topics I might have forgotten.

Update from 10.12.2015 - please check with your proposal:

A) Please add "limit" feature to HTML table , showing [20|50|100|all] tickets + navigation "previous|next page"
B) your invoice according german tax laws highly appreciated, see https://wiki.proz.com/wiki/index.php/Invoicing_requirements_for_Germany for details

Additional information:
A) no login mechanism needed; will be used only by little number of people & site will be locked using .htaccess
B) For now, show all columns available on screen & in export to XLS; this may change in later version.
C) No proxy or other data transport to other servers please; Due to limited usage (<10 calls per day) data security over speed.

Update 15.12.: make sure export/ table shows german umlaut correct (ÄäÖöÜüß)

Update 15.12.2015: We extended RfP period by 7 days because of internal clarification needs. Sorry for that.

Excel PHP Perancangan Perangkat Lunak Layanan Web

ID Proyek: #9083764

Tentang proyek

17 proposal Proyek online Aktif Dec 22, 2015

Diberikan kepada:

sureshdevi

I can create script to get jitbit tickets using their webservice api and display result as table on website and option to download the results in excel. I will complete this work in 10 days. Looking for your reply t Lebih banyak

€264 EUR dalam 10 hari
(1142 Ulasan)
8.0

17 freelancer rata-rata menawar €501 untuk pekerjaan ini

meet2amitvw

Let's discuss more about project to finalize the proper scope with estimated cost and time so ping me over the freelancer chat. I am myself developer so you will directly work with me. No mediators. No managers. No Lebih banyak

€1030 EUR dalam 15 hari
(166 Ulasan)
9.3
rinsadsl

Hello Good Day I went through the Jibit API. I also understood the challenges you have pointed out. I am quite confident to complete this project as per your expectation, within the time and budget. Looking forward Lebih banyak

€315 EUR dalam 15 hari
(1054 Ulasan)
8.8
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

€412 EUR dalam 15 hari
(449 Ulasan)
8.2
helmot

I have +10 years of experience in programming. I had a look at Jitbit API. I am expert in working with such RESTful APIs. I can easily handle chalenges you listed and deliver you working table with export functional Lebih banyak

€400 EUR dalam 5 hari
(182 Ulasan)
8.1
srinichal

I look forward to discuss more details about the project requirements and deliver the same asap .

€368 EUR dalam 3 hari
(162 Ulasan)
7.5
luminous15

Hello There I think I can help you out to achieve this task. Couple of questions though. 1. Do we need to handle login mechanism or is it already in place and we just need to provide a view to list tickets and exp Lebih banyak

€427 EUR dalam 30 hari
(48 Ulasan)
6.1
winspireweb

A proposal has not yet been provided

€368 EUR dalam 15 hari
(10 Ulasan)
5.1
ksaxena837

Hi there, I have reviewed the Jitbit API documentation and I believe that I can help you in writing a script that can: Write PHP code: 1) Read all custom and non-custom field values for all existing tickets via Lebih banyak

€1666 EUR dalam 35 hari
(2 Ulasan)
3.3