Difference between revisions of "Person"
Line 83: | Line 83: | ||
Please confirm that no one uses this form | Please confirm that no one uses this form | ||
http://tazendra.caltech.edu/~azurebrd/cgi-bin/forms/confirm_paper.cgi | http://tazendra.caltech.edu/~azurebrd/cgi-bin/forms/confirm_paper.cgi | ||
− | In the last year 111 IPs have used it (mostly once) but a couple of them over 100 each. If you don't use it, is it in the emails you send out or in the submit forms in WormBase ? -- J answer Please keep form, must be the one linking to old papers associated but not verified -- Ceci '''Sounds good, added to list of forms to check -- J''' | + | In the last year 111 IPs have used it (mostly once) but a couple of them over 100 each. If you don't use it, is it in the emails you send out or in the submit forms in WormBase ? -- J answer Please keep form, must be the one linking to old papers associated but not verified -- Ceci '''Sounds good, added to list of forms to check -- J''' '''thanks ceci''' |
1681 two_middlename without value, is that okay ? | 1681 two_middlename without value, is that okay ? | ||
Line 91: | Line 91: | ||
SELECT * FROM two_middlename WHERE two_order IS NULL; | SELECT * FROM two_middlename WHERE two_order IS NULL; | ||
− | answer i've been adding aka_middlename = NULL to every aka entry, if it is not necessary them we can delete it, but if it is necessary please keep it. Talk tomorrow? Ceci. I am also fixing some typos showing searching in new Person editor Ceci '''I don't know if you need it to say 'NULL' or not, but I thought you were never supposed to have blank values, you can skype me whenever you want -- J''' | + | answer i've been adding aka_middlename = NULL to every aka entry, if it is not necessary them we can delete it, but if it is necessary please keep it. Talk tomorrow? Ceci. I am also fixing some typos showing searching in new Person editor Ceci '''I don't know if you need it to say 'NULL' or not, but I thought you were never supposed to have blank values, you can skype me whenever you want -- J''' '''will talk in person about all middle/aka names, empty values''' |
two427 had under wormbase_comment : | two427 had under wormbase_comment : | ||
Line 110: | Line 110: | ||
* old_institution shows old_inst_date data, and webpage shows usefulwebpage vertically because I assume you need more space, if you'd rather display them horizontally like old_email, let me know. answer OK ceci | * old_institution shows old_inst_date data, and webpage shows usefulwebpage vertically because I assume you need more space, if you'd rather display them horizontally like old_email, let me know. answer OK ceci | ||
− | * All changes to the person editing section of the person editor are done, please let me know if I overlooked something. answer looks ok, will look more in detail, thanks Juancarlos ceci Cool, let me know. Thanks -- J two_comment is missing ceci''' added - J''' | + | * All changes to the person editing section of the person editor are done, please let me know if I overlooked something. answer looks ok, will look more in detail, thanks Juancarlos ceci Cool, let me know. Thanks -- J two_comment is missing ceci''' added - J''' ''thanks, c''' |
− | * '''In the Search Paper (to create people from XML) section, do you want to see input fields to create new people for authors that are already verified 'YES' ? Right now people that are verified 'YES' have a grey background, if you don't want to see the inputs, do you still want the grey background ? Probably easier to talk about this in person / skype. Some papers I tried were 00003865 00026893 -- J''' | + | * '''In the Search Paper (to create people from XML) section, do you want to see input fields to create new people for authors that are already verified 'YES' ? Right now people that are verified 'YES' have a grey background, if you don't want to see the inputs, do you still want the grey background ? Probably easier to talk about this in person / skype. Some papers I tried were 00003865 00026893 -- J''' '''wow thanks, looks really great, will look in more detail. Yes talk in person, lots of new stuffs, when do you have time? I have to be in Pasadena on Friday, is that OK with you? I like the grey part. Paper 00026893 is showing aid77392 Davis J - xml Jerel C. Davis - 1 matches two4351 (Ralph E. Davis) -> Are matches to last names even when it doesn't match first initial or first name? ceci''' |
==To Do== | ==To Do== |
Revision as of 17:05, 17 May 2011
Contents
Form URL
http://mangolassi.caltech.edu/~postgres/cgi-bin/cecilia/person_editor.cgi (sandbox for testing)
New postgreSQL Tables
table 'two' does not have history, only has joinkey (two#), two value (integer), two_timestamp (timestamp)
all other tables have joinkey (two#), two_order (integer), two_
(data -- text), two_curator (two# -- text), two_timestamp (timestamp) :- two_firstname
- two_middlename
- two_lastname
- two_standardname
- two_street
- two_city
- two_state
- two_post
- two_country
- two_institution
- two_old_institution
- two_old_inst_date
- two_mainphone
- two_labphone
- two_officephone
- two_otherphone
- two_fax
- two_email
- two_old_email
- two_old_email_date
- two_pis
- two_lab
- two_oldlab
- two_left_field
- two_unable_to_contact
- two_privacy
- two_aka_firstname
- two_aka_middlename
- two_aka_lastname
- two_webpage
- two_wormbase_comment
- two_hide
- two_status
- two_mergedinto
- two_acqmerge
- two_comment
- two_usefulwebpage
What is this section for ?
Current tables: These are forms, not tables, and aren't these the ones listed below under Todo for changing ? -- J http://tazendra.caltech.edu/~azurebrd/cgi-bin/forms/confirm_paper.cgi http://tazendra.caltech.edu/~postgres/cgi-bin/cecilia/two_display.cgi http://tazendra.caltech.edu/~postgres/cgi-bin/cecilia/twoeditor.cgi http://tazendra.caltech.edu/~azurebrd/cgi-bin/forms/paper_display.cgi http://tazendra.caltech.edu/~postgres/cgi-bin/paper_editor.cgi? http://tazendra.caltech.edu/~azurebrd/cgi-bin/forms/person.cgi http://tazendra.caltech.edu/~azurebrd/cgi-bin/forms/person_lineage.cgi
Para asociar a single match: You're missing /home/ in the first three, and the / in the last one -- J cecilia/work/UPLOAD/new-upload ./connect_single_match_authors_and_get_histogram.pl
Verificar papeles by labs and lineage cecilia/work/UPLOAD/new-upload ./verify_by_labs_or_lineage.pl
Email Persons for verification cecilia/work/UPLOAD/new-upload ./email_connected_authors.pl
Para upload acedb: home/acedb/cecilia/citace_upload/ ./get_pap_person_ace.pl > persons.ace
Changes between old and new tables
- Adding history tables as h_two_...
- Removing two_apu_ tables, two_groups
- Adding two_usefulwebpage, two_old_inst_date, two_old_email_date
- Changing two_comment into normal table with order
- Changing old_timestamp column to two_curator (all values will be 'two1')
Questions
Please confirm that no one uses this form http://tazendra.caltech.edu/~azurebrd/cgi-bin/forms/confirm_paper.cgi In the last year 111 IPs have used it (mostly once) but a couple of them over 100 each. If you don't use it, is it in the emails you send out or in the submit forms in WormBase ? -- J answer Please keep form, must be the one linking to old papers associated but not verified -- Ceci Sounds good, added to list of forms to check -- J thanks ceci
1681 two_middlename without value, is that okay ? SELECT * FROM two_middlename WHERE two_middlename = ' '; <-- no space in between the singlequotes --J answer It was from when we thoght that a data was needed in tag, please delete if not needed -- Ceci.
1004 two_middlename with NULL order, value, old_timestamp, what should we do with that ? SELECT * FROM two_middlename WHERE two_order IS NULL;
answer i've been adding aka_middlename = NULL to every aka entry, if it is not necessary them we can delete it, but if it is necessary please keep it. Talk tomorrow? Ceci. I am also fixing some typos showing searching in new Person editor Ceci I don't know if you need it to say 'NULL' or not, but I thought you were never supposed to have blank values, you can skype me whenever you want -- J will talk in person about all middle/aka names, empty values
two427 had under wormbase_comment :
- two427 | 1 | Due to illness, please get in touch with: Mark Edgley (edgley@interchange.ubc.ca) for gene knockout inquiries. Teresa Rogalski (rogalski@zoology.ubc.ca) for muscle lab matters. 2003-03-07 18:36:25.089309-08 | 2003-03-19 11:38:57.295736-08 |
- two427 | 1 | Lab:DM or VC | 2003-03-10 16:23:56.877045-08 | 2003-03-19 11:38:57.295736-08
- two427 | 2 | DM his own lab and VC head of the KO | 2008-01-31 00:00:00-08 | 2008-01-30 10:04:25.884154-08
Which has two order '1', I've deleted the first one, if you want to add it again as order '3' -- J. answer Deleted OK, thanks Ceci
Please comment on these changes :
- I've added history tables, and changed the postgres tables to store the curator in the 4th column where the old_timestamp used to be. Updating data updates the data table with current timestamp ; removes any history data for that table-joinkey-order in the last 10 minutes, and inserts with current timestamp. answer OK Ceci
- Street field always has at least 4 fields. answer YES ceci
- name and aka_name now show first/middle/last in a row with timestamp below them. answer Like it Ceci
- old_email shows data from old_email_date horizontally with timestamp. answer OK ceci
- old_institution shows old_inst_date data, and webpage shows usefulwebpage vertically because I assume you need more space, if you'd rather display them horizontally like old_email, let me know. answer OK ceci
- All changes to the person editing section of the person editor are done, please let me know if I overlooked something. answer looks ok, will look more in detail, thanks Juancarlos ceci Cool, let me know. Thanks -- J two_comment is missing ceci added - J' thanks, c
- In the Search Paper (to create people from XML) section, do you want to see input fields to create new people for authors that are already verified 'YES' ? Right now people that are verified 'YES' have a grey background, if you don't want to see the inputs, do you still want the grey background ? Probably easier to talk about this in person / skype. Some papers I tried were 00003865 00026893 -- J wow thanks, looks really great, will look in more detail. Yes talk in person, lots of new stuffs, when do you have time? I have to be in Pasadena on Friday, is that OK with you? I like the grey part. Paper 00026893 is showing aid77392 Davis J - xml Jerel C. Davis - 1 matches two4351 (Ralph E. Davis) -> Are matches to last names even when it doesn't match first initial or first name? ceci
To Do
Check these forms / scripts :
- /home/postgres/public_html/cgi-bin/cecilia/two_display.cgi
- /home/postgres/public_html/cgi-bin/cecilia/twoeditor.cgi
- /home/postgres/public_html/cgi-bin/paper_editor.cgi
- /home/postgres/work/get_stuff/for_paul/curation_stats/wbperson_creation_stats/get_recent.pl
- /home/azurebrd/public_html/cgi-bin/forms/paper_display.cgi
- /home/azurebrd/public_html/cgi-bin/forms/person.cgi
- /home/azurebrd/public_html/cgi-bin/forms/person_lineage.cgi
- /home/azurebrd/public_html/cgi-bin/forms/confirm_paper.cgi
- /home/azurebrd/work/parsings/authorperson/citaceLineage/update_twos_in_two_lineage.pl
- /home/cecilia/UPLOAD/new-upload/connect_single_match_authors_and_get_histogram.pl
- /home/cecilia/UPLOAD/new-upload/verify_by_labs_or_lineage.pl
- /home/cecilia/UPLOAD/new-upload/email_connected_authors.pl
- /home/cecilia/work/gaps_in_twos/get_recent.pl
- /home/acedb/cecilia/citace_upload/get_pap_person_ace.pl
Work in progress c Paper - Person track
I'd like to have: Showing only: papers flagged from Person curation by Kimberly. Ignore: For funtional annotations only, Invalid papers
WBPaper00000000 identifier link_to_paper_editor curated What's curated ? -- J