Get Jitbit-Tickets via WebService-API and display result as Table on Website, Excel-Download
€100-400 EUR
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.
ID Proyek: #9083764
Tentang proyek
Diberikan kepada:
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
17 freelancer rata-rata menawar €501 untuk pekerjaan ini
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
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
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
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
I look forward to discuss more details about the project requirements and deliver the same asap .
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
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