In Progress

Web Dashboard from Vendor's API ( Part 1)

Hi,

Please forgive a poor description. I'm a professional IT Tech, but have little programming knowledge.

This is PART 1 of a possibly 3 part project. This part is a Proof of Concept, checking that the information required can be retrieved. Part 2 would be more comprehensive. Part 3 would be making some refinements (possibly major, depending on feedback from friends who also would like to use this).

We use an application called CommitCRM for our job management. Client details are entered once, and for each client we can enter new Tickets (jobs) and add billable time to each ticket, as well as assigning a Status to the ticket (new, in progress, closed). Time billed (a Charge) is listed against a technician's name, and multiple technicians may work on a ticket, or a single technician may enter multiple Charges in a ticket in a single day.

Currently it is not easy to see how efficiently we are working, and how much of our working time is invoiced to a client. There are reports available, but they are text based, and I would like to see this information presented graphically on a big screen in our office in near real time, along with some other information about jobs that require attention.

The software developer publish an API which should allow easy access to most or all of the information we need. Information is available here:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

What I have in mind is a very simple application which is launched from Windows Task Scheduler. It reads some parameters from a configuration file, then retrieves information using the API about labour charges for the current day. It would need to run some calculations on these, and then output a basic static HTML file (which will be displayed separately).

Requirements for the output HTML file for this Proof of Concept are:

- It does not need to be pretty. We are just checking the information is retrievable.

SECTION 1 (simply divide sections with a horizontal line)

- List of employees who have submitted billable labour charges that day.

- Their first Start time and last Finish time for charges in that day

- The number of hours they charged (add up the charged Hours for today)

SECTION 2

- List of Tickets that are overdue (a Due Date before today's date), just showing the Ticket Number

- List of Tickets not modified in the last 3 days (is there is no Last Modified date available, then tickets with no Labour charge in the last 3 days).

You will possibly need to install a trial version of CommitCRM at your site. We can assist with requesting an extension to the Trial Period as we have a good relationship with the software vendor.

We will make available a Windows XP Professional or Windows 7 Professional computer at our site with a copy of our CommitCRM installation, and give you Remote Desktop access. You would be welcome to install your development tools on this computer if desired, or simply use it for testing with live data.

The attached files are a simple hand drawing of how the output will look when Part 2 of the project is complete, and a sample charge (showing Start and Finish times that show around 1.2 hours was spent on this, but only 0.8 hours was charged).

Skills: HTML, Visual Basic

See more: work remote jobs, work line jobs, work computer jobs, windows remote jobs, windows developer jobs, web wiki software, web site programming job, web site development tools, web programming jobs, web office live, web jobs development, web development software list, web development remote jobs, web development job requirements, web development charges, web developer wiki, web developer requirements job, web developer professional project, web developer line, web developer jobs line, web developer job requirements, web developer job application, web developer charges, web based jobs, web application make development

About the Employer:
( 0 reviews ) Auckland, New Zealand

Project ID: #1274678

Awarded to:

martinkemp

HELLO SIR PLEASE CHECK PMB

$250 NZD in 6 days
(0 Reviews)
0.0

3 freelancers are bidding on average $233 for this job

ABKrish

Hi I am having 12+ years of experience in software development mainly using microsoft technologies. I am a Microsoft certified professional in C#.NET

$250 NZD in 21 days
(3 Reviews)
4.0
AvulaVijayaChand

Hi I am a IT professional Working on similar kind of automation, I can help you on the Described Requirement.

$200 NZD in 4 days
(0 Reviews)
0.0