8.5 - Admin
The Admin ribbon contains tools that can aid the user in managing both local and remote databases.
8.5.1 - Database
The Database section contains tools that are used to clean the database as well as fix errors.
Note that many of these tools make irreversible changes to your database and come with the risk of corrupting your data. It is strongly recommended that you back up your local database before running any of these tools.
Append OP: This option appends the operator name as a suffix to the field name of all fields under the operator. This action is performed on all operators/fields in the database.
Clean DB: The Clean Database tool will fix any errors in the database due to missing records and data corruption. When run, this tool will do the following:
Check to see if child tables associated with plans / actuals and surveys exist and remove any orphaned tables not associated with any wells.
Checks and removes duplicate records.
Checks and removes daily report records no longer associated with any wells.
Checks that a survey program references wells / surveys which still exist.
Checks and adds in a default depth datum for all wells.
Checks the depth datum for a plan / actual exists and is assigned.
Checks to see if any Instrument Performance Models (IPM’s) which are referenced exist in the IPM folder.
Schema Update: When logged into a remote server database, this option can be used to update the server table schema to match with the user’s current version of Well Seeker. When used, Well Seeker will display a message similar to the one below, comparing the user’s version of Well Seeker with the remote server’s.
Well Seeker will then update all the relevant tables to the remote server to bring it up to date with the user’s version of Well Seeker. Please note that this can sometimes cause issues for users that try to connect to the remote database using old versions of Well Seeker.
White Space: This tool allows the user to check if there are any ‘space’ characters at the start or end of any names in the Database Tree. Upon opening the tool, the grid will be populated with any names with spaces at the start or end. The Level column informs the user where in the database tree each name has been found. If there are many names found, the Search box can be used to filter out all but the desired name.
If the user checks the checkbox in the Repair column beside a name and clicks OK, Well Seeker will remove the spaces from the names in the database tree. The user can use the Check All and Un-check All buttons to check or uncheck the whole of the Repair column.
Check Duplicates: This tool works in a similar way to the Check Names for Whitespace tool. It checks for any duplicated names in the Database Tree and displays them in a list. The Level column tells the user where in the Database Tree the duplicated name can be found. The Parent column displays the name of the level above the duplicated item. If there are many names found, the Search box can be used to filter out all but the desired name.
If the user checks the checkbox in the Repair column beside a name and clicks OK, Well Seeker will fix the duplicated names in the database tree. The user can use the Check Alland Un-check Allbuttons to check or uncheck the whole of the Repair column.
8.5.2 - Organization Settings
8.5.2.1 - Rig Names
The Rig Names window allows the user to create a list of rig names. In other areas of Well Seeker where the rig name needs to be entered, such as the Job Data dialog, the user will be presented with a dropdown box populated with the rigs entered here. Un-checking the Active checkbox next to each rig name will hide that rig from any dropdown list.
If this list is set up on the company’s server database, it will be downloaded to the user’s local database whenever they fetch a well using the Data Fetch feature.
8.5.2.2 - Personnel Names
The Personnel Details window can be used to keep a list of all personnel involved with wells in the database. In other areas of Well Seeker where the rig name needs to be entered, such as the Daily Reporting, the user will be presented with a dropdown box populated with the rigs entered here.
If this list is set up on the company’s server database, it will be downloaded to the user’s local database whenever they fetch a well using the Data Fetch feature.
The user should enter the name of each member of personnel into the Name column and then select their position from the dropdown box in the Position column. The Employment, Email, Phone, Personnel ID and Day Rate columns are optional. The checkboxes in the Active column can be toggled on/off to show/hide personnel from other Well Seeker features.
At the top of the window the user can filter the list by typing in the Search box, which searches all fields in the table. The dropdown boxes can be used to filter by the Position and Employment fields and clicking on ‘Reset Filters’ will clean the filters and show the whole list again.
8.5.2.3 - Personnel Utilization
The Personnel Utilization tool can be used to generate a personnel utilization report. This report will mark on a calendar each day that the selected personnel member(s) have worked as well as the rig(s) that they worked on.
The user should select a date range in the Date Range section and choose which personnel to include from the list. The Check Alland Un-check Allbuttons can be used to quickly include or exclude all personnel. The personnel list is populated by names that have been entered into the Well Data & Personnel section in a Daily Report.
The list can also be filtered by coordinator and personnel type by clicking on the check boxes in the top right of the window. The co-ordinator dropdown is populated from data entered into the Job Data dialog. The personnel dropdown is populated from the Personnel dialog in the Daily Reports window. The user can also filter the list using the Search box in the top right corner. Clicking on Print Report will print the Personal Utilization Report in Excel format.
8.5.3 - User Permissions
This option can only be accessed when logged into a remote server database, and the user has Administrator permissions. The User Permissions tool allows the user to edit the permissions of users registered to your company’s remote server database.
Note that Innova recommends managing user access via Innova Vantage, as it provides additional functionality.
The following permissions are available:
Create New Items: User can create new items in the database.
Delete Items: User can delete items in the database.
Edit Items: User can edit items that other users have created.
Administrator: The user can change the permissions of other users.
Approver: User has permission to approve and archive bid sheets. See section 13.16 – Create Bid Sheet.
New users can be created using the Add User button and removed using the Delete User button. Click on the Username field to edit an existing user’s login name. If a user forgets their password, another user with administrator permission can reset their password by clicking on the Password field.
8.5.4 - Audit Logs
This window allows the user to track changes made to the database. The Audit Data grid will display the time each change was made, a description of the action performed, the object the action was performed on and the user that performed the action. If on a local database this will always be ‘local user’ but if logged into a remote server this will display the username of the person that performed the action. At the bottom of the window the user can change the number of records shown in the grid using the Number of Recordsbox. The two dropdown boxes can be used to filter by description and by object name.
8.5.5 - Company Details
Company Details allows the user to enter the Name, Website and Telephone Number for their company. This information can then be added to the cover page of survey, error ellipse and anti-collision reports. Check the include details option in the Report Manager to include the company details.
Last updated
Was this helpful?