NextGen Knowledge Center

Import a GPCI Comma Delimited Flat File

You can import a comma delimited flat file to add GPCI values to an existing GPCI library.

Make sure your comma delimited flat file meets the following criteria:

  1. Carrier and Locality must be merged into one column. For example, New Orleans, LA has a Carrier of 528 and Locality of 01. The two values would be combined in one column to become 52801.
  2. There are five columns and the data in each row must be in the following order: Carrier/Locality, Description, GPCI Work, GPCI PE, and GPCI PLI.
  3. Commas must be removed. For example, NEW ORLEANS, LA would become NEW ORLEANS LA.
  4. The column headings must be removed.

  5. Select Libraries > GPCI to open the GPCI Library List.
  6. Select the name of the library to import the values into.
  7. Select open menu button , then select GPCI Import.

  8. In theComma Delimited Input Filefield, selectOpen Folderto browse for the flat file.
    TheSelect Filewindow opens.
  9. Locate and select the applicable flat file, and then selectOpen.
    The path for the file location displays in theComma Delimited Input Filefield.
  10. Select OK.
  11. To see the imported values, you can open the GPCI library. The values display in the columns.