29
Fri, Nov
0 New Articles

Case Study: BCD's ProGen WebSmart

Case Studies
Typography
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times
In November of 2004, a man entered the Allegany County Detention Center in Cumberland, Maryland, to visit an inmate. When a guard keyed the visitor's name into a newly installed iSeries-based police reporting system, he realized that the man he was talking to was wanted on an outstanding arrest warrant. If not for this browser-based crime fighting tool, the man might have left freely following his visit, since it would have taken several phone calls for guards to unearth any connection to wrongdoing. As it happened, he left in handcuffs.
Normally, wanted criminals don't willingly enter buildings through doors that automatically lock shut behind them. Most often, it takes solid police work and good information to catch them. Up-to-date information is a key weapon in the war on crime, say police officials. The U.S. Department of Homeland Security apparently agrees: It offers financial incentives to agencies that acquire information management systems that integrate into a larger network.

One new tool that gives police officers instant access to information is the MCCI Police Reporting System from Mason Computer Consulting, Inc. in Hagerstown, Maryland. The MCCI Police Reporting System is a multifaceted incident-reporting system with a database and executables that reside on an IBM iSeries box. Authorized users can access this system from any PC-based Web browser. Common, inexpensive wireless technology and laptop computers make this system accessible to officers on patrol. The MCCI Police Reporting System is also designed to be uncomplicated for end users and easily maintained.

Former IBM system engineer Chuck Mason is the president of MCCI. Founded in 1995, MCCI initially sold IBM midrange hardware. Now, it turns out high-quality custom RPG and Web-based applications for more than 50 customers in Maryland, Pennsylvania, West Virginia, and Virginia. The majority of MCCI's customers are small and medium-sized businesses.

Mason is a fervent believer in truth, justice, and technologies that make life easier. In 1997, he discovered an RPG application development tool called ProGen Plus from Business Computer Design Int'l. (BCD). ProGen helped Mason and three of his programmers keep pace with demand for a large number of AS/400 applications that his clients wanted. "When I first started my business, a lot of customers wanted work done but couldn't afford to pay for the time it would take to write programs. With ProGen, we were able to develop applications in a fraction of the time," says Mason. In one early instance, he quoted a client $100,000 for an extensive new system, but the fee was mistakenly based on the amount of time it would have taken him to write it manually in RPG. "When we finished, it actually came in at $30,000 because of the amount of time I saved using ProGen." Since his development fees were so reasonable, customers continued to add new projects to the list. "ProGen helped me build my consulting business," he says.

In 2003, many of Mason's customers began asking for browser-based systems, and again he looked around for a good development environment. He investigated WebSphere initially, but it required hardware upgrades, training, and lots of development time. And in the end, the applications ran slowly. He also considered manual Java development. Then, his past led him forward: "From working with ProGen, I knew BCD was stable. I knew where they were coming from and where they were going. We were very happy with ProGen, so I tried WebSmart. Soon, I had WebSmart running on a Model 150," says Mason, adding, "I took existing green-screen maintenance programs and had them converted in 10 to 15 minutes. It was simple."

A time and attendance system and a couple of shopping cart apps were the first systems Mason developed after a few days of WebSmart training. "If you are able to follow a Visual Basic program, you can create your logical flow," he says, adding, "WebSmart will allow you to generate the code using standard chains and reads. You can also use a template that generates everything in SQL. So if you have an SQL background, you can use this template to generate your reads, writes, and lists."

In 2004, the police department for the City of Cumberland engaged MCCI to write a Web-accessible police reporting system that would run on the AS/400 Model 270 that served the municipality. "In the middle of developing the system for Cumberland, a couple of other police agencies approached me about sharing information across the board," Mason says. He went on to design a system using WebSmart that runs on the iSeries Apache Web server. It allows multiple agencies to be online at the same time and share information. "If you are searching for warrants, you have the ability to see warrants from all the agencies on this system. For police reporting systems, this is a first," he says.

This system tracks incidents, names, property, and narratives and uses SQL calls from a WebSmart application template to facilitate all searches. It lets multiple agencies share the same major database through controlled and secured access. Now dubbed the MCCI Police Reporting System, it allows for the attachment and storage of any PC file to an incident, including digital video, audio, pictures, Microsoft Word and Excel documents, and others.

The Master Name database stores the names of complainants, witnesses, victims, and suspects, as well as arrests, traffic accidents, etc. The system allows for the storage of multiple mug shots per name. Included is the interface to a mug shot camera. The system also interfaces with Microsoft Word documents.

The MCCI Police Reporting System is inexpensive for police agencies to maintain and can be serviced by those who use it. All drop-downs are maintained through WebSmart maintenance programs. "If an agency wants to add another type of activity, they can simply add it to the system. If they want to add an officer's rank or some other parameter, they can add that also," says Mason.

The system is buttoned down with secure SSL and encryption. Access is granted to those with a user ID and password. Once someone logs on, the system knows what agency the user is assigned to and the approved security clearance level. Access can be limited to view only, view and update, and multi-agency access.

Working with WebSmart

To develop the new police reporting system, Mason first found an SQL template in WebSmart that did a substantial amount of what he wanted his program to do. A developer who was familiar with HTML helped him tweak it to match his data presentation requirements. Then, Mason used PML, WebSmart's advanced programming language, to add more functionality. "We got very deep into PML," says Mason. "Awhile back, I took Visual Basic and Java classes, and I was very skeptical about getting into another new language. I found that I caught on to PML very quickly, and in three days I was very productive. The BCD Web site is also very helpful. It helped me with the Microsoft Word interface. And their tech support guys are very skilled; I would come across some specific and unique requirement, and they would let me know how to handle it."

In some cases, past transgressions should not be forgotten, so Mason then set out to populate the system with as much historical information as possible, and he converted data from several agencies going back as far as seven years. "All of those agencies had their separate systems. I had to write a conversion program for the legacy data from all of those separate PC-based systems," he says.

The MCCI Police Reporting System went live in Cumberland in July 2004. Since then, Mason has added four additional agencies to this site, and all of them are sharing information. It is currently serving around 160 police officers. "Another three agencies are scheduled to come onto that site soon, and we are also working with Chambersburg, (Pennsylvania)." Mason sees no visible upper limits. "I can put this system on the biggest iSeries box in production and serve 1,000+ officers."

The Verdict

By facilitating instant access to data, the MCCI Police Reporting System has put one more tool in the hands of police officers to help catch criminals. It has also made their jobs easier in many ways. In the past, an officer had to type several paragraphs of text into a criminal complaint. "We have set it up so he can click on a button and look for the statute code that he is charging the person with and paste the five or six paragraphs that it produces right into the complaint," says Mason.

The State's Attorney's office has gotten a boost, too. Not long ago, all requested police reports came on paper, and it took days to get them. Now, users have instant access and can review all of these documents online.

The MCCI Police system is now being readied for general release and will be sold throughout the United States. To view the MCCI Police Information System demo, click here. Use PDDEMO for both the user ID and password. You can also obtain a free copy of WebSmart for evaluation purposes.

Robert Gast has had an extensive number of articles published on technology and business management-related issues. He is the managing partner of Chicago area-based Evant Group and can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it..

http://www.mcpressonline.com/articles/images/2002/BCDStorySnapshots%232forMCPressV4--11-15-0400.png

Business Computer Design, Int'l, Inc. (BCD)
Contact: Eric Figura, Director, Sales and Marketing
950 N. York Rd.
Hinsdale, IL 60521-2950
Tel: 630.986.0800
Fax: 630.986.0926
Web: www.bcdsoftware.com
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

BLOG COMMENTS POWERED BY DISQUS

LATEST COMMENTS

Support MC Press Online

$

Book Reviews

Resource Center

  • SB Profound WC 5536 Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application. You can find Part 1 here. In Part 2 of our free Node.js Webinar Series, Brian May teaches you the different tooling options available for writing code, debugging, and using Git for version control. Brian will briefly discuss the different tools available, and demonstrate his preferred setup for Node development on IBM i or any platform. Attend this webinar to learn:

  • SB Profound WP 5539More than ever, there is a demand for IT to deliver innovation. Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects. The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the company are not aligned with the current IT environment.

  • SB HelpSystems ROBOT Generic IBM announced the E1080 servers using the latest Power10 processor in September 2021. The most powerful processor from IBM to date, Power10 is designed to handle the demands of doing business in today’s high-tech atmosphere, including running cloud applications, supporting big data, and managing AI workloads. But what does Power10 mean for your data center? In this recorded webinar, IBMers Dan Sundt and Dylan Boday join IBM Power Champion Tom Huntington for a discussion on why Power10 technology is the right strategic investment if you run IBM i, AIX, or Linux. In this action-packed hour, Tom will share trends from the IBM i and AIX user communities while Dan and Dylan dive into the tech specs for key hardware, including:

  • Magic MarkTRY the one package that solves all your document design and printing challenges on all your platforms. Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product. Make sure your data survives when catastrophe hits. Request your trial now!  Request Now.

  • SB HelpSystems ROBOT GenericForms of ransomware has been around for over 30 years, and with more and more organizations suffering attacks each year, it continues to endure. What has made ransomware such a durable threat and what is the best way to combat it? In order to prevent ransomware, organizations must first understand how it works.

  • SB HelpSystems ROBOT GenericIT security is a top priority for businesses around the world, but most IBM i pros don’t know where to begin—and most cybersecurity experts don’t know IBM i. In this session, Robin Tatam explores the business impact of lax IBM i security, the top vulnerabilities putting IBM i at risk, and the steps you can take to protect your organization. If you’re looking to avoid unexpected downtime or corrupted data, you don’t want to miss this session.

  • SB HelpSystems ROBOT GenericCan you trust all of your users all of the time? A typical end user receives 16 malicious emails each month, but only 17 percent of these phishing campaigns are reported to IT. Once an attack is underway, most organizations won’t discover the breach until six months later. A staggering amount of damage can occur in that time. Despite these risks, 93 percent of organizations are leaving their IBM i systems vulnerable to cybercrime. In this on-demand webinar, IBM i security experts Robin Tatam and Sandi Moore will reveal:

  • FORTRA Disaster protection is vital to every business. Yet, it often consists of patched together procedures that are prone to error. From automatic backups to data encryption to media management, Robot automates the routine (yet often complex) tasks of iSeries backup and recovery, saving you time and money and making the process safer and more reliable. Automate your backups with the Robot Backup and Recovery Solution. Key features include:

  • FORTRAManaging messages on your IBM i can be more than a full-time job if you have to do it manually. Messages need a response and resources must be monitored—often over multiple systems and across platforms. How can you be sure you won’t miss important system events? Automate your message center with the Robot Message Management Solution. Key features include:

  • FORTRAThe thought of printing, distributing, and storing iSeries reports manually may reduce you to tears. Paper and labor costs associated with report generation can spiral out of control. Mountains of paper threaten to swamp your files. Robot automates report bursting, distribution, bundling, and archiving, and offers secure, selective online report viewing. Manage your reports with the Robot Report Management Solution. Key features include:

  • FORTRAFor over 30 years, Robot has been a leader in systems management for IBM i. With batch job creation and scheduling at its core, the Robot Job Scheduling Solution reduces the opportunity for human error and helps you maintain service levels, automating even the biggest, most complex runbooks. Manage your job schedule with the Robot Job Scheduling Solution. Key features include:

  • LANSA Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.

  • LANSAWhen it comes to creating your business applications, there are hundreds of coding platforms and programming languages to choose from. These options range from very complex traditional programming languages to Low-Code platforms where sometimes no traditional coding experience is needed. Download our whitepaper, The Power of Writing Code in a Low-Code Solution, and:

  • LANSASupply Chain is becoming increasingly complex and unpredictable. From raw materials for manufacturing to food supply chains, the journey from source to production to delivery to consumers is marred with inefficiencies, manual processes, shortages, recalls, counterfeits, and scandals. In this webinar, we discuss how:

  • The MC Resource Centers bring you the widest selection of white papers, trial software, and on-demand webcasts for you to choose from. >> Review the list of White Papers, Trial Software or On-Demand Webcast at the MC Press Resource Center. >> Add the items to yru Cart and complet he checkout process and submit

  • Profound Logic Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application.

  • SB Profound WC 5536Join us for this hour-long webcast that will explore:

  • Fortra IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn: