Difference between revisions of "Adding Papers not in PubMed"
(4 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
+ | '''Question:''' When papers are entered manually, is there a script that associates the paper with genes mentioned in the abstract? | ||
+ | |||
+ | '''To Do:''' Get a diff list of journals indexed by PubMed and Web of Science to focus W of S searches. | ||
+ | |||
New paper information can be entered through the paper editor, but you have to create the paper (i.e. get a WBPaper ID) through postgres first. | New paper information can be entered through the paper editor, but you have to create the paper (i.e. get a WBPaper ID) through postgres first. | ||
To do this, you will need to login to tazendra using the acedb account and access postgres with psql testdb. | To do this, you will need to login to tazendra using the acedb account and access postgres with psql testdb. | ||
− | 1.- Type SELECT * FROM | + | 1.- Type SELECT * FROM pap_status ORDER BY joinkey DESC; |
to find the highest wpa, then create the next one, e.g. 00035244 new one -> 00035245 | to find the highest wpa, then create the next one, e.g. 00035244 new one -> 00035245 | ||
Line 9: | Line 13: | ||
Type 'q' to get back to the command line. | Type 'q' to get back to the command line. | ||
− | 2.- INSERT INTO | + | 2.- INSERT INTO pap_status VALUES ('00035245', 'valid', NULL, 'two1'); |
(or two1843 for Kimberly) | (or two1843 for Kimberly) | ||
Line 42: | Line 46: | ||
To add authors, reload the page, click on Add Another Author and follow steps to add new authors. | To add authors, reload the page, click on Add Another Author and follow steps to add new authors. | ||
+ | |||
+ | |||
+ | [[Category:Curation]] |
Latest revision as of 19:37, 19 November 2010
Question: When papers are entered manually, is there a script that associates the paper with genes mentioned in the abstract?
To Do: Get a diff list of journals indexed by PubMed and Web of Science to focus W of S searches.
New paper information can be entered through the paper editor, but you have to create the paper (i.e. get a WBPaper ID) through postgres first.
To do this, you will need to login to tazendra using the acedb account and access postgres with psql testdb.
1.- Type SELECT * FROM pap_status ORDER BY joinkey DESC;
to find the highest wpa, then create the next one, e.g. 00035244 new one -> 00035245
Type 'q' to get back to the command line.
2.- INSERT INTO pap_status VALUES ('00035245', 'valid', NULL, 'two1');
(or two1843 for Kimberly)
When done, enter control d or /g to finish the session.
Then you can query that WBPaper on the paper editor to enter all the other information.
3.- Paper_editor
wpa_identified doi
wpa_title XXXXXXx valid update
wpa_publisher Wiley-VCH valid update
wpa_pages 227//250 valid update
wpa_year 2004 valid update
wpa_date_published October 2004 valid update
wpa_abstract (description) valid update
wpa_type BOOK-CHAPTER valid update
wpa_editor Erich A. Nigg valid update
wpa_in_book 00035208.2 (SAME # as the paper ADD .2 al final) valid update
Update info!
To add authors, reload the page, click on Add Another Author and follow steps to add new authors.