02
Sat, Nov
2 New Articles

Hang a Left at Calendarville and Head to the AS/400 Meeting Scheduler

Visual Basic
Typography
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

A friend of mine is the chief financial officer for a medical firm. We were chatting one day and out of the blue he said he had a problem: He had 50 employees and not one single standard type of calendaring software. By calendaring, I mean a way to keep track of appointments and meetings. He said that some people were using Lotus Notes, some Microsoft Outlook, and others resorted to chicken scratch on a pad of paper, but not everyone was using the same software for their calendaring needs. He said it made things difficult to figure out who was in what meetings and when. He also said that his budget dollars were all used up so he couldn’t purchase more software. My response was “don’t you have an AS/400?” He looked at me puzzled. “But,” he responded, “I want an application that runs on my PC, not a native green-screen application. It has a better feel to it.” I told him to give me a few weeks to throw something together for him. This is how the AS/400 Meeting Scheduler came to be.

After a few weeks, I threw together the program shown in Figure 1. The program addressed his scheduling needs and didn’t cost him anything other than some time to sit down and learn new software. The AS/400 Meeting Scheduler’s main interface is written in Microsoft’s Visual Basic (VB) for that robust GUI. The main control in the VB program is Microsoft’s ActiveX Data Object (ADO). The back-end database resides on the AS/400. Client Access/400’s OLE DB driver was used as the pipeline to the data on the AS/400. Throw in some embedded SQL, stored procedures, and RPG programs on the AS/400, and you are good to go. No, it doesn’t have all of the bells and whistles of Microsoft Outlook or Lotus Notes, but I’m not Bill Gates either.

Calendarville Information Center

OK. Let’s see what this baby is made up of. There are three distinct areas to the AS/400 Meeting Scheduler that I want to review. (I’ll jump into further detail later.) The areas are as follows:


• Administrative menu—This allows the designated AS/400 Meeting Scheduler Administrator to add, delete, update logon IDs, and control all meetings scheduled on the AS/400. Please note that a logon ID in the AS/400 Meeting Scheduler Profile is not the same as a user profile on the AS/400.

• Schedule a meeting—This allows you to schedule a meeting. It checks for conflicts and allows you to enter meeting information.

• View meeting schedule—You can view today’s meetings or another date in the future. This shows you all of your meetings for the selected date, meeting location, meeting agenda, and all attendees for the meeting.

Before creating your first meeting, you need to make sure that everything is installed correctly on both the PC and AS/400. This program assumes a few things:

• You are running a PC in a Windows 95, 98, or NT environment.

• You are using AS/400 Client Access Express for Windows or a previous version of CA/400 that supports the OLE DB driver. CWBZZODB.DLL is the .DLL that contains the code for the driver and is available with CA/400 V3R1M3. This DLL should automatically be loaded onto your machine when Client Access is installed.

• You have the Microsoft Data Access Components (MDAC) installed. This is free and can be found at www.microsoft.com/data/ download.htm. Be warned that, while the initial download of the MDAC software development kit (SDK) is fast, the actual installation on your PC of the MDAC SDK comes from Microsoft’s Web site and over a dial-up connection. This installation can be a very long-running process.

To get the AS/400 objects and the PC setup program, go to www.midrangecomputing.com to download the objects related to this article. The readme.txt explains how to install the objects on the AS/400 and the PC.

The first time you run the scheduler, you must do a few things. An input box will appear and ask you to enter the AS/400 system name. Enter the name of the AS/400 that the Scheduler Objects reside on. Next, the input box will ask you the library where the installed programs reside. The library name entered must be the name of the library the objects for this utility were restored into on the AS/400. It is very important that the objects for the AS/400 are restored to a library that is part of the AS/400 user profile, QUSER, library list. It is important so that the QUSER profile behind the scenes can locate the AS/400 objects necessary on the AS/400 end. If all has been entered correctly, you will be asked to log on. Figure 2 shows what the logon screen looks like.

The first time you log onto the scheduler, there is only one valid logon ID and password. The logon ID needs to be MC400. Also, enter MC400 for the password. Press the Sign In to Scheduler button to try to log onto the program. Because this logon ID has administrator rights, you are brought into the Administration Menu. If you have signed on correctly and checked the box titled Save Log on Attributes for Meeting Scheduler, the logon ID, password, system name, and library name are all saved to your PC’s registry. This will bypass typing in each of these parameters each time you log on.

Administration Menu Boulevard

The Administration Menu will only be shown if the logon ID that has logged into scheduler has administrative rights. First, check out the Modify Attributes drop-down box. Select Add/Update/Delete Log In Profile. Figure 3 is what you should see on your screen.

Look under the heading All AS/400 Meeting Scheduler Users. This is where you add all of your scheduler IDs. The only logon ID currently out there should be MC400.


Now you can add a few new identifiers: In the login ID field, type in a Scheduler ID name. The scheduler name cannot be longer than 10 characters and is automatically converted to uppercase. This name will be used to log into the scheduler. Enter the logon person’s first name in the First Name field provided and the last name in the Last Name field. Next, enter the a password. This password will be what the person uses to log on to the AS/400. This, too, can only be up to 10 characters long and isn’t visible when entering in the password field. Check the Administrative Rights? box if you wish this person to be an administrator when he or she logs on the system. Click on the Add Record in Database button. Notice that the new ID was added to the right in the users list.

Notice that in the users list box there are horizontal and vertical scroll bars. The horizontal scroll bar hides the passwords for each person. Scrolling over will reveal the passwords. Scrolling down will show more people enrolled in the Scheduler. All of the entries are in alphabetical order. Click on an entry and it automatically fills in the login ID, first name, last name, password, and administrative right fields. You can change any fields other than the login ID field, and click Update Record in Database to make an update. Clicking the Delete Record in Database button will delete the current record selected. The Clear button clears all of the fields so you can start entering data again.

Notice the colors in the users list box. All of the entries in red indicate that these people have administrative rights. Remember that administrative rights give you access to the Administration Menu tab. All other users will show up in blue. Maintaining users is critical to the success of this program. All of the users that are in your database will show up as valid people who can be selected for meetings. Notice that all changes that you make will show up under the Administrative History list box. You may want to remove the MC400 logon ID and add or change a different ID to be the new administrator. Right-click in the Administrative History area to delete the entries in history. Go back up to Modify Attributes and select Delete Meetings. The meeting administration is now on your screen.

The first time in this screen you’ll see all of the meetings in your scheduler under the heading All Meetings in Scheduler. If you click on a specific meeting, the attendees for that meeting are shown in the Attendees list. Click on the drop-down box for Select Login ID. This will contain all of the IDs that are currently set up in the scheduler. By clicking on a profile, you’ll be shown all of the meetings that this person is scheduled in.

Select a meeting by clicking on it. Right-click on it and a message box will appear allowing you to delete the entry. Press the Yes button for the deletion to occur. Pressing the Clean Up Meetings will delete all meetings in the scheduler that are older than the current date. It is recommended that you do this from time to time. All deletions are recorded in the Administration History list. Go back and enter some valid profiles in your workplace and create a meeting by clicking on the Schedule a Meeting tab.

Schedule a Meeting Street

This screen looks pretty boring. The screen was designed to have the user follow a specific order when entering meeting information. Follow these steps to add a meeting:

1. Fill in a meeting location—The default here is your signature and it is in your in your office. This can be modified.

2. Fill in a meeting title—What could your meeting be called?

3. Enter data for an agenda—Why was the meeting called? What will be discussed in the meeting? Remember, when you enter an agenda, everyone that is scheduled will be able to see what you’ve entered, so be descriptive.

4. Select meeting participants—Choose from the list of possible people on the lower left side of the screen. Double-click on a name to move it into an attendee of the meeting. Select


all of the people you wish to add for your meeting. To remove a person that you’ve selected, click on his name, and it will return back to the original list.

5. Select the date—Choose the date you wish to have the meeting. You cannot select a date that has previously expired.

6. Select the start time—Enter a time from the drop-down box. The meeting can be as early as 7:00 a.m.

7. Select the end time—Based on the start time, entries are automatically provided for you.

Once the end time has been selected, you will either get a confirmation to add a meeting or a conflict message box. The screen will look like Figure 4. A conflict means that one or more of the people that you’ve selected to attend the meeting has already been scheduled during that time frame. The conflict message box looks like Figure 5. The confirmation box, if you decide to add the meeting, will enter all of the data to the scheduler. It is now available for everyone to view. That’s all there is to it. Now view your meetings.

View Meeting Schedule Plaza

This is the easiest part of the entire program. When you first log onto the scheduler, if you do not have administrative rights, you will see Figure 1. The default date is the current date. You will see what meetings you have scheduled for that day. A list on the left-hand side shows what meetings you have scheduled, the start time and end time for the meeting, and the title of the meeting. Click on a specific meeting and the meeting information will appear under Meeting Agenda on the right side. Click on any other date to view what has been scheduled for you as well. If you are an attendee of the meeting, you have been given rights to delete the meeting too. Right-click on a meeting to delete it. This will remove the meeting details and attendee list from the scheduler. It’s that simple.

Final Directions

Hopefully, more people will find some use for the AS/400 Meeting Scheduler in the workplace. This is just a small example of how powerful the AS/400 can be in client/server applications. I remember programming with the Client Access API and having to be a rocket scientist to do it. Client Access came out with its own OLE DB provider, and it made applications very easy to code. This entire application uses regular calls to stored procedures and RPG programs. I chose to use stored procedures and RPG programs because, in the future, someone could also get at this data from a Web browser as well as your everyday native green-screen programs without reinventing the wheel. Thank you for visiting Calendarville. Come back again soon.

REFERENCES AND RELATED MATERIALS

• SQL/400 by Example. James Coolbaugh. Loveland, Colorado: 29th Street Press, 1999


Hang_a_Left_at_Calendarville_and_Head_to_the...05-00.png 397x338

Figure 1: The AS/400 Meeting Scheduler on the View Meeting Scheduler tab shows you detailed information about a day’s meeting.

Figure 2: The logon screen for the AS/400 Meeting Scheduler allows only authorized users access.


Hang_a_Left_at_Calendarville_and_Head_to_the...05-01.png 395x336

Hang_a_Left_at_Calendarville_and_Head_to_the...06-00.png 395x336

Figure 3: This shows the Administration Menu on with the login administration screen shown.

Figure 4: The Schedule a Meeting screen allows you to simply coordinate a meeting.


Hang_a_Left_at_Calendarville_and_Head_to_the...06-01.png 406x331

Hang_a_Left_at_Calendarville_and_Head_to_the...07-00.png 406x154

Figure 5: Conflicts have been found for this scheduled meeting.


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: