webmill:Database Access Tools

Build the Tools

Download the
```
custom-tools
```
folder in the WebMill trunk.
Run
```
ant
```
to run the build script.
Add the jar in the
```
custom-tools/jars
```
to your classpath, i.e., java -cp <...>/jars/TOOLS-current.jar <...>

java edu.jhu.ece.webmill.reportProjectDetails <outfile.xls> <mySQLUser> <mySQLPassword> [<mySQLdatabase string> | optional]

- outfile.xls - Excel file to generate with output.
- mySQLUser - Username to use to connect to the MySQL database
- mySQLPassword - Password for the indicated user
- mySQLDatabase - String to use to start database connection. Defaults to localhost/webMill. This parameter is optional.

Download a report on the system state as above.
Open the excel file.
To edit project details, edit the sheet labeled "project".
- Only edit the fields in column "B".
To edit region details, edit the sheet labeled "region".
- To remove a region (and ALL associated tasks AND results for this region), type "yes" in the column labeled "Remove Region (edit only)" that corresponds to the region that you want removed. THERE IS NO GOING BACK! Delete with care.
- To add a new region, add a new rpw under the last region.
  - Fill out all columns.
  - The id must be unique.
  - A valid PNG logo file must be specified. The default size is 32x32.
  - If you are editing existing regions, the logo image files that were extracted above MUST still be available.
  - Regions that exist in the database but are not listed in the file will not be modified.
Run the Update Project Details program:

java edu.jhu.ece.webmill.updateProjectDetails <ExcelFile> <mySQLUser> <mySQLPassword> [<mySQLdatabase string> | optional]

- ExcelFile.xls - Excel file to parse for input.
- mySQLUser - Username to use to connect to the MySQL database
- mySQLPassword - Password for the indicated user
- mySQLDatabase - String to use to start database connection. Defaults to localhost/webMill. This parameter is optional.

Download a report on the system state as above.
Open the excel file.
Tasks may be removed by typing "yes" in the corresponding column on the "task-*" sheet.
- No editing of existing tasks is permitted.
- Note: All results for a deleted task will be removed.
Existing slices may be removed by typing "yes" in the corresponding column on the "slice" sheet.
- No editing of existing slices is permitted.
New slice / task pair may be added by adding new rows to the "slice" sheet.
- All slice ID's must be unique. Any GUID entry will be ignored and a new GUID will be assigned.
- Only the subj/vol/slice combinations must be unique per dataset.
- Currently, task notes are limited to 1024 characters (extra characters will be truncated).
- All image paths must be accessible to the ingest tool.
When editing is complete:
Run the Update Project Details program:

java edu.jhu.ece.webmill.updateProjectData <ExcelFile> <mySQLUser> <mySQLPassword> [<mySQLdatabase string> | optional]

- ExcelFile.xls - Excel file to parse for input.
- mySQLUser - Username to use to connect to the MySQL database
- mySQLPassword - Password for the indicated user
- mySQLDatabase - String to use to start database connection. Defaults to localhost/webMill. This parameter is optional.