[ A B Y SCRNLINE C [A  M A I L L I S T P R O G R A M 컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 賽賽賽賽賽賽賽賽賽賽賽賽賽賽賽賽賽賽賽賽賽賽賽賽賽賽賽� Creating MailList Data Base - MISCNAME.DBF There are two ways of introducing existing MAIL LIST data to the DYNAMENU Mail List System. The most straight forward method, however possibly more time consuming, is to use the everyday program, supplied in the main menu, to add/edit names. This means typing much of the information, which may be the best way depending on the level of computing expertise on staff and the amount of data to be typed. Another method involves the use of a utility program, found in the NAMES column (column 1) to import an existing word processor or ASCII type file. The latter requires that an existing data be manipulated to support the order of the DYNAMENU Mail List System database (MISCNAME.DBF) which is described as follows. To utilize the import method select the IMPORT NAMES entry. Two types of ASCII files may be imported using this program; the user will be asked to specify either a Comma delimited or Space delimited. A sample of a Comma delimited file follows: "","RMC LONESTAR","Guy","Waller", "45601 Telstar Parkway", "Pleasanton, CA","94566", "Technical Sales & Marketing Manager", "415/442-6267","008","SFYP", As one can see, a Comma delimited file is comprised of random length records. There are eleven fields in the record shown above. A minimum of two double quotes (preceded by a comma if it is not the first field in the record) are required to represent a field with an absence of data. Note the two double quotes and the comma at the beginning of the record. This information is required to determine where the information for a particular name ends and the next one begins. In the Space delimited file below, the first field also has no data represented; however, the meaning of the data and the anticipated length of the field, in terms of blank spaces, is provided for potential use. Typically the first field will not contain any data. Space delimited files (actually called System Data Format) are different in that each field is filled with spaces (as the reference implies) even when there is no data: _____(Five character field is reserved for mail list number. Leave this field blank) RMC LONESTAR___________________________(Company(40)) Guy_________________First Name (20)) Waller______________(Last Name (20)) 45601 Telstar Parkway___________________(Street Address 40) Pleasanton, CA___________(City, State (25)) 94566_____(Zip Code (10)) Technical Sales & Marketing Manager_____(Title(40)) 415/442-6267 (Telephone Number (12)) 008___(General classification of this name (6)) see Mail List Classifications below. SFYP________(source of this name (12)) In reality, each example of these two filetypes represents one record on a single line and are shown as they are for page display reasons. In other words, only one carriage return should be present for any name and it should be at the end of the data representing a single name. The user will then be prompted for an input filename - that file/directory must be resident. When the file is found and successfully converted the user is asked to review the file and approve it's use. Use the page up/down, arrow, tab, end and home keys to look over the results. Pay particular attention to the names of the fields versus the corresponding content of those fields. After pressing , if the results are favorable, respond positively otherwise respond negatively. Each time the MISCNAME file is newly created, the existing file is saved in a file called TEMPNAME.TMP. Responding negatively will cause all changes to be reversed - file TEMPNAME.TMP will have been erased in this case. In the event that the import needs to be accomplished a second or third time, it is as simple as starting over again at step one. Make any necessary changes to the original input file and leave the rest to the import program. NOTE: The import program will allow the complete overwrite of the MISCNAME database. If records have been previously added to that database be very careful to not overlay if that is not your intention. If there are records present in the existing file - the user is notified and options are presented. Mail List Classifications Every name in the MISCNAME.DBF file contains a classification that is derived from the MISCLASS.DBF. A window is brought up at the end of every add or when you are making changes to an existing name - this window allows the user to select previously determined name classifications. The entry in the 'NAMES' column (column 1) for MAIL CLASSES i simply a review of the database MISCLASS.DBF using program FILEBROW. You may add/edit/delete the classifications in the MISCLASS.DBF by selecting 'MAIL CLASSES' program in the main menu under the column labeled 'NAMES'. If you intend to import names into this file, be sure to create an input file with all fields filled in (except MAIL LIST NUMBER). This will make it much easier to subsequently integrate the file.