subject: IMPORTING overview: IMPORT is the process of bringing data from other sources into your PC-Type II text file. If you have not defined an import data source via the Configuration process of PC-Type II, you must define the source and record selection criteria which begins with the menu shown below. (See the "Import Source Definition" and "Import Selection Definition" sections in the Configure section of this manual). 旼컴컴컴컴컴컴컴커 쿔MPORT options: � 팠袴袴袴袴袴袴袴孤 � (0) PC-File+ � � (1) PC-FILE:dB � � (2) PC-Calc+ � � (3) Mail � � (4) ASCII-L � � (5) ASCII-C � � (X) Exit � 읕컴컴컴컴컴컴컴켸 After the import data has been defined, data importation begins. This import process is described in this section. Since the terminology is based upon the import definition, we recommend you refer to the Configuration references cited above before continuing. When all the data you want has been imported, PC-Type II returns to its normal edit mode. If you define the import criteria from the "(I)mport" option of the Main Menu, the information will neither be saved in a .IMP file nor referenced in a .PRO file. You must go to the Configure option of PC-Type II to save the import information to disk via the "(F)ile handling" option to create the .IMP file. To have that file referenced in your .PRO file, you must answer Y to the question "Save data to .PRO file?". If you defined the import criteria within the Configuration section of PC-Type II, the .IMP file is created at your request when saving the updated .PRO file. It is only necessary to create a .IMP file if you plan to use the same import rules in multiple PC-Type II sessions. When PC-Type II begins, if the .IMP file is referenced in your .PRO file, it will be loaded automatically. When you select the "(I)mport" option, you are given the option to modify the "search criteria" and the fields of data in a record to import. After any modifications have been made, you can begin importing data into your text file. 175 subject: RETRIEVING IMPORT DATA discussion: PC-Type II begins the process of retrieving data by moving through the data source and finding records which match your selection criteria. When a match is found, the fields to be imported you are displayed on the screen like: 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� � NAME Cat~Garfield � � STREET 123 Feline Court � � CITY Lyons � � STATE CA � � ZIP# 90014 � � � � Record 2 of 11 � 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� and you are asked: Import? Press Y or N Esc: If you press Esc at this point, (or at any point in the import process), importing is terminated and you will be immediately returned to the normal PC-Type II edit mode. N: If you respond by pressing N, the source file will continue to be scanned until another record meets the selection criteria. It data will then be displayed and you will be asked again if you wish to import this data. Y: If you respond by pressing Y, the data displayed will be inserted into your source file and you will be asked: Select another? Press Y or N If you answer by pressing N, the import process is terminated. If you answer by pressing Y, then the source file will again be searched for another match. Finally, if no more matches are found in the source file, the message: At End of File. Press a key to continue ... is displayed and you will be returned to the standard PC-Type II edit mode. The data you imported will be visible on your PC-Type II screen and your cursor will be below the information just imported. NOTE:딬n the example, "Cat~Garfield" will be imported 땇s "Garfield Cat". PC-Type II flips data 땣urrounding the tilde character. 176 field names: Note the sample screen on the preceding page which is displayed when you are asked if you want to import the data. If you defined a PC-File+ or PC-File:dB data source, the field names are displayed to the left of the data. With PC-Calc+ and ASCII file data, field names are not available. In these cases, the names "Fieldi", ... "Fieldn" will be displayed instead. selection: The Command Line will display the selection formula being used to find record matches within the source file. If you opted for the "(A)ll" selection criteria, the Command Line will be blank. inserting data: Except for a special PC-Calc+ import option (described below), all data which is imported is brought into your PC-Type II text file as a new line for each import field. (Empty fields of data are ignored.) After all the selected fields for a given record have been brought into your file, a blank line is inserted which separates multiple records of data which may have been imported. The lines of imported data will be inserted in your text immediately below the line on which the cursor was located when the "(I)mport option was invoked. PC-Calc+: A special import option exists for PC-Calc+. Suppose you defined the data to be imported to be in the range B5:H100. From PC-Calc line 5 and continuing through line 100, fields in columns B through H are inspected to see if they match the selection criteria imposed. If they do, and you opted to import the data in columns D, E, G and H, then the four fields in each row may be imported into one row (each field being separated by a Tab character), or into four lines with each field on its own line. The Tab character is inserted so that you can set your margins and reformat the area to move the elements into the desired locations. 旼컴컴컴컴컴컴컴컴커 If you want all cells from one 쿜uestion: � PC-Calc+ line to be placed in 팠袴袴袴袴袴袴袴袴孤 one PC-Type II line, answer N to 쿚ne cell per line?� the window at the left which is 쿛ress Y or N � asked during import definition. 읕컴컴컴컴컴컴컴컴켸 旼컴컴컴컴컴컴컴컴컴컴컴컴컴� This unique 쿜uestion: � PC-Calc+ question 팠袴袴袴袴袴袴袴袴袴袴袴袴袴� lets you import all 쿍ring in all rows in range?� the lines without 쿛ress Y or N � stopping and asking 읕컴컴컴컴컴컴컴컴컴컴컴컴컴� at each line. 177