eaudeweb / ozone / 3396

47%

push

travis-ci

Export submissions (#1215)

* Export an excel file

* Export to known path

* Filter by party and reporting period

* Limit number of rows

* Substance ID or blend legacy ID

* Example submission

* Import and export an xlsx

* Convert xlsx to csvdir

* Convert csvdir to xlsx

* Convert values when loading/dumping spreadsheets

* Vagrant: memory, cpus, job name

* These are not numbers

* More numbers

* Work with example spreadsheet

* WIP export overall sheet

* Just add snap to the path

* Fill out the `Overall` sheet, skip the rest

* Fix the test excel

* Export `Import` table

* Bring back the `if` from commit b057172

* Move export code to its own package

* Multiple ImportNew rows for the same substance

* We actually exported `ImportNew` it seems

* aggregate `ImportNew` sheet to produce `Import`

* Whitespace: pk on first line, metadata on last

* Make values from Export to be numeric

* Export the Export sheet

* Whitespace

* Export the Produce sheet

* Export the Destroy sheet

* Export the NonPartyTradeNew sheet

* Break out values for NonPartyTradeNew sheet

* Aggregate NonPartyTradeNew to NonPartyTrade

* Submission reported at midnight

* Remove useless function

* Make flake8 happy

* Sort rows when exporting

* TODOs

* Fill in `DataID` column

* Make `DataID` numeric

* Extract `METHYL_BROMIDE` substance id

* Test with substance `194` (`METHYL_BROMIDE`) too

* Allow blend party to be blank

* Refactor fixtures

* Export blends. Getting mixed results tho.

* Fix blends export

* Remove obsolete TODOs

* Export remarks

* Export `UNK` party

* Export legacy submissions from Django admin

* Extract fixtures creator

* Add lab uses too

* Detect fixtures from data file

* Allow for unknown `SrcDestCntryID`

47 of 636 branches covered (7.39%)

Branch coverage included in aggregate %.

5269 of 10253 relevant lines covered (51.39%)

0.63 hits per line