First Purchaser > FP Utilities > FP Import Run Tickets

File Import types: CODE format, Sentinel (non-CODE-unsupported), and XLS/XLSX. Imports into Daily Run Ticket file. The Excel import has advanced error checking and reporting for the fields it supports as well as the ability to import Net Bbls and already locked in ticket prices. The Starting and Ending Temps must be within 20 degrees. The Observed Temp and the Starting Temp must be within 50 degrees. The created date/ time is on the import as well as an "Undo Import" utility that will need the import stamp if the import need to be undone. The API Gravity can be imported as long as there is a net volume value.

This import will import tickets. The only required field are the Sub-Account and Sub-Table fields. Once you have decided what import type you are doing and have chosen the fields to import, click on the "Create Template" button. A template of the file format will be automatically created for you making the import easy. In addition, the "Use Crossref ONLY" option is available with the XLS/XLSX Import Type so that "our lease" field is not required. The comment field is also available on the import.

NOTE: If the import type is tank where there are no starting/ending gauge readings however the import has them defined, the readings will be imported and the ticket will be changed to meter.