Thread: Bibtex
View Single Post
Old 02-16-2023, 02:47 AM   #24
erymaxuk
Member
erymaxuk began at the beginning.
 
Posts: 18
Karma: 10
Join Date: Nov 2018
Location: Thailand
Device: jlalik14@gmail.com
scientific articles and xml

Quote:
Originally Posted by ProfElm View Post
Debbie, thank you so much! I changed a few things that you recommended and tweaked some minor things.

My main question now is: What should go under the .xml files section?

If we can get a way to parse through a documents first few pages for the isbn, that would be epic.

I have also added screenshots and completed the .xml section. Is there anything else that should be added? When can this be incorporated into the manual?
If you are collecting academic articles, you should be aware of the new standard of publishing articles in xml formate. The NLM and PubMed has millions of articles in DTD JATS xml formate. They have to be transformed with xslt processor such as Saxon ( I use it). The xml file can be transformed in bib, html or other format. I have many articles and books using mssql database. Calibre is an excellent database for eboks, pdf and other formats but you cannot import JATS xml files into calibre. My process flow is following:
download DTD xml files from NLM ftp sites daily. Transform them with Saxon to bib files using jatstobib.xslt. Import all (ususaly 15000) into Mendeley which will update the metadata. Export them as one bib file which I import in Zotero. From there export as csv file and load in excel. The excel file can be easily imported into mssql database and process with Visual studio. (Window Forms in C#)

I also download books and articles as pdf. Import them into Zotero and update metadata, export as csv file, import with zotero importer plugin into calibre. Create in calibre searchable tags and covers. Creating catalog using the command line as csv and load it in excel (same way to mssql).

If you want to know more please contact me.
erymaxuk is offline   Reply With Quote