Project

General

Profile

1
Installation:
2
	Check out svn: svn co https://code.nceas.ucsb.edu/code/projects/bien
3
	cd bien/
4
	Install: make install
5
		WARNING: This will delete the current public schema of your VegBIEN DB!
6
	Uninstall: make uninstall
7
		WARNING: This will delete your entire VegBIEN DB!
8
		This includes all archived imports and staging tables.
9

    
10
Maintenance:
11
	on a live machine, you should put the following in your .profile:
12
		umask ug=rwx,o= # prevent files from becoming web-accessible
13
		unset TMOUT # TMOUT causes screen to exit even with background processes
14
	to synchronize vegbiendev, jupiter, and your local machine:
15
		WARNING: pay careful attention to all files that will be deleted or
16
			overwritten!
17
		install put if needed:
18
			download https://uutils.googlecode.com/svn/trunk/bin/put to ~/bin/ and `chmod +x` it
19
		when changes are made on vegbiendev:
20
			on vegbiendev, upload:
21
				overwrite=1 bin/sync_upload
22
					then rerun with l=1 ...
23
			on your machine, download:
24
				overwrite=1      swap=1 src=. dest='aaronmk@jupiter:~/bien' put            --exclude=.svn inputs/VegBIEN/TWiki
25
					then rerun with l=1 ...
26
				overwrite=1 swap=1 bin/sync_upload
27
					then rerun with l=1 ...
28
	to synchronize a Mac's settings with my testing machine's:
29
		download:
30
			WARNING: this will overwrite all your user's settings!
31
			overwrite=1 swap=1 src=~/Library/ dest='aaronmk@jupiter:~/Library/' put --exclude="/Saved Application State"
32
				then rerun with l=1 ...
33
		upload:
34
			do step when changes are made on vegbiendev > on your machine, download
35
			overwrite=1        src=~ dest='aaronmk@jupiter:~' put --exclude="/Library/Saved Application State" --exclude="/.Trash" --exclude="/bin" --exclude="/bin/pg_ctl" --exclude="/bin/unzip" --exclude="/Documents/BIEN/large_files" --exclude="/Documents/BIEN/svn/backups/*.backup" --exclude="/Documents/BIEN/svn/backups/analytical_aggregate.*.csv" --exclude="/Dropbox/home"
36
				then rerun with l=1 ...
37
			overwrite=1        src=~ dest=~/Dropbox/home      put --exclude="/Library/Saved Application State" --exclude="/.Trash" --exclude="/.dropbox" --exclude="/Documents/BIEN" --exclude="/Dropbox" --exclude="/software" --exclude="/VirtualBox VMs/**.sav" --exclude="/VirtualBox VMs/**.vdi" --exclude="/VirtualBox VMs/**.vmdk"
38
				then rerun with l=1 ...
39
	to backup files not in Time Machine:
40
		inplace=1 src=/ dest=/Volumes/Time\ Machine\ Backups/ put Users/aaronmk/VirtualBox\ VMs/
41
			then rerun with l=1 ...
42
		stop the PostgreSQL server
43
		src=/ dest=/Volumes/Time\ Machine\ Backups/ sudo put Library/PostgreSQL/9.1/data/
44
			then rerun with l=1 ...
45
		start the PostgreSQL server
46
	VegCore data dictionary:
47
		Regularly, or whenever the VegCore data dictionary page
48
			(https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegCore)
49
			is changed, regenerate mappings/VegCore.csv:
50
			make mappings/VegCore.htm-remake; make mappings/
51
			svn di mappings/VegCore.tables.redmine
52
			If there are changes, update the data dictionary's Tables section
53
			When moving terms, check that no terms were lost: svn di
54
			svn ci -m "mappings/VegCore.htm: Regenerated from wiki"
55
	Important: Whenever you install a system update that affects PostgreSQL or
56
		any of its dependencies, such as libc, you should restart the PostgreSQL
57
		server. Otherwise, you may get strange errors like "the database system
58
		is in recovery mode" which go away upon reimport, or you may not be able
59
		to access the database as the postgres superuser. This applies to both
60
		Linux and Mac OS X.
61

    
62
Single datasource import:
63
	(Re)import and scrub: make inputs/<datasrc>/reimport_scrub by_col=1
64
	(Re)import only: make inputs/<datasrc>/reimport by_col=1
65
	(Re)scrub: make inputs/<datasrc>/rescrub by_col=1
66
	Note that these commands also work if the datasource is not yet imported
67

    
68
Full database import:
69
	WARNING: You must perform *every single* step listed below, to avoid
70
		breaking column-based import
71
	On jupiter: svn up --force
72
	On local machine:
73
		./fix_perms
74
		do steps under Maintenance > "to synchronize vegbiendev, jupiter, and
75
			your local machine" above
76
		make inputs/upload
77
		make inputs/upload live=1
78
		make test by_col=1
79
			See note under Testing below
80
	On vegbiendev:
81
	Ensure there are no local modifications: svn st
82
	svn up
83
	make inputs/download
84
	make inputs/download live=1
85
	For each newly-uploaded datasource above: make inputs/<datasrc>/reinstall
86
	Update the auxiliary schemas: make schemas/reinstall
87
		The public schema will be installed separately by the import process
88
	Delete imports before the last so they won't bloat the full DB backup:
89
		make backups/vegbien.<version>.backup/remove
90
		To keep a previous import other than the public schema:
91
			export dump_opts='--exclude-schema=public --exclude-schema=<version>'
92
	Make sure there is at least 300GB of disk space on /: df -h
93
		The import schema is 255GB, and may use additional space for temp tables
94
		To free up space, remove backups that have been archived on jupiter:
95
			List backups/ to view older backups
96
			Check their MD5 sums using the steps under On jupiter below
97
			Remove these backups
98
	Remove any leftover TNRS lockfile: rm inputs/.TNRS/tnrs/tnrs.make.lock
99
		Usually, the PID in it would not exist, but sometimes it now refers to
100
			a different, active process which blocks tnrs.make
101
	screen
102
	Press ENTER
103
	set -o ignoreeof #prevent Ctrl+D from exiting `screen` to keep attached jobs
104
	unset TMOUT # TMOUT causes screen to exit even with background processes
105
	unset version
106
	Start column-based import: . bin/import_all by_col=1
107
		To use row-based import: . bin/import_all
108
		To stop all running imports: . bin/stop_imports
109
		WARNING: Do NOT run import_all in the background, or the jobs it creates
110
			won't be owned by your shell.
111
		Note that import_all will take up to an hour to import the NCBI backbone
112
			and other metadata before returning control to the shell.
113
	Wait (overnight) for the import to finish
114
	To recover from a closed terminal window: screen -r
115
	When there are no more running jobs, exit the screen
116
	Get $version: echo $version
117
	Set $version in all vegbiendev terminals: export version=<version>
118
	Upload logs (run on vegbiendev): make inputs/upload live=1
119
	On local machine: make inputs/download-logs live=1
120
	In PostgreSQL:
121
		Check that the provider_count and source tables contain entries for all
122
			inputs
123
	Check that TNRS ran successfully:
124
		tail -100 inputs/.TNRS/tnrs/logs/tnrs.make.log.sql
125
		If the log ends in an AssertionError
126
			"assert sql.table_col_names(db, table) == header":
127
			Figure out which TNRS CSV columns have changed
128
			On local machine:
129
				Make the changes in inputs/.TNRS/schema.sql
130
				rm inputs/.TNRS/tnrs/header.csv
131
				make inputs/.TNRS/reinstall schema_only=1
132
				make schemas/public/reinstall
133
				If there are errors "column ... does not exist", etc.:
134
					Make the necessary changes in schemas/vegbien.sql
135
					make schemas/public/reinstall
136
				make schemas/remake
137
				inputs/test_taxonomic_names/test_scrub
138
				In inputs/test_taxonomic_names/_scrub/TNRS.sql, copy the
139
					"COPY tnrs ..." statement to inputs/.TNRS/data.sql
140
				Commit
141
			On vegbiendev:
142
				If dropping a column, save the dependent views
143
				Make the same changes in the live TNRS.tnrs table on vegbiendev
144
				If dropping a column, recreate the dependent views
145
				Restart the TNRS client: make scrub by_col=1 &
146
	tail inputs/{.,}*/*/logs/$version.log.sql
147
	In the output, search for "Command exited with non-zero status"
148
	For inputs that have this, fix the associated bug(s)
149
	If many inputs have errors, discard the current (partial) import:
150
		make schemas/$version/uninstall
151
	Otherwise, continue
152
	Publish the new import:
153
		WARNING: Before proceeding, be sure you have done *every single*
154
			verification step listed above. Otherwise, a previous valid import
155
			could incorrectly be overwritten with a broken one.
156
		make schemas/$version/publish
157
	unset version
158
	backups/fix_perms
159
	make backups/upload live=1
160
	On jupiter:
161
		cd /data/dev/aaronmk/bien/backups
162
		For each newly-archived backup:
163
			make -s <backup>.md5/test
164
			Check that "OK" is printed next to the filename
165
	On nimoy:
166
		cd /home/bien/svn/
167
		svn up
168
		export version=<version>
169
		make backups/analytical_stem.$version.csv/download
170
		In the bien_web DB:
171
			Create the analytical_stem_<version> table using its schema
172
				in schemas/vegbien.my.sql
173
		make -s backups/analytical_stem.$version.csv.md5/test
174
		Check that "OK" is printed next to the filename
175
		table=analytical_stem_$version bin/publish_analytical_db \
176
			backups/analytical_stem.$version.csv
177
	If desired, record the import times in inputs/import.stats.xls:
178
		Open inputs/import.stats.xls
179
		If the rightmost import is within 5 columns of column IV:
180
			Copy the current tab to <leftmost-date>~<rightmost-date>
181
			Remove the previous imports from the current tab because they are
182
				now in the copied tab instead
183
		Insert a copy of the leftmost "By column" column group before it
184
		export version=<version>
185
		bin/import_date inputs/{.,}*/*/logs/$version.log.sql
186
		Update the import date in the upper-right corner
187
		bin/import_times inputs/{.,}*/*/logs/$version.log.sql
188
		Paste the output over the # Rows/Time columns, making sure that the
189
			row counts match up with the previous import's row counts
190
		If the row counts do not match up, insert or reorder rows as needed
191
			until they do. Get the datasource names from the log file footers:
192
			tail inputs/{.,}*/*/logs/$version.log.sql
193
		Commit: svn ci -m "inputs/import.stats.xls: Updated import times"
194
	To run TNRS:
195
		To use an import other than public: export version=<version>
196
		make scrub &
197
		To view progress:
198
			tail -100 inputs/.TNRS/tnrs/logs/tnrs.make.log.sql
199
	To remake analytical DB:
200
		To use an import other than public: export version=<version>
201
		bin/make_analytical_db &
202
		To view progress:
203
			tail -100 inputs/analytical_db/logs/make_analytical_db.log.sql
204
	To back up DB (staging tables and last import):
205
		To use an import other than public: export version=<version>
206
		If before renaming to public: export dump_opts=--exclude-schema=public
207
		make backups/vegbien.$version.backup/test &
208

    
209
Backups:
210
	Archived imports:
211
		Back up: make backups/<version>.backup &
212
			Note: To back up the last import, you must archive it first:
213
				make schemas/rotate
214
		Test: make -s backups/<version>.backup/test &
215
		Restore: make backups/<version>.backup/restore &
216
		Remove: make backups/<version>.backup/remove
217
		Download: make backups/<version>.backup/download
218
	TNRS cache:
219
		Back up: make backups/TNRS.backup-remake &
220
			runtime: 3 min ("real 2m48.859s")
221
		Restore:
222
			yes|make inputs/.TNRS/uninstall
223
			make backups/TNRS.backup/restore &
224
				runtime: 5.5 min ("real 5m35.829s")
225
			yes|make schemas/public/reinstall
226
				Must come after TNRS restore to recreate tnrs_input_name view
227
	Full DB:
228
		Back up: make backups/vegbien.<version>.backup &
229
		Test: make -s backups/vegbien.<version>.backup/test &
230
		Restore: make backups/vegbien.<version>.backup/restore &
231
		Download: make backups/vegbien.<version>.backup/download
232
	Import logs:
233
		Download: make inputs/download-logs live=1
234

    
235
Datasource setup:
236
	umask ug=rwx,o= # prevent files from becoming web-accessible
237
	Add a new datasource: make inputs/<datasrc>/add
238
		<datasrc> may not contain spaces, and should be abbreviated.
239
		If the datasource is a herbarium, <datasrc> should be the herbarium code
240
			as defined by the Index Herbariorum <http://sweetgum.nybg.org/ih/>
241
	For MySQL inputs (exports and live DB connections):
242
		For .sql exports:
243
			Place the original .sql file in _src/ (*not* in _MySQL/)
244
			Follow the steps starting with Install the staging tables below.
245
				This is for an initial sync to get the file onto vegbiendev.
246
			On vegbiendev:
247
				Create a database for the MySQL export in phpMyAdmin
248
				Give the bien user all database-specific privileges *except*
249
					UPDATE, DELETE, ALTER, DROP. This prevents bugs in the
250
					import scripts from accidentally deleting data.
251
				bin/mysql_bien database <inputs/<datasrc>/_src/export.sql &
252
		mkdir inputs/<datasrc>/_MySQL/
253
		cp -p lib/MySQL.{data,schema}.sql.make inputs/<datasrc>/_MySQL/
254
		Edit _MySQL/*.make for the DB connection
255
			For a .sql export, use server=vegbiendev and --user=bien
256
		Skip the Add input data for each table section
257
	For MS Access databases:
258
		Place the .mdb or .accdb file in _src/
259
		Download and install Access To PostgreSQL from
260
			http://www.bullzip.com/download.php
261
		Use Access To PostgreSQL to export the database:
262
			Export just the tables/indexes to inputs/<datasrc>/<file>.schema.sql
263
			Export just the data to inputs/<datasrc>/<file>.data.sql
264
		In <file>.schema.sql, make the following changes:
265
			Replace text "BOOLEAN" with "/*BOOLEAN*/INTEGER"
266
			Replace text "DOUBLE PRECISION NULL" with "DOUBLE PRECISION"
267
		Skip the Add input data for each table section
268
	Add input data for each table present in the datasource:
269
		For .sql exports, you must use the name of the table in the DB export
270
		For CSV files, you can use any name. It's recommended to use a table
271
			name from <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegCSV#Suggested-table-names>
272
		Note that if this table will be joined together with another table, its
273
			name must end in ".src"
274
		make inputs/<datasrc>/<table>/add
275
			Important: DO NOT just create an empty directory named <table>!
276
				This command also creates necessary subdirs, such as logs/.
277
		If the table is in a .sql export: make inputs/<datasrc>/<table>/install
278
			Otherwise, place the CSV(s) for the table in
279
			inputs/<datasrc>/<table>/ OR place a query joining other tables
280
			together in inputs/<datasrc>/<table>/create.sql
281
		Important: When exporting relational databases to CSVs, you MUST ensure
282
			that embedded quotes are escaped by doubling them, *not* by
283
			preceding them with a "\" as is the default in phpMyAdmin
284
		If there are multiple part files for a table, and the header is repeated
285
			in each part, make sure each header is EXACTLY the same.
286
			(If the headers are not the same, the CSV concatenation script
287
			assumes the part files don't have individual headers and treats the
288
			subsequent headers as data rows.)
289
		Add <table> to inputs/<datasrc>/import_order.txt before other tables
290
			that depend on it
291
	Install the staging tables:
292
		make inputs/<datasrc>/reinstall quiet=1 &
293
		For a MySQL .sql export:
294
			At prompt "[you]@vegbiendev's password:", enter your password
295
			At prompt "Enter password:", enter the value in config/bien_password
296
		To view progress: tail -f inputs/<datasrc>/<table>/logs/install.log.sql
297
		View the logs: tail -n +1 inputs/<datasrc>/*/logs/install.log.sql
298
			tail provides a header line with the filename
299
			+1 starts at the first line, to show the whole file
300
		For every file with an error 'column "..." specified more than once':
301
			Add a header override file "+header.<ext>" in <table>/:
302
				Note: The leading "+" should sort it before the flat files.
303
					"_" unfortunately sorts *after* capital letters in ASCII.
304
				Create a text file containing the header line of the flat files
305
				Add an ! at the beginning of the line
306
					This signals cat_csv that this is a header override.
307
				For empty names, use their 0-based column # (by convention)
308
				For duplicate names, add a distinguishing suffix
309
				For long names that collided, rename them to <= 63 chars long
310
				Do NOT make readability changes in this step; that is what the
311
					map spreadsheets (below) are for.
312
				Save
313
		If you made any changes, re-run the install command above
314
	Auto-create the map spreadsheets: make inputs/<datasrc>/
315
	Map each table's columns:
316
		In each <table>/ subdir, for each "via map" map.csv:
317
			Open the map in a spreadsheet editor
318
			Open the "core map" /mappings/Veg+-VegBIEN.csv
319
			In each row of the via map, set the right column to a value from the
320
				left column of the core map
321
			Save
322
		Regenerate the derived maps: make inputs/<datasrc>/
323
	Accept the test cases:
324
		make inputs/<datasrc>/test
325
			When prompted to "Accept new test output", enter y and press ENTER
326
			If you instead get errors, do one of the following for each one:
327
			-	If the error was due to a bug, fix it
328
			-	Add a SQL function that filters or transforms the invalid data
329
			-	Make an empty mapping for the columns that produced the error.
330
				Put something in the Comments column of the map spreadsheet to
331
				prevent the automatic mapper from auto-removing the mapping.
332
			When accepting tests, it's helpful to use WinMerge
333
				(see WinMerge setup below for configuration)
334
		make inputs/<datasrc>/test by_col=1
335
			If you get errors this time, this always indicates a bug, usually in
336
				the VegBIEN unique constraints or column-based import itself
337
	Add newly-created files: make inputs/<datasrc>/add
338
	Commit: svn ci -m "Added inputs/<datasrc>/" inputs/<datasrc>/
339
	Update vegbiendev:
340
		On jupiter: svn up
341
		On local machine:
342
			./fix_perms
343
			make inputs/upload
344
			make inputs/upload live=1
345
		On vegbiendev:
346
			svn up
347
			make inputs/download
348
			make inputs/download live=1
349
			Follow the steps under Install the staging tables above
350

    
351
Datasource refreshing:
352
	VegBank:
353
		make inputs/VegBank/vegbank.sql-remake
354
		make inputs/VegBank/reinstall quiet=1 &
355

    
356
Schema changes:
357
	When changing the analytical views, run sync_analytical_..._to_view()
358
		to update the corresponding table
359
	Remember to update the following files with any renamings:
360
		schemas/filter_ERD.csv
361
		mappings/VegCore-VegBIEN.csv
362
		mappings/verify.*.sql
363
	Regenerate schema from installed DB: make schemas/remake
364
	Reinstall DB from schema: make schemas/public/reinstall schemas/reinstall
365
		WARNING: This will delete the current public schema of your VegBIEN DB!
366
	Reinstall staging tables:
367
		On local machine:
368
			sudo -E -u postgres psql <<<'ALTER DATABASE vegbien RENAME TO vegbien_prev'
369
			make db
370
			. bin/reinstall_all
371
			Fix any bugs and retry until no errors
372
			make schemas/public/install
373
				This must be run *after* the datasources are installed, because
374
				views in public depend on some of the datasources
375
			sudo -E -u postgres psql <<<'DROP DATABASE vegbien_prev'
376
		On vegbiendev: repeat the above steps
377
			WARNING: Do not run this until reinstall_all runs successfully on
378
			the local machine, or the live DB may be unrestorable!
379
	Sync ERD with vegbien.sql schema:
380
		Run make schemas/vegbien.my.sql
381
		Open schemas/vegbien.ERD.mwb in MySQLWorkbench
382
		Go to File > Export > Synchronize With SQL CREATE Script...
383
		For Input File, select schemas/vegbien.my.sql
384
		Click Continue
385
		In the changes list, select each table with an arrow next to it
386
		Click Update Model
387
		Click Continue
388
		Note: The generated SQL script will be empty because we are syncing in
389
			the opposite direction
390
		Click Execute
391
		Reposition any lines that have been reset
392
		Add any new tables by dragging them from the Catalog in the left sidebar
393
			to the diagram
394
		Remove any deleted tables by right-clicking the table's diagram element,
395
			selecting Delete '<table name>', and clicking Delete
396
		Save
397
		If desired, update the graphical ERD exports (see below)
398
	Update graphical ERD exports:
399
		Go to File > Export > Export as PNG...
400
		Select schemas/vegbien.ERD.png and click Save
401
		Go to File > Export > Export as SVG...
402
		Select schemas/vegbien.ERD.svg and click Save
403
		Go to File > Export > Export as Single Page PDF...
404
		Select schemas/vegbien.ERD.1_pg.pdf and click Save
405
		Go to File > Print...
406
		In the lower left corner, click PDF > Save as PDF...
407
		Set the Title and Author to ""
408
		Select schemas/vegbien.ERD.pdf and click Save
409
		Commit: svn ci -m "schemas/vegbien.ERD.mwb: Regenerated exports"
410
	Refactoring tips:
411
		To rename a table:
412
			In vegbien.sql, do the following:
413
				Replace regexp (?<=_|\b)<old>(?=_|\b) with <new>
414
					This is necessary because the table name is *everywhere*
415
				Search for <new>
416
				Manually change back any replacements inside comments
417
		To rename a column:
418
			Rename the column: ALTER TABLE <table> RENAME <old> TO <new>;
419
			Recreate any foreign key for the column, removing CONSTRAINT <name>
420
				This resets the foreign key name using the new column name
421
	Creating a poster of the ERD:
422
		Determine the poster size:
423
			Measure the line height (from the bottom of one line to the bottom
424
				of another): 16.3cm/24 lines = 0.679cm
425
			Measure the height of the ERD: 35.4cm*2 = 70.8cm
426
			Zoom in as far as possible
427
			Measure the height of a capital letter: 3.5mm
428
			Measure the line height: 8.5mm
429
			Calculate the text's fraction of the line height: 3.5mm/8.5mm = 0.41
430
			Calculate the text height: 0.679cm*0.41 = 0.28cm
431
			Calculate the text height's fraction of the ERD height:
432
				0.28cm/70.8cm = 0.0040
433
			Measure the text height on the *VegBank* ERD poster: 5.5mm = 0.55cm
434
			Calculate the VegBIEN poster height to make the text the same size:
435
				0.55cm/0.0040 = 137.5cm H; *1in/2.54cm = 54.1in H
436
			The ERD aspect ratio is 11 in W x (2*8.5in H) = 11x17 portrait
437
			Calculate the VegBIEN poster width: 54.1in H*11W/17H = 35.0in W
438
			The minimum VegBIEN poster size is 35x54in portrait
439
		Determine the cost:
440
			The FedEx Kinkos near NCEAS (1030 State St, Santa Barbara, CA 93101)
441
				charges the following for posters:
442
				base: $7.25/sq ft
443
				lamination: $3/sq ft
444
				mounting on a board: $8/sq ft
445

    
446
Testing:
447
	On a development machine, you should put the following in your .profile:
448
		umask ug=rwx,o= # prevent files from becoming web-accessible
449
		export log= n=2
450
	Mapping process: make test
451
		Including column-based import: make test by_col=1
452
			If the row-based and column-based imports produce different inserted
453
			row counts, this usually means that a table is underconstrained
454
			(the unique indexes don't cover all possible rows).
455
			This can occur if you didn't use COALESCE(field, null_value) around
456
			a nullable field in a unique index. See sql_gen.null_sentinels for
457
			the appropriate null value to use.
458
	Map spreadsheet generation: make remake
459
	Missing mappings: make missing_mappings
460
	Everything (for most complete coverage): make test-all
461

    
462
Debugging:
463
	"Binary chop" debugging:
464
		(This is primarily useful for regressions that occurred in a previous
465
		revision, which was committed without running all the tests)
466
		svn up -r <rev>; make inputs/.TNRS/reinstall; make schemas/public/reinstall; make <failed-test>.xml
467
	.htaccess:
468
		mod_rewrite:
469
			IMPORTANT: whenever you change the DirectorySlash setting for a
470
				directory, you *must* clear your browser's cache to ensure that
471
				a cached redirect is not used. this is because RewriteRule
472
				redirects are (by default) temporary, but DirectorySlash
473
				redirects are permanent.
474
				for Firefox:
475
					press Cmd+Shift+Delete
476
					check only Cache
477
					press Enter or click Clear Now
478

    
479
WinMerge setup:
480
	Install WinMerge from <http://winmerge.org/>
481
	Open WinMerge
482
	Go to Edit > Options and click Compare in the left sidebar
483
	Enable "Moved block detection", as described at
484
		<http://manual.winmerge.org/Configuration.html#d0e5892>.
485
	Set Whitespace to Ignore change, as described at
486
		<http://manual.winmerge.org/Configuration.html#d0e5758>.
487

    
488
Documentation:
489
	To generate a Redmine-formatted list of steps for column-based import:
490
		make schemas/public/reinstall
491
		make inputs/ACAD/Specimen/logs/steps.by_col.log.sql
492
	To import and scrub just the test taxonomic names:
493
		inputs/test_taxonomic_names/test_scrub
494

    
495
General:
496
	To see a program's description, read its top-of-file comment
497
	To see a program's usage, run it without arguments
498
	To remake a directory: make <dir>/remake
499
	To remake a file: make <file>-remake
(4-4/9)