Author Person

From WormBaseWiki
Jump to navigationJump to search

Cecilia's Author-Person wiki

Script upgrade to catch more possible connections

        F M L and under regular name
        delete empty spaces beginning and end of the name
        keep empty space between names
        delete commas and periods
        change all letters to lower cases
        for middle name adds first initial
        delete two_status Invalid
        Por each Person each Last name  Each name (including initial)
        L F
        F L
        If middle name exist: algorithm
        L F M
        L FM
        F M L
        FM L

- for xml test program

   1. akas lower case
   2.  - For each author of each paper not verified YES search:
              Paper   auhor_id    Author_name
        - look for pap_identifier to get pmid/read XML
        - open

b.- Pubmed xml

        xtract:  <LastName>Pierce</LastName>
                   <ForeName>Sarah B</ForeName>
                   <Initials>SB</Initials>
        Construct exact name:
        two_firstname = ForeName
        two_middlename = blank
        two_lastname = LastName
        two_standardname = Forename + LastName
        two_aka_firstname = Initials
        two_aka_middlename = NULL
        two_aka_lastname = Forename
                  <Affiliation>Departments of Medicine (Medical

Genetics), Genome Sciences, Biological Structure, and Biochemistry, University of Washington, Seattle, WA 98195.</Affiliation>

  c- Tablas: Autocomplete, save clicking not reloading

show: WBPaper00039201 affiliation

124733 (Suda H) possible two3928 SENT 124734 (Sato K) 4possible NO match to F+L (xml) 124735 (Shimizu Y) 0possible

NEW PROPOSE TABLE: email separadamente as attachment excel document

tabla two: for reference two (auto populated by script) two_firstname (auto populated by script) two_middlename (manually added by Cecilia) two_lastname (auto populated by script) two_standardname (auto populated by script) two_street (manually added by Cecilia) two_city (manually added by Cecilia) two_state (manually added by Cecilia) two_postcode (manually added by Cecilia) two_country (manually added by Cecilia) two_instituion (manually added by Cecilia) two_old_institution (manually added by Cecilia) two_mainphone (manually added by Cecilia) two_officephone (manually added by Cecilia) two_labphone (manually added by Cecilia) two_otherphone (manually added by Cecilia) two_fax (manually added by Cecilia) two_email (manually added by Cecilia) two_old_email (manually added by Cecilia) two_pis (manually added by Cecilia) two_lab (manually added by Cecilia) two_oldlab (manually added by Cecilia) two_left_field (manually added by Cecilia) two_unable_to_contact (manually added by Cecilia) two_privacy (manually added by Cecilia) two_aka_firstname (auto populated by script) two_aka_middlename (auto populated by script) two_aka_lastname (auto populated by script) two_webpage (manually added by Cecilia) two_wormbase_comment (ENTER WBPaper#) two_hide (manually added by Cecilia) two_status (auto populated by script) two_mergedinto (manually added by Cecilia) two_acqmerge (manually added by Cecilia) two_comment (manually added by Cecilia)