Difference between revisions of "Adding Papers not in PubMed"

From WormBaseWiki
Jump to navigationJump to search
Line 18: Line 18:
  
 
3.- Paper_editor
 
3.- Paper_editor
 +
 +
wpa_identified  doi
  
 
wpa_title      XXXXXXx valid  update
 
wpa_title      XXXXXXx valid  update

Revision as of 14:05, 21 December 2009

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 wpa 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 wpa VALUES ('00035245', '35245', NULL, 'valid', '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!

Back to add another author and follow steps to add new authors.