You are not logged in.

IKS- Food Composition Database Redevelopment

Details

Tender Closed
RFx ID : 16760707
Tender Name : IKS- Food Composition Database Redevelopment
Reference # : PFR 02-2015
Open Date : Thursday, 17 September 2015 4:00 PM (Pacific/Auckland UTC+12:00)
Close Date  : Wednesday, 14 October 2015 12:00 PM (Pacific/Auckland UTC+13:00)
Department/Business Unit : Corporate
Tender Type : Request for Quotations (RFQ)
Tender Coverage : Sole Agency  [?]
Categories :
  • 43231500 - Business function specific software
  • 43232300 - Data management and query software
  • 43232600 - Industry specific software
Regions:
  • New Zealand
Exemption Reason : None
Required Pre-qualifications : None
Contact : Matthew Laurenson
matthew.laurenson@plantandfood.co.nz
099263505
Alternate Physical Delivery Address  :
Alternate Physical Fax Number  :
Agency Address : NEW ZEALAND
Overview

Plant & Food Research needs to redevelop an existing internal Web Application, the Food Composition Database (FCDB), and seeks to engage an external developer to complete the first phase of the redevelopment with the prospect of further work on subsequent phases. FCDB stores food nutrition data and helps with the preparation of various publicly-available nutrition dataset publications on behalf of clients including the Ministry of Health (MoH) and the Food Safety Authority (FSANZ) of the Ministry of Primary Industries (MPI).

FCDB has 3 main components:
• The database itself - a SQL Server database with some executable stored procedures and functions needed for the system but primarily for data storage.
• Food Information Management System (FIMS) - a Java based Web application hosted in JBoss. FIMS is the primary data entry and editing mechanism for FCDB. It also has code for recipe and attribute calculations (more later).
• FCDB Auxiliary - a PHP-based web application for extracting reports and bulk entering data into the FCDB.
FIMS and the database were both developed in the early 2000s – FCDB Auxiliary was developed around 2010.
The present system although functional and working is dated and has become difficult to maintain and enhance.
The first phase of our redevelopment will be to replace FIMS and FCDB Auxilliary with a new Python/Django based application that will take over the data manipulation and reporting functionality of these two applications. The new application will be based on the requirements artefacts provided with this request (use cases, mockups, and entity relationship diagrams).

RFx Outcome

No Winner Decided not to go ahead with this project