GenoPro Home
GenoPro Home  |  Get Started With My Genealogy Tree  |  Buy  |  Login  |  Privacy  |  Search  |  Site Map
 

GenoPro Support Forum


Home » GenoPro » Suggestions, Wish List and Feature Requests » Table import


Table import

Click to view RSS...
Author Import table or spreadsheet
appleshaw
Posted Thursday, April 24, 2008 - Post #21478
Grand Master

Grand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand Master

Customers
Important Contributors
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.0
Last Login: Yesterday @ 11:27 PM
Posts: 1,595, Visits: 32,481
There have been several requests, both on this forum and elsewhere, for the ability to import spreadsheets. The general answer is that they are different sets of data and not compatible. SmartGenealogy does export to Xls spread sheet and also imports them. However they need to be in a specific format.

This gives rise to the thought that if a single sheet spreadsheet format were defined then it should be possible to import into GenoPro. It could lead to a feature akin to the Gedcom import. This would be based on a text export from the table, such as csv or even xml (although older programs would not support this)

Looking at the xml file of a simple family shows that it contains a header followed by a list of Individuals; then a list of Families and finally the PedigreeLinks where Individuals are linked as "Parent" or "Biological" in the defined families.

A list of fields would need to be identified, including place & date of birth/baptism and of death. A separate import routine would be an easier way to deal with marriages. This would lead to a similar situation to the Gedcom import where, using LDS data, you usually get these separately and have join/merge the data manually.

Some of the information in the output relates to position. This would need to be derived in a similar way to the Gedcom import and presumably the same Auto Arrange routine could be used for that.

Any chance that this could be developed? Seems like the sort of task to give to a project trainee or as degree course work.
GenoProSupport
Posted Thursday, April 24, 2008 - Post #21482
Legendary Master

Legendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary Master

Administrators
Moderators
Customers
Gamma
FamilyTrees.GenoPro.com
Translator
GenoPro version: 3.1.0.1
Last Login: Tuesday, October 28, 2025
Posts: 4,886, Visits: 22,799
Importing data from a spreadsheet is always a case-by-case basis.  One approach would be to write a stand-alone application, may in VB or C# that converts the tabular data to produce an XML file for GenoPro.  This way, if soneome has a spreadsheet, he can download the source code and modify the code to fit his spreadsheet format.
Poolzone
Posted Thursday, April 24, 2008 - Post #21485
Famous Writer

Famous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous Writer

Customers
Important Contributors
GenoPro version: 2.5.4.0
Last Login: Thursday, January 11, 2024
Posts: 386, Visits: 4,475
This code has previously been produced in the conversation table excel import, together with an offer for help.  Perhaps we could ask the writer to post the VBA code so it could be stored by GenoPro and modified by users wanting to use this function.

Poolzone  a mere cog in a revolution

Edited: Thursday, April 24, 2008 by GenoProSupport


Similar Topics

Click to view RSS...
Expand / Collapse

Reading This Topic

Expand / Collapse


Powered By InstantForum.NET 2010-3-x © 2025
Execution: 0.031. 5 queries. Compression Enabled.