Author Person
Cecilia's Author-Person wiki
Script upgradet 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)