Contents
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.
DNA_mtDNA_locationslist.sql
DNA_Y-STR_markerslist.sql
Sample direct query of a Y-STR DNA Test fact:
Above processed by DNA_Y-STR_markerslist query:
| Person | DNAtest |
| Surname, James Gordon | “<?xml version=”1.0″ encoding=”UTF-8″?> <dnatest><type>Y-STR</type><laboratory code=”DNAConsultants”>DNA Consultants</laboratory><description>TestDesc</description><id>Test/Kit ID</id><haplogroup confirmed=”true”>Haplogroup</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 </markers></dnatest> “ |
Extract of above pasted into PSPAD and then into text-formatted cells in Excel 2010:
Discussions & comments from Wikispaces site
Use a XML Viewer
03 September 2018 20:36:11
ve3meo Jun 18, 2011
Here’s another way to view the XML data. Copy the Details cell contents to a text file and save it with the extension .XML; then open it with Internet Explorer or some other XML viewer for a color-coded and formatted view that is a big readability improvement.