Create a Family Tree using Google Sheets and yEd

Поділитися
Вставка
  • Опубліковано 1 лис 2024

КОМЕНТАРІ • 40

  • @user7user
    @user7user 2 роки тому +1

    Thanks a lot for the video! So simple and brilliant idea how to visualize ANY relational data

  • @Dadax9398
    @Dadax9398 2 роки тому +1

    Clear explanations, good video. Thanks sir

    • @uuoocl
      @uuoocl  2 роки тому +1

      Thanks for the feedback

  • @MultiMacsek
    @MultiMacsek 10 місяців тому

    Hi Jonathan, Thanks a lot for creating and improving this template for yEd! I wanna create my own layout for the nodes so I'm using your 2022 version google sheet w/ the data mapping from this video. However I'm getting "Family tree layout expects a family tree as its input. The current graph is not a family tree." error in the Layout/Family Tree option. I boiled it down to the software not liking that the family gets a custom template. I see that in the downloadable 2022 config file you no longer have visible family nodes, and that also seems to work fine for me, but not the method shown in this video (family node gets a template assigned). I kinda want a custom node for the families as I'd like to show marriage year there. Do you perhaps have an idea for a solution?

    • @MultiMacsek
      @MultiMacsek 10 місяців тому

      To whom it may concern, The solution was to set the correct color corresponding to the family nodes in the Family Tree layouter. yEd doesn't seem to care if the male/female colors are set right, but the incorrect family color seems to break the layouter.

  • @markcastrovinci6074
    @markcastrovinci6074 Рік тому

    Thank you for taking the time to invent this wonderful approach and sharing it.
    I'm trying to decide how to create a family tree site and I really don't want the bells and whistles of WordPress so I'd prefer to use Google Sites.
    Again, I'm just deciding which platform to use so I haven't immersed myself in all of the details so I'd like to ask what might be an obvious question which is "Can I use your methods to create a Family Tree then drop the result into a Google Sites page?" Thanks for your help.

    • @uuoocl
      @uuoocl  Рік тому +1

      Hi Mark, thanks for the question! I think the yEd family tree could be saved as a PDF file. Then the PDF could be embedded in a Google Sites page. Hope that helps with your project.
      Publii is a site generator to check out too. getpublii.com/

    • @markcastrovinci6074
      @markcastrovinci6074 Рік тому

      @@uuoocl Thanks for the response. I will check it out. -- Mark

  • @NamTH2718
    @NamTH2718 2 роки тому

    Thank you. This helps me a lot.

    • @uuoocl
      @uuoocl  2 роки тому

      Glad it helped! New version is available now too. ua-cam.com/video/i_U7COUTCtg/v-deo.html

  • @rawan0061
    @rawan0061 2 роки тому +1

    thank you for the video and template I extremely loved it, but can I ask you if I can add more than one spouse for the same person?

    • @rawan0061
      @rawan0061 2 роки тому

      okay I think I can figure it I saw the example thanks

    • @uuoocl
      @uuoocl  2 роки тому

      Thanks for the comment. I’m happy you could figure out adding more than one spouse. Let me know if you have other questions.

  • @ytlasuzuki
    @ytlasuzuki Місяць тому

    Love the "how to" I've been using your process for a few years, but I have found that I can't up load to Yed Graph more than 162 data entries. Any work around? Thank you again.

    • @uuoocl
      @uuoocl  Місяць тому

      Happy to know you've been using this! I've uploaded files with thousands of records to yEd previously. You have to tell yEd what range to import. Have you set the import range to match the excel file?

    • @ytlasuzuki
      @ytlasuzuki Місяць тому

      @@uuoocl I will check, I follow the process faithfully, but I'll try to double check that all the range is correct. Thank you

  • @HenryKemlin
    @HenryKemlin 6 місяців тому

    Thanks for the video. I want to sort brother and sister with de birt date. Is that possible ?

  • @klughbamba
    @klughbamba 3 роки тому +1

    Thanks for this video. This is really helpful for my project. Would you know if there are ways to add photos to the family tree?

    • @uuoocl
      @uuoocl  3 роки тому +1

      Yes, photos can be added. See this yEd forum post with instructions for adding photos.
      yed.yworks.com/support/qa/13024/how-can-i-add-an-icon-to-a-label

    • @klughbamba
      @klughbamba 3 роки тому

      @@uuoocl will check it out. Thanks

  • @omerviso
    @omerviso Рік тому

    How do add the dates as Day/Month/Year to the family tree? Only the year comes into it. Thank you.

    • @uuoocl
      @uuoocl  Рік тому

      Thanks for trying to make a family tree from my video!
      To use the day/month/year format, click
      the Edit menu➡Properties Mapper. In the Properties Mapper find the row with "Birth Date" change the "Conversion" column to "Automatic"

  • @madisonarchard6230
    @madisonarchard6230 2 роки тому

    Is there any common reason that I would be unable to upload the excel file onto yed? It isn't lit up as an option when I click "open" after setting up the family tree palette.

    • @uuoocl
      @uuoocl  2 роки тому

      Hi Madison, thanks for your interest in making family trees and thanks for the question. I’m not sure why importing the excel into yEd isn’t an option.
      I tried to simplify the process in this video
      “Create a Photo Family Tree with Google Sheets and yEd v. 3”
      ua-cam.com/video/qs8Ips159ts/v-deo.html
      Please try to follow the instructions on the updated video.

    • @madisonarchard6230
      @madisonarchard6230 2 роки тому

      @@uuoocl I will check out that video! Thanks so much--for responding to my question and for making these videos in the first place.

  • @patriciaduzey3284
    @patriciaduzey3284 2 роки тому

    Hi Jonathan, I have my Google sheet ready as described in your video, but the yEd part is not matching what I see on the yEd website, which also isn't loading at times. Now that I have put this sheet together, is there another way to load it to a printable tree format?

    • @uuoocl
      @uuoocl  2 роки тому

      Patricia, thanks watching this video. I’m working on updating the instructions to make the process easier.

    • @pduzey
      @pduzey 2 роки тому

      @@uuoocl Great, hope that will be available soon. I am using the family tree as part of a StoryWorth book for my mother.

    • @pduzey
      @pduzey 2 роки тому

      @@uuoocl What version of yEd did you use in your video? The current version is 3.22 and I cannot reconcile it to the video. Sorry to appear impatient; my Mom is 92 and timing is key as to whether I can accomplish this or not.

    • @uuoocl
      @uuoocl  2 роки тому

      Thanks for your patients. Here the new version. ua-cam.com/video/i_U7COUTCtg/v-deo.html

    • @pduzey
      @pduzey 2 роки тому

      @@uuoocl Hi Jonathan, thank you so much for getting this done! Meanwhile, I began and got stuck when trying to add the FamilyTree file to configuration in yEd. I work on a Mac desktop and it doesn't recognize the file type. Do you know what app will allow me to open the file and use it?

  • @yanivlugassy3190
    @yanivlugassy3190 Рік тому

    Hi where can i find a working template please ?

    • @uuoocl
      @uuoocl  Рік тому

      This version should work. ua-cam.com/video/qs8Ips159ts/v-deo.html

  • @joandresser3461
    @joandresser3461 2 роки тому +1

    Template doesn't load.

    • @uuoocl
      @uuoocl  2 роки тому

      Thanks for letting me know. I’m not certain why it isn’t loading.
      A new version of the template will be released soon.

  • @sajit63
    @sajit63 11 місяців тому

    Consider using Google drawing and Google sheet for creating the family tree.

    • @uuoocl
      @uuoocl  11 місяців тому

      Thanks for the suggestion. Can you share an example of how to do that?