Skip to main content
Sign in Explore

How To: Using DDA

Caution:   Manual modifications to database records should only be attempted by authorized technical contacts, and can result in orphaned records if not executed properly. Before making any changes you should perform a manual backup of your PowerSchool database.

Summary:

Follow these generalized steps for using the different functions of DDA. 

Process:

Mass Modifying Records:

  1. From your start page click System under Setup
  2. Click Direct Database Export (DDE) under Data Management
  3. In the URL change DDE to USM to access DDA 

Example:/admin/tech/dde/ becomes /admin/tech/usm/

  1. Select the table for which you would like to search for records
  2. Use the Search boxes to filter your records
  3. Use either the table or list view to verify that your selection of records is correct
  4. Once you have the records you would like to edit click the link for Modify Records
  5. In the first drop down select the field to edit
  6. In the second box enter the new field value
  7. Click Modify Selected Records to submit the change

_____________________________________________________________________

Match Selections:

Note: Before you attempt a Match Selection make sure the tables have a valid relationship. 

  1. From your start page click System under Setup
  2. Click Direct Database Export (DDE) under Data Management
  3. In the URL change DDE to USM to access DDA 
  4. Select the table for which you would like to search for records
  5. Make a selection of records in the first table you would like to match, use the filters to drill down to the exact set of records
  6. In the current table switch to the second table you would like to match
  7. Click the button for Select all xxxx records in this table
  8. Click the link for Match Selection
  9. In the drop down select the original table from step 1
  10. Click Proceed to match
  11. Now your current record selection will be matched based on the criteria of the original search.

_____________________________________________________________________

Exporting Records:

  1. From your start page click System under Setup
  2. Click Direct Database Export (DDE) under Data Management
  3. In the URL change DDE to USM to access DDA 

Example:/admin/tech/dde/ becomes /admin/tech/usm/

  1. Select the table for which you would like to search for records
  2. Use the Search boxes to filter your records
  3. Use either the table or list view to verify that your selection of records is correct
  4. Click the link to Export Records
  • Use the drop down to select fields from the table you are currently in
  • Click the link Use All Fields to export every field available for the current table
  • In the box use the [Table name or Number] Field Name method to pull fields 
  1. Fill out all other desired options for export on the Export Records page such as Field and Record Delimiter
  2. Click Submit to begin the export.

_____________________________________________________________________

Mass Deletion of Records:

 Note: A full backup of the system is recommended before deletion of records

  1. From your start page click System under Setup
  2. Click Direct Database Export (DDE) under Data Management
  3. In the URL change DDE to USM to access DDA 

Example:/admin/tech/dde/ becomes /admin/tech/usm/

  1. Select the table for which you would like to search for records
  2. Use the Search boxes to filter your records
  3. Use either the table or list view to verify that your selection of records is correct
  4. Once you have the records you would like to edit click the link for Modify Records
  5. Check the box to verify a delete command
  6. Click Delete Selected Records

 

 

Related articles