tag:blogger.com,1999:blog-4726802159327032874.post3144137674088546228..comments2024-02-21T05:48:18.552+11:00Comments on Twigs of Yore: Visualising Ancestry DNA matches-Part 2-Loading files the first timeShelley Crawfordhttp://www.blogger.com/profile/15008715347583341427noreply@blogger.comBlogger82125tag:blogger.com,1999:blog-4726802159327032874.post-62581360717561652452018-10-09T22:10:17.991+11:002018-10-09T22:10:17.991+11:00You're very welcome!You're very welcome! Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-58581695848031630282018-10-09T22:09:23.505+11:002018-10-09T22:09:23.505+11:00It will make a difference to the grouping. Try it ...It will make a difference to the grouping. Try it both ways and see which makes more sense!Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-24723261416543303172018-10-02T07:05:27.221+10:002018-10-02T07:05:27.221+10:00This is seriously awesome. I had a large Excel-she...This is seriously awesome. I had a large Excel-sheet of known associates of a person of interest, and their associates. The NodeXL template together with your instructions allowed me to visualize the whole network. Thank you so much!Yvette Hoitinkhttps://www.blogger.com/profile/10807310204372870735noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-80498880347764777562018-09-21T11:27:11.692+10:002018-09-21T11:27:11.692+10:00If I am only interested in the grouping data and n...If I am only interested in the grouping data and not the plot, does it matter if I enter skip in my closest matches? I am thinking they could help me identify which part of my tree these groups are.Kent Jhttps://www.blogger.com/profile/12356187245661856343noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-53679940253693594082018-08-16T01:22:23.618+10:002018-08-16T01:22:23.618+10:00Instead of using the “Additional Input” file to sk...Instead of using the “Additional Input” file to skip the close matches I do the following:<br /><br />When importing the matches file, I select “range” item in addition to the other recommended items (“name”, “admin”, etc.) for “Is Vertex 2 Property Column”. Range is the relationship bucket displayed in Ancestry.<br /><br />Then I go to the Vertices tab of the workbook and set the Range column to display only the close matches (Parent/Child, Close relations, etc.) and also blanks. You can then change the display option for those lines that you wish to hide or skip. The line with the blank relationship is the test taker. While I am there I usually add SELF to the name field of the test taker to keep track of it.<br /><br />Now reset the range column to display all and that’s it. No need for that third spreadsheet.<br />John MOTZInoreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-49420304934500202202018-07-09T02:25:30.148+10:002018-07-09T02:25:30.148+10:00I just created a new nodexl graph for a dna test w...I just created a new nodexl graph for a dna test with which I am intimately familiar, the first one I ever "solved" (for an adopted friend). I have skipped him but nobody else. He has two maternal uncles ~1800 cm, I have not skipped them. When I create the graph and tell it to put each group into a separate box, I get ONE group (all dark blue). I have tried tweaking the upper level of the cm to show such that the uncles are excluded, and that doesn't appear to break the data up into more than one group (would it?). This is not endogamous data, quite the opposite. There's his father's side which has colonial roots mostly from England, his mother's side - maternal is 100% norwegian immigrants, paternal is 100% scottish immigrants, the only overlap between the Scottish and the Norwegian is his mother (who hasn't tested) and her two brothers (who have).<br /><br />Yet somehow nodexl thinks this is one big group?Alexandra Dixonnoreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-71438620477964276272018-05-13T17:30:07.405+10:002018-05-13T17:30:07.405+10:00Hi Caitlin, how much RAM does your machine have? T...Hi Caitlin, how much RAM does your machine have? The NodeXL FAQ page https://www.smrfoundation.org/nodexl/faq/ says that a network of 200,000+ edges would require 32GB of RAM. <br />Assuming that's it, there are still some things to try:<br />- Double and triple check that you and any very close relatives have "Skip" in the visibility column. <br />- Follow the instructions about clearing duplicates from this page http://twigsofyore.blogspot.com.au/2017/07/visualising-ancestry-dna-matchespart-4.html<br />- If you have downloaded ALL matches, try entering "Skip" in the Visibility column for the more distant ones. Either find the level you want to start skipping from and copy the work down, or use the Autofill Columns button > Vertex Visibility > arrow on the side to set which to skip. (double check you haven't accidentally unskipped yourself by doing this).<br />If that doesn't work come on in to the Network Graphs for Genetic Genealogy Facebook group. There's an excel worksheet in the files section that takes care of the above for you, or we can help you get started with Gephi (another network graph tool that will handle larger networks).Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-36428686893124183622018-05-13T10:58:51.900+10:002018-05-13T10:58:51.900+10:00Same thing just happened with me. I've importe...Same thing just happened with me. I've imported everything correctly 3 times now, and I still don't get a graph showing up. I did the ABC test as above and that worked perfectly.<br />I do have over 220,000 lines of data in the Edge section. Could it be that it is just too big to load?Caitie Ghttps://www.blogger.com/profile/02054807096733772596noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-34499269169519044632018-03-09T11:19:56.046+11:002018-03-09T11:19:56.046+11:00Is the "Additional Input" file to be sav...Is the "Additional Input" file to be saved as .xls or .csv? Thanks!dBhttps://www.blogger.com/profile/04020304484607717734noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-46375293609542123052018-02-23T20:34:18.571+11:002018-02-23T20:34:18.571+11:00Hi Jane, you will need to create that file yoursel...Hi Jane, you will need to create that file yourself (see the first part). The main purpose of it is to make sure that the dot that represents you isn't shown. If you can find the correct row on the vertices sheet you can simply enter "Skip" in the visibility column if that's easier for you. Don't forget to do it one way or another or you'll end up waiting for ages only to see a blob! Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-43068843267927949872018-02-23T20:31:47.541+11:002018-02-23T20:31:47.541+11:00Hi Alisha, sorry I didn't reply sooner. You ju...Hi Alisha, sorry I didn't reply sooner. You just need to type in the word without delineating it.Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-8855405631107399292018-02-23T09:23:56.338+11:002018-02-23T09:23:56.338+11:00Yes, indeed, thank you for the explicit instructio...Yes, indeed, thank you for the explicit instructions. I managed to get to step 3 of Import. That is where I have a problem. I don't have an "additional input file." I do, however, have a file that begins with "a_..." I tried that but did not get the subsequent questions/boxes/steps. How do I get the "additional input>?" I tried Googling it and was referred back here.Jane Bonnyhttps://www.blogger.com/profile/15204935165607430432noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-90398438019617120912018-01-02T20:49:22.083+11:002018-01-02T20:49:22.083+11:00I imported the three worksheets. Should I be putti...I imported the three worksheets. Should I be putting the word in quotation marks or otherwise delineating the <a href="http://www.filehippoa.com/" rel="nofollow"> word</a>?<br />Anonymoushttps://www.blogger.com/profile/16955291297569179100noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-11284380314316238962018-01-02T08:46:31.876+11:002018-01-02T08:46:31.876+11:00Thanks! I'll give it a try.Thanks! I'll give it a try.SmithHunter1783https://www.blogger.com/profile/10799752373378214676noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-28325693235575867022018-01-01T14:08:29.543+11:002018-01-01T14:08:29.543+11:00Hi Chris, you probably missed fixing the import op...Hi Chris, you probably missed fixing the import options to retain data already imported:<br />On the NodeXL ribbon, click the Import button.<br />Choose Import Options… (the bottom item on the menu).<br />Clear the box next to “Clear the NodeXL workbook before data is imported”. <br />I think that should fix your problem!Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-7829649538225637402018-01-01T14:02:28.715+11:002018-01-01T14:02:28.715+11:00Loading "Additional Input File.xlsx" and...Loading "Additional Input File.xlsx" and it erases everything from Edges and Vertices tables. What am I doing wrong?SmithHunter1783https://www.blogger.com/profile/10799752373378214676noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-58212621600901699382017-12-02T19:08:50.093+11:002017-12-02T19:08:50.093+11:00Hi Lynn, first I want to clarify that it's not...Hi Lynn, first I want to clarify that it's not my program. I just applied it to DNA matches. :-)<br />Hopefully you might have had better luck when you closed out and came in again. The program is quite memory intensive, especially if you have a lot of matches, and it could be that your PC doesn't quite manage it.<br />Some things you can try: <br />Minimise the work your PC is doing while working on the spreadsheet. Don't have other processes running.<br />The Additional worksheet is primarily a way to easily apply the word "Skip" to your own record on the Vertices sheet. You can enter the word manually if necessary. Your name won't be in the file, you will need to search on your ID number. (The general find function will work better than the column filters for that).<br />If you downloaded all matches, you might be better off to only download 4th and closer cousins.<br />Assuming you are able to move on... before you try to plot the graph, do make sure that you and any very closer relatives have "Skip" marked. Also, move ahead to part 4 and follow the instruction about removing duplicates before you try and plot. http://twigsofyore.blogspot.com.au/2017/07/visualising-ancestry-dna-matchespart-4.html <br />I hope some of these suggestions help!Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-78452611273960371782017-12-02T04:03:23.947+11:002017-12-02T04:03:23.947+11:00Hello, Thank you very much for your wonderful prog...Hello, Thank you very much for your wonderful program. I am at step 2 and trying to load my Additional Worksheet. I receive this error: [OutOfMemoryException]: Exception of type 'System.OutOfMemoryException' was thrown. <br />Is there a workaround for this? My icw and match files loaded fine. I enjoy your step by step, detailed explanations! Thank you Lynn Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-77245566374281956272017-11-21T22:04:25.670+11:002017-11-21T22:04:25.670+11:00Hi g, but you can see data in the first two column...Hi g, but you can see data in the first two columns of the Edges sheet?Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-86869762546238178422017-11-16T04:15:31.323+11:002017-11-16T04:15:31.323+11:00Hi Shelley, I have the same problem as Daniela abo...Hi Shelley, I have the same problem as Daniela above. I have tried the test data as suggested and I get the three connected dots. Still no graph for my main data though. I am the only user named in the additional info file and the Skip has copied over into the Vertices tab. Wonder what is going wrong.<br />TIAghttps://www.blogger.com/profile/09952072182649357976noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-25424202104270963182017-11-14T22:17:39.634+11:002017-11-14T22:17:39.634+11:00Hi Daniela, if you can see data in the first two c...Hi Daniela, if you can see data in the first two columns on the Edges sheet you should get a graph even if something else has gone wrong. <br />To confirm that NodeXL works on your system, try creating a new empty NodeXL sheet and hand enter some information in the first few rows of the Edges worksheet. eg<br />Vertex 1, Vertex 2<br />A, B<br />B, C<br />C, A<br />This should draw three dots connected by lines when you click refresh. Did that work?<br />Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-42516267588488889442017-11-14T22:11:20.530+11:002017-11-14T22:11:20.530+11:00Did you get it working?Did you get it working?Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-34964936643466420732017-11-12T21:58:59.562+11:002017-11-12T21:58:59.562+11:00Hi Shelley, I wonder if you might have an idea on ...Hi Shelley, I wonder if you might have an idea on what I've done wrong. I've been through the process twice, reading everything carefully (or so I thought), and yet I get nothing at the end. When I hit the button to make the graph, it thinks for about one second and acts like it's done, but no graph shows up. When I hit "refresh" --- same thing. I can move freely around the spread, so it's obviously not hung in the middle of thought. I use Excel every day at work (although nothing this complicated), so I feel that I am fairly well versed in its basic use. Any help would be greatly appreciated! Thank you in advance!Anonymoushttps://www.blogger.com/profile/14116587130970790009noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-37869679990086955472017-10-26T14:32:32.781+11:002017-10-26T14:32:32.781+11:00I've closed out for the night, and will work w...I've closed out for the night, and will work with it again in the morning. My screen looks exactly like the sample when I am at the import step. When I click on import, there is a pause and then that message pops up. Open to playing with any ideas....just an aside, I LOVE this tool and appreciate all of the work you have put in to writing up such great directions with illustrations. Thank YOU. (Now I just need to get it to work!) Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-73830143623389324772017-10-26T09:40:15.007+11:002017-10-26T09:40:15.007+11:00Hi, I've never come across that message. I ass...Hi, I've never come across that message. I assume that your ICW file has more than two rows. Do you see the same "Import from Open Workbook" dialog as shown in the post? Do you get the message before or after that?Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.com