Test - Dataset Integration

TESTING PROTOCOL INTEGRATION
06042011

TESTER (Comments included for all testers):

1. Shelby Manney 06012011 -06042011

2. Hannah Reitzel Rivera 06042011

General Overview Test of Integration Functionality
Before integration:
1. Note column names (variables), ontology mapping, coding sheet mapping, & variable types for Spitalfields tDAR ID 5649 & Alexandria tDAR ID 5653

Preintegration instructions:

1. Go to each dataset below
2. Bookmark
3. hover mouse over "Workspace"
4. Click on "integrate tables in your workspace" from the drop down box
5. follow directions in testing plan attached
6. Make comments in comment box on table in file, save and change version info and initials on file.

Spitalfields: http://alpha.tdar.org/dataset/5874
Alexandria: http://alpha.tdar.org/dataset/3739

ACTION	RESULT	COMMENT	Status

1. Click on Workspace	Takes user to workspace page	http://alpha.tdar.org/workspace/list	ok
2. Click on Integrate tables in your workspace	Takes user to workspace- select tables page	http://alpha.tdar.org/workspace/select-tables	ok
3. Click on Alexandria	Check mark highlights	Table Name: e_3617_qrybone (ID=5653) CHANGE this so that it displays the title also? **	ok
4. Click on Spitalfields	Check mark highlights	Table Name: e_3606_sheet1 (ID=5649) CHANGE this so that it displays the title also? ON ALPHA THE TDAR ID SEEMS TO KEEP CHANGING?? FOR THE DATA TABLES...NOT SURE IF THIS IS A PROBLEM OR WHY IT IS DOING THIS**	ok
5. Click on Next Step	Step 2: Select Columns to Integrate or Display (takes you to this page	http://alpha.tdar.org/workspace/select-columns.action	ok
6. Click on integration button	Box expands to include select data table and select column drop down box		ok
7. Spitalfields column selection – click on up down arrow in drop down box	Drop down box opens and ONLY displays Integrate table columns		ok
8. Check Integratable column list against known list of variables mapped to ontologies	N/A		ok
8. Select "Period Text" Ontology	Drop down box collapses and "Period Text" Populates the drop down box field		ok
7. Alexandria column selection – click on up down arrow in drop down box	N/A		ok
8. Check 'Integratable' column list against known list of variables mapped to ontologies	N/A		ok
9. Select "SITENO" from column drop drown list	Drop down box collapses and "SITE" Populates the drop down box field		ok
10. Click on +add an integration column	A new box appears with the original selection of add an integration column or add a display column	This needs to be MUCH more prominent. Hard to see that this is the next step. I have often accidentally clicked next while in the middle of this process. The next should be in another brown box below this one (consistent with the previous and following pages in this process) perhaps add an exit button and eventually a back button?**	ok - suggestion
11. Click Add a display column	The previous box disappears and is replaced by a select a data table box		ok
12. Click Spitalfields	Box is replaced with another brown box with a drop down menu for selecting which variables. All variables should appear		ok
13. From Drop down box select PART COMMON	Selected, drop down menu collapse, and now appears in drop down menu		ok
14. open drop down menu again and check the that all columns are displaying (with and with ontology mappings).			ok
15. Check the type of column (VARCHAR, etc.) against the types that are present in CORE or that you have printed out			ok
16. Click Add a display column			ok
17. Click Alexandria			ok
18. From Drop down box select BPORTION			ok
19. open drop down menu again and check the that all columns are displaying (with and with ontology mappings).			ok
20. Check the type of column (VARCHAR, etc.) against the types that are present in CORE or that you have printed out			ok
21. Click on integration button	Box expands to include select data table and select column drop down box		ok
22. Spitalfields column selection – click on up down arrow in drop down box	Drop down box opens and ONLY displays Integra table columns		ok
23. Check Integratable column list against known list of variables mapped to ontologies	N/A		ok
24. Select "Species Common Name" Ontology			ok
25. Alexandria column selection – click on up down arrow in drop down box			ok
8. Check 'Integratable' column list against known list of variables mapped to ontologies			ok
9. Select "Taxon" from column drop drown list			ok
10. Click on +add an integration column	A new box appears with the original selection of add an integration column or add a display column	This needs to be MUCH more prominent. Hard to see that this is the next step. I have often accidentally clicked next while in the middle of this process. The next should be in another brown box below this one (consistent with the previous and following pages in this process) perhaps add an exit button and eventually a back button?**	ok- suggestions
11. Look at the two display tables below the "Step 2" box. Check these against the notes you took for from the "Map Columns" area for each dataset			ok
12. Click on "Next Filter Values"	Takes you to Filter Ontology Values	http://alpha.tdar.org/workspace/filter.action	ok
13. The Variables should be in the order you selected them (i.e. Period Text then Taxon)			ok
26. Check to make sure nothing is highlighted			ok
∫27. ERROR CHECK: 15. Click "Next Apply Filter" WITHOUT SELECTING ANY PART OF THE ONTOLOGY TREE (ALL CHECK BOXES SHOULD BE UNCHECKED)	Should Display The following errors were found with your submission Either no integration columns or filter values were selected, please go back and select both	http://alpha.tdar.org/workspace/display-filtered-results.action 1 PROBLEM: There is not any way of getting back. This should be handled the way the errors are handled in the metadata population for new resources??**	ERROR!! ok as of 06032011 (Put in Jira Number?)
28. Repeat the steps up to step 26.			ok
29. Check that the present variables match the data that is the dataset (blue check boxes and red x boxes for each data table are present) by using excel or access to verify		http://alpha.tdar.org/workspace/filter.action	ok
30. "Ontology labels from Alexandria / Spitalfields Faunal Date" Ontology Period Text and SITE NO, check on Period 2 - After 1600 – everything else should be cleared	Box should be checked off to the right of the " Period 2 - After 1600 (all	clear)"			ok
31. Ontology labels from Fauna Taxon - TAG (UK) select radome items on ontology tree (select, deselect) on table Updated - Default Ontology Draft	Box should be checked and unchecked			ok
32. Select one entry from tree that includes only information from one dataset and not the other (Clupea for example)	Box is checked, should only display this variable with no change			ok
33. Check on highest level category with none coded at the higher level in either dataset, but children are coded. ( Elopomorpha (all	clear)	Box Checked, should aggregate all children to this level in output. For example all Anguilla anguilla (common eel European eel) Conger conger (conger eel sea eel) should aggregate up to Elopomorpha .		ok
34 Select CHRONDRICHTHYES (cartilaginous fishes rays requins sharks)	Box checked (testing skipping variables)			ok
35 click "Apply filter button"	Takes you to data integration results page	http://alpha.tdar.org/workspace/display-filtered-results.action		ok
35. Check table display on view page in tdar for correct display				ok
36. Click download all DOWNLOAD all results as an Excel file. Click save in the pop up box	Computer download box pops up.			ok
36. scroll down and click download for each table	Download box pops up, click save			ok
37. check all downloaded datasets in excel against each other				ok
38. open the original dataset (not integrated), check against all downloaded datasets by using sort. Make sure the number of entries, filtering, and that the aggregation is correct. Note how tdar modified the data				ok
Repeat with different variables, display & integration tables, et.				ok