Importing a flat file

Program Information

  1. Click Inventory Control>Electronic Price Update>Flat File Import.
  2. In the Service Code field, enter the pricing service code from Service Code F/M. For vendor direct data, enter the AP Vendor number.
  3. In the Load Command field, press Enter to default to the load command entered for this service provider in Service Code F/M.
  4. In the File Name field, press Enter to default to the flat file name entered for this provider in Service Code F/M. If the file already exists on the system, a message will display "File already exists. Download a new flat file?" Answer No to update the existing file on the system. Answer Yes to overwrite the existing file on the system.
  5. In the Beginning and Ending Vendor fields, enter the beginning and ending vendor numbers to process.

    image\pinpurpl_shg.gifA file from a pricing service normally contains data for several vendors. To load a specific vendor’s information from that file, enter the vendor number to process. All data that does not match this vendor will be skipped.

    A file from a     specific vendor normally contains that vendor’s data. Enter the vendor’s number or press Enter for FIRST.

    If you are importing data from a     CD catalog (and this service code uses ICU452 as its update program), press Enter to default to ALL. (The system cannot select a range of vendors when its importing data from CD-ROM catalogs.) You can also enter a specific vendor number.
  6. When the system displays: Initialize the Pending file before updating? Enter Yes to clear the pending file before processing the new data from this flat file. Enter No to leave any unprocessed records in the pending file before processing the new data from this flat file. Note: Records remain in the pending file until they are manually removed through Pending File Maintenance or updated through Pending File Update.
  7. In the Number Of Records field, specify the number of records to import from the flat file. In the testing and setup phases of EPU, this function could be used to check the EPU Service Code record against the layout of the flat file record sent by the provider without having to import the entire flat file. Press Enter to default to ALL.
  8. (Optional) If you want to continue and import the file, type YES in the selection prompt in the bottom right-hand corner of the screen.
  9. (Optional) If you are importing information from a CD Catalog, and you entered ICU452 as the update program in Service Code F/M, FACTS opens the Flat File Preprocessor Program.
  10. The Flat File Preprocessor program tells FACTS what to do with the CD Catalog information. If you need to create and import a file, select B from the pick list. If you just want to create a flat file and import it later, select C. If a flat file already exists, select I to import it.
  11. Click Exit.