Jump to content


Photo

CSV Import - easiest way?


  • Please log in to reply
6 replies to this topic

#1 pbooth99

pbooth99

    Advanced Member

  • Members
  • PipPipPip
  • 45 posts

Posted 04 November 2017 - 09:03 AM

Hello,

 

There are many online databases that output data in the form of HTML tables.

One example would be the FreeReg query shown below. It's trivial to convert

this output to a CSV file. Is there a straightforward way to import this data into RootsMagic?

 

Peter

 

 

You searched for:
Last Name HARGREAVES Exact Match? Yes Record Type Marriage Start Year 1780 End Year 1790 County Lancashire Place Haslingden
54 Search ResultsSelect a heading to sort results on that column.
Each link in the Detail column opens a page with all the information we have for that record. Main participant(s) Record type Event date County Place : Church : Register type Detail Margaret HARGREAVES 
John HAWORTH Marriage 24 Jan 1780 Lancashire Haslingden : St James : Unspecified Row 1 Betty INGHAM 
Christopher HARGREAVES Marriage 22 Jun 1780 Lancashire Haslingden : St James : Unspecified Row 2 Ann ORMEROD 
John HARGREAVES Marriage 05 Aug 1780 Lancashire Haslingden : St James : Unspecified Row 3 Elizabeth HARGREAVES 
James TOMLINSON Marriage 15 Sep 1781 Lancashire Haslingden : St James : Unspecified Row 4 Alice HARGREAVES 
Abram DOBSON Marriage 09 Feb 1782 Lancashire Haslingden : St James : Unspecified Row 5 Mary HARGREAVES 
William LONSDALE Marriage 09 Mar 1782 Lancashire Haslingden : St James : Unspecified Row 6 Betty HARGREAVES 
John HARGREAVES Marriage 14 Mar 1782 Lancashire Haslingden : St James : Unspecified Row 7 Mary HARGREAVES 
James BARLOW Marriage 09 Apr 1782 Lancashire Haslingden : St James : Unspecified Row 8 Ann HEAP 
John HARGREAVES Marriage 27 Apr 1782 Lancashire Haslingden : St James : Unspecified Row 9 Alice GREENWOOD 
Thomas HARGREAVES Marriage 09 May 1782 Lancashire Haslingden : St James : Unspecified Row 10 Alice WILKINSON 
Henry HARGREAVES Marriage 17 Aug 1782 Lancashire Haslingden : St James : Unspecified Row 11 Mary ASHWORTH 
Ralph HARGREAVES Marriage 18 Aug 1782 Lancashire Haslingden : St James : Unspecified Row 12 Alice HAWORTH 
George HARGREAVES Marriage 26 Oct 1782 Lancashire Haslingden : St James : Unspecified Row 13 Susan LONSDALE 
Henry HARGREAVES Marriage 19 Dec 1782 Lancashire Haslingden : St James : Unspecified Row 14 Mary HARGREAVES 
Samuel BURGAS Marriage 27 Jan 1783 Lancashire Haslingden : St James : Unspecified Row 15 Alice DOBSON 
Robert HARGREAVES Marriage 24 May 1783 Lancashire Haslingden : St James : Unspecified Row 16 Ann HARGREAVES 
James WARBUTTON Marriage 06 Sep 1783 Lancashire Haslingden : St James : Unspecified Row 17 Sarah HOYLE 
James HARGREAVES Marriage 29 Jul 1784 Lancashire Haslingden : St James : Unspecified Row 18 Mary WILKINSON 
George HARGREAVES Marriage 14 Aug 1784 Lancashire Haslingden : St James : Unspecified Row 19 Alice HARGREAVES 
John WOODS Marriage 20 Sep 1784 Lancashire Haslingden : St James : Unspecified Row 20 Sarah HARGREAVES 
John HAWORTH Marriage 25 Nov 1784 Lancashire Haslingden : St James : Unspecified Row 21 Ann HARGREAVES 
Thomas HOLDEN Marriage 25 Dec 1784 Lancashire Haslingden : St James : Unspecified Row 22 Alice HARGREAVES 
George HOLDIN Marriage 08 Feb 1785 Lancashire Haslingden : St James : Unspecified Row 23 Betty ASHWORTH 
Richard HARGREAVES Marriage 12 Mar 1785 Lancashire Haslingden : St James : Unspecified Row 24 Ann HARGREAVES 
John HARGREAVES Marriage 26 Mar 1785 Lancashire Haslingden : St James : Unspecified Row 25 Martha HARGREAVES 
James CUNLIFFE Marriage 30 Jul 1785 Lancashire Haslingden : St James : Unspecified Row 26 Ellin HARGREAVES 
Henry DUCKWORTH Marriage 27 Aug 1785 Lancashire Haslingden : St James : Unspecified Row 27 Mary HAWORTH 
George HARGREAVES Marriage 22 Oct 1785 Lancashire Haslingden : St James : Unspecified Row 28 Ann HARGREAVES 
James DUCKWORTH Marriage 11 Feb 1786 Lancashire Haslingden : St James : Unspecified Row 29 Mary HARGREAVES 
Christopher WESTAL Marriage 04 Apr 1786 Lancashire Haslingden : St James : Unspecified Row 30 Alice PICKUP 
John HARGREAVES Marriage 18 May 1786 Lancashire Haslingden : St James : Unspecified Row 31 Betty HARGREAVES 
William BOOTHMAN Marriage 27 Aug 1786 Lancashire Haslingden : St James : Unspecified Row 32 Alice HARGREAVES 
Robert SUTCLIFFE Marriage 29 Aug 1786 Lancashire Haslingden : St James : Unspecified Row 33 Betty HARGREAVES 
George RISHTON Marriage 04 Sep 1786 Lancashire Haslingden : St James : Unspecified Row 34 Mary HARGREAVES 
John HAWORTH Marriage 10 Oct 1786 Lancashire Haslingden : St James : Unspecified Row 35 Mary ASHWORTH 
George HARGREAVES Marriage 03 Dec 1786 Lancashire Haslingden : St James : Unspecified Row 36 Ruth HARGREAVES 
John GREENWOOD Marriage 15 Jan 1787 Lancashire Haslingden : St James : Unspecified Row 37 Ellin HERD 
Ralph HARGREAVES Marriage 20 Feb 1787 Lancashire Haslingden : St James : Unspecified Row 38 Nancy HARGREAVES 
Robert WARBUTTON Marriage 22 Jul 1787 Lancashire Haslingden : St James : Unspecified Row 39 Alice HARGREAVES 
John BERRY Marriage 08 May 1788 Lancashire Haslingden : St James : Unspecified Row 40 Mary BARNS 
Thomas HARGREAVES Marriage 14 Jun 1788 Lancashire Haslingden : St James : Unspecified Row 41 Susan HARGREAVES 
Robert HOLDEN Marriage 27 Sep 1788 Lancashire Haslingden : St James : Unspecified Row 42 Ann WILLIS 
James HARGREAVES Marriage 31 Dec 1788 Lancashire Haslingden : St James : Unspecified Row 43 Alice HARGREAVES 
James NUTTALL Marriage 31 Jan 1789 Lancashire Haslingden : St James : Unspecified Row 44 Mary BARLOW 
Henry HARGREAVES Marriage 13 Apr 1789 Lancashire Haslingden : St James : Unspecified Row 45 Ann FENTO
Christopher HARGREAVES Marriage 26 Apr 1789 Lancashire Haslingden : St James : Unspecified Row 46 Nelly DUCKWORTH 
Thomas HARGREAVES Marriage 05 Nov 1789 Lancashire Haslingden : St James : Unspecified Row 47 Anne HARGREAVES 
John HEAP Marriage 05 Nov 1789 Lancashire Haslingden : St James : Unspecified Row 48 Alice HARGREAVES 
Andrew NUTTALL Marriage 19 Dec 1789 Lancashire Haslingden : St James : Unspecified Row 49 Mary HARGREAVES 
Thomas BARNS Marriage 19 Dec 1789 Lancashire Haslingden : St James : Unspecified Row 50 Mary LORD 
Thomas HARGREAVES Marriage 13 May 1790 Lancashire Haslingden : St James : Unspecified Row 51 Jenny HOYLE 
Richard HARGREAVES Marriage 12 Jun 1790 Lancashire Haslingden : St James : Unspecified Row 52 Isabel HAWORTH 
John HARGREAVES Marriage 21 Aug 1790 Lancashire Haslingden : St James : Unspecified Row 53 Peggy HARGREAVES 
John WOODS Marriage 11 Sep 1790 Lancashire Haslingden : St James : Unspecified Row 54

 



#2 TomH

TomH

    Advanced Member

  • Members
  • PipPipPip
  • 6255 posts

Posted 04 November 2017 - 11:17 AM

No straightforward way. You can import CSV into a spreadsheet. Then you could parse the data as needed and transform it into GEDCOM for import into RM or transform it into tables that could be imported into a SQLite database. The SQLite database might be a RootsMagic one or an intermediate one. That's the broad overview and sounds straightforward but the devil is in the details.

Tom user of RM7550 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com
SQLite_Tools_For_Roots_Magic_in_PR_Celti wiki, exploiting the database in special ways >>> RMtrix-tiny.png app, a bundle of RootsMagic utilities.


#3 Trebor22

Trebor22

    Advanced Member

  • Members
  • PipPipPip
  • 192 posts

Posted 06 November 2017 - 04:40 AM

It appears Gramps can import / export in .csv format - I've not tried  this feature - this might allow you to get csv into  gedcom format and then import that into RM? Back ups' first!!

 

see - https://www.gramps-p...port_and_Export



#4 TomH

TomH

    Advanced Member

  • Members
  • PipPipPip
  • 6255 posts

Posted 06 November 2017 - 08:24 AM

Good find, Trebor22. When I looked at Gramps some years ago, my interest collapsed because it crashed repeatedly. Sounds like it is time to look again.

Tom user of RM7550 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com
SQLite_Tools_For_Roots_Magic_in_PR_Celti wiki, exploiting the database in special ways >>> RMtrix-tiny.png app, a bundle of RootsMagic utilities.


#5 Jerry Bryan

Jerry Bryan

    Advanced Member

  • Members
  • PipPipPip
  • 3593 posts

Posted 06 November 2017 - 09:10 AM

Last time I looked at Gramps years ago, I didn't have any trouble with it crashing. But I found it too spartan - too lacking in features that I needed. But this is a super feature.

 

Potentially, I could create a spreadsheet with genealogical data, export the data as csv, import into Gramps, export into GEDCOM, import into RM. The process sounds convoluted but potentially it could save an enormous amount of data entry time. This especially would be true if the genealogical data in question was already in electronic format of some kind or if it could be OCR'd. But even if I had to do all the typing myself, typing data into a spreadsheet is oh so much faster than all the sub-windows and clickiness in the RM user interface.

 

Jerry



#6 Renee Zamora

Renee Zamora

    Advanced Member

  • Support
  • PipPipPip
  • 8474 posts

Posted 06 November 2017 - 04:03 PM

Vyger created a series of YouTube videos on Excel to GEDCOM.

 

https://www.youtube....enealogyReviews


Renee
RootsMagic

#7 keithcstone

keithcstone

    Advanced Member

  • Members
  • PipPipPip
  • 125 posts

Posted 07 November 2017 - 01:14 PM

I just noticed Reunion on the Mac has the capability to map fields in a CSV to fields and event types, so if you're a Mac user you could pull them in to a blank file, merge them, and export as GEDCOM to RootsMagic.

 

Gramps is free, but uses a fixed format.

 

I don't use Reunion for much anymore, but I find it's book generator nicer than RootsMagic and when I need to key some book info in to create a GEDCOM it's faster.