Difference between revisions of "ProjectAdministration"

From GombeMIWiki
Jump to: navigation, search
(New database management section)
(There is a web interface for adding a user)
 
(One intermediate revision by the same user not shown)
Line 4: Line 4:
   
 
=== Database Management ===
 
=== Database Management ===
  +
  +
* [https://{{ServerName}}/programs/pfw/add_user Add_User] -- Create a database user
 
* [[DeleteDBUser|Delete a Database User]]
 
* [[DeleteDBUser|Delete a Database User]]
 
* [[DBDiskSpaceManagement|DB Disk Space Management]]
 
* [[DBDiskSpaceManagement|DB Disk Space Management]]
Line 14: Line 16:
   
 
=== Lingering Tasks ===
 
=== Lingering Tasks ===
# Upgrade server OS to the next long-term release
 
# Implement a web interface for adding a database user
 
 
# Husband the "replace existing data on import" patch into upstream PPA
 
# Husband the "replace existing data on import" patch into upstream PPA
 
# Husband the "import into views" patchs into upstream PPA
 
# Husband the "import into views" patchs into upstream PPA

Latest revision as of 18:27, 7 March 2019

Wiki User Management

Database Management

Gombe-MI Mailing List

Conversion Process

Lingering Tasks

  1. Husband the "replace existing data on import" patch into upstream PPA
  2. Husband the "import into views" patchs into upstream PPA
  3. Add a feature to PPA allowing it to accept user-supplied multi-statement SQL input
  4. Add a feature to PPA allowing it to export from user-supplied SQL input
  5. Consider creating the following data integrity rule: when a mother is found in the group composition survey all offspring less than 5 years old must also be included in the survey.
  6. Fix PPA so that it gives detail on trigger errors which occur during upload.
  7. Write Karen a query that compares 1 minute times to 5 minute group comp times.
  8. Look at processing/having a view for eating bouts.