{"id":577,"date":"2020-03-12T10:16:24","date_gmt":"2020-03-12T10:16:24","guid":{"rendered":"http:\/\/www.stratadata.co.uk\/blog\/?p=577"},"modified":"2020-03-12T10:16:24","modified_gmt":"2020-03-12T10:16:24","slug":"multi-well-header-loading","status":"publish","type":"post","link":"https:\/\/www.stratadata.co.uk\/blog\/index.php\/2020\/03\/12\/multi-well-header-loading\/","title":{"rendered":"Multi-well header loading"},"content":{"rendered":"

Many thanks to Lawrence Febo (Chevron USA) for this post…<\/p>\n

A very useful StrataBugs feature, though perhaps overlooked, is the bulk well importer using the Organiser interface.<\/p>\n

Step 1: Prepare a spreadsheet with your well header data as shown below. Four fields are required for each well (Name, Code, Location, and TD), though others can be added.\u00a0 In the US Gulf of Mexico, additional identifiers may be added, such as the OCS Numbers (Outer Continental Shelf).<\/p>\n

\"\"<\/p>\n

Step 2: Choose the Organiser Module, then select File>Open file\u2026>XLS Well headers\u2026(Figure 2).\u00a0 After selecting the Excel file, you will need to select the depth units for the wells.\u00a0 Be sure to bulk load wells that have the same depth units. Do not import a mix of wells where some are in meters and others are in feet. If you do, then they will all go into the database in the units selected.<\/p>\n

\"\"<\/p>\n

Figure 3 \u2013 View of an individual well in the list and the fields that get populated in the database.<\/p>\n

\"\"<\/p>\n

Step 3: Once the well headers are read into the workspace, the last step is to Match the wells from the workspace into the database (Figure 4). You can choose \u201cadd all\u201d if they are all new. Figure 4 \u2013 Final steps > select \u201cMatch all\u201d first, and then \u201cAdd all\u201d of the unmatched wells. Any wells left unmatched will be excluded when you close the dialog.<\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Many thanks to Lawrence Febo (Chevron USA) for this post… A very useful StrataBugs feature, though perhaps overlooked, is the bulk well importer using the Organiser interface. Step 1: Prepare a spreadsheet with your well header data as shown below. Four fields are required for each well (Name, Code, Location, and TD), though others can […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-577","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.stratadata.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/577","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stratadata.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stratadata.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stratadata.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stratadata.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=577"}],"version-history":[{"count":1,"href":"https:\/\/www.stratadata.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/577\/revisions"}],"predecessor-version":[{"id":582,"href":"https:\/\/www.stratadata.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/577\/revisions\/582"}],"wp:attachment":[{"href":"https:\/\/www.stratadata.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stratadata.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stratadata.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}