Gedcom is a format for storing genealogical information designed by The Church of Jesus Christ of Latter-Day Saints (http://www.lds.org).
This module allows to converting data in GEDCOM format to SQLite DB.
$ gedcom -file sergeyb.gedcom
$ sqlite3 sergeyb.sqlite
SQLite version 3.20.1 2017-08-24 16:21:36
Enter ".help" for usage hints.
sqlite> -- "Total number of persons:"
sqlite> SELECT COUNT(*) FROM person_st;
sqlite> -- "Total number of childs:"
sqlite> SELECT COUNT(*) FROM famchild;
sqlite> -- "Total number of families:"
sqlite> SELECT COUNT(*) FROM family;
sqlite> -- "Total number of male persons:"
sqlite> SELECT COUNT(*) FROM person_st WHERE sex='M';
sqlite> -- "Total number of female persons:"
sqlite> SELECT COUNT(*) FROM person_st WHERE sex='F';
sqlite> -- "Total number of death dates:"
sqlite> SELECT COUNT(*) FROM person_st WHERE deat_date IS NOT "";
sqlite> -- "Total number of burial dates:"
sqlite> SELECT COUNT(*) FROM person_st WHERE buri_date IS NOT "";
sqlite> -- "Total number of birth dates:"
sqlite> SELECT COUNT(*) FROM person_st WHERE birt_date IS NOT "";$ gedcom -file samples/bronte.ged
Person (I0003) Maria /Brontë/
EI112: person has no family pointers
Person (I0004) Elizabeth /Brontë/
EI112: person has no family pointers
Person (I0006) Patrick Branwell /Brontë/
EI112: person has no family pointers
Person (I0007) Emily Jane /Brontë/
EI112: person has no family pointers
Person (I0008) Anne /Brontë/
EI112: person has no family pointers
Person (I0014) Elizabeth /Branwell/
EI112: person has no family pointers
Family (F001)
EP102: child is born before mother
Family (F002)
EF107: family missing pointer to child
Family (F002)
EF100: family has no members
[Brunty] Brontë
Family (F003)
EP106: child doesn't inherit father's surname
The application builds a family tree based on data from social networks. So far, support has been implemented only for VKontakte.
Facebook:
- https://developers.facebook.com/docs/graph-api/reference
- Заполнить: Профиль -> Информация -> Семейные отношения
VK API:
- Методы: account.getProfileInfo, users.get
- Частотные ограничения: "К методам API ВКонтакте можно обращаться не чаще 3 раз в секунду."
- Ошибки: https://vk.com/dev/errors
- Приложение
- Аккаунты для отладки:
Copyright (c) 2017-2021, Sergey Bronnikov