Changes between Version 1 and Version 2 of ReportingInterface


Ignore:
Timestamp:
Mar 6, 2013, 4:02:50 PM (13 years ago)
Author:
adehnert
Comment:

mention the db-dump directory

Legend:

Unmodified
Added
Removed
Modified
  • ReportingInterface

    v1 v2  
    11The reporting interface (https://asa.mit.edu/groups/reporting/) allows extracting a large amount of data from the ASA Database.
    22
    3 == Using the reporting interface to group lists for forms ==
     3== Using the reporting interface to generate group lists for forms ==
    44
    55Forms such as the midway application form (http://asa.scripts.mit.edu/applications/midway/midway.php) need to be regularly updated with a current list of groups. To find the group list that's being used, look in the form source for a line like "`include '../include/group_list_midway.php';`". That indicates that the group list lives in `/mit/asa/web_scripts/applications/include/group_list_midway.php`.
    66
    77Using the reporting interface, select the groups that you want and include "<option> entry" under "Special fields". If you need to filter the list in ways that the reporting interface doesn't support, you can open the output file in Excel or a similar tool and do further filtering there. Then, copy and paste the "<option> entry" field into the group list file that the form uses. (You should likely include a header like "`<!-- Generated from the reporting interface. See https://asa.scripts.mit.edu/trac/wiki/ReportingInterface. -->`" to encourage future updaters to use the semi-automated generation method.)
     8
     9=== Other approaches ===
     10
     11Before using the reporting interface, you might check if `/mit/asa-db/data/db-dump/` contains a file you can just copy over.