- Create a GISB compliant flat file.
- Logon to NrG Web Highway (www.nrghighway.com).
- Select a service provider.
- Select the Nominations module.
- Click the Import button on the toolbar to display the Import dialog box.
- Click the Look in field to select the file you wish to import.
- Click the Import & Validate radio button (first time default) OR click Import & Send, (default if previously selected).
- Click the Import button to start the import.
- Review the Response field at the bottom of the window. It will either identify the batch number assigned to the batch or identify errors that must be fixed.
- Close the Import dialog box.
- Correct any reported errors in your flat file and click the Import button again.
- Check for a notification that the import is complete. Note: You will only be notified if the Upload Validation option is turned on in NrG Highway's User Preferences module.
- View any validation messages on the generated import report available through the NrG Reporting module. Find the report by selecting Custom Reports/NrG Modules/Nominations/Import Summary.
- Send the transactions through the Nominations module if you did not elect to automatically send your transactions. Note: Any transactions containing format errors will not be saved to the NrG database. Any saved transactions containing validation type errors can be corrected through the Nominations module.
You need to know that when copying rows of data from an existing Excel file to create a new Excel file, if there are no values in any rows within the final column of the copied data, then the pasted rows will not recognize that the empty fields are valid. This means that a final comma will not be included for this field in the new CSV (comma separated value) file, therefore the number of columns in the new file will not match the number of columns in the header record, thus invalidating the file format.
There is an easy solution! Create a “dummy” final column, using your own naming convention, then populate all rows in that column. This will ensure that the number of columns matches the header records therefore the file will pass the system header check.
DUNS and Contract numbers
If you are using Excel to create or edit your csv file to import your nominations records onto NrG Web Highway, it is important to note that leading zeros WILL be lost in fields containing DUNS and Contract numbers.
You must reformat the following fields:
- For DUNS numbers: TSP, SVC REQ, UP ID, DN ID (9 digits required)
- For Contracts: UP K, DN K (especially for NGTL - 2 digits required)
For more information see the Nominations Import User Guide.
What Can I Do?
Updated 02/16/00