DNA+Test+results+list

RootsMagic 4 allows one to add a DNA Test fact to a person and enter the results of two types of test. However, there is no report available for the results making it difficult to verify that all data have been accurately transcribed. The results are stored in the EventTable Details column in XML format, making a direct query of this field difficult to read. These two queries, one for each type of test, produce more easily read results by stripping out much of the XML tagging and formatting the results in list format, tab-delimited for the Y-STR query which has multiple columns.



Y-STR DNA Consultants TestDesc Test/Kit ID Haplogroup   DYS385a  5   DYS385b  10.2   DYS388  6   DYS389i  11   DYS389ii  21   DYS390  17   DYS391  4   DYS392  8   DYS393  6   DYS19  12-15   DYS426  6.2   DYS437  14   DYS438  6  <marker code="DYS439"> DYS439  10  <marker code="DYS441"> DYS441  8  <marker code="DYS442"> DYS442  13  <marker code="DYS444"> DYS444  8  <marker code="DYS445"> DYS445  7  <marker code="DYS446"> DYS446  8  <marker code="DYS447"> DYS447  18  <marker code="DYS448"> DYS448  11  <marker code="DYS449"> DYS449  23  <marker code="DYS452"> DYS452  7  <marker code="DYS454"> DYS454  9  <marker code="DYS455"> DYS455  4  <marker code="DYS456"> DYS456  16  <marker code="DYS458"> DYS458  10  <marker code="DYS459a"> DYS459a  5  <marker code="DYS459b"> DYS459b  2  <marker code="DYS460"> DYS460  10.1  <marker code="DYS461"> DYS461  11-12  <marker code="DYS462"> DYS462  10  <marker code="DYS463"> DYS463  5  <marker code="DYS464a"> DYS464a  10.3  <marker code="DYS464b"> DYS464b  10.1  <marker code="DYS464c"> DYS464c  9.3  <marker code="DYS464d"> DYS464d  10.3  <marker code="GAAT1B07"> GGAAT1B07  14  <marker code="YCAIIa"> YCAIIa  16.1  <marker code="YCAIIb"> YCAIIb  16.1  <marker code="GATAA10"> GATA-A10  14  <marker code="DYS635"> DYS635  21-22  <marker code="GATAH4"> GATA-H4  12  <marker code="DYS465X"> DYS464X  4  <marker code="DYS464f"> DYS464f  10.3  <marker code="DYS481"> DYS481  22  <marker code="DYS485"> DYS485  15  <marker code="DYS487"> DYS487  12     || Y-STR <laboratory code="DNAConsultants">DNA Consultants TestDesc Test/Kit ID</id> Haplogroup <marker code="DYS385a"> DYS385a 5 <marker code="DYS385b"> DYS385b 10.2 <marker code="DYS388"> DYS388 6 <marker code="DYS389i"> DYS389i 11 <marker code="DYS389ii"> DYS389ii 21 <marker code="DYS390"> DYS390 17 <marker code="DYS391"> DYS391 4 <marker code="DYS392"> DYS392 8 <marker code="DYS393"> DYS393 6 <marker code="DYS19"> DYS19 12-15 <marker code="DYS426"> DYS426 6.2 <marker code="DYS437"> DYS437 14 <marker code="DYS438"> DYS438 6 <marker code="DYS439"> DYS439 10 <marker code="DYS441"> DYS441 8 <marker code="DYS442"> DYS442 13 <marker code="DYS444"> DYS444 8 <marker code="DYS445"> DYS445 7 <marker code="DYS446"> DYS446 8 <marker code="DYS447"> DYS447 18 <marker code="DYS448"> DYS448 11 <marker code="DYS449"> DYS449 23 <marker code="DYS452"> DYS452 7 <marker code="DYS454"> DYS454 9 <marker code="DYS455"> DYS455 4 <marker code="DYS456"> DYS456 16 <marker code="DYS458"> DYS458 10 <marker code="DYS459a"> DYS459a 5 <marker code="DYS459b"> DYS459b 2 <marker code="DYS460"> DYS460 10.1 <marker code="DYS461"> DYS461 11-12 <marker code="DYS462"> DYS462 10 <marker code="DYS463"> DYS463 5 <marker code="DYS464a"> DYS464a 10.3 <marker code="DYS464b"> DYS464b 10.1 <marker code="DYS464c"> DYS464c 9.3 <marker code="DYS464d"> DYS464d 10.3 <marker code="GAAT1B07"> GGAAT1B07 14 <marker code="YCAIIa"> YCAIIa 16.1 <marker code="YCAIIb"> YCAIIb 16.1 <marker code="GATAA10"> GATA-A10 14 <marker code="DYS635"> DYS635 21-22 <marker code="GATAH4"> GATA-H4 12 <marker code="DYS465X"> DYS464X 4 <marker code="DYS464f"> DYS464f 10.3 <marker code="DYS481"> DYS481 22 <marker code="DYS485"> DYS485 15 <marker code="DYS487"> DYS487 12 " ||
 * Sample direct query of a Y-STR DNA Test fact:**
 * **Person** || **DNAtest** ||
 * Surname, James Gordon || <range type="comment" id="775599"><?xml version="1.0" encoding="UTF-8"?>
 * Above processed by DNA_Y-STR_markerslist query:**
 * Person || DNAtest ||
 * Surname, James Gordon || "<?xml version="1.0" encoding="UTF-8"?>
 * Extract of above pasted into PSPAD and then into text-formatted cells in Excel 2010:**