Skip to main content
How Can We Help?

Search for answers or browse our knowledge base.

Export import single well

You are here:
< Back

Newer script instructions here:

Import Export Single Wells – Employees Only

 

Use the scripts from:

Apergy\Theta Team – Documents\Data Base Merges\Single Well Data Export-Import

To export you must edit the top variables of the script in notepad, primarily nodeID and the date range

# Set Variables
$serverName = "localhost"
$database = "xspoc"
$username = "SpocWrite"
$password = "SpocWrite"
$nodeId = "SomeWellNodeID theta sam 01"
$startDate = "20190101 00:00:00" # Format: YYYYMMDD HH:mm:ss
$endDate = "20190522 23:59:59" # Format: YYYYMMDD HH:mm:ss