Keskustelu: Nettisivujen teko: Dataa MySQL:ään

Miten tällaista dataa saa siirrettyä mysliin ?
Eli nollasta alkaa aina uusi henkilö.

0 @IZW25-5L@ INDI
1 NAME Simon Simonson /TAPIO/
2 GIVN Simon Simonson
2 SURN TAPIO
1 AFN ZW25-5L
1 SEX M
1 SOUR @S01@
1 BIRT
2 DATE 1 Jan 1755
2 PLAC Soder Ija, Oulu County, Finland
1 DEAT
2 DATE 16 Dec 1818
2 PLAC
1 FAMS @F7321628@
1 FAMC @F7321232@
0 @IZW25-6R@ INDI
1 NAME Maria Hendrictytar //
2 GIVN Maria Hendrictytar
2 SURN
1 AFN ZW25-6R
1 SEX F
1 SOUR @S01@
1 BIRT
2 DATE 18 Mar 1857
2 PLAC <Soder Ija, Oulu County, Finland>
1 FAMS @F7321628@
0 @IZW25-7X@ INDI
1 NAME Henric Simonpoika /TAPIO/
2 GIVN Henric Simonpoika
2 SURN TAPIO
1 AFN ZW25-7X
1 SEX M
1 SOUR @S01@
1 BIRT
2 DATE 21 Jan 1782
2 PLAC Yli-Ii, Oulu Co., Finland
1 FAMC @F7321628@
0 @IZW26-KS@ INDI
1 NAME Anna Simontytar /TAPIO/
2 GIVN Anna Simontytar
2 SURN TAPIO
1 AFN ZW26-KS
1 SEX F
1 SOUR @S01@
1 BIRT
2 DATE 18 Aug 1784
2 PLAC <Yli-Ii, Oulu Co., Finland>
1 FAMC @F7321628@
0 @IZW25-CM@ INDI
1 NAME Simon Simonpoika /TAPIO/
2 GIVN Simon Simonpoika
2 SURN TAPIO
1 AFN ZW25-CM
1 SEX M
1 SOUR @S01@
1 BIRT
2 DATE 11 Feb 1787
2 PLAC Yli-Ii, Oulu Co, Finland
1 FAMC @F7321628@
0 @IZW25-BG@ INDI
1 NAME Margareta Simontytar /TAPIO/
2 GIVN Margareta Simontytar
2 SURN TAPIO
1 AFN ZW25-BG
1 SEX F
1 SOUR @S01@
1 BIRT
2 DATE 4 Jun 1791
2 PLAC Yli-Ii, Oulu Co, Finland
1 FAMC @F7321628@
0 @F7321628@ FAM
1 HUSB @IZW25-5L@
1 WIFE @IZW25-6R@
1 CHIL @IZW25-7X@
1 CHIL @IZW26-KS@
1 CHIL @IZW25-CM@
1 CHIL @IZW25-BG@
0 @IZW06-V5@ INDI
1 NAME Simon Simonpoika /TAPIO/
2 GIVN Simon Simonpoika
2 SURN TAPIO
1 AFN ZW06-V5
1 SEX M
1 SOUR @S01@
1 BIRT
2 DATE 20 Sep 1724
2 PLAC Soder Ija, Oulu Co., Finland
1 DEAT
2 DATE 30 Dec 1785
2 PLAC Soder Ija, Oulu Co., Finland
1 FAMS @F7321232@
1 FAMC @F7321233@
0 @IZW06-DQ@ INDI
1 NAME Anna Sigfridsdotter /KORVALA/
2 GIVN Anna Sigfridsdotter
2 SURN KORVALA
1 AFN ZW06-DQ
1 SEX F
1 SOUR @S01@
1 BIRT
2 DATE 2 Dec 1727
2 PLAC Ij, Oulu County, Finland
1 FAMS @F7321232@
1 FAMC @F12779203@
0 @IZW06-G3@ INDI
1 NAME Sigfrid Simonson /TAPIO/
2 GIVN Sigfrid Simonson
2 SURN TAPIO
1 AFN ZW06-G3
1 SEX M
1 SOUR @S01@
1 BIRT
2 DATE 6 Oct 1753
2 PLAC Soder Ija, Oulu County, Finland
1 FAMC @F7321232@
0 @IZW06-FW@ INDI
1 NAME Anna Simonsdotter /TAPIO/
2 GIVN Anna Simonsdotter
2 SURN TAPIO
1 AFN ZW06-FW
1 SEX F
1 SOUR @S01@
1 BIRT
2 DATE 22 Feb 1752
2 PLAC Soder Ija, Oulu County, Finland
1 DEAT
2 DATE 1 Feb 1758
2 PLAC Yli-Ii
1 FAMC @F7321232@
0 @IZW06-KL@ INDI
1 NAME Elizabeth Simonsdotter /TAPIO/
2 GIVN Elizabeth Simonsdotter
2 SURN TAPIO
1 AFN ZW06-KL
1 SEX F
1 SOUR @S01@
1 BIRT
2 DATE 15 May 1756
2 PLAC Soder Ija, Oulu County, Finland
1 FAMC @F7321232@
0 @IZW06-LR@ INDI
1 NAME Margareta Simonsdotter /TAPIO/
2 GIVN Margareta Simonsdotter
2 SURN TAPIO
1 AFN ZW06-LR
1 SEX F
1 SOUR @S01@
1 BIRT
2 DATE 16 Feb 1758
2 PLAC Soder Ija, Oulu County, Finland
1 FAMC @F7321232@
0 @IZW06-MX@ INDI
1 NAME Catharina Simonsdotter /TAPIO/
2 GIVN Catharina Simonsdotter
2 SURN TAPIO
1 AFN ZW06-MX
1 SEX F
1 SOUR @S01@
1 BIRT
2 DATE 2 Jan 1760
2 PLAC Soder Ija, Oulu County, Finland
1 FAMC @F7321232@
0 @IZW06-N4@ INDI
1 NAME Anna Simonsdotter /TAPIO/
2 GIVN Anna Simonsdotter
2 SURN TAPIO
1 AFN ZW06-N4
1 SEX F
1 SOUR @S01@
1 BIRT
2 DATE 22 Jun 1761
2 PLAC Soder Ija, Oulu County, Finland
1 DEAT
2 DATE 29 Sep 1762
2 PLAC Yli-Ii, , Finland
1 FAMC @F7321232@
0 @IZW06-P9@ INDI
1 NAME Maria Simonsdotter /TAPIO/
2 GIVN Maria Simonsdotter
2 SURN TAPIO
1 AFN ZW06-P9
1 SEX F
1 SOUR @S01@
1 BIRT
2 DATE 15 Dec 1762
2 PLAC Soder Ija, Oulu County, Finland
1 FAMC @F7321232@
0 @IZW06-H8@ INDI
1 NAME (Infant) /TAPIO/
2 GIVN (Infant)
2 SURN TAPIO
1 AFN ZW06-H8
1 SEX M
1 SOUR @S01@
1 BIRT
2 DATE 22 Jan 1754
2 PLAC Yli-Ii, , Finland
1 DEAT
2 DATE 24 Jan 1757
2 PLAC Yli-Ii, , Finland
1 FAMC @F7321232@
0 @F7321232@ FAM
1 HUSB @IZW06-V5@
1 WIFE @IZW06-DQ@
1 CHIL @IZW06-G3@
1 CHIL @IZW06-FW@
1 CHIL @IZW06-KL@
1 CHIL @IZW25-5L@
1 CHIL @IZW06-LR@
1 CHIL @IZW06-MX@
1 CHIL @IZW06-N4@
1 CHIL @IZW06-P9@
1 CHIL @IZW06-H8@
1 MARR
2 DATE 19 Apr 1751
2 PLAC Soder Ija, Oulu County, Finland
0 @IZW06-QG@ INDI
1 NAME Simon Mattson /KAIKKONEN/
2 GIVN Simon Mattson
2 SURN KAIKKONEN
1 AFN ZW06-QG
1 SEX M
1 SOUR @S01@
1 BIRT
2 DATE 25 Feb 1683
2 PLAC Ij, Oulu County, Finland
1 FAMS @F7321233@
0 @IZW06-RM@ INDI
1 NAME Anna Bertilsdotter /MERILAINEN/
2 GIVN Anna Bertilsdotter
2 SURN MERILAINEN
1 AFN ZW06-RM
1 SEX F
1 SOUR @S01@
1 BIRT
2 DATE 9 May 1686
2 PLAC Soder Ija, Oulu County, Finland
1 DEAT
2 DATE 27 Apr 1767
2 PLAC Soder Ija, Oulu County, Finland
1 FAMS @F7321233@
0 @IZW06-SS@ INDI
1 NAME Elizabeth Simonsdotter /KAIKKONEN/
2 GIVN Elizabeth Simonsdotter
2 SURN KAIKKONEN
1 AFN ZW06-SS
1 SEX F
1 SOUR @S01@
1 BIRT
2 DATE 16 Feb 1718
2 PLAC Soder Ija, Oulu County, Finland
1 FAMC @F7321233@
0 @IZW06-T0@ INDI
1 NAME Anna Simonsdotter /KAIKKONEN/
2 GIVN Anna Simonsdotter
2 SURN KAIKKONEN
1 AFN ZW06-T0
1 SEX F
1 SOUR @S01@
1 BIRT
2 DATE 3 Mar 1721
2 PLAC Soder Ija, Oulu County, Finland
1 FAMC @F7321233@
0 @IZW25-38@ INDI
1 NAME Anders Simonson /TAPIO/
2 GIVN Anders Simonson
2 SURN TAPIO
1 AFN ZW25-38
1 SEX M
1 SOUR @S01@
1 BIRT
2 DATE 5 Oct 1726
2 PLAC Soder Ija, Oulu County, Finland
1 DEAT
2 DATE 6 Mar 1789
2 PLAC
1 FAMC @F7321233@
0 @IZW06-XH@ INDI
1 NAME Johannes Simonson /TAPIO/
2 GIVN Johannes Simonson
2 SURN TAPIO
1 AFN ZW06-XH
1 SEX M
1 SOUR @S01@
1 BIRT
2 DATE 3 Jun 1730
2 PLAC Soder Ija, Oulu County, Finland
1 FAMC @F7321233@
0 @F7321233@ FAM
1 HUSB @IZW06-QG@
1 WIFE @IZW06-RM@
1 CHIL @IZW06-V5@
1 CHIL @IZW06-SS@
1 CHIL @IZW06-T0@
1 CHIL @IZW25-38@
1 CHIL @IZW06-XH@
0 @I20RJ-3M3@ INDI
1 NAME Sigfrid /KORVALA/
2 GIVN Sigfrid
2 SURN KORVALA
1 AFN 20RJ-3M3
1 SEX M
1 SOUR @S01@
1 BIRT
2 DATE 17 Feb 1690
2 PLAC <Ii, Oulu, Finland>
1 FAMS @F12779203@
0 @I20RJ-3N9@ INDI
1 NAME Anna /HENRIKSDR/
2 GIVN Anna
2 SURN HENRIKSDR
1 AFN 20RJ-3N9
1 SEX F
1 SOUR @S01@
1 BIRT
2 DATE ABT 1705
2 PLAC <Ii, Oulu, Finland>
1 FAMS @F12779203@
0 TRLR