1 / 18

Overview of FDOT Database Database Training #1 Nov.23

Overview of FDOT Database Database Training #1 Nov.23. Prepared by Erica Hughes Presented by Michael Faraone and Gurpreet Modi Bridge Software Institute University of Florida. About Projects. Everything starts with a Project Project’s unique identifier is called ‘Project Number’

tavita
Download Presentation

Overview of FDOT Database Database Training #1 Nov.23

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Overview of FDOT DatabaseDatabase Training #1 Nov.23 Prepared by Erica Hughes Presented by Michael Faraone and Gurpreet Modi Bridge Software Institute University of Florida

  2. About Projects • Everything starts with a Project • Project’s unique identifier is called ‘Project Number’ • Project Number generally coincides with FDOT’s Financial Project Number

  3. About Projects cntd. • Project Administrators like District Geotech Engineers create the Project in the database system and create/assign user accounts

  4. GeoTech Security Hierarchy

  5. How To: DGE Create Projects • Log into DGE account (DGE accounts have Project creator permissions)http://fdot.ce.ufl.edu– Admin Interface • Click the ‘Create Project’ button • Fill in required field, ‘Project Number’ which should coincide with the FDOT Financial Project Number • Project Number must be unique and only used for 1 Project in the database

  6. Main Interface for DGE Create New Users Create New Projects

  7. Create Project Interface • Corresponds to FDOT’s Financial Project Number • Unique Identifier for the Project • Will be used for all database submissions for the Project

  8. Create New User Interface • Unique Identifier for User Account • Geotechs should use geo- prefix for new user accounts

  9. New User Notified by Email • The User will receive a notification of their new user account and their auto-generated password.

  10. Assign User to Project • After User is created, you can assign the New User to the Project you created earlier.

  11. Assign User to Project • You may locate the Project by ‘Project Number’ (top) or by ‘Project Name’ (bottom)

  12. Assign User to Project • Confirm the User Account you want to Assign to the Project. Existing users for the Project are listed in the top, new users are listed in the bottom section (the new account is auto-selected).

  13. Assign User to Project • Check each type of job role the user should be granted for the Project. Do not give a user access to Lab data if they will only be submitting Insitu (SPT/CPT/etc.) data.

  14. User Notified by Email • User will be notified of their user account’s new security settings for the Project Number. • The Admin will also receive a copy of the user’s email message as confirmation.

  15. Security Access for Excel • In order for Users to submit data using the Insitu Excel application, they will need to be assigned as ‘Insitu Poster’. • In order for Users to submit data using the Lab Test Excel application, they will need to be assigned as ‘Lab Rock Poster’ and ‘Lab Soil Poster’.

  16. Project Hierarchy

  17. Naming Conventions • Hole Name is the unique identifier for Borings/Holes. • Hole Name: B1 ¹B-1 they would be submitted as different Holes in the database. • Make sure to know your Project’s naming conventions in order for boring information to be submitted correctly.

  18. Protect Your Data • Multiple users can submit to the same Hole if they have the appropriate permissions. • Once the Boring data is complete, the Hole should be locked by one of the submitters to prevent changes. The last person to submit a portion of the data (ex: SPT) will be recorded as the Submitter for the data. • If the Hole is locked, no submissions can be made to any of the Hole’s nodes (ex: Lab Rock).

More Related