Well Test Email Importer Setup

Some companies may decide they want to bring in well test data via an email sent from the field. With the proper formatted .XLSX file, users can send well test directly to XSPOC.  Note: This email configuration is separate from the notifications for alarms.

What You Will Need

Excel file formatted with the following column example:
System parameters configured for retrieving email that users can send an attached well test excel file.

1. Add the below to your tblSystemParameters table with the Value fields changed to your mail server configuration.

System Parameters Needed

Parameter	Value	Comment
WellTestEmailImport.EmailAddress	import@domain.com	The email address that is used to get the well test attachments to import.
WellTestEmailImport.Host	server.domain.com	The hostname of the server that the email client will connect to.
WellTestEmailImport.Password	Password	The password used to authenticate with the email server.
WellTestEmailImport.Port	993	The port number that the email client needs to connect to the email server.
WellTestEmailImport.Username	import@domain.com	The user name used to authenticate with the email server (if blank, then defaults to email address).
WellTestEmailImport.UseSsl	1	0: Do not use SSL, “1”: Use SSL
WellTestEmailImport.Verbosity	Info	The verbosity used for logging this task.

2. Second, you will need to create a new Excel .xlsx document that is required to have the following format:

NodeID	TestDate	OilRate	WaterRate	GasRate	TubingPressure	CasingPressure
Well1	10/1/2020	3	2	1	5	4
Well 2	10/2/2020	6	7	8	9	10

a. All Measurements must be Imperial
b. All Column data is required except for TubingPressure and CasingPressure
c. The format for TestDate is unimportant and may include time if desired.
d. The sheet name of the Excel table must be called “Sheet1”, which is the default name for new Excel documents.