MBF COMPANY CONFIDENTIAL FIELD INFORMATION BULLETIN SERVICE GROUP(S): MICRO,MINI,LARGE MFG: ACCESS TECHNOLOGY NACS TYPE(S): N053 MFG. MODEL(S): 20/20 CATEGORY: SOFTWARE DESC: Spreadsheet *** TABLE OF CONTENTS AS OF 12/20/90 *** FIB 00001.Integration of MBF Data Files with 20/20 [ WPSF 626 ]......10/11/90 FIB 00002.ACCESS 20/20 2.3 for GPx40/MSDOS Software Announcement [ WP11/19/90 SOFTWARE-ACCESS TECHNOLOGY-20/20--------------------Table Of Contents Pg01 of 01 FIB 00001 10/11/90 *** Integration of MBF Data Files with 20/20 [ WPSF 626 ] *** QUESTION: Can 'MBF' data files be integrated with a 20/20 Spreadsheet? (Where 'MBF' represents any application software which currently runs on MBF hardware). ANSWER: 20/20 does allow data files from outside the 20/20 software package to be imported into a spreedsheet. However, MBF file types (except for string type) are not recognized by 20/20. If the customer would like to use his data files for 20/20, then he would: 1) Create a string file. 2) Read his data from the MBF file and write it to the string file, specifying a field delimiter and record delimiter. The record delimiter must be a double field delimiter. For example, if the field delimiter is a #, then the record delimitor would be two #'s (##). This is an example of one file type that 20/20 would recognize. The instructions for importing into 20/20 can be found in the 20/20 Manual under the Integration section. The instructions will explain how to import different file structures. ORIGINATOR: Jackie Shea SOFTWARE-ACCESS TECHNOLOGY-20/20--------------------FIB001 Pg001 FIB 00002 11/19/90 *** ACCESS 20/20 2.3 for GPx40/MSDOS Software Announcement [ WPSS 179 ] *** MAI Basic Four, Inc. is pleased to announce the availability of Access 20/20 Release 2.3 on the GPx Series 40 and MS-DOS based platforms. Access 20/20 is a powerful, yet uncomplicated, spreadsheet software package. MBF is an authorized distributor of Access 20/20 on MBF hardware for both the UNIX and DOS products. Access 20/20 will run on the following platforms: Hardware Platform Operating System Required o GPx Series 40 1.0A or above o MS-DOS machines 3.0 or above This software announcement will describe in detail the installation and setup of Access 20/20 for the GPx Series 40 platform including MBF terminal and printer definitions. As a distributor, MBF can sell Access 20/20 directly. If problems arise with MBF terminals, printers or hardware platforms (specified in this announcement) and Access 20/20, support is provided by MBF. Access 20/20 provides direct support to licensed users in the form of telephone support. Assistance can be provided for both DOS and UNIX versions of Access 20/20. TABLE OF CONTENTS 1.0 SYSTEM REQUIREMENTS. . . . . . . . . . . . . . . . . . . . 1 1.1 MEMORY REQUIREMENTS . . . . . . . . . . . . . . . . . 1 1.2 DISK REQUIREMENTS . . . . . . . . . . . . . . . . . . 1 2.0 ACCESS 20/20 INSTALLATION INSTRUCTIONS . . . . . . . . . . 1 3.0 MBF TERMINAL SUPPORT FOR 1.0A*30 . . . . . . . . . . . . . 3 3.1 MBF TERMINAL SUPPORT FOR 1.0B OR HIGHER . . . . . . . 4 4.0 EXECUTING ACCESS 20/20 . . . . . . . . . . . . . . . . . . 4 5.0 PRINTER SUPPORT FOR ACCESS 20/20 . . . . . . . . . . . . . 7 5.1 MBF SPOOLER CONFIGURATION . . . . . . . . . . . . . . 7 5.1.2 ACCESS 20/20 PRINTER SETUP WITH MBF SPOOLER . 7 5.2 UNIX SPOOLER CONFIGURATION. . . . . . . . . . . . . . 8 5.2.1 ACCESS 20/20 PRINTER SETUP WITH UNIX SPOOLER .10 6.0 HELPFUL HINTS. . . . . . . . . . . . . . . . . . . . . . .11 7.0 ADDITIONAL REFERENCE MATERIAL. . . . . . . . . . . . . . .11 1.0 SYSTEM REQUIREMENTS SOFTWARE-ACCESS TECHNOLOGY-20/20--------------------FIB002 Pg001 SYSTEM O/S LEVEL GPx 340 1.0A *30 GPx 440 1.0A *30 GPx 240 1.0B Before 20/20 can be installed successfully, the UNX product must be installed from the operating system tape. 1.1 MEMORY REQUIREMENTS Minimum 4MB Memory NOTE: It is recommended that the 80387 math co-processor be installed on the system for better performance using 20/20. 1.2 DISK REQUIREMENTS 20/20 needs approximately 2.4MB of disk space on the root partition. 2.0 ACCESS 20/20 INSTALLATION INSTRUCTIONS When installing 20/20, it is recommended to have all users log off the system. Once they are off: STEP 1: Log on as root at the console. STEP 2: At the shell prompt, change directory to /tmp. #cd /tmp STEP 3: Insert the 1/4" tape or the first of two 3 1/2" floppies that contain the 20/20 software into the appropriate drive. Enter the following command to restore 20/20 if installing from a 1/4" cartridge: #cpio -icvdumB < /dev/tape Enter the following command to restore 20/20 if installing from a 3 1/2" floppy: #cpio -icvdumB < /dev/dsk/f03ht After the first floppy has been restored, you will be returned to the shell prompt. Remove the first floppy from the drive, install the second floppy and enter the same cpio command as above to restore the contents of the second floppy. NOTE: When installing from a 3 1/2" floppy, there is a long delay (approx. 3 minutes) before the first file is restored. No message is displayed on the screen until the listing of the files being restored is displayed. BE PATIENT and do not abort the install. STEP 4: Execute the interactive 20/20 installation script, /tmp/i2020. This file is an interactive string file that will prompt for the library and startup directories for 20/20 and the company site-specific information, including; company name, support SOFTWARE-ACCESS TECHNOLOGY-20/20--------------------FIB002 Pg002 phone number, and software license number. The directories /usr2/2020lib and /usr2/2020exe are suggested directories for the library and startup directory prompts during 20/20 installation. If the directories, /usr2/2020lib and /usr2/2020exe, do not exist, they MUST be created using the mkdir command prior to executing the 20/20 installation script. #/tmp/i2020.r2 The message, '20/20 Installation Starting', will display. The installation script will then move all the 20/20 files from the /tmp directory to the library and startup directories specified above. The files will be deleted from the /tmp directory after a successful transfer. Once the files are moved and the temporary directory cleaned, the message, '20/20 INSTALLATION COMPLETED', will display and you will be returned to the shell prompt. NOTE: If the library directory specified does not exist, the installation program will display the following message: /xxx is not a valid directory. Enter the full pathname of the 20/20 library directory. where /xxx is the directory specified earlier. NOTE: A CTRL+C will abort the 20/20 installation if needed. Return to step 1 to start the installation process again. 3.0 MBF TERMINAL SUPPORT FOR 1.0A*30 In order to use an MBF terminal with 20/20, the contents of the file, tfil.mbf, must be added to the 20/20 terminal database file, tfil. The file, tfil.mbf, resides under the /usr/tps/2020 directory and is restored from the operating system tape when the UNX product is installed. The 20/20 terminal database file, tfil, is a text file and resides in the 20/20 library directory specified during installation. The text file is too large to be edited using the UNIX editor, vi. Follow the steps below to insert the contents of 'tfil.mbf' into the 'tfil' database. STEP 1: Copy the mbf terminal file 'tfil.mbf' to the /usr2/2020lib.r2 directory. #cp /usr/tps/2020/tfil.mbf /usr2/2020lib/2020.r2 STEP 2: Change directory to 2020 library directory. #cd /usr2/2020lib STEP 3: Make a back up copy of the 2020 terminal database file. #cp 2020.r2/tfil 2020.r2/tfil.orig STEP 4: Split the text file at DEVICE. SOFTWARE-ACCESS TECHNOLOGY-20/20--------------------FIB002 Pg003 #csplit 2020.r2/tfil '/^!DEVICE/' The quotes must be included in the above command. Two numbers will be displayed before returning to the shell prompt. STEP 5: Cat from the mbf terminal file to the 2020 terminal database file. #cat xx00 2020.r2/tfil.mbf xx01 > 2020.r2/tfil STEP 6: Merge the text file back together using the indextfl command. #/usr2/2020exe/indextfl 2020.r2/tfil STEP 7: Remove xx00 and xx01. #rm xx00 xx01 3.1 MBF TERMINAL SUPPORT FOR 1.0B OR HIGHER In order to use an MBF terminal with 20/20, the terminal installation script, mbf2020, must be run. This is an interactive script that will guide the user through the installation. To run this script, you must be logged on as root. The terminal script, mbf2020, will add the contents of the file, tfil.mbf, to the 20/20 terminal database file, tfil. The file, tfil.mbf, resides under the /usr/tps/2020 directory and is restored from the operating system tape when the UNX product is installed. The 20/20 terminal database file, tfil, is a text file and resides in the 20/20 library directory specified during installation. The text file is too large to be edited using the UNIX editor, vi. STEP 1: Change directory to the /usr/tps/2020 directory. #cd /usr/tps/2020 STEP 2: Execute the terminal script file mbf2020. #./mbf2020 NOTE: On the 1.0B operating system tape, the UNX product is a selectable item using mbfinstall. On the 1.0C operating system tape, the UNX product is NOT a selectable item from the product menu. The UNX product is installed as part of the base system during a new operating system installation or update. 4.0 EXECUTING ACCESS 20/20 In order to use the 20/20 Software package, an operator must be set-up in oprinfo to log onto the system. NOTE: If every user on the system will be using 20/20, the file, /usr/mbf/etc/mbfprofile file can be modified to include the correct PATH definition which is described in detail under Step 2. The /usr/mbf/etc/mbfprofile file is the file that is used as the default when an individual user's .profile file is created. STEP 1: From the shell prompt, type: SOFTWARE-ACCESS TECHNOLOGY-20/20--------------------FIB002 Pg004 # oprinfo The operator information menu displays. Select option number one to add an operator. The home directory should be where all the user files will be stored. For example: /usr2/operator_name Set the program option to: /xxx/xxx/s2020 (ie; /usr2/2020exe/s2020) * /xxx/xxx should be the directory where the 20/20 executable files reside. A to continue will display the following message on 1.0A or 1.0B operating systems ONLY: 'The program specified cannot be run unless the shell is '/bin/execsh'. Enter to continue. The system will automatically change the login shell from /bin/sh to /bin/execsh. to end. When prompted to have a profile file created for user, answer yes! NOTE: On 1.0C operating system level, the user's .profile is automatically created in the user's home directory in all cases except where BASIC is being executed initially. If BASIC is executed initially, then the user is prompted to create a .profile file. STEP 2: Modify the .profile file for each 20/20 User. NOTE: If the /usr/mbf/etc/mbfprofile file has not been modified or existing operators have been added prior to modifying the /usr/mbf/etc/mbfprofile file, the following step must be executed. From the shell prompt: #cd /usr2/operator_name #vi .profile The UNIX editor displays with the default .profile file. Command mode and input mode key strokes: Command mode: o Shift + g - moves cursor to the end of file. o Arrow keys - moves cursor one character at a time up, down, left or right. o 'a' (append) - exits command mode and enters input mode. The cursor will move one character to the right for input. o 'O' (Open) - exits command mode and enters input mode. A blank line will be inserted above the line that the cursor resides SOFTWARE-ACCESS TECHNOLOGY-20/20--------------------FIB002 Pg005 on. o ESC - exits input mode and returns to command mode. Cursor movement can be executed with arrow keys. Using shift + g move to the end of the file. Use the arrow keys to move up to the PATH=:... line and to the end. Press the letter 'a' to enter append mode and add the user's directory to the PATH. # PATH=:$PATH:"your_path" # PATH=:$PATH:/usr2/2020exe HZ=100 export MAIL PATH TERM HZ ESC exits input mode, :wq writes the changes to the file and exits the editor. NOTE: A SHIFT + zz is another way of writing the changes to the file and exiting the editor. 5.0 PRINTER SUPPORT FOR ACCESS 20/20 5.1 MBF SPOOLER CONFIGURATION In order to configure a device in the MBF configure utility, the system must be in single user mode. If the printer device is already configured in the MBF configure utility, skip to Step 1 under Section 5.1.2, 20/20 Printer Setup With MBF Spooler. STEP 1: From the shell prompt, enter: # configure Select the option to add a device and type in the correct port number. Define the port for printer type and select the option that corresponds to the printer that is connected to the port. STEP 2: Save the configuration and exit the configure utility. STEP 3: Boot up into multi-user mode. 5.1.2 ACCESS 20/20 PRINTER SETUP WITH MBF SPOOLER STEP 1: Logged on as root, change directory to the 20/20 library directory specified during product installation. # cd /usr2/2020lib/2020.r2 STEP 2: Edit the 20/20 system tailoring file, 2020ini.sh file to add the default spooler command, using the vi editor. Locate the line that defines the SuPQDF variable and modify the line as follows: SOFTWARE-ACCESS TECHNOLOGY-20/20--------------------FIB002 Pg006 export SuPQDF; SuPQDF='1pr' NOTE: If only one printer will be used to output 20/20 spreadsheets, then the 1pr command can specify the printer name. For example: 'lpr list= P#'. STEP 3: Save changes to the tailoring file by entering: :wq 5.2 UNIX SPOOLER CONFIGURATION STEP 1: Verify that a device file for the printer exists. # ls -l /dev If the device file already exists and the UNIX spooler process has been successfully started, skip to Section 5.3.. If the device file does not exist for the corresponding port to which the printer is connected, create the device file with the following command: # mknod /dev/tty0xx c 31 yy Where xx represents the port number and yy represents the minor number. - Minor number is always the same as port number. - Major number 31 is for serial devices. - Serial printers are defined as a tty device. STEP 2: Start the UNIX Print Services. Verify that the UNIX spooler process (/usr/lib/lpsched) exists. # ps -ef If the process does not exist, start the process: # /usr/lib/lpsched The message, 'print services started', will display. STEP 3: Define Printer Name and Port Configuration. The port containing the printer should be the same as the port defined in Step 1. # /usr/lib/lpadmin -p -v . A warning will display that others can access the printer and unwanted output may result. STEP 4: Define Printer Attributes. The default printer attributes regarding communications, are shown below: SOFTWARE-ACCESS TECHNOLOGY-20/20--------------------FIB002 Pg007 SYMBOL MEANING 9600 9600 baud rate cs8 character size 8-bits -cstopb 1 stop bit -parenb no parity checking ixon enable XON/XOFF flow control -ixany allow only XON to restart output If any of these attributes need to be changed, the lpadmin command with the -0 and stty option will need to be used. For example, to configure the printer for 7 data bits and odd parity, type: # /usr/lib/lpadmin -p -o "stty = 'parenb parodd cs7" NOTE: Where is the same name previously specified in Section 5.2, Step 3. At this point, the printer is fully configured. STEP 5: Enable the UNIX spooler and printer. To enable the spooler, enter: # /usr/lib/accept To enable the printer, enter: # enable Now the printer is configured and ready to accept print requests in the UNIX spooler. 5.2.1 ACCESS 20/20 PRINTER SETUP WITH UNIX SPOOLER NOTE: Before adding 20/20 printing capabilities to the UNIX spooler, verify that the printer is defined in the UNIX spooler and currently accepting UNIX print files. Refer to Section 5.2 for UNIX spooler printer set-up. STEP 1: Logged on as root, cd to the 20/20 library directory specified during product installation. # cd /usr2/20/20lib/2020.r2 STEP 2: Edit the 20/20 system tailoring file, 2020ini.sh file to add the default spooler command, using the vi editor. Locate the line that defines the SuPQDF variable and modify the line as follows: export SuPQDF; SuPQDF='lp' NOTE: If only one printer will be used to output 20/20 spreadsheets, then the 1pr command can specify the printer name. For example: 'lpr list= P#'. SOFTWARE-ACCESS TECHNOLOGY-20/20--------------------FIB002 Pg008 STEP 3: Save changes to the tailoring file by entering: :wq 6.0 HELPFUL HINTS QUESTION: Can 'MBF' data files be integrated with a 20/20 Spreadsheet? (Where 'MBF' represents any application software which currently runs on MBF hardware). ANSWER: 20/20 does allow data files from outside the 20/20 software package to be imported into a spreedsheet. However, MBF file types (except for string type) are not recognized by 20/20. If the customer would like to use his data files for 20/20, then he would: 1) Create a string file. 2) Read his data from the MBF file and write it to the string file, specifying a field delimiter and record delimiter. The record delimiter must be a double field delimiter. For example, if the field delimiter is a #, then the record delimitor would be two #'s (##). This is an example of one file type that 20/20 would recognize. The instructions for importing into 20/20 can be found in the 20/20 Manual under the Integration section. The instructions will explain how to import different file structures. 7.0 ADDITIONAL REFERENCE MATERIAL For additional reference regarding 20/20, refer to: o 20/20 for UNIX-Based Systems - Installation Guide AT&T 6386 o AT&T UNIX System V/386 Release 3.2 System Administrator's Reference Manual ORIGINATOR: Jackie Shea SOFTWARE-ACCESS TECHNOLOGY-20/20--------------------FIB002 Pg009