#README

Usage
______


* Create the raw data spreadsheet, name it "dataload.xls"
* Create the seed script:
```
  rails runner dataload/parse.rb > dataload/load.rb
```


* Run the seed script:
```
  rails runner dataload/load.rb
```

* 'Comments' is a sql file that is too big to be loaded the slow junky rails way:
```
	psql -d lineups_development -f comments.sql
```

* Reset the database sequence columns, since (at least in postgres) we have inserted them ourselves. (without this, the very first save will try to use a sequence value that already exists)
```
	dataload/reset_sequences.sh
```


There is more to come.
The data load script uses some raw data files that are extracted from the legacy databases (.txt files and a spreadsheet, etc.). It is important that these are "fresh" when an initial data load is run.