If you need to upgrade your PGV installation, then hopefully you will also consider that you can conveniently move to webtrees with our PGV-to-webtrees wizard. It will move ALL your users, news, favorites and family trees to webtrees in a matter of minutes.
  • Page:
  • 1

TOPIC:

Excel, CSV switch to webtrees? 2 months 3 weeks ago #1

  • nguoiveday
  • nguoiveday's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 128
May I ask, I have an excel , CSV genealogy file. Now I want to import to webtrees, what to do?

Please Log in or Create an account to join the conversation.

Last edit: by nguoiveday.

Excel, CSV switch to webtrees? 2 months 3 weeks ago #2

  • bertkoor
  • bertkoor's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Greetings from Utrecht, Holland
  • Posts: 2743
Export to GEDCOM with the provided Excel macro.
Never used that, but it should be possible.
stamboom.BertKoor.nl runs on webtrees v1.7.13

Please Log in or Create an account to join the conversation.

Excel, CSV switch to webtrees? 2 months 3 weeks ago #3

Not sure if this is of any help but I’ve used the free software GRAMPS to import a csv genealogy file into the software and then export it to a GEDCOM 5.5.1 file to be imported into webtrees. The csv file has to have a specific format to be imported to GRAMPS, see: gramps-project.org/wiki/index.php/Gramps..._with_multiple_areas.
Gudjon
PHP 8.0, webtrees 2.1.7, JustLight Theme 2.2.2.1, Fancy Imagebar 2.2.0, Fancy Research Links 2.2.0, webtrees-simple-menu 1.1, webtrees-fan-chart 2.4.0, webtrees-pedigree-chart 1.4.0, webtrees-descendants-chart 1.2.0 and other webtrees custom modules.

Please Log in or Create an account to join the conversation.

Last edit: by gudjonsi.

Excel, CSV switch to webtrees? 2 months 2 weeks ago #4

  • nguoiveday
  • nguoiveday's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 128
Download the software GRAMPS but install error

Please Log in or Create an account to join the conversation.

Excel, CSV switch to webtrees? 2 months 2 weeks ago #5

  • hermann
  • hermann's Avatar
  • Offline
  • Premium Member
  • Premium Member
  • Posts: 610
Maybe it is easier to use GedTool: gedtool.de/index.php/en/
GedTool converts csv to GEDCOM and vice versa.
Hermann
Designer of the custom module "Extended Family"

webtrees 2.0.23 (all custom modules installed, php 7.4.15, MySQL 5.6) @ ahnen.hartenthaler.eu

Please Log in or Create an account to join the conversation.

Excel, CSV switch to webtrees? 2 months 2 weeks ago #6

  • TheDutchJewel
  • TheDutchJewel's Avatar
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 117

Download the software GRAMPS but install error
Try the portable version: portableapps.com/apps/education/gramps_portable
- webtrees 2.0.19 (not 2.0.23 because missing fix for too strict markdown implementation)
  + PHP 7.4.29 | modules: Rural theme, Vesta Classic Look & Feel, Extended Family, Fancy Research Links, Family Tree Home Page, ℍ&ℍwt MultTreeView
- testing webtrees 2.1.7

Please Log in or Create an account to join the conversation.

Excel, CSV switch to webtrees? 2 months 2 weeks ago #7

  • nguoiveday
  • nguoiveday's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 128

Download the software GRAMPS but install error
Try the portable version: portableapps.com/apps/education/gramps_portable
Attachments:

Please Log in or Create an account to join the conversation.

Excel, CSV switch to webtrees? 2 months 2 weeks ago #8

  • TheDutchJewel
  • TheDutchJewel's Avatar
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 117
Extract 'GrampsPortable_5.1.5.paf.exe' with 7-zip (or another archive manager) to a new folder (you can remove the $PLUGINSDIR folder) and run GrampsPortable.exe from there.
- webtrees 2.0.19 (not 2.0.23 because missing fix for too strict markdown implementation)
  + PHP 7.4.29 | modules: Rural theme, Vesta Classic Look & Feel, Extended Family, Fancy Research Links, Family Tree Home Page, ℍ&ℍwt MultTreeView
- testing webtrees 2.1.7

Please Log in or Create an account to join the conversation.

Last edit: by TheDutchJewel.
Do you need a web hosting solution for your webtrees site?
If you prefer a host that specialises in webtrees, the following page lists some suppliers able to provide one for you: 

Excel, CSV switch to webtrees? 2 months 2 weeks ago #9

  • nguoiveday
  • nguoiveday's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 128

Extract 'GrampsPortable_5.1.5.paf.exe' with 7-zip (or another archive manager) to a new folder (you can remove the $PLUGINSDIR folder) and run GrampsPortable.exe from there.
I can install the software, but I can't convert the CSV file into it

Please Log in or Create an account to join the conversation.

Excel, CSV switch to webtrees? 2 months 2 weeks ago #10

  • nguoiveday
  • nguoiveday's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 128
>????
Attachments:

Please Log in or Create an account to join the conversation.

Excel, CSV switch to webtrees? 2 months 2 weeks ago #11

  • bertkoor
  • bertkoor's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Greetings from Utrecht, Holland
  • Posts: 2743
I was under the impression you had an Excel file edited with gedtool, but apparently that is not the case. Webtrees only imports proper GEDCOM files. So lets start from the beginning.

Where did you get the file from? Can you share the first few lines?
csv is plain text, use notepad.exe to open it.
stamboom.BertKoor.nl runs on webtrees v1.7.13

Please Log in or Create an account to join the conversation.

Last edit: by bertkoor.

Excel, CSV switch to webtrees? 2 months 2 weeks ago #12

Extract 'GrampsPortable_5.1.5.paf.exe' with 7-zip (or another archive manager) to a new folder (you can remove the $PLUGINSDIR folder) and run GrampsPortable.exe from there.
I can install the software, but I can't convert the CSV file into it

If you want to use Gramps for csv import you need to make sure that your csv file is set up like Gramps expects the file to be configured, using the field names that Gramps recognises, see example below (file viewed in a text editor, like Notepad):
,,,,
"Person","Firstname","Lastname",”Birthdate”,
1,"Peter","Blank",”22 JAN 1970”,
2,"Anna Maria","Blank",”22 FEB 1970”,
3,"Georg","Schmidt",”22 MAR 1980”,
4,"Barbara","Schmidt",”22 APR 1980”,
5,"Johann","Blank", ” 22 MAY 1990”,
6,"Fides","Blank",”22 JUN 1991”,
7,"Sebastian","Schmidt",”22 AUG 2000”,
8,"Magdelena","Schmidt",”22 SEP 2001”,
,,,
"Marriage","Husband","Wife","Date"
"A",1,2,"28 jan 1990"
"B",3,4,"4 may 2000"
,,,
"Family","Child","Child",
"A",5,6,
"B",7,8,

More detailed information can be found at this path, including proper field names, CSV import

If your csv file isn’t configured as Gramps expects it to be for proper import then it will fail. Field names need to be in accordance with Gramps csv field names so you may need to make changes to you csv file for this to work. Always make a copy of your original csv file and only make changes to the copy file to test this. This may require several trials on your part before it works so you fully understand how this Gramps import process functions. It took me awhile to get it to work as I wanted. A simple csv test file is included in the above guidance from Gramps to better test this import function.

Maybe the GEDtool is better to handle csv import, as suggested by Hermann, I haven’t tried it though.
Gudjon
PHP 8.0, webtrees 2.1.7, JustLight Theme 2.2.2.1, Fancy Imagebar 2.2.0, Fancy Research Links 2.2.0, webtrees-simple-menu 1.1, webtrees-fan-chart 2.4.0, webtrees-pedigree-chart 1.4.0, webtrees-descendants-chart 1.2.0 and other webtrees custom modules.

Please Log in or Create an account to join the conversation.

Last edit: by gudjonsi.

Excel, CSV switch to webtrees? 2 months 2 weeks ago #13

  • nguoiveday
  • nguoiveday's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 128

Maybe it is easier to use GedTool: gedtool.de/index.php/en/
GedTool converts csv to GEDCOM and vice versa.
GedTool: Thanks for the instructions on how to use it

Please Log in or Create an account to join the conversation.

Excel, CSV switch to webtrees? 2 months 2 weeks ago #14

  • Peter_S
  • Peter_S's Avatar
  • Offline
  • Senior Member
  • Senior Member
  • Posts: 332
Order the Shareware version of GedTool (for free), read the manual (in particular chapter 5) and have a look to the example files. Questions about GedTool can be placed in the GedTool-Forum or direct to the author. See gedtool.de
Peter

webtrees 2.1.6, vesta modules, chart modules of magicsunday, extended family of hartenthaler
PHP 8.0, MySQL 8.0.16
Webhosting: genonline.de

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Powered by Kunena Forum