GitHub - lupin7/XML-Project

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 1 Commit
css		css
test		test
xalan		xalan
xml		xml
Estrada, Marc XML Project Self-eval.docx		Estrada, Marc XML Project Self-eval.docx
README.txt		README.txt
Xalan.exe		Xalan.exe
data_transform.xsl		data_transform.xsl
mysql_log.txt		mysql_log.txt
mysqldump.txt		mysqldump.txt
sales.xsd		sales.xsd
salescript.sql		salescript.sql
sql.txt		sql.txt
start.bat		start.bat
transform.jse		transform.jse
transform_to_fo.xsl		transform_to_fo.xsl
transform_to_xhtml_amount.xsl		transform_to_xhtml_amount.xsl
transform_to_xhtml_date.xsl		transform_to_xhtml_date.xsl
transform_to_xhtml_salesperson.xsl		transform_to_xhtml_salesperson.xsl
validate.jse		validate.jse
xml_project.mwb.bak		xml_project.mwb.bak
xmlproj.txt		xmlproj.txt

Repository files navigation

Database Password: password

* You only need to provide the names of the output files, no need to provide an extension for the files

CODES BEING EXECUTED:
* mysqldump database to sale.xml
mysqldump -u root -p --xml project_schema sale > Documents\project\sale.xml

* transform xml dump to sale.xml accdg to schema
(-i 2 = line spaces; -o sales.xml = output file)
xalan -i 2 -o sales.xml sale.xml data_transform.xsl

* transform to xhtml 1 by descending amount
transform sales transform_to_xhtml_amount sales_by_amount xhtml
* transform to xhtml 1 by ascending salesperson
transform sales transform_to_xhtml_salesperson sales_by_salesperson xhtml
* transform to xhtml 1 by recent to old date
transform sales transform_to_xhtml_date sales_by_date xhtml

* transform xsl-fo to pdf, rtf, png
call fop -xml sales.xml -xsl transform_to_fo.xsl -pdf sales.pdf
call fop -xml sales.xml -xsl transform_to_fo.xsl -rtf sales.rtf
call fop -xml sales.xml -xsl transform_to_fo.xsl -png sales.png