Transcript National Drug Control System

NDS
UNODC (United Nations Office on
Drugs and Crime)
Blas Llarena
Systems Development Specialist
Information Technology Service
United Nations Office at Vienna
United Nations Office on Drugs and Crime
NDS
Excel Report Processor Interface for NDS
• Enables data comparison between data sent by Domestic
Traders against existing data on NDS DB used by Local Drug
Control Authorities.
• Use MS Excel spreadsheets as default format to load data.
• Doesn’t need to have installed Microsoft Office on user’s PC.
• Now, in production by Swiss Drug Control Authorities.
NDS
Excel Report Processor Interface for NDS - Functionality
NDS
Excel Report Processor Interface for NDS - Functionality
NDS
Excel Report Processor Interface for NDS - Functionality
NDS
Excel Report Processor Interface for NDS - Functionality
NDS
License module – Proposed enhancements
• Integrate in one module all Licenses functionality.
• Outlook-like interface.
• Keep existing basic functionality for querying and data-entry.
NDS
License module – Proposed enhancements
• Change license status by just pressing a button instead to open
another window
NDS
License module – Proposed enhancements
• Current Licenses menu
NDS
License module – Proposed enhancements
• In one single window we are going to have all functionality:
processing, reports and License Type Master.
NDS
What’s next ?
•
Standard INCB forms to be loaded in a Web application: data entered
manually or loaded using pre-formatted Text, XML or MS-Excel file.
•
Using Excel Processor Interface for directly updating Domestic data on
NDS.
•
Import-Export and License Module as a Web Application.
•
Import-Export new features with status not used or expired
authorization and relevant updates on reporting to include these
features on these queries.
•
Allow substances to be disabled instead of just deleted.
•
Encourage to use Linux as DB Server. UNODC can provide technical
assistance when installing and configuring.
NDS
Thank You – Questions?