# Makefile to generate a list of unabbreviated words and a SQL script
# to load journal names to a RefDB database. Not officially part of
# RefDB due to the humongous size of the input and output files

all: journalwords.xml journalwords.sql serials.sql

journalwords.xml: lsi2008.xml
	xsltproc -nonet extractjournalwordsxml.xsl lsi2008.xml > journalwords.xml

journalwords.sql: lsi2008.xml
	xsltproc -nonet extractjournalwords.xsl lsi2008.xml|sort|uniq > journalwords.sql

lsi2008.xml:
	wget ftp://ftp.nlm.nih.gov/online/journals/lsi2008.xml

serials.sql: lsi2008.xml journalwords.xml
	xsltproc -nonet extractserial.xsl lsi2008.xml > serials.sql

clean:
	rm -f journalwords.xml journalwords.sql serials.sql
