EMS Greenscan Imports
Learn how to upload data for SIR analysis via EMS Greenscan.
Written by Jess Hamilton
Updated at September 5th, 2024
Table of Contents
Overview
EMS Greenscan detects and predicts leaks by analyzing the daily reconciliation data from your storage tanks.
At a high level, here’s how the data is accessed and processed.
Setup Checklist
If this is your first time integrating with EMS Greenscan, or if you are adding a new facility or tank, please reach out to your Customer Success Manager or email support@titancloud.com for mapping assistance. The following items are necessary for setting up the integration.
What we need |
Why we need it |
Where you find it |
Where we save it |
|---|---|---|---|
FTP folder |
This enables file uploads in Titan |
We set this up for you when your account first goes live. If you’ve never uploaded files in Titan, or if you don’t know your account’s FTP access credentials, please reach out to support@titancloud.com. |
Your Customer Success Manager will have shared the credentials with you. We do not save these in the Titan platform itself.
|
Inventory Variance Setup |
This enables file uploads in Titan at the site level. |
We set this up for you when your account first goes live. If you’ve never uploaded files in Titan, or if you are setting up a new site, please email support@titancloud.com. |
Release Detection Setup > Inventory Variance Daily Shift Totals w/Sales & Gross Deliveries OR Daily Shift Totals w/Sales & Net Deliveries |
OUID Field |
This unique ID associates an EMS customer with a Titan customer. |
Titan Cloud creates this ID and adds it to your General Account Information. |
Account Information > OUID Field
|
PDI Facility Code |
This unique ID associates the PDI facility with the Titan facility. |
This is retrieved from your PDI account. |
Facility Profile > Misc Information > PDI Facility Code |
EMS Site ID |
This unique ID associates the EMS facility with the Titan facility. |
This is retrieved from your EMS account. |
Facility Profile > Misc Information > EMS Site ID
|
PDI Tank Code |
This unique ID associates the PDI tank with the Titan tank. |
This is retrieved from your PDI account. |
Tanks Page > PDI Tank Code |
Reconciliation data in a correctly formatted .csv file |
You upload this in Titan so we can display and analyze the data |
You create this, but we have detailed instructions below. |
File Format
Click here to open a template .csv file including the columns described below. Feel free to download a copy for your own use.
General Rules
- Imported files must be in .csv format.
- Any columns that do not match the accepted headers below will not be imported.
- If a facility or tank code does not match what has been mapped in Titan, the data will notbe imported.
Required Columns
The following columns must be included, using the format described below.
Column Header |
Acceptable Alternate Column Headers |
Data Format |
Example Value |
|---|---|---|---|
PDI Facility Code |
PDI_Facility_Code Site |
Alphanumeric, must match the field by the same name on the Titan facility profile page. |
001111 |
PDI Tank Code |
PDI_Tank_Code TankNo |
Alphanumeric, must match the field by the same name on the Titan facility profile page. |
001 |
Fuel Grade |
Fuel_Grade ProductID |
Alphanumeric |
REGULAR UNL |
Date |
|
YYYY-MM-DD |
2023-01-01 |
Sold Volume |
Sold_Volume SalesUnits |
Number, up to two decimal places |
1000.00 |
You must also have one or both of the following:
Column Header |
Acceptable Alternate Column Headers |
Data Format |
Example Data |
|---|---|---|---|
Purchase Units Gross |
Purchase_Units_Gross PurchaseUnitsGross |
Number, up to two decimal places |
1000.00 |
Purchase Units Net |
Purchase_Units_Net PurchaseUnitsNet |
Number, up to two decimal places |
1000.00 |
Optional Columns
You may choose to include the following optional columns.
Column Header |
Acceptable Alternate Column Header |
Data Format |
Example Data |
|---|---|---|---|
Beginning Inventory |
Beginning_Inventory BeginningInventoryUnits |
Number, up to two decimal places |
1000.00 |
Ending Inventory |
Ending_Inventory EndingInventoryUnits |
Number, up to two decimal places |
1000.00 |
Water Units |
Water_Units WaterUnits |
Number, up to two decimal places |
0.00 |
Import Setup Instructions
From the Facility page click Inventory Variance and Inventory Variance Setup in the left-side navigation menu.
At the center of the page, select either “Daily Shift Totals w/Sales & Gross Deliveries (*File Import)” OR “Daily Shift Totals w/Sales & Net Deliveries (*File Import)”. The selection you make must match the “Purchase Units Gross” or “Purchase Units Net” column in the .csv file.
You will be prompted to set an effective date. If no effective date is set, the selected inventory variance source will be effective for all past periods. For accurate results, we strongly recommend setting the effective date to the earliest date accounted for in the .csv file.
You then have the option to allow manual adjustments or overrides to the data, which if permitted, may be managed on the Inventory Variance Entry page.
Once submitted, the data will be routed to EMS for SIR analysis.
Results & Reports
Once EMS has finished processing the data, you may access the following results and reports in Titan Cloud in any of the following locations:
-
SIR Release Detection Reports
- Electronic File Cabinet (E-Files)
-
Release Detection Summary & SIR Results Page
Need Help?
If you are having difficulty setting up your Greenscan EMS integration or uploading files for analysis, please reach out to your Titan Customer Success Manager or email support@titancloud.com.
If you need assistance analyzing results and reports received from EMS, please email TitanAnalysis@drivingfueliq.com.