1 / 12

UNODC (United Nations Office on Drugs and Crime)

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. Excel Report Processor Interface for NDS.

pomona
Download Presentation

UNODC (United Nations Office on Drugs and Crime)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. UNODC (United Nations Office onDrugs and Crime) Blas Llarena Systems Development Specialist Information Technology Service United Nations Office at Vienna United Nations Office on Drugs and Crime

  2. 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.

  3. Excel Report Processor Interface for NDS - Functionality

  4. Excel Report Processor Interface for NDS - Functionality

  5. Excel Report Processor Interface for NDS - Functionality

  6. Excel Report Processor Interface for NDS - Functionality

  7. License module – Proposed enhancements • Integrate in one module all Licenses functionality. • Outlook-like interface. • Keep existing basic functionality for querying and data-entry.

  8. License module – Proposed enhancements • Change license status by just pressing a button instead to open another window

  9. License module – Proposed enhancements • Current Licenses menu

  10. License module – Proposed enhancements • In one single window we are going to have all functionality: processing, reports and License Type Master.

  11. 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.

  12. Thank You – Questions?

More Related