Presents Presents Presents Presents Presents Background - - PowerPoint PPT Presentation

Presents Presents Presents Presents Presents

• History of the TERMinator
• Concept, ROI.
• Development Cycle.
• Business Units involved.
• Future of the TERMinator.

– International deployment? – TERMninator Goals?

Background History/Future

• The ability to modify the TERMinary Libraries
• READ-Read, Edit, Add, Delete or full editing capabilities for Library and

Dictionary

• Test the newly created TERMinary library prior to deployment.

– Ability to compile/encrypt library. – Test within Word and PowerPoint environments

• Ability to import/upload Terminary from and to multiple file formats.
• i.e..Excel.xls, Word.txt, Excel.csv.
• Generate a TERMinary Report for export.
• i.e..Excel.xls, Word.txt, Excel.csv.
• Stealth Install for TERMinary Library Update.

Requirements-Challenges

End End

The DMT is a full-featured Client Server Terminary Dictionary Management System (DMT) that is designed to be run on the WindowsTM environment. DMT is compatible with WindowsTM, 98, NT, 2000, XP. The application layer runs locally on individual workstations and the database server runs either on the same machine as a non- dedicated workstation or as a dedicated server.

Workstation Printer Server Workstation

The DMT is designed using Microsoft WindowsTM EXCEL Visual Basic with Apllication (VBA) standards and concepts to provide an intuitive and consistent Graphical User Interface (GUI). Toolbars and representative icons are used throughout the software to promote ease of use for users. The DMT supports a wide range of custom interface options available to better suit the clients needs to provide full Microsoft Office integration with direct links to ie. WordTM and ExcelTM. WindowsTM desk top tools are used by the system for storing Dictionary files.

DMT Export WordTM ExcelTM

The Client Server architecture provides the power and security of a minicomputer or Intel (XP) based server with the flexibility and ease of use provided by Microsoft WindowsTM. DTM currently utilizes the MSADO Connectivity Standard to provide communication between clients and the database server. The ability to adherence to the ODBC standard means that DMT has the ability to utilize databases including: OracleTM and SQLServerTM. The DTM is designed for use on the lastest version of Microsoft's WindowsTM

• perating system.

ER Diagram Logical

tblDictionary PK,FK2,I1 Library_ID PK,I1 Dictionary_ID Original OriginalEncoded Reason ReasonEncoded Suggested SuggestedEncoded Region DateTime Author Active Version FK1 User_ID tblLibrary PK Library_ID Language Label_Name Word_Count Version Date Comments tblSecurity PK,I1 User_ID User_Name Name Group Access Date Comments

DMT ER Diagram

Data Source Intranet

Terminary Data Flow Diagram

Email distribution/ Outlook Excel.CSV File Export Audit SQL Server Master Source VBA Local Terminary Interface Oracle Update A1 Export Email List Access Excel .TXT File Export Export File linked to mailing list File linked to mailing list Flat File WEB Terminary Interface Excel File Export Export File linked to mailing list

Data Flow Diagram

Select Library for Update or Management of New Dictioinary View English Terminary Update Dictionary

• r Management or

Create New Setup Directory and File Paths and Table Management Configure Security View German Terminary View Spanish Mexican Terminary View Spanish European Terminary View Japanese Terminary View French Terminary

Menu-Terminary

Import/Export Files in multiple formats Generate Reports

Terminary-Library Management

Viewable Library Attribute Display Export Selected Library as Excel File Export Selected Library as Text File Export Selected Library as CSV File Library Selection Pulldown Full Attribute Editing Capabilities Full Library Editing Capabilities

Terminary Dictionary Management

Record Navigation Viewable Dictionary Data Export Viewed Dictionary as Excel File Export Viewed Dictionary as Text File Export Viewed Dictionary as CSV File Encode Dictionary Export Dictionay to XML.dll Select Dictioonary Full Field editting capabilities Full Library Editing Capabilities

View English U.S. Terminary

Viewable Dictionary Data Export Dictionary as Excel File Navigation to Menu Export Dictionary as CSV File Export Dictionary as TXT File Viewable Encoded Data Viewable Encoded Data

Setup Interface

Database Mapped Path Export.TXT File Mapped Path Export.CSV File Mapped Path Export Excel File Mapped Path Clear DB Dictionary Table

Terminary Security Interface

Editable test box entry Custom GUI Custom GUI Viewable Attributes Menu User Name Select Pull Down Full Editing Capabilities

Intranet/ Internet

Terminary Is there an update available? Request application save, shutdown, then update.

Update Deployment Task Flow

Questions?