ICT705 Data Integration: Clinic Locator Application Development Report

This report details the development of a clinic locator application designed to provide employees with demographic details of clinics using postcodes. The application, built using Python with the Bottle and petl frameworks, incorporates data cleaning, merging, RESTful web services, and mashup techniques. The report outlines the process of cleaning and merging data from 'clinics.csv' and 'locations.xml' into 'clinic_locations.csv', using petl for data transformation. It describes the implementation of RESTful web services for postcode-based clinic searches, utilizing the Bottle framework for efficient web service development. Additionally, the report explains the mashup component, enabling users to view clinic locations on Google Maps and send email requests. The guidelines for running the demo are provided, detailing the execution of the 'data_merger.py' and 'clinic_locator.py' scripts. The application allows employees to easily locate clinics and initiate contact, enhancing their ability to find and connect with various clinics in different areas.

Windows User
[COMPANY NAME] [Company address]
REPORT

Executive Summary:
The report consists of the information about technologies involving the medical software. It has been
described that the discussed topic is one of the most important area that is emerging lately in the area
of the information technology. In the report the description of the application has been provided that
would help the employees in viewing the demographic view of the clinics located across the area. They
would only require to provide the postcode of the area for which they are looking to find the clinic in. In
addition to this, this report provides the description of the development of the application which is to
developed using the python platform. The bottle and petl frameworks have been used for the
development of the application and the procedures such as the Data cleaning, Data Merging, RESTful
web service and Mashup are to be used for the development of the application. In addition to this, the
application implementation and the components of the system has been discussed in this report. The
cleaning and merging of data for the system implementation has been discussed in the report. The
clinic.csv and the location.xml file has been cleaned and records have been used for the merging them
into the clinicslocation.xml. the entire procedure for the same has been described in this report. The
Representational state exchange REST] is used for standard composition of the web services in the
system. Additionally, the functions like getlocation has also been included in the system development
for fetching the address for the system and other type of request queries have been executed for this
system. Mashup is the fundamental part of the coding and this part is involved with the representation
of the location of the client and should be able enter the postcode of the area in which they want to
perform the action in.

Contents
Introduction:...............................................................................................................................................2
Segment 1:..................................................................................................................................................2
Data merging and cleaning:.....................................................................................................................2
Segment 2....................................................................................................................................................3
RESTful Web services...............................................................................................................................3
Segment 3....................................................................................................................................................4
Mashup....................................................................................................................................................4
Guidelines to run the demo:........................................................................................................................4
To Execute the Script data_merger.py:...................................................................................................4
To Execute the Script clinic_locator.py:...................................................................................................5
Conclusion:..................................................................................................................................................5

Introduction:
Medical software and technologies are the most emerging areas of that are continuously adopting
information technologies in business solutions. As a part of implementation of Service Oriented
Architecture, an application is required for the employees where they can view demographic details of
clinics around in the state with the help of postcode through Google. The application would be
developed in Python programming. The code would be developed using the frameworks Bottle and petl.
The code would utilizing three major concepts namely, Data cleaning, Data Merging, RESTful web service
and Mashup. This report would discuss the components and implementation of the code.
Segment 1:
Data merging and cleaning:
The cleaning and merging of data would be performed on the records specifically, "clinics.csv" and
"locations.xml". The clinics.csv document contains the records specifically ID, Name, Postcode, State,
Email IDs and Suburb of clinic. The data given in the record isn't in revise shape, a portion of the Email
IDs have spaces while some are not in rectify shape. This data should be cleaned first in request to use
them in appropriate way. This cleaned data is then converged with the record "clinicslocation.xml" that
contains the locations of the clinics and after that stacked in the csv record in particular
"clinic_locations.csv". This usefulness would be accomplished utilizing a bundle in Python specifically
petl that permits extraction, change and stacking of data.
The piece of the code that imports the system is: "import petl as etl", where etl is name of the question.
Petl has various techniques out of which "fromxml" is utilized to peruse the clinicslocation.xml record
though "fromcsv" is utilized to peruse the clinics.csv document, the strategy "sub" is utilized to take out
superfluous spaces in the middle of the email ids while utilizing the "pursuit" strategy, the lines in the
clinics.csv document that had wrong passages of the email ids are totally evacuated.
This brought about just 26 records left in the clinics.csv document out of 29. At that point with the
assistance of "join" technique the cleaned data is then converged with the clinicslocation.xml document.

Segment 2
RESTful Web services
The Representational state exchange REST gives a given arrangement of compositional standards which
permits web services outlining that spotlights on assets of the framework, including however not
constrained to how the conditions of the assets would be tended to and exchanged over HTTP, in
various languages composed by a variety of clients. The Web service in our code is made which is
"/getlocation?postcode=xxxx". The script has a function called getlocation, with the assistance of this,
we separate postcode from request.query. The asked for postcode in the web benefit is looked utilizing
the petl structure in clinic_location.csv record made in the principal segment. In the event that the given
postcode is find in the document, it restores every one of the records from the csv document as a
reaction in Json record. This is finished utilizing the Json library. For another situation if the
predetermined postcode isn't found in the record then the circumstance is taken care by blunder taking
care of in which the mistake would be prematurely ended utilizing the error code 500. For the usage of
this part we have utilized Bottle system which is regularly known web system in Python. The utilization
of this system permits advancement of RESTful web services in a quick and simple way, and the reaction
time and throughput of this system is especially better.

Segment 3
Mashup
This is the fundamental part of the code. In this part the representative or client would have the
capacity to enter the postcode of the required clinic and the resultant location containing that clinic is
shown on the google delineate, the clinic isn't found in that suburb than the default clinic with postcode
2000 would be shown on the Google outline. For taking the postcode from the clients we have made
cleaning_map.html which have an information field and a submit option. Whenever the client enters the
postcode in the information field and taps the option, the get strategy is used to get the postcode and
call web administration, and it additionally passes that code to the administration.
In the wake of tapping the submit option two alternatives are shown, specifically, "see location on map"
which on clicking shows the location of clinic at the map the assistance of longitude and scope of the
clinic another is "Forward request mail", which produces a programmed email utilizing the email address
of the clinic in cc and with subject "clinic request".
Guidelines to run the demo:
To Execute the Script data_merger.py:
1) Double tap on the record/open with pycharm
2) Ensure records – clinics.csv and clinicslocation.xml in a similar organizer
3) Run the content in pycharm.
4) On effective execution the document will have just separated records and clinic_new.csv will be made

To Execute the Script clinic_locator.py:
1) Add the content in the venture and put clinic_location.csv, clinic_map.html, clinic_map.tpl and
bottle.py in same envelope.
2) Once executed effectively at that point open program and run http://localhost:8080/get location?
postcode=4000
3) Response will be as json
Case:
On Web program will pass the postcode:
http://localhost:8080/getlocation?postcode=4000
It returns Json:
For Masup demo:
Same content will be utilized, rather than entire web services we simply need to go to localhost with
port 8080, at that point clinic_map.html will be indicated where postcode will be entered and guide will
be shown.
At the point when postcode is entered and submit option is squeezed then demand will be sent for the
subtle elements also, server will restore the scope and longitude and in light of its location will be
appeared.
At the point when interface Email to clinic is clicked then standpoint application will be opened with
subtle elements as of now made:
Conclusion:
By utilizing this application the representatives will discover the location of the clinic and can reach to
the clinic by sending email with the assistance of the email to clinic interface. This will help them a
considerable measure on the off chance that they need to discover various clinics adjacent there
postcode and in light of postcode they can look through the clinics.