cd /home/bien/svn # should happen automatically at login

Single datasource import:

	(Re)import and scrub: make inputs/<datasrc>/reimport_scrub by_col=1 &

	(Re)import only: make inputs/<datasrc>/reimport by_col=1 &

	Note that these commands also work if the datasource is not yet imported

Full database import:

	WARNING: You must perform *every single* step listed below, to avoid

		breaking column-based import

	On jupiter: svn up --force

	On local machine:

		do steps under Maintenance > "to synchronize vegbiendev, jupiter, and

		make backups/upload live=1

Datasource setup:

	Example steps for a datasource: wiki.vegpath.org/Import_process_for_Madidi

	umask ug=rwx,o= # prevent files from becoming web-accessible

	Add a new datasource: make inputs/<datasrc>/add

	to synchronize a Mac's settings with my testing machine's:

		download:

			WARNING: this will overwrite all your user's settings!

			overwrite=1 swap=1 sync_local_dir=~/Library/ sync_remote_subdir=Library/ bin/sync_upload --exclude="/Saved Application State"

				then rerun with l=1 ...

		upload:

				overwrite=1      sync_local_dir=~              sync_remote_subdir=             bin/sync_upload ~/"VirtualBox VMs/**"

					then rerun with l=1 ...

	to backup files not in Time Machine:

		pg_ctl. stop # stop the PostgreSQL server

		src=/ dest=/Volumes/Time\ Machine\ Backups/ sudo -E put Library/PostgreSQL/9.1/data/

			then rerun with l=1 ...

		Regularly, or whenever the VegCore data dictionary page

			(https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegCore)

			is changed, regenerate mappings/VegCore.csv:

			make mappings/VegCore.htm-remake; make mappings/

			svn di mappings/VegCore.tables.redmine

			If there are changes, update the data dictionary's Tables section

Backups:

	Archived imports:

		Back up: make backups/<version>.backup &

			Note: To back up the last import, you must archive it first:

				make schemas/rotate

		Remove: make backups/<version>.backup/remove

		Download: make backups/<version>.backup/download

	TNRS cache:

		Back up: make backups/TNRS.backup-remake &

			runtime: 3 min ("real 2m48.859s")

		Restore:

			yes|make schemas/public/reinstall

				Must come after TNRS restore to recreate tnrs_input_name view

	Full DB:

		Back up: make backups/vegbien.<version>.backup &

		Test: make -s backups/vegbien.<version>.backup/test &

		Restore: make backups/vegbien.<version>.backup/restore &

		Download: make backups/vegbien.<version>.backup/download

	Import logs:

		Download: make inputs/download-logs live=1

Datasource refreshing:

	VegBank:

		make inputs/VegBank/vegbank.sql-remake

		make inputs/VegBank/reinstall quiet=1 &

Schema changes:

	When changing the analytical views, run sync_analytical_..._to_view()

		to update the corresponding table

	Remember to update the following files with any renamings:

	On a development machine, you should put the following in your .profile:

		umask ug=rwx,o= # prevent files from becoming web-accessible

		export log= n=2

	Mapping process: make test

		Including column-based import: make test by_col=1

			If the row-based and column-based imports produce different inserted

					press Enter or click Clear Now

WinMerge setup:

	Install WinMerge from <http://winmerge.org/>

	Open WinMerge

	Go to Edit > Options and click Compare in the left sidebar

Documentation:

	To generate a Redmine-formatted list of steps for column-based import:

		make schemas/public/reinstall

		make inputs/ACAD/Specimen/logs/steps.by_col.log.sql

	To import and scrub just the test taxonomic names:

		inputs/test_taxonomic_names/test_scrub

General: