MvCaTs Product Details

MVCATS PRODUCT DETAILS
Seeing is Believing - Click on any Product to email a request for a FREE Hands-On Demo. Styles: OSV = Original Screen Version; CBI = Character Based Interface (share subs w/GUI); GUI = Graphical User Interface (Windows).
Product	Styles	Description
AccuTerm GUI Sample Screens Click Product to Request a Free Demo See Product Codes with GUI Styles	OSV, CBI, GUI	Want to "go GUI" without going broke? And still retain the Legacy Code & Database you have so much invested in? You don't have to leave PICK or RPL to "go GUI"! Did you know that programmers write AccuTerm GUI code in 100% MultiValue Basic, but the screens run in Visual Basic and C? As an Official AccuTerm GUI Resource, we can "put a GUI face on an old friend" faster and at less cost than you would think possible. We can upgrade just one screen, several, or your entire software suite. So if you have PICK or RPL programmers on staff, they won't be left pounding the pavement. Our FREE hands-on demo was designed to erase every misconception you may have about AccuTerm GUI. We believe it's one of the best kept secrets in the MultiValue world. And we're working hard to change that. Click here to see how we make the case for AccuTerm GUI.
Ad Hoc Command Editor Click Product to Request a Free Demo Product Code AHEU	OSV	If you've ever entered an Ad Hoc Command at the TCL prompt but mistyped a character and had to enter the entire command all over again, you will love this editor. Even if you are familiar with the TCL-Stack and its dot commands, this Editor is much easier to use. The screen prompts using our Ticker Tape Text Editor (see details below) so you can edit the Command even during initial entry. After you press [Enter], the Full Command is parsed into values then displayed below the edit line. You can page through those lines from the Action line and go back to edit the Command Line as often as desired. (Anyone who has ever typed an Ad Hoc Report using Heading and Footing statements knows just how tedious this task can be.) Each time you Perform the Command, the revised version will be updated in your Ad Hoc User List. Then it will appear in the initial Search the next time you call up the screen so you can choose it at a later date to Edit, Perform, Copy, or Delete. We've also included an Import option to bring selected TCL-Stack commands into your Ad Hoc User List via Search window. (When you call up this screen for the first time, the Ad Hoc User List will inherit your most recent 20 TCL-Stack commands to get you started.) You will also be able to Sort the Ad Hoc User List from A to Z or from Z to A. Editing an existing stored command is a breeze; with just a couple of keystrokes, you're on your way. This editor organizes Ad Hoc Reports and System Administration Procedures so you'll never need to tediously retype anything at the TCL prompt again. One command could run a dictionary listing while another command could build an Ad Hoc Report on that file. This editor can greatly increase productivity for programmers and management. But we feel it only fair to warn you that its use can be addicting. Your are encouraged to eat & sleep occasionally.
Archive by Year or Month with Restore & Blend Click Product to Request a Free Demo Product Code ARCU	OSV, CBI, GUI	We offer a user-friendly Archive Utility by Year or Month which accommodates stand-alone files as well as paired Header & Detail files. It includes a Restore feature in case you archived too soon or specified data levels too small or too large. Or perhaps you archived by month when you meant to archive by year. And it comes with a Blend feature to combine selected archived data with current data into work files for Sorting then Reporting or Exporting. All three Processes include a Review option so you can see exactly how the data would be processed. And a SysAdmin feature displays a search window of Access Sentences to let you examine the data files before or after any process.
Automated Email Error Reporting Click Product to Request a Free Demo Product Code ELMU	OSV, CBI, GUI	Whenever MvCaTs software encounters a Critical Error which would require a screen or process to terminate prematurely, an Error Log entry is created. (Example: a file cannot be opened or a control file record is missing.) Then the user is informed and prompted for permission to send an automated email to our support email address to notify MvCaTs of the error. Upon receipt, MvCaTs administration will forward the email to the District Manager who services that account. This reduces both reporting & response times. This capability can also be linked quickly to ANY multivalue application software to notify your own IT staff. And it comes with a Maintenance screen with Search, Edit, & Delete options. The Edit option opens the Editor to display the program in which the error occurred. The Programmer no longer has to try to trace the source of the error. This saves a great deal of time and reduces client frustration while waiting for a "patch".
B-Tree Index Maintenance Utility Click Product to Request a Free Demo Product Code BTIU	OSV	This utility takes the tedium and risk out of Creating & Maintaining B-Tree Indexes. The system will then use these indexes "behind the scenes" each time an access sentence which references an indexed field is run from TCL or executed within a program or proc. At the File Name prompt, you can enter a valid File Name or Search the B-Tree file. The second prompt will enable you to maintain a list of B-Tree Indexes as values. The first time a File Name is called up in this screen, any indexes already attached to the File Name D-Pointer will be retrieved to initialize the Index List. Each screen prompt has an online help window that can be opened not only at the prompt but also from the screen Selection line. At the Selection line prompt, you will be able to enter any of the following options: a prompt # to edit data, F# or B# to page through the Index List, A to Add an Index, X1 to CREATE, X2 to VERIFY, X3 to CLEAR, X4 to DELETE, X5 to VIEW, X6 to TEST, X7 to SELECT, ? to open online Help to see Selection line options, FI to file the List, DEL to Delete all Attached Indexes as well as the List, EX to exit and start over without saving changes, or END to close the screen. The TEST option will ask for the Line # of an Index, then prompt for the "Raw" data to Test for. This is the data as it comes directly from a File read, still in its internal format. For example, to search a Date field for 09/12/2010, enter 15596, the internal date. The SELECT option will ask for the Line # of an Index, then prompt for a Dict Item Name with search capability. Then you will be prompted for the sample data to select with the ability to enter individual criteria and ranges. Unlike the TEST option, this data will be in its external format. To search for 9/12/2010, you would enter 9/12/2010. You will then be asked for a List Name to Save the selected IDs. Then the SELECT sentence will be displayed and you will have the opportunity to perform or exit. If performed, the Time Elapsed will be displayed afterward. You can use the X7 SELECT option both before and after index creation to see how the index improves performance time.
Catalist Source Pointers Click Product to Request a Free Demo Product Code MCFU	OSV	If you are a multivalue Programmer, how often have you invoked your favorite source editor only to realize you specified the wrong Basic File Name? What if you could just specify the Program Name and have the system look up the Basic File Name then place you in the editor? Now you can. Several MultiValue Operating Systems maintain a Cataloged Pointer in the Master Dictionary (MD) for each PROGRAM.NAME in a Basic Program file. A Programmer normally checks this item to find the File Name where the source code resides. But some multivalue systems, such as jBase, do not maintain this Pointer. So MvCaTs provides an alternate method which we call CATALIST. The User calls up the Catalist utility and enters one or several File Names separated by semi-colons as FILENAME1;FILENAME2;etc via our Ticker Tape Editor to create an AD HOC List of Program Files to Catalist or Decatalist. The User may also enter ?? to Search for Files in the Current Account which end with "BP". One or several can be selected during the Search. When the User enters X1 to Catalist, a record is verified or created for each Program Name, containing an attribute list of each file where this Program resides. And the User has the option to Catalog as well. (The X2 Decatalist function includes the option to Decatalog.) This list is then used behind the scenes to retrieve the File Name in routines such as our Clone Utilities where the Programmer specifies the Application Name, then the system retrieves the File Name. During installation, we assign your preferred source editor to a master control file item. Then at TCL, when you enter SED PROGRAM.NAME, our SED (source editor) utility retrieves the file name from either the cataloged MD pointer or from attribute 1 in CATALIST for PROGRAM.NAME then feeds the file name to your preferred source editor. Upon return from SED, the User will have the option to Compile, Catalog, do Both, or do Neither. Fewer keystrokes saves time and yields more accurate results. CATALIST is also a handy tool for identifying more than one file where the same program resides, perhaps because of a copy rather than a move. (If the only Program File you ever work with is BP, you can ignore this Product offering ;-).
Change Line Printer Assignment Click Product to Request a Free Demo Product Code LPAU	OSV	We offer a small, user-friendly utility to Change Line Printer Assignment. You don't have to understand system administration to use it. When the screen is first called up, the Current Assignment will display below the prompt. At the first prompt, you may enter L to List Printers. You may also enter a Form Number to Assign. If running a jBase system, you may enter a Queue Name or the Number associated with it. You may also enter H to assign output to a Hold file or S to assign output to a Slave printer. At the Action line prompt, you may go back to this prompt to modify your selection, or enter L to List Printers. If you enter C at the Action line prompt, the current Line Printer Assignment will be changed and the new assignment will display below the prompt. This utility can be easily attached to any menu or executed from any routine to quickly check or change your Line Printer Assignment.
Data Correction or Conversion Click Product to Request a Free Demo Product Codes: BFCU, RFCU	OSV	Our Data Correction or Conversion Templates prompt for File to Convert From, File to Convert Into, and Cutoff Date if Needed. You can Convert into the same file from which the data came, or into a Work File, or into another file. The File prompts also offer File Search capability. And a Cutoff Date can be specified if needed or left null. Two Templates are available: one with extra code to handle BY-EXPloding sorts and selects, the other with code to handle standard sorts and selects. Both Templates include a Review mode so the user can watch each step in the Selection process and see how each Conversion record is populated. Both the Review mode and the option to Convert into a Work File are included to ensure greater accuracy in the final product. They are Look Before You Leap features that can provide a comfort level and potentially save a programmer's bacon. Anyone who has fired up a Data Correction or Conversion routine prematurely on live data knows exactly what we mean! Once the first Template has been customized to your specifications, that routine can then be cloned in a matter of seconds then customized very quickly to address the next need for a Data Correction or Conversion. This saves a great deal of time and money while providing the Search, Review, and Work File features you have come to know and appreciate. Once you purchase a Template, customizing can be done either by MvCaTs or your own IT staff.
Data Encryption Click Product to Request a Free Demo Product Code MDEU	OSV, GUI	We offer custom Data Encryption for "Data at Rest" on MultiValue / PICK Legacy systems for both AccuTerm GUI and CBI screens and menus. This Utility includes a Maintenance screen to identify files & fields to encrypt then assign a security level to each of those fields. This screen has options to Encrypt, Decrypt, and Test Access to encrypted data. There is also a User Profiles screen to assign User Security Levels. For example, a User may be allowed to see a customer's Credit Balance, but may not be allowed to see a customer's Credit Card Numbers. So those two fields should have different Security Levels. The user's Security Level would match or exceed the security level to view the Credit Balance but would be less than the security level to view the Credit Card Numbers field. If encrypted data is referenced on an entry screen, and the User's Security Level is insufficient to view or edit the data, those fields will remain encrypted both in the file and in the retrieved record but will display as though the fields were null (empty). And User access to those fields will be restricted. If a multivalue data set contains at least one field with encrypted data, and the User's Security Level restricts access, the entire set will become "Display Only" and the restricted field will be hidden. If encrypted data is referenced on a report, and the User's Security Level restricts access, those fields will be reset to null (empty) since reports do not update the files which they reference. If the User lists encrypted fields from TCL using dictionary field names, and the User's Security Level restricts access, those fields will display as though they were null (empty). If the User edits a record manually from TCL and it contains encrypted data, those fields will appear encrypted and should not be changed! MvCaTs can attach calls quickly in your own entry screens and reports once User Profiles have been defined and sensitive data files have been identified. For those Clients who want their own programmers to implement our Data Encryption utility, we provide a sample Maintenance/Inquiry screen with all the encryption "hooks" in place as a Teaching Tool. We also supply a Word document which explains How To Implement Data Encryption and provides code samples.
Define Dictionary Attributes Click Product to Request a Free Demo Product Code DDAU	OSV	Want to take the guess work out of Creating & Maintaining your multivalue data file dictionaries? Then this utility is for you. You can select from a Search list of all files within the current account or simply enter a File Name. If the file name does not exist, you could have the option to create the file via our File Size Monitor utility (see product details) if that product is also installed; they work well in tandem. At the item name prompt, you can enter an item or search the dictionary. During this search, you can Print a Hard Copy of the entire dictionary, sorted by ascending attribute number and item name. You can then Define, Review, Edit, Copy, or Delete a dictionary item. You can also Test an item in an access listing to see how it performs.
Dispatch Data to Pagers or Cell Phones Click Product to Request a Free Demo Product Code DTPU	OSV	Ever wish your Dispatcher could simply enter data into a screen then hit SEND and it would somehow magically format the data & send it to the pager or cell phone of a technician or sales rep in the field? Well, your wish has been granted. We have a called subroutine that can be customized to format data from any number of multivalue files then send it via email to one or several pagers or cell phones. A test screen is included with this utility. It prompts for Dispatcher, Request Date, Request Time, Pager or Cell Phone Number, Recipient Email Addresses, and free-form entry of 12 lines of text. There are options to Send, File, or Delete the Dispatch. The first 3 prompts offer a Search so you can call up former Dispatches that have not yet been sent or that you wish to modify and/or send again, or that you are ready to delete. This test screen is designed to guide your in-house programmer in how to connect the subroutine call and collect data for your own dispatch application. Or we can connect and customize the call if you prefer.
ETL Exporting Click Product to Request a Free Demo Product Codes XLEU, CSVU, MDBU	OSV, CBI, GUI	We can Extract, Transform, and Load (ETL) your MultiValue / PICK Legacy Data from any number of files into a blended "normalized" work file then send the output to Excel Spreadsheets, Comma-Delimited files, or Access Databases via scalable, user-run utilities for conversions or migrations. The utility includes a Review mode to watch the Selection process and see how each record is populated. This utility is expandable; an unlimited number of Exports can be stored by Code Name for retrieval and export any time. When the screen is initially displayed, a search window opens so the user can select a Code Name. Each Code Name record includes a Description of the Export, a Primary MultiValue / PICK File Name, and a Windows file path for Export to an Excel Spreadsheet. Once this utility is installed and the first four sample Code Name subroutines have been customized to the User's own files for output as Exports, additional Code Names can be implemented by MvCaTs in 3 to 4 hours on average. So this one utility could become the hub for (re)producing ALL your ETL Exporting.
ETL Importing Click Product to Request a Free Demo Product Code XLIU	OSV, CBI, GUI	We can Extract, Transform, and Load (ETL) data from Excel Spreadsheets into a "normalized" PICK work file then redefine the output to update your MultiValue / PICK Database files for conversions or migrations. The Review option monitors the Selection & Creation processes to show how each record is populated; this protects your live data from being affected until you are sure the Import is producing the desired results. Then the Import option will convert spreadsheet data into your PICK files. The Report option will output your PICK data to 5 selectable Destinations: the Screen, a Line Printer, a Slave Printer, your Windows Printer, or a Hold File. And the Report may be run to include only the records "W"ritten to the DataBase, or only the Imported records which were "S"kipped, or "B"oth. The Edit option will display a detailed Screen Edit Listing from which you can choose records to Edit if any data requires correction. The chosen record will open in your preferred Editor. When the Import Utility is initially displayed, a Table Search window opens so the user can select which Import to run. Each Import in the Table includes an XLS Code (such as CUST), the Primary Data File to Import into (such as CUSTOMERS), an Import Description (such as Customer Import), and a Windows Source File Path to Import from (such as C:\XLS_IMPORT\CUSTOMERS.xls). Several files in addition to the Primary file may be updated at run time as well simply by specifying them during customization. This utility is expandable; once it has been installed and the first XLS Code subroutine has been customized to the User's own PICK file(s) for Import, additional XLS Code Imports can be implemented by MvCaTs in 4 to 5 hours on average. An unlimited number of Imports can be stored in the initial Search Table by XLS Code for repeated retrieval and Import any time. And any number of Source Path Names can reference the same XLS Code so that various spreadsheets can populate the same PICK files. For example, you may have several spreadsheets containing Customer data in the same format and would like to Import all of that data to your PICK database. We can setup each additional spreadsheet name in the Search Table, in a matter of minutes, to reference an already customized XLS Code, such as CUST. Then you simply run the utility and choose one of those Spreadsheets from the initial Table Search to perform that Import. This one utility could become the hub for (re)producing ALL your ETL Importing.
ETL Reporting Click Product to Request a Free Demo Product Code ETLU	OSV, CBI, GUI	We can Extract, Transform, and Load (ETL) your MultiValue / PICK Legacy Data from any number of files into a blended, "normalized" work file then format the report for output to 7 selectable Destinations: the Screen, a Line Printer, a Slave Printer, your Windows Printer, an Excel Spreadsheet, an Access Database, or a Hold File. This utility includes an optional Review mode to watch the Selection process and see how each work file record is populated. And it's expandable; an unlimited number of Reports can be stored by Report Code for retrieval and printing at any time. And once a Report has been sent to one destination, it can be sent to any of the others as well without regenerating. Just change the Destination then enter X1 to Report. When the screen is initially displayed, a search window opens so the user can select a Report Code. Each Report Code record includes a Description of the Report, a Primary MultiValue / PICK File Name, a Windows file path for Export to an Excel Spreadsheet or an Access Database, and an Access Table Name. Once this utility is installed and the first five sample Report Code subroutines have been customized to the User's own files for output as Reports or Exports, additional Report Codes can be implemented by MvCaTs in 3 to 4 hours on average. So this one utility could become the hub for (re)producing ALL your ETL Reporting.
Fast File Search or Report with Hard Copy Click Product to Request a Free Demo Product Code QFSU	OSV, CBI, GUI	With our Fast File Search or Report Utility, your IT staff will never need to write another custom search or report. The subroutine template which calls this Utility comes with complete step-by-step instructions on how to activate each desired feature. It can show full screen or a partial display window, include several columns of data or just IDs only, receive a list of pre-selected IDs or prompt the user. And it can display stacked data in any number of defined rows. It can also provide totals for monetary columns. And it can include data from both a Primary & Secondary file. This feature is great for reporting posted & unposted data together. And it includes a Hard Copy feature to enable the user to print a full Report to a Line, Slave, or Windows Printer with option to create a Hold file. And just by setting one switch, the Search can retrieve the data silently behind the scenes then deliver it to any GUI program for custom reporting. So one routine can do triple-duty. All MvCaTs file searches for both CBI & GUI screens call this utility. The subroutine template which performs the call can be cloned to any screen name then quickly customized.
Fast Table Search or Report with Hard Copy Click Product to Request a Free Demo Product Code QTSU	OSV, CBI, GUI	With our Fast Table Search or Report Utility, your IT staff will never need to write another custom search or report. The subroutine template which calls this Utility comes with complete step-by-step instructions on how to activate each desired feature. It can show full screen or a partial display window, include several columns of data or just IDs only, receive a list of pre-selected IDs or prompt the user. And it can display stacked data in any number of defined rows. It can also provide totals for monetary columns. And it includes a Hard Copy feature to enable the user to print a full Report to a Line, Slave, or Windows Printer with option to create a Hold file. And just by setting one switch, the Search can retrieve the data silently behind the scenes then deliver it to any GUI program for custom reporting. So one routine can do triple-duty. All MvCaTs table searches for both CBI & GUI screens call this utility. The subroutine template which performs the call can be cloned to any screen name then quickly customized.
File Size Monitor Click Product to Request a Free Demo Product Code MFMU	OSV	Are you weary of waiting for a full filesave and restore to resize your out-of-shape files in order to achieve optimum performance in data storage & retrieval? Have you ever had the dubious honor of resizing a file manually, with the tedium of creating a hold file, copying the DICT & DATA levels as well as any indexes, deleting the original file, then renaming the hold file back to the original file name? What a Bear! And if you don't enjoy trying to guess at the correct prime number Modulo to use when creating a new file, then our File Size Monitor is right for you. This utility makes "a la carte" File Size Creation, Monitoring, and Resizing a snap. You can select from a Search list of qualified files within the current account. This Search will display the Total Bytes, Current Modulo, Optimum Modulo, & Growth Modulo for each file listed. And the System Frame Size will be displayed. It's a fast and easy way to keep your finger on the pulse of all files in an account. And the Hard Copy (HC) Option in the Search window will enable you to print a report of this list to a selected printer. In lieu of searching, you can simply enter a File Name. If the file exists, the utility will retrieve & display the Current Modulo & the Total File Byte Size. If the file does not exist, the utility will prompt for that Total, providing the "String" Calculator (see details below) to experiment with the anticipated Average Item Size times Total Item Count to determine the Total File Byte Size. For example, 100 (bytes) * 2000 (items) = 200000 estimated Total File Byte Size. Then the System Frame Size will be retrieved, displayed, and used to calculate both the Suggested Optimum Modulo and the Suggested Growth Modulo. After these are displayed, the User can choose the X1 function to CREATE the file at the Optimum modulo if it does not exist. Or they can choose the X2 function to RESIZE an existing file to either the Optimum or Growth modulo. Literally in a matter of seconds, you can run this utility then be on your way to more important tasks.
Mailing Lists and Labels Click Product to Request a Free Demo Product Code MLLU	OSV	We can Extract, Transform, and Load (ETL) your MultiValue / PICK Legacy Data from any number of files into a blended "normalized" work file then format either to Labels any Number Across or to a Mailing List Report then output to the Screen, a Line Printer, a Slave Printer, your Windows Printer, or a Hold File, or Export to an Excel Spreadsheet. This utility includes a Review mode to watch the Selection process and see how each work file record is populated. To limit the selection, names can be mixed with record IDs in full or partial ranges. Or the user can specify a pre-selected list of IDs by entering 'GET' LISTNAME. This utility is expandable; any number of Mailing Lists & Label formats can be stored by Code Name for retrieval and printing any time. When the screen is initially displayed, a search window opens so the user can select a Code Name. Each Code Name record includes a Description of the Mailing List & Labels, a Primary MultiValue / PICK File Name, and a Windows file path for Export to an Excel Spreadsheet. After the work file is initially populated for Labels, a Report, or an Export, any of these 3 options can be run repeatedly without repopulating the file, until the user changes data in any field. And all fields are preserved for retrieval as defaults the next time the user calls up this utility and chooses a Code Name. Once this utility is installed and the sample Code Name subroutines have been customized to the User's own files for output as Labels, a Report, or an Export, additional Code Names can be created by MvCaTs in 3 to 4 hours on average. So this one utility could become the hub for (re)producing ALL your Mailing Lists and Labels.
Manage Spooler Hold Files Click Product to Request a Free Demo Product Code MHFU	OSV	This utility takes the grunt work out of managing scores or hundreds of Spooler Hold File Entries each month. When the screen is first activated, all Hold Entries are collected to populate a Work File. Then the first 3 prompts for Hold Dates, Port Numbers, and Account Names (or User Names depending on the OS), enable the user to narrow the Work File Search at the Hold Numbers prompt. The 4th prompt is Sort Order which enables the user to define the SORT BY Order for the Hold Numbers Search. Each prompt offers online help in a popup window by entering a ? at the prompt. And each prompt offers our Ticker Tape Editor with help for its use displayed on the bottom row of the screen. Prompt 5 for Hold Numbers will automatically open a Search window to display the Hold Entries which match the criteria specified in the first 4 prompts. Within the Search window, you may choose specific Line #s which correspond to Hold #s. Or you may choose a Range of Lines, for example, #~#. Each Line # selected will display an indicator signifying it has been selected. To deselect, simply enter a Line # again and the indicator will disappear. When you finish selecting Line #s within the Search window, enter FI to save your selections. Then they will display separated by semi-colons at the Hold Numbers prompt. If you do not wish to save your selections, you may enter EX or END to close the Search window without saving. If no Hold Numbers are selected, the Hold Numbers field will remain empty, indicating that ALL Hold Numbers which were displayed in the Search Window will be eligible for EDIT, DELETE, or REVIEW from the Modify prompt. At the Modify prompt, the user may perform the X1 EDIT function to view selected Hold Entries which can be Spooled to a Printer or the Terminal then deleted during EDIT if desired. The user may also perform the X2 DELETE to delete selected Hold Entries or ALL Hold Entries which match the criteria specified in the first 3 prompts if the Hold Numbers field is left empty. Also at the Modify prompt, the user may enter R to REVIEW the Deletion process in order to achieve a comfort level before activating the X2 function. And at the Modify prompt, the user may display online help for any other prompt by entering ?# where # is the prompt number.
Maintenance Double-Duty Inquiry Click Product to Request a Free Demo Product Code MAIN	OSV, GUI	Our CBI & GUI entry screens are written to include an INQUIRY flag so that one screen can handle both Maintenance and Inquiry. Simply by passing a special flag from a menu or proc and placing a few "hooks" in the code, a Maintenance screen can do "double-duty" as an Inquiry screen. Then both stay "in sync". This feature alone can add up to significant savings in both time and money, not only during initial development but also later, when upgrades are requested. You get two screens for the price of one, and there is only one screen to maintain going forward. If your software has separate screens for Maintenance and Inquiry, we can reengineer your Maintenance screen to do "double-duty". We provide screen samples for your in-house programmers.
MultiValue Editor Click Product to Request a Free Demo Product Code MVEU	OSV, CBI	Our MultiValue Editor takes all the "grunt work" out of multivalue handling. It can be used to edit or display a single value field or an entire value set with values displayed on different screen rows. The Editor is called after a Prompt Literal is displayed in the calling routine and has selectable in-screen or bottom-screen prompting. It will handle input of one line at a time to Add, Insert, or Replace any data field within a value set & will continue to Add or Insert through the set until a Null entry is received at the controlling prompt. It also handles all Deleting and value set Paging Forward or Back any number of Pages. And it offers the Option to Move a line to a different Line Number. It also includes our "String" Calculator capability for Amount fields so a formula can be entered instead of an amount. And it can begin the calculation with the amount already stored in the field. The subroutine call to this Editor can be connected easily to any non-GUI MultiValue prompt. A test screen is included with this utility to guide your in-house programmer in how to connect the Editor to each field of a value set. Or we can connect it wherever you like.
PassWord Encryption Click Product to Request a Free Demo Product Code PWMU	OSV, GUI	We offer custom PassWord Encryption with tampering detection on MultiValue / PICK Legacy systems for both AccuTerm GUI and CBI screens and menus. This feature includes a Maintenance screen as well as a PassWord prompt screen. The CBI version of the prompt screen uses our Ticker Tape Text Editor to prompt for the PassWord by displaying an Asterisk (*) in place of each character entered. The "Three Strikes Rule" applies. A User will have three opportunities to get the PassWord right before access to the destination screen is denied. The PassWord prompt screen will open in the center of the screen which calls it. This subroutine call is easy to connect to client screens.
Revolving Menus Unleashed Click Product to Request a Free Demo Product Code DRUM	OSV	You are probably familiar with "green screen" Menus that long ago ran out of room to display selections. So the programmer began using letters and other keyboard characters as options. This is not only confusing to the user but overcrowds both the menu display and the Menu Selection line. MvCaTs provides table-driven "Revolving" Menus which are run from a single driver routine and can display a changeable number of Selections per "page" (from 1 to 34) with an unlimited number of "pages". So One Size (literally) Fits All. Let's say the Menu is preset to display 20 Selections per page and contains a total of 48 defined selections. The first 20 are shown when the Menu is displayed initially. And the Selection Line reads: 1-48,F[#],B[#],L#,MS#,S,? or E[ND]. You know immediately how many selections there are. And you can page Forward or Back any [#] of pages. If the first page is displayed and you want to go Back, the screen will "revolve" to the last page. If the last page is displayed, and you want to go Forward, the screen will "revolve" to the first page. Or you can List from any Selection # and the display will start with that # and show up to the preset 20 selections. To display fewer or more selections per "page" at run time, you can enter MS# where # is the number of selections to display per "page". To easily find a selection, you can enter S[string] where string is part of the Selection Label you want to find. If string is omitted, you will be prompted. Each Selection Label which matches string will be displayed and you will have the option to activate that selection or continue or exit the search. If you can't remember what all the Menu Selection Line options mean, just enter ? to open a help window. As an added bonus, if a selection is entered as R#, the menu will display the Selection Label for #, whether control will return to the menu after the selection is performed, and what action is about to be taken (such as EXECUTE PROGRAM where PROGRAM is the actual name attached to the menu). This makes tracing from a menu so much easier for your IT staff. A revolving menu can also be executed from another revolving menu to act as a sub-menu. This product includes a Menu Maintenance Utility screen which let's your System Administrator create powerful menus with just a few keystrokes. You can search for existing menus or enter a known menu ID or a new menu ID. If the Menu is PassWord protected, you must know the PassWord in order to be allowed to edit the Menu. The screen will prompt for Menu Title and Number of Selections to Display per Screen "page". Then a value set will prompt for Selection Label, Program or Procedure to run, and Action to Perform (for example, EXECUTE). An unlimited number of Selections may be Added, Inserted, Deleted, or Moved around. A Menu table may be Filed with or without the Menu Test option. It may also be Copied to a New Name or Deleted. Existing Client menus can be converted very quickly to Revolving Menus because there is no programming required.
Scan For Corrupted Data Click Product to Request a Free Demo Product Code SFCU	OSV	Is your data entry staff having trouble switching between the "green screen" [Enter] key and the Windows [Tab] key? Trying to move from one field to the next by pressing the Tab key in a "green screen" will look to the user as though nothing has happened. But a CHAR(9) becomes embedded in the data at any point where the user hits the Tab key. The presence of "invisible" embedded control characters in data can impair your system's ability to select and report on affected data. Yet, when you "eyeball" the data that's missing from your reports, it will appear to be perfectly normal. At that point, you'll want to tear your hair out and blame the programmer. But let's not go there. Instead, we offer a utility to Scan multivalue files for the presence of embedded Control Characters. The user can specify one, several, or ALL files throughout an entire Account. Or the user can Search for files to scan then enter the line number of each file to include. If a single file name is entered, the user will have the option to specify one, several, or all IDs to limit the scan. Then they can indicate whether to Locate, Remove, or Replace control characters found during the scan. After the Scan has been performed, the User will have the option to Print a Screen Report of the findings, with a Hard Copy option to send the report to a printer. This utility can ensure that your files remain "clean" for selection and reporting. And it can be used to identify data that continually becomes "corrupted" with control characters to determine which screen(s) may be the culprit. Once identified, we offer another subroutine which can be called from any non-GUI prompt to remove control characters right after the user presses [Enter]. This subroutine is called from every prompt in every MvCaTs non-GUI screen.
Screen Cloning Click Product to Request a Free Demo Product Codes CCSU, CGSU	GUI	We offer one clone utility for CBI and another for GUI Screens. Both are written in AccuTerm GUI. And both take care of all "housekeeping" related to cloning a screen. Both have options to Copy to a New Name, a New File, and Delete After. Once the Application Name has been specified, the utility finds the files where it exists, collects all programs that begin with that name, copies each to the new name or new files, changes all references to the former name in the new version, compiles & catalogs the new, decatalogs & deletes the old (if applicable), copies or removes the password if applicable, and creates audit trails. This utility greatly increases accuracy and programmer productivity. It's great for archiving old screens and creating new versions. It's also great for creating new screens because you can select a screen which does something similar to what you need to accomplish. Then you can clone it and be well on you way to creating that new screen or report without having to "reinvent the wheel".
Search and Replace with Undo Click Product to Request a Free Demo Product Code SARU	OSV	Our Global Search & Replace (or Remove) Utility can search any number of files throughout an entire Account. It includes Find, Ask to Replace, Replace, List, & Undo options as well as a Review (Look before you Leap) feature. It can also Compile & Catalog after changing program files. And record IDs can be included in or excluded from the search. The List option displays a search window showing all Files where any records were modified. If the user selects a File from this list, another search window opens to display IDs of all records which were (or would be) modified in that File. If the user selects an ID, the Editor will open to enable review or further modifications to that record. After editing, this search window will redisplay with the most recent line number selection as the default. This utility greatly increases productivity for programmers and management. If you've ever experienced the cold sweat that comes from realizing that the global change you just made to your data or software was a big mistake, then our Undo option is right up your alley!
"String" Calculator Click Product to Request a Free Demo Product Code STRC	OSV, CBI, GUI	Our "String" Calculator can be called from any "monetary" CBI or GUI prompt to calculate a "String" formula entered by a user, then return the Result. Valid Operators are: ()^%*/+-. For example, if the user enters 325%10, the Result would be 32.5 (10% of 325). If the field already contains an amount which the user wants to start with, they can simply begin the formula with an operator. For example, let's say the field is Balance Due and it already contains 153.27. If the user wants to log a payment and types -20 [Enter], the Result would be 133.27. This subroutine call can be connected easily to any CBI or GUI monetary prompt. A test screen is included with this utility to guide your in-house programmer in how to connect the call.
"String of Pearls" Validator Click Product to Request a Free Demo Product Code SOPV	OSV, CBI, GUI	Our "String of Pearls" Validator can turn any CBI or GUI single entry field into a multiple entry field then handle all validation, conversions, and extracts. The user enters Individual Criteria separated by semi-colons, as #;#. Range Criteria can be separated by tilde, as #~# and leading or trailing # can be omitted for open Ranges. Use ] and/or [ to indicate wild card selection, for example: 10] selects data beginning with 10; [10 selects data ending with 10. Leaving the field empty indicates that ALL Criteria should be included. Once the User leaves the field, the String of Pearls subroutine is called. Any "pearl" which fails to validate is removed from the "string" so if one side of a range entry fails to validate, the entire range is removed. If no "pearls" validate, the "string" will be returned empty. If the Required flag is set, the User will be informed that Entry is Required and the field will reprompt. If a Dictionary Item Name is passed to the validator, a variable will be populated with the portion of an access sentence which can be used to select the "pearls". For example, if 'WITH INV.DATE' is passed to the validator, and the user entered "7/30/09;~6/25/09", the selection variable would be set to 'WITH INV.DATE EQ "07/30/2009" OR WITH INV.DATE LE "06/25/2009"'. This subroutine call can be connected easily to any CBI or GUI prompt. A test screen is included with this utility to guide your in-house programmer in how to connect the call.
Table Maintenance Utility Click Product to Request a Free Demo Product Code TMUU	OSV	This utility takes the tedium out of Creating & Maintaining Tables. At the Table Name prompt, you can enter a Name or search the file. If a new Name is specified, you will be prompted for a Table Description which will become the Screen Title when this Table is displayed in a Search window. Then you will be asked for the Sort Order (AL,AR,DL,DR or NA) to perform on the table data columns. Sort Order NA will keep the table in the order in which lines were entered. But if the Sort Order is not NA, the Table will be sorted whenever it is filed, copied, or before verifying a user request to exit without saving changes. Up to four Column Headers can be specified which then become the Prompt Headers to accommodate up to four associated Data Columns in a value set. The first data column must contain unique entries with no duplicates. Columns 2 through 4, if those Headers are specified, will contain data associated with each entry in the first column. To remove a data column, just clear the Header. Each screen prompt has an online help window that can be opened not only at the prompt but also from the screen Selection line. At the Selection line prompt, you will be able to page forward or back through the data column value set, reactivate Walk mode at any prompt, Copy to a New Table Name, open online Help for the options in the Selection line, File the Table after sorting, or Exit without saving changes.
Telephone Number Validator Click Product to Request a Free Demo Product Code TELV	OSV, CBI, GUI	Our Telephone Number Validator can be called from any CBI or GUI prompt to validate then format entry in any combination of alpha and/or numeric characters. For example, enter a toll-free number such as 888MVTECHS and the validator will return 888-688-3247. The user can also tack an extension onto a 10 character number or an extension can be preceded by a comma. For example, if the user enters 888MVTECHS,236 or 888MVTECHSCEO, the validator would return 888-688-3247,x236. If a phone number is entered containing a space, the number will not be validated or formatted. This will enable entry of international numbers. A leading 1 will be removed whereas a leading 0 will be preserved after entry has been formatted. This subroutine passes only the phone number and error message variables and is very easy to connect.
Ticker Tape Text Editor Click Product to Request a Free Demo Product Code TTTE	OSV, CBI	Ever wish you could use the Tab key to move from one prompt to another in a non-GUI screen, just as you are used to in a GUI (Windows) screen? Our Ticker Tape Text Editor can be called from any non-GUI prompt to enable unlimited text entry and character editing without "overflowing" the field or destroying the screen display. And the user can press either the Tab key or the [Enter] key to go on to the next prompt. This Editor can prompt in-screen or bottom-screen. And it eliminates the need to reenter an entire field just to make a small change. (For example, what if the user typed in the Customer Name then pressed [Enter] but forgot to include the ', Inc.'? Without Ticker Tape, they would have to reenter the entire Customer Name. But with Ticker Tape, they go back to the field, enter CTRL<Z> to go to the end of the data, then type ', Inc.' and press [Enter].) When data entry reaches the end of the field, the data begins to "ticker tape" off the left side of the field, just as it does if you enter data in a text field in a GUI (Windows) screen. The bottom line of the terminal displays revolving help messages which explain the handful of intuitive control commands which enable the text to be edited. CTRL<L> will Locate a string within the text. CTRL<D> will Delete from the current position through the end of the text, etc. As an added bonus, our Ticker Tape Text Editor can prompt for a PassWord by displaying an Asterisk (*) in place of each character entered. This editor is compatible with any terminal, PC, or workstation keyboard and the subroutine call can be attached quickly to any non-GUI prompt. A test screen is included with this utility to guide your in-house programmer in how to connect the call or MvCaTs can do it for you.
Version Control with User Preference Click Product to Request a Free Demo Product Code VCUP	OSV, CBI, GUI	MvCaTs Version Control includes User Preference. Individual users can decide whether to run the OSV (Original Screen Version), the reengineered CBI (Character Based Interface) version (which shares its subs with GUI), or the GUI (Graphical User Interface) version based on a control flag. Both the CBI and GUI versions will have a layout very similar to the original screen. A simple generic Application Name and Description (such as XLIU for Excel Import Utility) will be assigned in the Version Control screen. Then an Active and Development Program Name can then be assigned to each OSV, CBI & GUI version. Next, the Application Name (for example XLIU) will be attached to your "green screen" menu or GUI menu. Once attached to the menu, it never has to be changed again because version control will dispatch the correct program version afterward. The User Preference screen enables the User to choose which of the 3 versions they prefer. Then when a user chooses that menu selection, Version Control checks User Preference and runs the preferred screen. With Version Control, we can Rollback the Rollout of a new screen to its former version in a matter of seconds if something unforeseen occurs which would require the new version to revert to development. Both the Version Control & User Preference screens contain a Review option to enable you to see which files and record IDs would be affected if the record was filed. And Version Control enables editing of any of the six programs attached by entering a simple 3 character code at the Option prompt. For example, to edit the GUI Active Program, the user would enter EGA (which means Edit GUI Active; EGD means Edit GUI Development). Then the actual Program source code would appear in the AccuTerm WED editor (if available) or else the ED editor. This edit feature saves the programmer lots of research and keystrokes.
Custom Programming and Terms	OSV, CBI, GUI	If it's MultiValue, we support it, whether you're running ADDS/NCR, Advanced Revelation (ARev), AP Pro, AT&T, D3 (Raining Data, TigerLogic), D3ProPlus, Honeywell, IBM U2 (UniData/UniVerse), jBase, mvBASE, mvENTERPRISE, OpenInsight, Power95Plus, Prime, R83, R91, Reality/Sequel, Ultimate, UniVision. If you are running Caché, Mumps, ONware, or OpenQM, we may be able to support those as well. And we'll even let you negotiate custom terms. We're a.k.a. MvCaTs: Affordable, Knowledgeable, Available.
If your work speaks for itself, don't interrupt.