Faculty Publications Management

28th May 2016 - reCsveditor good tool for large csv files

Wanted to get data based on charts for NCL Publications. Since WOS does not allow to download more than 500 records initially downloaded all data in csv format and then tried to club together all data in csv but one of the major challenge was libreoffice as well as gnumeric does not handle large size of csv data. Spent lot of time on figuring out how to get filtered data from a large size of csv data. After spending 2 days of work found one very good csv editor which handles large csv files name of the editor is "reCsved" this editor was found very useful and could gather lot of filter data from large csv file such as yearly number of publications, publications by division etc. Thanks to this very good editor which could handle more than 5000 records at a time.

18th March 2016

For last few months working on getting WebofScience exported csv file data into Drupal to manage faculty publications automatically with Feeds Module available in Drupal. Drupal has a very good Feeds module and Feeds Tamper module which allow to import any csv file data to drupal.

I tried it and it worked but still has few doubts about getting fully drupal into action. I created in drupal Content Type as "Faculty Publications" and added fields as Authors, Title, Publisher, Journal, Year, Keywords, DOI, FullText, Affiliation, Pages, Volume, Issue, URL link etc. I was trying to set up one content type as Authors, Publishers, Keywords etc. and then tried to bring those content types using "Entity Reference" but when this option was set Feeds does not bring any data. May be I am missing something which is why data is remaining blank after import. Need to get some help on this.

22nd December 2014

Today created virtual machine of ubuntu 14.04.01 and several time tried installation of Eprints but it was throwing error of NameVirtual host entry not available in apache. I was thinking because of port number it is giving any error. Tried several times installation of Eprints on latest ubuntu but it failed. After searching on Net found that Eprints yet does not work with latest ubuntu. This is again a major issue.

I then tried to create ubuntu 12.04.05 64bit.iso with vmplayer. Installed Eprints on ubuntu 12.04 and Eprints worked. I then wanted to check whether webofscience bibtex records can be imported in Eprints. The import does not work properly. It did not bring records properly. Import/Export in digital library software is a major factor which should work easily.

11th November - 23rd  November 2014

Continously worked on learning how to manage publications of faculty members with automated tools such as Web of Science. There were lot of issues observed while managing and maintaining publications generated by Web of Science.

The following tools were found and useful to maintain publications:-

1. Tellico

2. Drupal (Drupal Biblio Module)

3. Open Office

Tellico is a good application to import/export  data in a variety of formats. Drupal also helps to maintain in large extent importing/exporting data. Only records generated from "Web of Science" in bibtex format didnot import "affiliation field" in biblio module. Zotero was also explored but realised that bibtex records if imported into Zotero it does not pick up affiliation. I wanted to have affiliation where "reprint author" is mentioned so that we could contact each "reprint author" to get full texts of their final versions of manuscripts.

10th-11th November 2014

Tried to save webofscience records as tab-windows text file and then imported those records in openoffice and then tried import in drupal. This worked. But again struggled a lot with one or two records from webofcience due to which i could not create csv file of one lot. This took lot of time to figure out.

7th-8th- November 2014

Was struggling to ge t web of science data into drupal. Web of Science when I gave search on organization and then year it was allowing to only save first 500 records. I tried to get bibtex file and then converted that bibtex file into csv using Tellico tool. But this csv file didnot work for feeds data import in drupal.

6th November 2014

My struggle for using publications module was still continuing. Today while reading on google realised that biblio module can help to work fine if I make following change in the following file so that I can easily get most of the pub lications where I have DOI available for articles. Made following change and it allowed me to get articles data easily just with doi and it was very consistent. The following change needed to be made for the error

First in biblio settings in crossref add your email address then change following to get rid of following error

"HTTP error: 400 when trying to contact crossref.org for XML input"

In the Biblio file, ...site/all/modules/biblio/modules/crossref/biblio.crossref.client.php, in the function called fetch, you have to make the following change:

FROM: $request_options = array('method' => 'POST');

TO: $request_options = array('method' => 'GET');

5th November 2014

Installed dspace-cris but it threw 'internal server error' while using cris-module in webui.

4th November 2014 - Trying to install dspace-cris on liblive vmplayer. Spent lot of time on running mvn package but then realised that it needs maven3 hence downloaded maven3, uninstalled maven2 and gave link to maven3 in sudo ln -s /usr/local/apache-maven-3.2.3/bin/mvn /usr/bin/mvn and added maven paths in /etc/profile file and then mvn package worked

export M2_HOME=/usr/local/apache-maven-3.2.3

export M2=$M2_HOME/bin

export PATH=$M2:$PATH

27th October - 3rd November 2014

Worked on Drupal to see how manage publications. Basically I had an objective that I should be able to import bulk data from webofscience or scifinder with format such as bibtex/marc/ris. Bibtex was not easy as it was showing {{ extra opening/closing brackets. hence removed extra { bracket and then tried to import records from webofscience into local drupal installation in Biblio. It then worked but views was not showing all authors as linked authors. So there was a limitation in Biblio. I also tried "Open Publication" but the installation was not successful. I also tried to create a simple database of publication in drupal but was worrying about adding several authors, their affiliations, other details and then linking those authors and looking at how to imort those authors in drupal.