Difference between revisions of "Person"

From WormBaseWiki
Jump to navigationJump to search
Line 57: Line 57:
 
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 ?
+
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
−
 
 
−
  '''answer Please keep form, must be the one linking to old papers associated but not verified Ceci'''
 
  
 
1681 two_middlename without value, is that okay ?
 
1681 two_middlename without value, is that okay ?
−
SELECT * FROM two_middlename WHERE two_middlename = ' ';  <-- no space in between the singlequotes
+
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.
−
 
 
−
  '''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 ?
 
1004 two_middlename with NULL order, value, old_timestamp, what should we do with that ?
 
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
−
  '''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'''
−
  '''I am also fixing some typos showing searching in new Person editor Ceci'''
 
  
 
two427 had under wormbase_comment :
 
two427 had under wormbase_comment :
Line 76: Line 71:
 
* two427  |        1 | Lab:DM or VC | 2003-03-10 16:23:56.877045-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
 
* 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'
+
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
−
 
 
−
  '''answer Deleted OK, thanks Ceci'''
 
  
 
Please comment on these changes :
 
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.
+
* 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
−
 
 
−
'''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.
+
* Street field always has at least 4 fields. answer YES ceci
  
−
'''answer OK ceci'''
+
* name and aka_name now show first/middle/last in a row with timestamp below them. answer Like it 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'''
+
* old_email shows data from old_email_date horizontally with timestamp. answer OK ceci
  
−
* All changes to the person editing section of the person editor are done, please let me know if I overlooked something.
+
* 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
  
−
'''answer looks ok, will look more in detail, thanks Juancarlos 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'''
  
 
==To Do==
 
==To Do==

Revision as of 18:21, 16 May 2011

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

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

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

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

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/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/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
Retrieved from "https://wiki.wormbase.org/index.php?title=Person&oldid=10499"