Data extraction 1

1 - Access <SITE>/[login to view URL]<PID>&lng=es <SITE> AND <PID> from table [login to view URL] 2 - Click each link in column "number" in the table 3 - In this page there are a list of articles, essays and research notes 4 - Get the title of them above authors names and save in column title in file [login to view URL] 5 - Click in the link text in (english, or spanish or portuguese) bellow authors names. 6 - Get author names and save in column author in file scielo.xlsx. When there are more than 1 author, repeat the title of article in the column title You can get the authors names in the first page too 7 - Get author email and save in column email. The emails are bellow all authors names. After the authors name there are a superscript number, the authors email is in the list bellow after the same number 8 - Get author institution and save in column institution. The institution is all the text besides the email after the authors number. Some different authors have the same number, then you will get the same institution and email. 9 -In the first column PID you save the pid used to access the first link