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 needs 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 fields 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 the "our lease" field is not required. The comment field is also available on the import.
NOTE: If the import type is a tank without starting/ending gauge readings, however, the import has them defined. Then, the readings will be imported, and the ticket will be changed to the meter.