Is this the link that takes to genealogical research? On Tuesday, April 21, 2015 at 12:04:29 PM UTC-4, Richard wrote: > > And what about just using Gramps (https://gramps-project.org/features/)?? > > Richard > > On Tue, Apr 21, 2015 at 2:08 AM, John <jhnp...@gmail.com <javascript:>> > wrote: > >> New to programming and web2py. Been dabbling in web design for a while, >> building sites with wordpress, plugging things in. My first real project >> will be a site/app for my sister. Genealogical resources. Lots of records >> that will need to be added via csv and also via forms. Will also need to be >> displayed in sortable grid/table format and will need advanced search >> capabilities. These records will be things like births, deaths, marriages >> etc and would have anywhere from 10-20 fields for things like; surname | >> given name(s) | DOB | State | County | City/Town | Father surname | father >> given name | mother surname | mother given name | source. >> On the site, people would most likely browse by clicking a State, then >> the County and then Birth records at which point they would see the >> sortable grid/table with all birth records for that County, State. >> Else they would go to an advanced search page where they would choose the >> record type from a drop down, State from a drop down which would then >> populate a drop down for Counties of the chosen State. A choice for all >> States/Counties would be nice. Names, they would type in. DOB could be >> typed in as well though it would be nice if they could choose a date or >> date range. Some records may only have a partial date like maybe just the >> year. >> Each record type will have all the same fields of course so it only makes >> sense to have a table for each. There will be approx 20-30 different record >> types. I thought about individual tables for each record type for each >> state but that would be 51 tables(50 States plus DC) times however many >> record types there ends up being so 1000-1500 tables. Seems like too many. >> I'm in no rush and realize I have a lot of work to do and a lot to learn. >> At some point this site will hopefully become a community based site so >> membership and permissions will be needed. A forum would be nice but I >> haven't seen anything regarding that in the documentation yet. But first >> and foremost is the data records. I've read that each application gets it's >> own database so I'm thinking my first/main app would be *Records* with >> db tables for births, deaths, marriages etc. Am I correct in thinking that >> a table for each record type would be best and to not break it down by >> State but rather make State a field/column? Then again, when/if we end up >> with lots of records, that would be a lot of rows considering the number of >> births in the USA over a period of a few centuries. >> >> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to web2py+un...@googlegroups.com <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > >
-- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
