CHANGELOG.md

SEED Version 3.0.0-beta.0

What's Changed

New Features 🎉

• Accountability Hierarchy by @haneslinger in #4186
• Allow data logger deletion by @haneslinger in #4563
• Allow sensor deletion by @haneslinger in #4561

Improvements 📈

• Better CO₂ Analysis error message by @haneslinger in #4568
• Limit member visibility to users within access level instance by @perryr16 in #4572
• Allow data logger update by @haneslinger in #4583
• Allow sensor update by @haneslinger in #4584
• Don't shorten lat/long by @haneslinger in #4587
• Empty label section remains same size when toggled by @haneslinger in #4588
• Don't get cycles when getting inventory list by @haneslinger in #4589
• Geocode UBIDs using centroid by @axelstudios in #4610
• Fix floating point rounding by @axelstudios in #4609
• Encrypt organization audit template password by @perryr16 in #4585
• Render scenario ui-grid on expand by @perryr16 in #4599

Maintenance 🧹

• Bump django from 3.2.23 to 3.2.25 in /requirements by @dependabot in #4573
• Fix broken license URLs by @axelstudios in #4578
• Feature/upgrade codebuild http2 by @dhaley in #4571
• Update to latest version of UBID library by @nllong in #4598
• Update Node in Docker images by @axelstudios in #4580
• Ruff linting and formatting by @axelstudios in #4604

Bug Fixes 🐛

• Fix meter delete bug by @perryr16 in #4574
• Redirect on org change if necessary by @perryr16 in #4576
• Fix property search endpoint in Swagger by @nllong in #4579
• Allow jurisdiction_tax_lot_id display name change by @haneslinger in #4577
• Allow superusers to list all org members by @axelstudios in #4593
• Updated Swagger config to prevent requesting external schemas by @axelstudios in #4590
• Clear invalid label tags by @perryr16 in #4591
• Show error on custom reports if no filter groups exist by @perryr16 in #4594
• Fix merge modal for all cycles by @axelstudios in #4612
• Fix ubid bugs by @perryr16 in #4613
• Call spinner on default report export by @perryr16 in #4586
• Changes the dataview evaluate endpoint from put to post by @perryr16 in #4595
• Enable blank filters for other inventory columns by @perryr16 in #4600
• Fixes bug to hide edit form on save by @perryr16 in #4623
• Handle null values in related columns by @axelstudios in #4626
• Fix mapping previews for files with a single column by @axelstudios in #4611

Full Changelog: https://github.com/SEED-platform/seed/compare/v2.22.0...v3.0.0-beta.0

SEED Version 2.22.0

What's Changed

New Features 🎉

• Support unicode characters by replacing unidecode with new normalize method by @nllong in #4484
• Redis backend update by @axelstudios in #4376

Improvements 📈

• Sort cycles by start_date on property insights page by @kflemin in #4441
• Fixed FontAwesome v6.5 alignment by @axelstudios in #4444
• Fixes text alignment following FontAwesome changes by @axelstudios in #4465
• Sensor reading performance improvement by @axelstudios in #4464
• Move program setup to modal on insights pages by @kflemin in #4468
• Retrieve all map data at once by @haneslinger in #4469
• Change unique name constraint on derived column so it's within inventory type by @haneslinger in #4472
• Add JSON response to GET Audit Template submission by @kflemin in #4477
• Labels: Added complex filtering logic by @ebeers-png in #4449

Maintenance 🧹

• Update developer documentation dependencies by @nllong in #4485
• Delete PropertyStateViewSet by @haneslinger in #4292

Bug Fixes 🐛

• Display x-axis label for ranked distance to compliance by @kflemin in #4442
• Fix multi-cycle test for new year by @perryr16 in #4459
• Fix and optimize sensors by @haneslinger in #4461
• Restore column filters when unpinning by @axelstudios in #4473
• Fix importing diesel meter readings by @axelstudios in #4476
• Add bulk meter reading error handling for duplicate date-pairs by @perryr16 in #4467
• Allow omitted fields on the mapping page to be unfilled by @haneslinger in #4471
• Default label to show in list by @haneslinger in #4448
• Show spinner on label creation by @perryr16 in #4458
• Catch invalid organization id preventing 500s by @perryr16 in #4475
• Fix inventory list timing console errors by @perryr16 in #4478
• Fix inventory list double refresh on load by @perryr16 in #4480
• Apply GHG and GHGI unit versions to canonical columns by @perryr16 in #4462
• Fix inventory loading if no previous sort settings exist in localStorage by @axelstudios in #4497
• Fix simple modal service by @kflemin in #4505
• Handle errors when filtering columns with special characters by @perryr16 in #4511
• Fix program setup's new program button action by @perryr16 in #4499
• Ignore duplicates when adding labels by @kflemin in #4523
• Fix 403 error for viewer role by @kflemin in #4526
• Inventory List - Ignore incomplete filters containing just an operator by @kflemin in #4527
• Inventory Map - Fix positioning of the popup tooltip to be closer to the pin by @kflemin in #4528
• Update error message on overlapping reading import by @perryr16 in #4533
• Fix Redis compatibility with boto3 by @axelstudios in #4534
• Reject import file if it contains braces by @perryr16 in #4537
• Update default dates on data quality rules by @nllong in #4538
• Apply unit conversion to extra data by @perryr16 in #4496
• Fix unit conversion for non-numeric values by @perryr16 in #4555
• Fix property insights categorical axis by @haneslinger in #4565

Full Changelog: https://github.com/SEED-platform/seed/compare/v2.21.0...v2.22.0

SEED Version 2.21.0

What's Changed

New Features 🎉

• Provide environment variable to disable wait-for-it condition in deployments by @dhaley in #4377
• Add healthcheck to docker web container by @axelstudios in #4374
• Audit Template report submission endpoint by @kflemin in #4411
• Remove Summary charts by @haneslinger in #4402
• Add count to default reports by @haneslinger in #4423

Improvements 📈

• Property Insights UI enhancements by @kflemin in #4384
• Add distance to target in table under property insights graph by @kflemin in #4386
• Populate default report using cycles by @haneslinger in #4420
• Analyses performance improvement by @haneslinger in #4434
• Additional analyses performance improvement by @haneslinger in #4438

Maintenance 🧹

• Updated developer resources documentation by @axelstudios in #4373
• Bump django from 3.2.20 to 3.2.23 in /requirements by @dependabot in #4379
• Updated salesforce pg_restore docs by @axelstudios in #4382

Bug Fixes 🐛

• Fix CO2 analysis column naming by @ebeers-png in #4410
• Salesforce scheduling issues by @axelstudios in #4387
• Custom report name field location by @kflemin in #4385
• Order cycles by start date on program setup by @kflemin in #4428
• Property Insights tooltip refinement by @kflemin in #4425

Full Changelog: https://github.com/SEED-platform/seed/compare/v2.20.1...v2.21.0

SEED Version 2.20.1

What's Changed

New Features 🎉

• Feature to enable Redis for ElastiCache by @dhaley in #4288
• Health check endpoint by @axelstudios in #4371

Improvements 📈

• Update dependencies and fonts by @axelstudios in #3941
• Update Redis config to support encryption in transit with AWS ElastiCache by @dhaley in #4258
• Decrease BETTER polling rate 5x, increase timeout 5x by @axelstudios in #4280
• Increase ESPM max timeout by @anchapin in #4296
• Update list of BETTER's measures returned by @nllong in #4300

Maintenance 🧹

• Code Cleanup by @axelstudios in #3539

Bug Fixes 🐛

• Fix mapping of BETTER's measures with empty strings to false by @nllong in #4276
• Enable natural sorting of Inventory List columns by @axelstudios in #4281
• Handle ambiguous timestamps by @axelstudios in #4287
• Fix cycle deletion modal by @axelstudios in #4291
• Handle nonexistent timestamps by @axelstudios in #4294
• Add failing logic to AT export if AT credentials are invalid by @perryr16 in #4282
• Add analysis description translations by @kflemin in #4304
• Fix showing derived column values on the inventory list page by @axelstudios in #4364

Full Changelog: https://github.com/SEED-platform/seed/compare/v2.20.0...v2.20.1

SEED Version 2.20.0

What's Changed

New Features 🎉

• Add new create_property and update_with_espm endpoint by @kflemin in #4012
• EEEJ Analysis Functionality by @kflemin in #4208
• Add Uniformat Table by @axelstudios in #4238
• Add Import Export to Audit Template by @perryr16 in #4215

Improvements 📈

• Optimize list analyses endpoint by @haneslinger in #4206
• Move analyses endpoint by @haneslinger in #4210
• Remove Beta label from text of analysis button by @kflemin in #4225
• Show Analysis debug_message If Available by @axelstudios in #4198
• Use display name in custom reports legend by @haneslinger in #4060
• Add more API documentation for meter and meter readings by @nllong in #4237
• Update default meter range selection for BETTER analysis by @perryr16 in #3819
• Add a cycle indicator to the analysis modal and filter analyses for current cycle by @perryr16 in #3837
• Add envvar to specify loading test EEEJ dataset by @kflemin in #4254
• Default to excluding Address Line 1 as a matching criteria by @axelstudios in #4256
• Refactor map page for functionality and performance by @axelstudios in #4260

Maintenance 🧹

• Remove Deprecated APIs by @axelstudios in #4049
• Lock google-chrome to v114 by @axelstudios in #4165
• Bump word-wrap from 1.2.3 to 1.2.4 by @dependabot in #4154
• Remove ID from inventory document display name by @perryr16 in #4125
• Bump uwsgi from 2.0.17.1 to 2.0.22 in /requirements by @dependabot in #4209
• Allow analysis property view related properties to be null by @perryr16 in #4227
• Disable ability to remove matching criteria fields once inventory is added by @perryr16 in #4222
• Add documentation for cleaning up conflicting column names during migration by @nllong in #4264

Bug Fixes 🐛

• Add Open Street Map to CSP rules by @axelstudios in #4169
• add error handling for sf edge case by @kflemin in #4159
• Fix display name by @haneslinger in #4223
• Fix refresh_metadata by @haneslinger in #4221
• Fix Meters Without source_id by @axelstudios in #4229
• Fix performance for fetching analyses and force user email to lowercase by @ebeers-png in #4213
• Update inventory selection to include current inventory type only by @perryr16 in #3862
• Delete BuildingFiles and Related Events on PropertyState delete by @perryr16 in #4217
• Fixed Issues with Scenario/Measure CRUD Operations by @axelstudios in #4240
• Fix Meter Overwrites by @axelstudios in #4250
• Fix filter group dropdown bugs by @ebeers-png in #4249
• Fix EEEJ analysis errors when there are no lat/long or address by @kflemin in #4247
• ArcGIS CSP rule by @axelstudios in #4265
• Fix edge case for map label filtering by @axelstudios in #4270

Full Changelog: https://github.com/SEED-platform/seed/compare/v2.19.0...v2.20.0

SEED Version 2.19.0

What's Changed

New Features 🎉

• Add Terms of Service by @kflemin in #4065
• Multiple cycle upload by @anchapin in #4073
• Add UBID relation to state by @perryr16 in #4074
• Store additional geocoding results by @nllong in #4020

Improvements 📈

• Move reports to insights page by @haneslinger in #4031
• Direct to property insight on click of program overview column by @haneslinger in #4011
• Add ranked sorting to insight property page by @haneslinger in #4030
• Include x and y in property insights tables by @haneslinger in #4075
• Add percentages to program overview by @haneslinger in #4077
• Add matching criteria to report export by @haneslinger in #4072

Maintenance 🧹

• Bump django from 3.2.18 to 3.2.19 in /requirements by @dependabot in #4034
• Improve inventory load times by @ebeers-png in #3990
• Updated installation steps by @anchapin in #3987
• Bump django-ses from 1.0.3 to 3.5.0 in /requirements by @dependabot in #4055
• Bump requests from 2.28.0 to 2.31.0 in /requirements by @dependabot in #4056
• Pin urllib3 by @axelstudios in #4059
• Remove OEP by @kflemin in #4109
• Bump django from 3.2.19 to 3.2.20 in /requirements by @dependabot in #4128
• Merge sphinx spelling list with VSCode's Code Spelling version by @nllong in #4149

Bug Fixes 🐛

• Fix duplicate users per organization by @axelstudios in #4033
• Require org id from endpoints with has_perm_class by @haneslinger in #4027
• Remove sync salesforce button due to timeout by @kflemin in #4038
• Fix column list profile GET request syntax by @ebeers-png in #3988
• Prevent Automatically Serving Static index.html Files by @axelstudios in #4057
• Fix User Creation Bugs by @axelstudios in #4094
• Fix categorical data on reports scatter plot by @haneslinger in #4085
• Fix ESPM Source Types by @axelstudios in #4096
• Fix Download URLs by @axelstudios in #4066
• Use iterator() when rehashing to save memory by @nllong in #4139
• Constrain uniqueness of column name and move geocoding column creation by @nllong in #4151

Full Changelog: https://github.com/SEED-platform/seed/compare/v2.18.1...v2.19.0

SEED Version 2.18.1

What's Changed

New Features 🎉

• Codebuild & Elasticache Redis integration support by @dhaley in #3981

Improvements 📈

• Add better error messaging that includes the property view ID by @kflemin in #3973
• Add Salesforce fields to store data admin contact by @kflemin in #3985
• Add salesforce mappings sort and more error checking and messaging by @kflemin in #3992
• Add zoom and panning to insights property page by @haneslinger in #3879
• Remove program overview tabular data by @haneslinger in #4007
• Save Insight property config locally by @haneslinger in #3994
• Add Salesforce delete_label_on_sync setting by @kflemin in #4022
• Replace seed getting started guide for v2.18 by @kflemin in #4026
• Add in the start and end cycle year to the title by @haneslinger in #4014

Bug Fixes 🐛

• Validate property state before creating BuildingSync document by @perryr16 in #3953
• Fix Update-Salesforce requests by @axelstudios in #3978
• Enforce non-null taxlot_id attached to TaxlotViews by @axelstudios in #4006

New Contributors

• @dhaley made their first contribution in #3981

Full Changelog: https://github.com/SEED-platform/seed/compare/v2.18.0...v2.18.1

SEED Version 2.18.0

What's Changed

New Features 🎉

• Implement Salesforce integration by @kflemin in #3840
• Add option to export meter data in GeoJSON by @nllong in #3900
• Create property timeline view by @perryr16 in #3899

Improvements 📈

• Update Evaluate Permissions by @haneslinger in #3864
• select cycles instead of start/end dates by @kflemin in #3895
• Specify cycle in eui analysis by @haneslinger in #3820
• Add labels button on property insights page by @haneslinger in #3860
• Bump yargs-parser and protractor by @dependabot in #3939
• Modularized nginx, added gzip, added cache expiration by @axelstudios in #3940

Maintenance 🧹

• Bump django from 3.2.17 to 3.2.18 in /requirements by @dependabot in #3863
• Bump sentry-sdk from 1.7.2 to 1.14.0 in /requirements by @dependabot in #3907
• Migrate BETTER API from V1 to V2 by @perryr16 in #3881
• Update copyright and copyright years by @nllong in #3903

Bug Fixes 🐛

• Filter cycle specific labels on inventory list by @perryr16 in #3858
• Fix casting of GHG metrics on Program Insight page by @haneslinger in #3880
• Fix deletion of new custom report by @haneslinger in #3924
• Fix saving BETTER/Salesforce data for non-active orgs by @axelstudios in #3925
• Fix GitHub Actions Masking by @axelstudios in #3930
• adding >= and <= to display by @kflemin in #3928
• Fix custom reports download button by @haneslinger in #3926
• Updated the meter import process to work with latest format from EnergyStar Portfolio Manager by @anchapin in #3927
• Fix active nav for deep URLs by @axelstudios in #3931
• Fixed saving Program Setup data for non-active orgs by @axelstudios in #3932
• Make test_compliance_metric_retrieve_endpoint deterministic by @haneslinger in #3934
• Fix custom report creation reload by @haneslinger in #3936
• Fixed issue with filtering Property columns from Tax Lot tab of Inventory by @anchapin in #3943
• Increase AnalysisMessage.user_message length by @perryr16 in #3935
• Fixes Timeline Bugs by @perryr16 in #3944
• Fix editing a derived column without changing the name by @axelstudios in #3949
• Fix Salesforce connection requests for non-superusers by @axelstudios in #3947

Other Changes

• None

Full Changelog: https://github.com/SEED-platform/seed/compare/v2.17.4...v2.18.0

SEED Version 2.17.4

What's Changed

Improvements 📈

• Open New Tab on Insight Property Click by @haneslinger in #3853

Maintenance 🧹

• Improve nginx security by @nllong and @axelstudios in #3873

Full Changelog: https://github.com/SEED-platform/seed/compare/v2.17.3...v2.17.4

SEED Version 2.17.3

What's Changed

New Features 🎉

• Add CRUD to MeterReading by @nllong in #3757
• Add export to meters and meter readings by @nllong in #3868

Improvements 📈

• Change "Program Configuration" to "Program Setup" by @anchapin in #3832
• Get audit date and audit date type from buildingsync files by @haneslinger in #3838
• Update GeoJSON export format with GeometryCollections and remove crs by @nllong in #3851

Maintenance 🧹

• Bump django from 3.2.17 to 3.2.18 in /requirements by @dependabot in #3863
• Remove project and compliance models by @nllong in #3743
• Fix nginx Security by @axelstudios in #3866

Bug Fixes 🐛

• Fix ESPM xml report import by @nllong in #3856
• Fix importing of GeoJSON property footprints by @nllong in #3848
• Fix clickable header by @axelstudios in #3867

Full Changelog: https://github.com/SEED-platform/seed/compare/v2.17.2...v2.17.3

SEED Version 2.17.2

What's Changed

New Features 🎉

• Allow switching cycles in inventory detail page by @haneslinger in #3783

Improvements 📈

• Remove add column in mapping page by @haneslinger in #3813
• Sort the dropdown of meter units by @nllong in #3822

Maintenance 🧹

• Update to Django 3.2.17 in #3824

Bug Fixes 🐛

• Fix 500 on data view evaluate when extra data is not present by @haneslinger in #3803
• Catch create column error correctly by @haneslinger in #3791
• Show all navigation links in the organization view #3811
• Remove state population in create column by @haneslinger in #3806

Full Changelog: https://github.com/SEED-platform/seed/compare/v2.17.1...v2.17.2

SEED Version 2.17.1

What's Changed

New Features 🎉

• Allow users to create columns by @haneslinger in #3730

Improvements 📈

• Show portfolio manager errors by @haneslinger in #3735
• Allow users to hide property insight dataset by @haneslinger in #3726

Maintenance 🧹

• Bump future from 0.18.2 to 0.18.3 in /requirements by @dependabot in #3792

Bug Fixes 🐛

• Fix stacked property points by @haneslinger in #3725
• Fix filter group with extra column work on revised programs by @haneslinger in #3727
• Fix filter on nulls and empty strings by @haneslinger in #3733
• Add the @has_perm_class permission to program metric api endpoints by @anchapin in #3729
• fix meter service route for units in organization settings by @kflemin in #3738
• Fix custom report legend sort for chrome by @haneslinger in #3740
• Sort column mappings in profile before export by @nllong in #3748
• Update derived column migration to prevent conflicting column names and prevent duplicate column names by @nllong in #3728
• Fixed issue with overlapping meter readings with new ESPM format by @anchapin in #3745
• Fix filtering on "" and !"" for all data types by @haneslinger in #3765
• Fix bug where compliance calculations were not being cast to the right data types by @nllong in #3789

Full Changelog: https://github.com/SEED-platform/seed/compare/v2.17.0...v2.17.1

SEED Version 2.17.0

What's Changed

New Features 🎉

• Switch to created filter group after creation by @haneslinger in #3569
• Use the same color for each axis per filter group by @haneslinger in #3587
• Add 'ghg' and 'ghg_intensity' to 'valid_column_data_types' for Custom Report by @anchapin in #3570
• Add export column mappings by @nllong in #3611
• Allow filtering on all columns including related taxlots/properties by @haneslinger in #3618
• Add the ability to create multiple compliance programs by @anchapin in #3623
• Add create, update, retrieve, and delete to Meter API by @nllong in #3639
• Nav property on click in property insight page by @haneslinger in #3679

Improvements 📈

• Refactor meter selection by @haneslinger in #3649
• Disable sorting by derived column by @haneslinger in #3669
• Sort legend on custom reports by @haneslinger in #3671
• Fix legend by @haneslinger in #3682
• Add spinner to model deletion by @haneslinger in #3713
• Make sure the left and right axis have the same range by @haneslinger in #3695
• Enter edit mode state on any change in custom report by @kflemin in #3710
• Reorder the metric type drop down text in Program Configuration by @anchapin in #3719

Maintenance 🧹

• Output proper error message by @haneslinger in #3592
• Final version of the BPS sample data files by @anchapin in #3584
• Remove nosetests and fix precommit by @nllong in #3619
• BPS Data Final Updates by @anchapin in #3646
• Update ci and publish to use latest versions by @nllong in #3656
• Update contribution information and enforce PR labels by @nllong in #3654
• Update links for support by @nllong in #3681
• Refactor properties_across_cycles_with_filters so it only makes one P… by @haneslinger in #3674
• ESPM formatting changes by @anchapin in #3716

Bug Fixes 🐛

• Add error check for blank Actual Column in Program Setup by @anchapin in #3572
• Use the same column for the names used in Property Insights by @anchapin in #3578
• On FilterGroup delete, filter groups don't filter≈y by @haneslinger in #3596
• Update inventory reporting charts by @nllong in #3604
• Fix update labels and label selected by @haneslinger in #3615
• Fix ESPM get template with no children by @haneslinger in #3632
• Fix note's API result to not include related model's view ID by @nllong in #3635
• Apply label to only selected by @haneslinger in #3637
• Update alt text, remove metric from program by @nllong in #3647
• Fix filtering on other inventory type by @haneslinger in #3658
• Fix swagger loading the Meter endpoints by @nllong in #3666
• Fix tooltip in insights legend by @haneslinger in #3678
• Support import of a csv file that has lots of spaces by @nllong in #3680
• Fix SEED to work with updated ESPM API, remove SEED ESPM API v2.1 by @nllong in #3709
• Fix evaluate request by @haneslinger in #3699
• Fix switching filter group by @haneslinger in #3702
• Delete Derived Columns Before Org by @axelstudios in #3700
• Fix #VALUE! errors when importing xlsx files by @nllong in #3685
• Update the BPS Sample Data AT Files by @anchapin in #3711
• Fix issue with evaluating compliance metric by @anchapin in #3715

Other Changes

• Bump django from 3.2.15 to 3.2.16 in /requirements by @dependabot in #3622
• Remove use of campus on the property model by @nllong in #3614
• Fix permissions for viewers to see program overview by @haneslinger in #3620
• Return only need columns in compliance evaluate by @haneslinger in #3664

Full Changelog: https://github.com/SEED-platform/seed/compare/v2.16.0...v2.17.0

SEED Version 2.16.0

This release contains new functionality to help track building-portfolio programs such as Benchmarking and basic-Building Performance Standards. In order to track programs, SEED was updated with a program configuration page with the selection of two metrics to track (an energy and emissions metric). The tracking requires an actual and a goal column to be defined allowing the program to determine if a property is in compliance.

A new program insight page was created to allow easy visualization over the compliance periods. In addition, new backend functionality was created for "filter groups" allowing for a user to save a set of labels and filters into a recallable filter group. The filter groups can be then aggregated with sums, averages, etc., and plotted on a custom report page.

Lastly, the new changelog format comes directly from GitHub now, removing the need to run the custom GitHub script.

What's Changed

New Features 🎉

• Add filter groups to insight page by @haneslinger in #3505
• Add GHG and GHG Intensity units by @Ryoken in #3518
• Data insight view format and usability improvements by @aviveiros11 in #3519
• Enable ability to not map a column in SEED by @haneslinger in #3523
• Program metric and insights pages by @kflemin in #3521
• BPS insights development by @haneslinger in #3546
• Program metric UI improvements by @aviveiros11 in #3542
• Implement Program Setup Page by @anchapin in #3541
• Add simple export buttons to charts by @haneslinger in #3561
• Switch to created filter group after creation by @haneslinger in #3569
• Use the same color for each axis per filter group by @haneslinger in #3587
• Add 'ghg' and 'ghg_intensity' to 'valid_column_data_types' for Custom Report by @anchapin in #3570
• Add export column mappings by @nllong in #3611
• Allow filtering on all columns including related taxlots/properties by @haneslinger in #3618
• Add the ability to create multiple compliance programs by @anchapin in #3623
• Add create, update, retrieve, and delete to Meter API by @nllong in #3639

Maintenance

• Update report charts to use Charts.js by @kflemin in #3368
• Add translations to BETTER Analysis helper text by @anchapin in #3562
• Add missing Lokalize tags by @aviveiros11 in #3563
• Fix Typos by @axelstudios in #3564
• Output proper error message by @haneslinger in #3592
• Final version of the BPS sample data files by @anchapin in #3584
• Remove nosetests and fix precommit by @nllong in #3619
• BPS Data Final Updates by @anchapin in #3646

Bug Fixes

• Fix only collect columns that aren't related by @Ryoken in #3515
• Revised the Custom Reports page to remove custom report from list after deletion by @anchapin in #3522
• Fix null x axis by @kflemin in #3543
• Fix SEED logo focus by @axelstudios in #3547
• Fix auto-populate scrollbars by @axelstudios in #3549
• Fix navigation gaps by @axelstudios in #3550
• Add tzdata dependency to docker images by @axelstudios in #3548
• Add 'string' data type to valid column data types in Program Setup by @anchapin in #3560
• Force utility spinner and refresh to update chart by @aviveiros11 in #3540
• Add error check for blank Actual Column in Program Setup by @anchapin in #3572
• Use the same column for the names used in Property Insights by @anchapin in #3578
• On FilterGroup delete, filter groups don't filter≈y by @haneslinger in #3596
• Update inventory reporting charts by @nllong in #3604
• Fix update labels and label selected by @haneslinger in #3615
• Fix ESPM get template with no children by @haneslinger in #3632
• Fix note's API result to not include related model's view ID by @nllong in #3635
• Apply label to only selected by @haneslinger in #3637
• Update alt text, remove metric from program by @nllong in #3647

Other Changes

• Remove use of campus on the property model by @nllong in #3614
• Fix permissions for viewers to see program overview by @haneslinger in #3620

Full Changelog: https://github.com/SEED-platform/seed/compare/v2.15.2...v2.16.0

SEED Version 2.15.2

Date Range: 07/20/22 - 09/08/22

Closed Issues and Features (Total: 15):

• Fixed #2843, BETTER - GHG emission reduction units
• Fixed #2885, Add indication of whether or not property has meters to inventory list
• Fixed #2953, BETTER: allow user to specify meter data to use for analysis
• Feature #3299, Include Units for CO2 Analysis Results
• Feature #3315, Create manage.py task to report backlog of celery tasks on an instance of SEED
• Fixed #3327, Resolve Cloudflare error when loading Sensor data by moving to background task
• Feature #3373, Enable customizable Postgres host in Docker files
• Improved #3374, Add helper text to Audit Template settings
• Fixed #3392, Fix error filtering doubles as strings
• Fixed #3425, AT Validation Broken
• Fixed #3444, Add "(Beta)" to summary tab
• Fixed #3484, Fix meters import failing with non-string operation
• Fixed #3507, Only return a max of 10 history on properties and taxlot details
• Maintenance #3508, Upgrade to Django 3.2.15
• Fixed #3510, New inventory list view breaks if ComStock functionality is enabled

SEED Version 2.15.1

This is a quick patch release to address a few issues experienced by users after rolling onto production.

Date Range: 07/18/22 - 07/19/22

Closed Issues and Features (Total: 5):

• Fixed #3390, Fix the Tax Lot tab not displaying data from Property List and Property Tab not displaying Tax Lot data
• Feature #3393, Control the number of decimal points being displayed in derived columns
• Fixed #3394, Fix when selecting delete doesn't delete records in new view
• Fixed #3401, Fix breaking query on Property List
• Feature #3402, Make "From" address in password-reset emails configurable when using Docker

SEED Version 2.15.0

Date Range: 04/01/22 - 07/17/22

Closed Issues and Features (Total: 61):

• Fixed #1601, Improve performance moving between different views (Detail to List, etc)
• Feature #1754, Attach PDF (or other files) to a building record
• Fixed #2685, Meter data can't be shown by month
• Feature #2760, Allow derived column definitions and parameters to be used in multiple derived column definitions
• Feature #2868, Add Run ID to fields in Property List and Detail view with BETTER
• Maintenance #3029, Clean up Prod MEDIA directory
• Fixed #3078, Add ability to import data loggers and sensors for a property
• Maintenance #3079, Run WAVA and address issues
• Fixed #3106, Implement container backup on production site
• Fixed #3133, Create Sensor Model Tab
• Fixed #3136, Create Sensor Readings
• Fixed #3146, Extra Data Fields: Need to be able to specify number of decimal points
• Fixed #3154, Add DataLogger concept
• Fixed #3174, Add canonical GHG fields
• Fixed #3175, Store results of carbon analysis into SEED db-based fields
• Feature #3178, BETTER: Retrieve R2 analysis value from API request and display it in the BETTER results in SEED
• Feature #3185, Derived Fields should be able to be moved anywhere in the Inventory List, not just at the end
• Fixed #3188, Letter spacing for some derived columns is odd in Inventory List
• Fixed #3193, Add email template help text on top of page
• Fixed #3199, Improve the ESPM data import process
• Feature #3200, BuildingSync Asset Extractor Integration
• Maintenance #3205, Update lxml to 4.7.1
• Fixed #3207, Disable showing measures and scenarios on tax lot page
• Feature #3209, Add export functionality for dataloggers and sensors
• Feature #3216, Add description field to columns
• Fixed #3218, Add inventory action to "touch" record - refresh metadata
• Fixed #3219, Integrate AT API to dynamically pull AT reports (via BuildingSync) into SEED
• Fixed #3221, Inject multiple cycles of the BPS data, determine how to view across cycles
• Fixed #3223, Generate example data set for use in BPS
• Maintenance #3231, Format all python code using precommit
• Fixed #3233, Create A Data Logger "Dismiss" button doesn't close the window if there is no data entered
• Fixed #3236, Error trying to upload sensor data due to datetime field
• Fixed #3243, Add timezone to property state
• Fixed #3248, Remove print statements from BAE
• Fixed #3253, Verify if Inventory List is pulling all the property states
• Fixed #3256, Refactor Layout of Inventory-Beta "Filter By Label" and "Current Filters"
• Fixed #3269, Unifying export functionality between Actions->Export and Hamburger Menu on UI Grid
• Maintenance #3275, Fix readthedocs as it is not generating the same documentation as local builds of the documentation
• Fixed #3277, Accountability hierarchy rough technical specification
• Fixed #3279, Sensor Action buttons text is being truncated
• Feature #3280, Sensors: Add more fields to Data Loggers section
• Fixed #3281, Sensor Export: Data Logger field is missing + field name tweaks
• Feature #3287, Add ability to API to filter property/labels by label names
• Feature [#3291]]( #3291 ), Add "Show in List" to Inventory List view
• Feature #3295, Column Description Field: Make larger, maybe memo box
• Feature #3300, Add Emmissions Intensity to Analysis Results
• Feature #3308, Add Audit Template Building ID to Audit Template Building Sync import
• Feature #3313, Add property search on exact result match
• Feature #3316, Add --pyseed argument to create_test_user_json managed task
• Maintenance #3318, Push latest docker images as well as version tagged images when releasing
• Fixed #3324, Importing Sensor Meta Data only imports one column name field -- timestamp
• Fixed #3325, Fix of duplicate BETTER GHG Fields
• Feature #3335, Add new BAE assets
• Fixed #3338, Sensors: Can't dismiss Create a Data Logger modal when it's empty
• Fixed #3343, Analysis results slow to load when connected to lots of properties
• Maintenance #3352, Bump version of lxml to 4.9.1
• Fixed #3357, Data Quality displays duplicate derived columns
• Maintenance #3362, Upgrade to Django 3.2.14
• Fixed #3366, Make beta properties list page the default (and move previous to Legacy)
• Fixed #3382, Replace Raven with Sentry-sdk
• Feature #3386, Add protocol to env var

SEED Version 2.14.0

Date Range: 12/27/21 - 03/31/22

Closed Issues and Features (Total: 46):

• Fixed #2508, Inventory Detail View: Text bubbles stay on the screen even if you scroll down the page
• Fixed #2515, Progress bar sits on 33% for a very long time so that users think the program has crashed
• Feature #2624, Merge and Link Matches - Enable and Change Sorting
• Fixed #2683, Meter screen shows intervals for meters that are "unselected"
• Feature #2761, Derived Columns: Many small improvements
• Feature #2806, Summarize the count for each of the columns from the "Columns Setting" Tab in the Property Tab
• Improved #2813, Update Portfolio Manager Defaults column mapping profile
• Fixed #2831, Deleting Property Inventory doesn't delete the BETTER analyses
• Fixed #2843, BETTER - GHG emission reduction units
• Feature #2844, BETTER -- show a list of all buildings in Org/Analyses, not just grouped by Portfolio
• Fixed #2891, Fix deprecated urls
• Fixed #2892, Fix usage of deprecated method request.is_ajax()
• Fixed #2902, XMLSchema fails to fetch gbXML Schema
• Fixed #2947, BETTER: update endpoint for token validity check
• Fixed #2959, BuildingSync: add matching/linking for imported files
• Fixed #2962, BSyncr: Analysis results link back to properties doesn't work
• Fixed #2974, Derived Columns: add ability to specify decimal places for individual columns
• Feature #2976, Export Properties and Tax Lots Progress Bar
• Feature #2998, Geocoding -- allow user to specify field to appear in text associated with map pin
• Maintenance #3020, Backup prod postgres docker volume
• Fixed #3040, Refactor list API to make adding related data optional
• Feature #3041, Add server-side filtering for canonical columns
• Feature #3042, Add server-side filtering for extra data columns
• Feature #3044, Add server-side filtering by labels
• Feature #3045, Add server-side sorting for inventory list
• Feature #3046, Frontend: enable actions for current page and across entire result set (for inventory list BETA page)
• Feature #3047, Add frontend functionality for filtering on canonical columns
• Feature #3048, Add frontend filtering for extra data columns
• Feature #3049, Add frontend filtering of inventory by labels
• Improved #3052, Update functionality of top right nav shortcut
• Maintenance #3062, Remove warnings from tests
• Fixed #3071, bug: saved filter/sort results in multiple initial queries
• Fixed #3073, Refactor Beta-Inventory List Filters View
• Maintenance #3079, Run WAVA and address issues
• Fixed #3081, refactor: move filtering of querysets into generalized function
• Fixed #3093, refactor: enable inventory /filter endpoints to return only IDs
• Fixed #3094, refactor(frontend): fetch all inventory IDs when an action is performed when user does a "select all"
• Fixed #3095, Fix the test using vcr
• Maintenance #3096, chore: update celery to 5.2.2
• Fixed #3108, refactor(buildingsync): use consistent scenario/measure/meter merge logic
• Feature #3126, Upload Portfolio Manager Meter Readings -- allow data shown on that screen to be exported
• Feature #3127, Portfolio Manager Meter Import Results -- add count of Properties + count of meters
• Feature #3128, Data Sets feedback on number of records for meters -- right now it says 0
• Fixed #3130, Org: Settings: Default Display Fields -- doesn't work for all fields
• Improved #3132, Update the Getting Started PDF for 2.13.0 release
• Fixed #3140, Redirect to home on 404s
• Fixed #3163, Recognize Empty not working as intended

SEED Version 2.13.0

Date Range: 11/20/21 - 12/27/21

Closed Issues and Features (Total: 17):

• Fixed #2702, Add sample data record for BETTER
• Fixed #2813, Update Portfolio Manager Defaults column mapping profile
• Fixed #2890, Update deprecated JSONFields
• Fixed #2902, XMLSchema fails to fetch gbXML Schema
• Fixed #2930, BuildingSync: improve UI/UX for post-mapping messages
• Fixed #2958, Improve progress data text when validating BuildingSync files
• Fixed #2960, BuildingSync: allow users to export warnings/errors when importing data
• Fixed #2999, Bug: property details "notes" tab breaks links
• Fixed #3018, Delete column timeout
• Fixed #3027, Configure OEP k8s
• Fixed #3028, Fix: electricity meter import from ESPM custom report
• Fixed #3034, RFC: begin using python 3 type hints in codebase
• Fixed #3039, Create new inventory list
• Fixed #3040, Refactor list API to make adding related data

SEED Version 2.12.4

Date Range: 11/11/21 - 11/19/21

Closed Issues and Features (Total: 2):

• Fixed #2822, Create documentation for running BETTER analysis
• Fixed #3014, Analysis: include Meter source 'Electric - Unknown' in analysis

SEED Version 2.12.3

Date Range: 11/05/21 - 11/10/21

Closed Issues and Features (Total: 7):

• Fixed #2702, Add sample data record for BETTER
• Fixed #2930, BuildingSync: improve UI/UX for post-mapping messages
• Fixed #2945, Deprecate PropertyState's analysis_state field
• Fixed #2958, Improve progress data text when validating BuildingSync files
• Fixed #2997, CO2 Analysis -- eGRID Subregion Code not picked up by program
• Fixed #2999, Bug: property details "notes" tab breaks links
• Fixed #3001, Tax Lot Inventory List View -- clicking on "i" to get to Detail view generates erro

SEED Version 2.12.2

Date Range: 09/28/21 - 11/04/21

Closed Issues and Features (Total: 36):

• Feature #2524, Export CSV -- Need a status bar or spinner or something to indicate that program is still working
• Feature #2557, Create Analyses Section
• Fixed #2587, Add admin tools
• Fixed #2651, Analysis and Merge/Link Matches on Property Detail view on production server (and shouldn't be)
• Fixed #2751, Update EKS Kubernetes version to 1.18
• Maintenance #2787, Move to BETTER Production API
• Fixed #2810, Bug: check meters tab on spreadsheet is broken
• Fixed #2830, Write tests for updated Audit Template import
• Feature #2840, BETTER - show which records had 0 savings in the Analyses view
• Fixed #2871, Analysis detail page trying to fetch bad pages
• Feature #2872, Create eGRID emissions analysis
• Fixed #2877, Tweak EUI Analysis
• Fixed #2884, Remove usage of address line 1 in BETTER analysis
• Fixed #2886, Update values parsed from BETTER analysis
• Fixed #2898, Update "contact us" mailto for the maintenance page
• Fixed #2899, v2.11 fails to load page after login
• Maintenance #2908, Bump BETTER BSync version to v2.3
• Fixed #2913, After importing Meter Data, program shows the previous Mapping screen
• Fixed #2917, BETTER: fails to create Buildings (too many meters?)
• Feature #2921, Analyses: Add a Creation Date to analyses
• Fixed #2924, [10-14-2021] Update staging:
• Fixed #2925, update priority spreadsheet
• Fixed #2926, move remaining BETTER tasks from spreadsheet into tickets
• Fixed #2928, BETTER: display building report above portfolio report
• Fixed #2929, BuildingSync: improve UI/UX for initial validation
• Fixed #2936, Remove old members from LBL AWS
• Fixed #2938, BuildingSync: add v2.4 to SEED
• Fixed #2944, release: v2.12.1 patch -- fix reset password url
• Fixed #2956, EKS RBAC Roles
• Fixed #2961, BuildingSync: ignore scenarios without meters or measures
• Fixed #2963, Columns: create eGRID Subregion Code column
• Fixed #2965, Add database/mediafiles backup to dev1
• Fixed #2969, Analysis: use organization's "Property Display Field" in analysis tables
• Fixed #2987, Analysis: indicate analysis functionality is BETA

SEED Version 2.12.1

Minor patch to fix resetting passwords.

Closed Issues:

• Fixed #2941, Password reset error

SEED Version 2.12.0

Date Range: 06/22/21 - 09/27/21

Closed Issues and Features (Total: 65):

• Fixed #869, Make import of Portfolio Manager Monthly meter data one step and include mapping
• Fixed #1962, Update data upload dialog with icons (or better text)
• Maintenance #2379, Refactor perms for several API v3 views
• Fixed #2433, Upgrade dependencies, python 3.9
• Fixed #2490, Update Python dependencies to re-enable Python package installation
• Feature #2511, Inventory List: Hover over the notes icon and see the notes
• Feature #2535, BSyncr Analysis results should render image results when available
• Fixed #2574, eui and area columns don't respect filter syntax
• Fixed #2654, Report on user adoption
• Fixed #2656, Django version 3.0 upgrade
• Fixed #2659, Add sample data record for BSync
• Feature #2660, Data Analysis (Statistics)
• Fixed #2674, Fix unit conversions between ESPM and SEED
• Fixed #2693, BuildingSync: allow bsync to import all current and future v2 docs
• Fixed #2696, BuildingSync: handling auc:ResourceUses with no auc:EnergyResource
• Maintenance #2723, BuildingSync Selection Tool API Update
• Fixed #2728, Fix post_office email backend
• Fixed #2734, Bump Django from 3.1 to 3.2
• Maintenance #2737, Bump Django from 3.0 to 3.1
• Feature #2739, Add EUI analysis
• Feature #2740, Add ability for users to view analysis results in inventory list view
• Fixed #2743, Test round-trip of BSync with Audit Template and SEED
• Fixed #2748, Inventory list: labels appear broken when viewing few columns
• Fixed #2749, Derived columns: Moving derived column in inventory list clears non-derived columns from column profile
• Improved #2752, Allow ESPM property types to be used
• Improved #2753, Allow all BETTER supported meter types to be used in SEED
• Improved #2757, User-facing errors from BETTER analysis should be informative
• Feature #2759, Embed BETTER results in SEED page
• Feature #2768, [stretch] Add BETTER portfolio analysis
• Feature #2769, Add batch analysis capability
• Feature #2770, [stretch] Add analysis results to original inventory PropertyState
• Feature #2778, Update fields that are saved into PropertyState from BETTER analysis building results
• Feature #2779, Add org-level setting for BETTER API token
• Fixed #2786, Fix square footage encoding/decoding
• Fixed #2790, Inventory List columns disappear in Column List Profile after hiding a field in the list view
• Fixed #2794, Derived columns request too large
• Improved #2801, Cleanup configuration display on the analysis summary UI.
• Improved #2802, The default value for the r^2 user input should be 0.6
• Improved #2803, HTML links for download should have more meaningful descriptions.
• Fixed #2807, Don't download BETTER pages that should be in iframe
• Fixed #2814, AT BSync import error
• Improved #2816, Users have to refresh analyses pages to get updated status
• Fixed #2818, Bad display for config for analysis run
• Improved #2828, Parse meter readings from Audit Template file
• Improved #2834, BETTER Results -- round the values to match the BETTER report
• Improved #2835, BETTER Reports - Units are defaulting to SI - Can they be set to either SI or IP?
• Improved #2836, BETTER -- HTML report sometimes has left logo overlapping the report title
• Improved #2837, BETTER -- run analysis immediately
• Improved #2838, BETTER -- Setting up analysis parameters - make default R2 an actual value
• Improved #2839, BETTER -- Portfolio Report Cost Savings units are % not USD
• Feature #2841, BETTER - Easy access to analysis report
• Feature #2842, BETTER -- Add PM Property ID as link in the Analyses sections
• Feature #2846, BETTER - Pin most recent BETTER analysis to top
• Maintenance #2858, CI: don't run tests on push for non-main branches
• Improved #2863, Make analyses page more easily accessible
• Improved #2864, Add dollar sign to cost savings
• Fixed #2865, Remove obj/dict/hash content from analysis card on inventory detail page
• Fixed #2867, Fix failing analysis tests
• Fixed #2873, Analysis cards show most recent highlights
• Fixed #2880, Data quality rule creation fails when label is added
• Fixed #2882, Recaptcha fails with local docker deployment
• Maintenance #2900, TypeError: the JSON object must be str, bytes or bytearray, not dict
• Fixed #2903, Analysis page fails to update analysis status after a step is "completed"
• Fixed #2904, Unable to run BSyncr analysis
• Feature #2910, Promote BETTER URL to a config setting

SEED Version 2.11.0

Date Range: 3/31/2021 - 5/22/21

Closed Issues and Features (Total: 42):

• Fixed #111, DataError: value too long for type character varying(255)
• Fixed #146, Remove S3 requirement
• Fixed #197, Implement generic XML import capability
• Fixed #653, Report the total number of records imported at the end of data upload
• Fixed #731, It is possible to create two datasets with the same name
• Fixed #851, Improve documentation about AWS configuration
• Fixed #881, Update wiki contributor guidelines
• Fixed #1338, Add the option to identify multiple fields within the same file for the same matching field
• Fixed #1589, Verify Permissions
• Fixed #1595, Update deployment documentation
• Feature #1642, Data Analysis: Ability to define new calculated fields based on existing data
• Feature #1643, Add ability for users to display labels and allow which labels to see in the list view
• Fixed #1657, Error Deleting Organization as Superuser
• Feature #1757, Add ability to filter on Notes
• Fixed #2093, List View Export from Actions menu contains history records, not just master
• Feature #2514, Add ability to download the originally imported file
• Maintenance #2536, Portfolio Manager import fails with TypeError
• Fixed #2629, Delete cycles does not work for non-default org
• Fixed #2637, SES Signature v3 is deprecated
• Fixed #2650, Defect template (added scope and console errors)
• Maintenance #2653, Audit/Trim down open tickets.
• Feature #2657, BETTER integration
• Maintenance #2662, Integrate stale-bot
• Maintenance #2663, questions for SEED users/platform developers
• Maintenance #2664, reach out to SF, Berkeley, Open, Clearly, and GB.
• Maintenance #2666, Fix bsync measures import
• Fixed #2671, Bug Template
• Improved #2673, Import data request meter data
• Maintenance #2677, Multiple visual org member permissions issues
• Fixed #2680, Update installed timescale extensions
• Feature #2681, Auto Populate Data -- I need the info about the data AFTER I upload it
• Maintenance #2684, Test new BuildingSync's unique ScenarioName unique
• Improved #2689, BuildingSync: default auc:Recommended to True
• Feature #2690, BuildingSync: parse auc:AnnualPeakElectricityReduction
• Improved #2691, BuildingSync: parse units for meter data
• Improved #2692, BuildingSync: parse additional auc:Measure fields
• Improved #2694, BuildingSync: returns None for is_virtual when ScenarioType is not PackageOfMeasures
• Improved #2695, BuildingSync: how to handle timeseries that isn't monthly meter data
• Feature #2709, Derived Columns: allow users to create/edit/delete derived columns
• Feature #2710, Derived Columns: users can view derived column results in inventory list view
• Feature #2711, Derived Columns: users can create data quality checks based on derived columns
• Feature #2717, Derived Columns: users can export derived column results

SEED Version 2.10.0

Date Range: 12/28/20 - 3/31/2021

Closed Issues and Features (Total: 54):

• Feature #1113, Delete Cycle
• Feature #1753, Add header file to show the filter criteria
• Fixed #2019, Geocoding confidence values have changed between versions
• Feature #2104, Add settings for emails sent out when an Org adds a new member
• Fixed #2237, Geocoding broken pipe error
• Fixed #2374, Import spreadsheets without a raw header results in an error
• Maintenance #2379, Refactor perms for several API v3 views
• Fixed #2410, Merge and Link Matches -- didn't seem to merge records that should have merged
• Maintenance #2432, Migrate production to helm and upgrade to latest approved version
• Fixed #2434, Ensure Sentry is working on all of our instances
• Feature #2440, Add API v3 endpoints /analyses GET and /analyses/{id}/ GET
• Feature #2455, Implement front-end for Analyses summary page for Property
• Feature #2456, Implement front-end for Analyses summary page for Organization
• Fixed #2470, Add nginx/uwsgi protections for oserrors and ioerrors
• Feature #2474, Implement UI/UX for taking the "Run Analysis" action on the property detail page
• Fixed #2476, Add API v3 endpoint /analyses/{analysis_id} - DELETE
• Fixed #2478, Add API v3 endpoint /analyses/{analysis_id}/stop - POST and create BSyncr stop analysis task
• Fixed #2493, PropertyState hash bug
• Fixed #2496, Duplicate states can be created if the unit selection is empty
• Fixed #2504, 504 error importing XLSX file with field set to "Currency"
• Feature #2507, DQ Rules - sorts alphabetically by field as you are creating the rule, and then you can't find it
• Improved #2509, Inventory List: Have a sort and/or filter for Notes icon
• Feature #2512, Inventory Detail: Allow the user to set the field that is displayed for the record
• Fixed #2518, Inventory List export includes Notes on multiple lines in between records
• Fixed #2519, Labels are not always exported from Inventory List
• Feature #2533, Allow configuration of the bsyncr analysis to handle different model types
• Improved #2534, BSyncr tasks should handle and pass along model type to server, then handle corresponding output
• Feature #2538, Allow users to self register
• Feature #2539, Each user should have their own organization
• Improved #2541, Links on About page should open separate tab
• Feature #2542, Organization owners can delete their own organization
• Feature #2543, nginx should render a more user-friendly page if SEED is offline.
• Fixed #2546, IntegrityError: duplicate key value violates unique constraint "seed_propertyview_property_id_f8bdf6c2_uniq"
• Fixed #2548, 500 errors can be triggered on some endpoints
• Fixed #2549, Mapping status at 0% even though file successfully imported
• Fixed #2550, Mapping/Matching finished but status bar never got above 0% complete
• Fixed #2553, DataError: Invalid data found: value too long for type character varying(255)
• Improved #2558, API returns DRF html pages if you're not logged in
• Fixed #2562, Excel removes leading zeros in field exported from SEED
• Maintenance #2571, Update OEP to use GH actions to build docker containers
• Maintenance #2576, Deprecate v2 endpoints
• Feature #2577, Add notes count to appear in rows
• Improved #2592, New User Improvements: Update Landing Page
• Feature #2594, New User Improvements: Develop FAQ Page
• Feature #2595, New User Improvements: Update Sample Data
• Improved #2596, Add warning to swagger endpoints for *views and *states
• Feature #2601, Push new field to Salesforce through OEP
• Improved #2602, Update OEP to use Version 3 of SEED API
• Fixed #2603, Deleting a column can crash SEED due to the memory spiking
• Maintenance #2610, Find and replace all occurrences of Master on the frontend
• Feature #2611, Admin functionality to force reset password for all users
• Fixed #2626, Authorize /media file requests
• Improved #2627, Reimplement ToS - "By creating an account, signing in, and using the website, you're agreeing to the..."
• Fixed #2634, Error on importing xlsx with empty first sheet

SEED Version 2.9.5

Minor patch to:

• Bump boto3 for security patch
• Most recent version of OEP which leverages SEED's v3 API

SEED Version 2.9.4

Minor patch that fixes access to inventory list page for organization user's with role "viewer".

Closed:

• Fix #2669, Fix org viewer perms

SEED Version 2.9.3

Minor patch that adds an option to exclude notes when exporting a list of properties.

Closed:

• Feature #2518, Inventory List export includes Notes on multiple lines in between records

SEED Version 2.9.2

This is a patch to update deployments with a filter functionality fix.

SEED Version 2.9.1

This is a patch to update deployments with a 255 character data error and progress bar fix.

SEED Version 2.9.0

Date Range: 09/25/20 - 12/28/20

Closed Issues and Features (Total: 70):

• Feature #1647, Add Cycle to various views to help user remember what cycle the file was imported under
• Improved #1869, Geocoding -- allow user to "uncheck" geocoding without deleting API key
• Feature #1904, Add ability to delete extra data columns in Column Settings
• Feature #1966, Create docker container to store all log data
• Fixed #1978, MapQuest API key error UX
• Feature #2047, Provide dedicated Tax Lot Map page
• Fixed #2079, Gateway timeout (504) importing a file with 120,000+ records
• Fixed #2092, Extra label showing up in Tax Lot export
• Fixed #2203, Dq admin page does not prevent duplicate rules
• Fixed #2206, Minimum value box not populated if data type is not defined by DATA_TYPES in data quality model
• Fixed #2207, Data Quality admin page only reports the first error message when multiple errors are detected
• Fixed #2215, Blank option for Inventory Type when SEED HEADER is "blank"
• Fixed #2237, Geocoding broken pipe error
• Feature #2301, Frontend uses API v3 - Properties v2
• Feature #2302, Frontend uses API v3 - Organizations
• Feature #2303, Frontend uses API v3 - TaxLots v2
• Feature #2304, Frontend uses API v3 - ImportFiles
• Feature #2305, Frontend uses API v3 - Users
• Feature #2306, Frontend uses API v3 - Columns
• Feature #2307, Frontend uses API v3 - Labels
• Feature #2308, Frontend uses API v3 - Data Quality
• Feature #2309, Frontend uses API v3 - ColumnMappings
• Feature #2310, Frontend uses API v3 - Datasets
• Feature #2311, Frontend uses API v3 - Cycles
• Feature #2312, Frontend uses API v3 - ColumnListProfiles
• Feature #2313, Frontend uses API v3 - Meters
• Feature #2314, Frontend uses API v3 - ColumnMappingProfiles
• Feature #2316, Frontend uses API v3 - Geocode
• Feature #2317, Frontend uses API v3 - BuildingFiles
• Feature #2318, Frontend uses API v3 - Upload and Progress
• Feature #2319, Frontend uses API v3 - UBID and PM import
• Feature #2320, Frontend uses API v3 - Version, Scenarios, TaxLotProperties export
• Feature #2321, Frontend uses API v3 - Report Data
• Feature #2322, Frontend uses API v3 - TaxLots Notes v2.1
• Feature #2323, Frontend uses API v3 - Properties v2.1
• Fixed #2327, Unit-aware columns had display names appended with display units
• Fixed #2330, Mapping: Decimal points and sorting should work the same for units "aware" vs "non-aware" fields
• Fixed #2331, Rename column mapping presets to column mapping profile
• Fixed #2333, Value changes for area or EUI fields on hand-edits if org has non-default display settings
• Fixed #2335, Rename column list settings to column list profiles
• Fixed #2344, Non-default measurement units for unit-aware columns are ignored during mapping.
• Fixed #2345, Hand-edit saves without changes results in a 500 being thrown
• Fixed #2370, Fix property detail page export as BuildingSync Excel
• Fixed #2384, PM import record of one property returns 400 status
• Feature #2395, Add tooltips to Inventory List icons
• Fixed #2397, DQ - failed to update/save rules after deleting duplicate rules
• Feature #2414, Organizations: Column Mapping: Add sort and filter functionality
• Fixed #2418, Swagger page typos in descriptions because text is taken as HTML vs plain text.
• Fixed #2434, Ensure Sentry is working on all of our instances
• Feature #2437, Build Analysis Model and Migration
• Feature #2438, Build AnalysisRun Model and Migration
• Feature #2439, Build AnalysisFile Model and Migration
• Feature #2440, Add API v3 endpoints /analyses GET and /analyses/{id}/ GET
• Feature #2442, Add API v3 endpoints /analyses/{analysis_id}/views GET and /analyses/{analysis_id}/views/{analysis_property_view_id} - GET
• Feature #2451, Define background task for creating Analysis, AnalysisPropertyView, etc.
• Feature #2455, Implement front-end for Analyses summary page for Property
• Feature #2456, Implement front-end for Analyses summary page for Organization
• Improved #2461, Upgrade OEP to Version 1.6
• Feature #2466, Update Analysis-related models
• Feature #2474, Implement UI/UX for taking the "Run Analysis" action on the property detail page
• Feature #2475, Add API v3 endpoint /analyses - POST
• Feature #2477, Add API v3 endpoint /analyses/{analysis_id}/start - POST and create BSyncr start analysis task
• Feature #2479, Implement front-end for an individual Analysis Property View record (aka results page)
• Feature #2480, Implement front-end for an individual Analysis page
• Fixed #2496, Duplicate states can be created if the unit selection is empty
• Feature #2499, User can create and kick off an Analysis for an individual property
• Feature #2500, User can view a list of all analyses created for an individual property
• Feature #2501, User can view an individual property's single analysis results
• Feature #2502, User can view a list of all analyses created for an organization
• Feature #2503, User views an Analysis detail page (not property specific)

SEED Version 2.8.2

This is a patch to bring the 2.7.6 hotfix into 2.8.1, repeated below.

• Fixed #2496, Duplicate states can be created if the unit selection is empty

SEED Version 2.8.1

This is a patch to bring the 2.7.5 hotfix into 2.8.0, repeated below.

• Fixed #2469, Error deduplicating raw col objs
• Fixed #2470, Add nginx/uwsgi protections for oserrors and ioerrors
• Fixed #2471, During label application, require non-empty list for inventory_ids

SEED Version 2.8.0

SEED Version 2.8.0 includes an update to the SEED frontend that leverages the new API v3 on the backend. API V2.1 and prior are still available, but will be deprecated in the next 6 months (see the note in the SEED Version 2.7.2 section below).

Date Range: 07/23/20 - 09/25/20

Closed Issues and Features:

• Feature #1647, Add Cycle to various views to help user remember what cycle the file was imported under
• Feature #1904, Add ability to delete extra data columns in Column Settings
• Fixed #1985, Reconcile SEED with BSync file for Audit Template Tool compatibility
• Feature #2047, Provide dedicated Tax Lot Map page
• Fixed #2138, BuildingSync and Audit Template Tool upload/download round trip
• Fixed #2164, Update label get_is_applied to support OEP
• Fixed #2203, Dq admin page does not prevent duplicate rules
• Fixed #2206, Minimum value box not populated if data type is not defined by DATA_TYPES in data quality model
• Fixed #2207, Data Quality admin page only reports the first error message when multiple errors are detected
• Fixed #2208, Data Quality tests
• Feature #2242, ComStock Support
• Fixed #2245, Integrate BuildingSync Selection Tool's Use Case API
• Feature #2301, Frontend uses API v3 - Properties v2
• Feature #2302, Frontend uses API v3 - Organizations
• Feature #2303, Frontend uses API v3 - TaxLots v2
• Feature #2304, Frontend uses API v3 - ImportFiles
• Feature #2305, Frontend uses API v3 - Users
• Feature #2306, Frontend uses API v3 - Columns
• Feature #2307, Frontend uses API v3 - Labels
• Feature #2309, Frontend uses API v3 - ColumnMappings
• Feature #2308, Frontend uses API v3 - Data Quality
• Feature #2310, Frontend uses API v3 - Datasets
• Feature #2311, Frontend uses API v3 - Cycles
• Feature #2312, Frontend uses API v3 - ColumnListProfiles
• Feature #2313, Frontend uses API v3 - Meters
• Feature #2314, Frontend uses API v3 - ColumnMappingProfiles
• Feature #2315, Frontend uses API v3 - Measures
• Feature #2316, Frontend uses API v3 - Geocode
• Feature #2317, Frontend uses API v3 - BuildingFiles
• Feature #2318, Frontend uses API v3 - Upload and Progress
• Feature #2319, Frontend uses API v3 - UBID and PM import
• Feature #2320, Frontend uses API v3 - Version, Scenarios, TaxLotProperties export
• Feature #2321, Frontend uses API v3 - Report Data
• Feature #2322, Frontend uses API v3 - TaxLots Notes v2.1
• Feature #2323, Frontend uses API v3 - Properties v2.1
• Fixed #2330, Mapping: Decimal points and sorting should work the same for units "aware" vs "non-aware" fields
• Fixed #2331, Rename column mapping presets to column mapping profile
• Fixed #2333, Value changes for area or EUI fields on hand-edits if org has non-default display settings
• Fixed #2335, Rename column mapping presets to column mapping profile
• Fixed #2344, Non-default measurement units for unit-aware columns are ignored during mapping.
• Fixed #2345, Hand-edit saves without changes results in a 500 being thrown
• Fixed #2370, Fix property detail page export as BuildingSync Excel
• Fixed #2371, Checking for duplicate fields is not working when only one Inventory Type is selected
• Fixed #2374, Import spreadsheets without a raw header results in an error
• Fixed #2382, Handle case where selection tool api is down for BuildingSync import
• Fixed #2384, PM import record of one property returns 400 status
• Fixed #2392, XLSX import of sample data hanging
• Fixed #2397, DQ - failed to update/save rules after deleting duplicate rules

SEED Version 2.7.7

• Fixed #2553, DataError for input over 255 chars

SEED Version 2.7.6

• Fixed #2496, Duplicate states can be created if the unit selection is empty

SEED Version 2.7.5

• Fixed #2469, Error deduplicating raw col objs
• Fixed #2470, Add nginx/uwsgi protections for oserrors and ioerrors
• Fixed #2471, During label application, require non-empty list for inventory_ids

SEED Version 2.7.4

This is a patch to update the deployment scripts for SEED. These changes did not result in any closed tickets.

SEED Version 2.7.3

• Fixed #2371, Checking for duplicate fields is not working when only one Inventory Type is selected

SEED Version 2.7.2

SEED Version 2.7.2 includes the introduction of API v3. This new API version will enable users to "Try" v3 endpoints using the Swagger page as well as improve on and consolidate previous API versions. Endpoints have been copied over from previous versions. Many were left as is - functionally remaining the same. Some were copied over and enhanced. Others were identified as no longer used or redundant; these are slated for deprecation and were not copied over at all.

The current list of endpoints slated for deprecation can be found here. Deprecation will occur with the deactivation of endpoints contained in API versions 2.1 and prior. The deprecation schedule will be released at a later date, but we recommend that users begin using API v3. For any questions or concerns, please reach out to the SEED team.

Date Range: 03/27/20 - 07/22/20

Closed Issues and Features:

• Improved #786, Save Changes button sequence in Data Cleansing Admin
• Feature #1369, DQ check - Add badge on each DQ admin tab (Property & Tax Lot) to indicate # of defined rules
• Feature #1591, Detail Screen: Highlight the changes in the columns
• Fixed #1614, Data Quality -- Not Null option needs refinement when there are multiple rule definitions for one field
• Fixed #1615, DQ Required vs Not Null
• Fixed #1675, Mapping to a field with units, that doesn't display the units, causes mapping to "hang"
• Improved #1716, Keep track of hand edits in Detail View
• Fixed #1847, Auto ESPM import -- criteria for duplicate records not being added
• Improved #1848, DQ Rules -- Add warning to save rules before leaving screen
• Fixed #1882, Filter operators ! and "" don't work on PM Generation Date
• Improved #1899, Import fields from BuildingSync reports
• Fixed #1932, BRICR upload/download
• Improved #1935, BuildingSync V2.0 Updates
• Fixed #1946, Meter data visible on some cycles but not all
• Fixed #1975, Tax Lot -specific merge check is inadvertently performed on properties
• Fixed #1983, Merging issue when Tax Lot data mapped differently
• Chore #1985, Reconcile SEED with BuildingSync file for Audit Template Tool compatibility
• Improved #1994, Store timeseries data from scenarios
• Improved #2020, DQ: Defining multiple rules for the same field is limited
• Feature #2024, Mapping: allow user to set up a mapping profile for a BuildingSync file
• Fixed #2066, Page not refreshed when switch menu tabs without saving changes and click on "stay on page"
• Fixed #2069, Selected Cycle not set on different inventory pages
• Feature #2082, Static SEED Webpage Development
• Fixed #2096, Meter import bug - postgres unique constraints removed from meterreading table
• Fixed #2098, Admin: Create User: Prevent adding an org with existing name
• Feature #2102, Add "Freeze Master Column" feature in Detail View
• Fixed #2105, Error message when editing in Detail view is incomprehensible
• Fixed #2114, Deleting a rule after saving previous changes does not reactive save buttons
• Fixed #2119, Re-enable created and updated fields for master records on the front end
• Improved #2121, User Testing for 2.7.0
• Fixed #2122, Uploading ESPM file as Spreadsheet, doesn't ignore header lines in file
• Improved #2127, Add functionality to see entire SEED HEADER field name in Mapping
• Improved #2131, Bricr-dev testing for potential merge into develop
• Feature #2134, Add new column setting to allow blank/'Not Available' values to overwrite other values
• Feature #2137, BuildingSync to handle v1.1 and v2.0
• Fixed #2139, Missing reverse match for password reset
• Fixed #2164, Update label get_is_applied to support OEP
• Improved #2169, Use Docker Compose instead of Swarm
• Feature #2175, API V3 - Import Files
• Feature #2176, API V3 - Users
• Feature #2177, API V3 - Columns
• Feature #2178, API V3 - Labels
• Feature #2179, API V3 - Data Quality
• Feature #2180, API V3 - Dataset
• Feature #2181, API V3 - Cycles
• Feature #2182, API V3 - Column List Profiles
• Feature #2183, API V3 - Column Mapping Profiles
• Fixed #2184, Minimum value input form disabled when a new rule is created with 'None' data_type
• Fixed #2200, Resolve WAVA Issues
• Fixed #2202, Organization's DQ Rules can be inadvertently deleted
• Fixed #2209, Data quality error report does not show applied labels
• Fixed #2216, StopIteration Error
• Fixed #2226, Losing unit-aware data on import after initial column mapping
• Fixed #2230, Default PM Mappings need improvements
• Fixed #2232, Swagger Django Errors
• Fixed #2238, Data quality - data type missing for rule "Address line 1" on taxlots view
• Feature #2242, ComStock Support
• Feature #2245, Integrate BuildingSync Selection Tool's Use Case API
• Feature #2249, API V3 - Organization
• Feature #2250, API V3 - Properties
• Feature #2251, API V3 - Tax Lots
• Feature #2252, API V3 - Meters
• Feature #2253, API V3 - Measures, building file, and upload
• Feature #2254, API V3 - Geocode, UBID, and Misc.
• Feature #2259, API V3 - LabelInventory (property or tax lot)
• Feature #2263, API V3 - GBR-related endpoints
• Fixed #2272, DQ Export problems
• Fixed #2281, Making new DQ rule, set Condition check, then set Field, condition check get set to blank
• Fixed #2286, Indicate mapped fields in DQ Admin definition or when running DQ Check in Inventory
• Fixed #2289, DQ Admin: Can't Save New Rule after deleting all existing rules
• Fixed #2290, DQ Admin: Valid Data Rule run from Inventory seems to "hang"
• Fixed #2293, DQ check - Not Null and Required rules for extra_data fields bug
• Fixed #2295, Migrating from very old versions to the latest can fail
• Fixed #2324, Can't change Column display name

SEED Version 2.7.1

Date Range: 12/21/19 - 03/27/20

• Fixed #94, Document how mapping works in the SEED-Platform / seed wiki
• Fixed #994, It is possible to have orphaned user accounts without an associated organization
• Fixed #1232, Need easy way to view data year over year
• Feature #1348, DQ Checking -- for Valid data, not errors in data
• Fixed #1480, Five digit zip codes with leading 0
• Feature #1591, Detail Screen: Highlight the changes in the columns
• Fixed #1592, Prevent adding an org with existing name
• Fixed #1713, Return progress status immediately when uploading large files
• Feature #1759, Save mappings for specific input file data sources (ESPM, Tax Lot, Building List)
• Feature #1760, Save Reports to CSV / PNG files
• Feature #1819, DQ: Add label field to DQ Results Modal and Export file
• Fixed #1899, Import fields from BuildingSync reports
• Improved #1913, Add Notes info to export
• Fixed #1932, BRICR upload/download
• Fixed #1933, BRICR BuildingSync exports after Update with BuildingSync
• Fixed #1946, Meter data visible on some cycles but not all
• Maintenance #1965, Re-enable sentry on systems
• Fixed #1975, Tax Lot-specific merge check is inadvertently performed on properties
• Fixed #1984, 403 error when trying to view the Users in an Organization
• Fixed #1992, Data Mapping for imported files does not reflect the actual mapping for that data file
• Fixed #1994, Store timeseries data from scenarios
• Fixed #1998, First edit including lat long change doesn't trigger manual geocoding logic
• Fixed #2009, Update to Django 2.0.13
• Feature #2013, Notes: add option to delete notes
• Fixed #2017, Column Settings: Add ability to sort by Display Name or Column Name
• Fixed #2018, Geocoding Confidence in Master record are blank for merged records
• Fixed #2023, Data Import: when importing a new file to a dataset, default to the last cycle imported rather than the first cycle in the pulldown list
• Improved #2027, Column Settings: Improve Help Text at the top of the page
• Fixed #2057, Tax Lot Excel export 500 error
• Fixed #2058, Portfolio Manager URL Changed (Flapping Issue)
• Fixed #2059, Geocoding order changes aren't included in column setting change preview
• Fixed #2060, Column mapping preset creation during import not created with current snapshot
• Fixed #2066, Page not refreshed when switch menu tabs without saving changes and click on "stay on page"
• Fixed #2069, Selected Cycle not set on different inventory pages
• Fixed #2072, Inventory Detail no highlights for changes between extra_data
• Fixed #2076, ESPM import no longer works due to ESPM website updates
• Fixed #2080, Historical mapping page bug from mapping preset changes
• Fixed #2082, Static SEED Webpage Development
• Improved #2084, Print logs when CI fails
• Improved #2089, Add Best Practices to Documentation
• Fixed #2091, 500 Error Importing Tax Lot Data
• Fixed #2095, Upgrade Django and API-related dependencies
• Fixed #2096, Meter import bug - postgres unique constraints removed from meterreading table
• Feature #2102, Add "Freeze Master Column" feature in Detail View
• Fixed #2105, Error message when editing in Detail view is incomprehensible
• Fixed #2114, Deleting a rule after saving previous changes does not reactive save buttons
• Fixed #2127, Add functionality to see entire SEED HEADER field name in Mapping
• Fixed #2131, Bricr-dev testing for potential merge into develop
• Fixed #2134, Add new column setting to allow blank/'Not Available' values to overwrite other values
• Fixed #2139, Missing reverse match for password reset

SEED Version 2.7.0-patch1

• Fixed #2202, Organization's DQ Rules can be inadvertently deleted

SEED Version 2.7.0

SEED Version 2.7.0 includes several significant updates that need to be thoroughly tested on production data before being deployed. The most notable changes:

• User can define which fields to match/merge/pair/link
• Properties and Tax Lots are now linked across multiple years or compliance cycles
• Users can define mapping profiles to save/recall mappings easier
• 57 closed issues/new features

Date Range: 09/30/19 - 12/20/19

Closed Issues and Features:

• Fixed #94, Document how mapping works in the SEED-Platform / seed wiki
• Feature #417, Reports -- Save the last settings
• Improved #656, Add filename to modal reporting matches when there are no matches
• Feature #709, Allow user to disable columns in import files and handle redundant column names in import files
• Fixed #1024, Can define user account without an organization
• Fixed #1117, Filter doesn't display all the rolled up data under some circumstances
• Improved #1361, Add a bit of space on left of mapping grid
• Fixed #1375, DQ Check - Save makes labels disappear on Admin Screen
• Improved #1409, Indicate that building/property records have merged/matched records
• Fixed #1480, Five digit zip codes with leading 0
• Fixed #1511, DQ results: Program doesn't tell user that a rule can't be applied due to data definition
• Improved #1563, Need an indicator that a filter has been applied to the data
• Fixed #1571, Update verbiage in dialog box(s) to reflect merging and pairing rather than matching
• Feature #1715, Add "Only Show Populated Columns" option to Detail List Settings
• Fixed #1740, Add UBID to BuildingSync and ensure it imports into SEED
• Fixed #1817, DQ: Program "hangs" when DQ rules can't be applied
• Fixed #1818, DQ: Program shows labels across all cycles in Filter by Labels list after running DQ check
• Fixed #1845, DQ Checking hanging in mapping due (possibly) to units issue
• Fixed #1873, data quality type error
• Fixed #1945, 403 (Forbidden) when trying to geocode records from Inventory List view
• Fixed #1963, Allow user to specify which fields are to be used for geocoding
• Maintenance #1965, Re-enable sentry on systems
• Fixed #1970, Problem importing a file into a specific org
• Fixed #1977, Review and update post-import file summary
• Fixed #1979, Detail View Edit of Custom ID 1 sometimes produces an error
• Fixed #1982, Display geojson map
• Fixed #1989, Unmerging records loses pairing
• Fixed #1990, Nonexistent properties/taxlots return bad responses
• Fixed #1991, Column Settings - Sort by MATCH CRITERIA needs some tweaks
• Fixed #1996, Release specific installation constraint of PostGIS docker container
• Fixed #2005, Unable to build docker image - Could not find library geos_c
• Fixed #2010, Mapping: Instructions: Group Matching fields by table
• Fixed #2015, Importing certain column names can break all future imports
• Fixed #2031, Importing mixed types with duplicate records can cause a 500
• Fixed #2039, Portfolio Manager Login URL Changed
• Fixed #2052, Column Settings: Saving Geocoding field definitions: getting 400 and 502 errrors
• Fixed #1348, DQ Checking -- for Valid data, not errors in data
• Fixed #786, Save Changes button sequence in Data Cleansing Admin
• Fixed #1998, First edit including lat long change doesn't trigger manual geocoding logic
• Improved #1592, Prevent adding an org with existing name
• Fixed #1592, Data Mapping for imported files does not reflect the actual mapping for that data file
• Feature #1591, Detail Screen: Highlight the changes in the columns
• Feature #1232, Need easy way to view data year over year
• Fixed #1946, Meter data visible on some cycles but not all
• Feature #1759, Save mappings for specific input file data sources (ESPM, Tax Lot, Building List)
• Fixed #994, It is possible to have orphaned user accounts without an associated organization
• Fixed #2057, Tax Lot Excel export 500 error
• Fixed #1913, Add Notes info to export
• Fixed #1713, Return progress status immediately when uploading large files

SEED Version 2.6.1-Patch1

• Fixed #2076, ESPM import no longer works due to ESPM website updates

SEED Version 2.6.1-Patch0

• This includes the patches from 2.6.0-patch0 since the patches were not complete until after the release of 2.6.1.
• Fixed #2039, Portfolio Manager Login URL Changed
• Fixed #2058, Portfolio Manager URL Changed (Flapping Issue)

SEED Version 2.6.1

Date Range: 08/09/19 - 09/30/19

Closed Issues and Features:

• Fixed #961, Inventory Detail UI Refinements
• Fixed #1571, Update verbiage in dialog box(s) to reflect merging and pairing rather than matching
• Fixed #1844, Can't map a field called Gross Floor Area without units
• Fixed #1857, Geocoding -- Tax Lot vs Property tables
• Fixed #1883, Can't create new users (as superuser)
• Fixed #1942, On import, duplicates are not flagged when ULID/UBIDs are involved
• Fixed #1944, ULID doesn't report that it could generate Lat/Long, but then does generate them
• Fixed #1950, ULID-only mapping - Geocoding confidence text is wrong

SEED Version 2.6.0-patch0

This patch has address a couple issues including:

• Use previous version of base image for docker builds (both SEED and PostgreSQL). This is due to Ubuntu edge repo no long including the correct version of Postgis.
• Update the deployment to automatically read the version of redis, postgres, and OEP from the docker-compose.build.yml file
• Fix data comparisons when merging records
• Use OEP Version 1.4
• Fixed #2039, Portfolio Manager Login URL Changed
• Fixed #2058, Portfolio Manager URL Changed (Flapping Issue)
• Fixed #2076, ESPM import no longer works due to ESPM website updates

SEED Version 2.6.0

Add time series related functionality. Make sure to review the migrations.mst on the upgrade.

Date Range: 05/04/19 - 08/09/19

Closed Issues and Features:

• Feature #835, Expand default Portfolio Manager field mapping to include report for timeseries data
• Feature #1861, Allow renaming of columns
• Feature #1871, Allow redis passwords
• Feature #1879, profile_id as query param and part of v2.1 API
• Feature #1888, Export Measures and Scenario Data in XLSX Format
• Feature #1917, Importing ESPM Meter data for multiple buildings
• Feature #1919, Meter Feature Improvements
• Feature #1927, Make table headers sticky
• Feature #1929, Update BuildingSync to BuildingSync 2.0-pr1
• Improved #1930, Upgrade UBID Dependency to Latest
• Fixed #442, Write unit test for simple_modal_service
• Fixed #1844, Can't map a field called Gross Floor Area without units
• Fixed #1867, Allow Bldg to be parsed as part of the normalized address
• Fixed #1875, Extra data not showing up in the pairing page
• Fixed #1881, Problem importing data
• Fixed #1887, Labels can be associated to Properties/TaxLots across Orgs (via Rules)
• Fixed #1893, Labels need to be associated to PropertyViews and TaxLotViews
• Fixed #1894, Meters could be lost during Property Merge and Unmerge
• Fixed #1895, Cannot import ESPM spreadsheets that have meter data
• Fixed #1896, Cannot import Green Button Data -- 500 error clicking on Energy link in Property Detail View
• Fixed #1903, 500 Internal Server Error trying to rename columns in Column Settings if the column already exists
• Fixed #1912, Error importing Green Button meter data
• Fixed #1916, Changed units for meters in Settings doesn't appear in the Inventory Meter view
• Fixed #1918, ESPM Meter Types that SEED doesn't recognize
• Fixed #1920, Incorrect meter display settings being used on Meter Detail Page.
• Fixed #1922, nginx page on staging
• Fixed #1923, Limit log files in Docker

SEED Version 2.5.2

Date Range: 04/15/19 - 05/04/19

Closed Issues and Features:

• Feature #1855, Add ULID as a matching field on taxlots
• Feature #1856, Import building and taxlot footprints from WKT format
• Feature #1861, Allow renaming of columns
• Fixed #1867, Allow Bldg to be parsed as part of the normalized address

SEED Version 2.5.1

Date Range: 03/28/19 - 04/15/19

Closed Issues and Features:

• Fixed #1734, segfault when loading a lot of records to view in Inventory List
• Fixed #1815, Property labels are not in the export file
• Feature #1832, Update BuildingSync to Version 1.0
• Feature #1833, Add ULID, Building Footprint, and Tax Lot Footprint to Database
• Feature #1855, Add ULID as a matching field on taxlots
• Feature #1856, Import building and taxlot footprints from WKT format

SEED Version 2.5.0

Date Range: 02/19/19 - 03/27/19

Add GIS related functionality. Make sure to review the migrations.mst file on how to deploy the update.

Closed Issues:

• Fixed #421, Reports - Message saying why there is no data
• Fixed #1730, Error importing BuildingSync File
• Fixed #1734, segfault when loading a lot of records to view in Inventory List
• Feature #1741, BuildingSync batch import from UI
• Fixed #1811, Unmerge Last doesn't work for BuildingSync XML files
• Fixed #1812, Merge screen doesn't show extra data fields
• Fixed #1815, Property labels are not in the export file
• Fixed #1831, Clean up database tables
• Feature #1832, Update BuildingSync to Version 1.0
• Fixed #1833, Add ULID, Building Footprint, and Tax Lot Footprint to Database
• Fixed #1837, Dimensionality Error
• Fixed #1838, Column Mappings can fail to load in the UI

SEED Version 2.4.2

Date Range: 01/05/19 - 02/19/19

Closed Issues:

• Fixed #421, Reports - Message saying why there is no data
• Fixed #1124, Linux install instructions
• Fixed #1626, 403 Error deleting Inventory from Org in Admin
• Fixed #1730, Error importing BuildingSync File
• Fixed #1738, No email sent to set password when I created a new organization
• Feature #1741, BuildingSync batch import from UI
• Feature #1782, Add OEI to docker deployment
• Fixed #1797, Ability to remove user who only belongs to a single organization
• Fixed #1800, Add managed task for adding user to organization via cli
• Feature #1801, Add dropdown for actions on inventory detail page
• Fixed #1807, Only fields in property or tax lot DB are shown in mapping screen (not showing Extra Data fields)
• Fixed #1812, Merge screen doesn't show extra data fields
• Fixed #1813, When merging records, the merged records don't show up in the detail view, only the final Master Record

SEED Version 2.4.1

Date Range: 10/06/18 - 01/04/19:

Closed Issues:

• Fixed #17, Ability to change mapping after it has been saved
• Fixed #43, Internationalization of units
• Fixed #343, Edit Organization Mappings screen -- add it
• Fixed #1561, Program Drops 2nd tax lot pairing (in mapping?) to do discarding duplicate tax lot record
• Fixed #1594, List view -- fields with long strings need popup like in building detail
• Fixed #1645, Release Date not being mapped as "Release Date" (defaulting to PM Release Date)
• Fixed #1718, Deleting all records for an org doesn't delete values in column settings
• Fixed #1724, KeyError: u'measures'
• Fixed #1733, Newly created column will not show up in API until data exists
• Fixed #1739, Admin Screen needs scroll bar at the bottom of the screen to scroll right
• Improved #1743, Remove deprecated repositories
• Fixed #1767, IDs for labels API return false
• Improved #1768, Upgrade to Python 3
• Improved #1769, Deploy script for docker stack deploy
• Fixed #1770, Update the update datetime field when changing tax lot or property
• Improved #1771, Remove Unused Django Models and Migration Code
• Fixed #1772, Return PropertyView ID from Label Filter API
• Fixed #1773, No measures in scenario break BuildingSync
• Improved #1774, Use alpine linux in Docker

SEED Version 2.4.0

Date Range: 07/04/18 - 10/05/18:

Closed Issues: 32

• Fixed #239, Rearchitect the progress API interactions
• Fixed #711, Associating and disassociating orgs causes account to become disfuctional
• Fixed #873, "NoneType object is not iterable" in _match_buildings
• Fixed #876, Upgrade fine-uploader
• Fixed #1172, Mapping Review Screen - field name case and punctuation
• Fixed #1200, allow for user to manage column mappings
• Fixed #1408, DQ checking not working for specific case
• Fixed #1497, File hangs on matching
• Fixed #1548, ESPM Auto Import -- Import file name
• Fixed #1565, Error importing large ESPM file
• Fixed #1582, Reports not displaying data
• Fixed #1585, Error 400 when unmerging record
• Fixed #1601, Performance is quite slow moving between different views (Detail to List, etc)
• Fixed #1608, Improve Matching Performance
• Fixed #1646, Value edited in Detail view is overwritten when old data is again imported into SEED
• Fixed #1654, 500 Error when logging into ESPM from SEED
• Fixed #1660, Fields are not being displayed in the Detail view for either Property or Tax Lot
• Fixed #1667, DQ Export not working from Inventory List -- server failed error
• Fixed #1668, New Mapping Page layout makes it hard to compare the file header with the SEED header
• Fixed #1672, Inventory export -- Excel puts up error message, but then opens it
• Fixed #1681, Suborganization error message unclear
• Fixed #1682, Suborganization error uploading data
• Fixed #1683, SEED shouldn't allow suborgs of suborgs
• Fixed #1685, Import Building Sync file from Audit Report Template
• Fixed #1686, Suborganization list settings don't work
• Fixed #1689, Importing file with crlf and blank line returns causes errors
• Fixed #1692, Error clicking "i" Nav Button
• Fixed #1694, Settings profile field list is reversed on save when saving the first Settings Profile
• Fixed #1696, 502 error displaying inventory in org with large number of records
• Fixed #1698, Add the ability to not overwrite the data by column on merge
• Fixed #1702, Test the spinner visibility during routing transitions
• Fixed #1707, Site EUI (kBtu/ft²) & Source EUI (kBtu/ft²) fields are not imported with autoimport from ESPM

Accepted Pull Requests: 25

• Fixed #1661, Address PM Import Error
• Fixed #1674, Report proper filename for uploaded_filename during PM import
• Fixed #1676, Improve progress bar functionality
• Fixed #1677, ID in CSV causing Excel to throw warnings
• Fixed #1680, Remove unused classes and cleanup deprecated code
• Fixed #1684, Hash object upon save
• Fixed #1687, Fix and cleanup suborganizations
• Fixed #1688, Buildingsync upload merge develop
• Fixed #1690, Fix first_five_rows method to be more flexible
• Fixed #1691, Fix privilege escalation bug
• Fixed #1695, Add transactions
• Fixed #1697, BuildingSync Upload
• Fixed #1699, Field by field merging preferences
• Fixed #1700, Fixed the spinner visibility during routing transitions
• Fixed #1701, Inventory Performance
• Fixed #1703, Strip spaces around value before typecasting
• Fixed #1704, Change default org to user first org available
• Fixed #1705, Inventory View Fixes
• Fixed #1706, Create default columns managed task, fix unicode error in mapping
• Fixed #1708, Update BuildingSync Upload
• Fixed #1709, Fix the reversed column order when saving a new settings profile
• Fixed #1710, Fix csv import
• Fixed #1714, Docker timeouts
• Fixed #1720, Fix pint cleaner and mapping error
• Fixed #1721, Handle Duplicate Measure IDs in BuildingSync Uploads

SEED Version 2.3.3

Date Range: 05/31/18 - 07/04/18:

Closed Issues: 13

• Fixed #127, Export unmatched records
• Fixed #360, Duplicate Data -- Cleanup after importing files
• Fixed #590, deleting data sets does not delete buildings?
• Fixed #654, Design feature which allows bulk editing of data
• Fixed #1282, Add space to the left of the Settings grids
• Fixed #1292, Blank record added to Tax Lot view
• Fixed #1344, Error trying to display inventory list
• Fixed #1414, get_api_request_user in seed/utils/api.py fails with UnboundLocalError when HTTP_AUTHORIZATION is not basic
• Fixed #1587, Mapping: If columns are mapped to both Property and Taxlot tables, ensure that a matching field is present for each table
• Fixed #1656, Update Version number to 2.3.2
• Fixed #1663, Program hangs at 100% on mapping
• Fixed #1665, DQ not working -- fields don't display in admin, 500 server error when running in inventory
• Fixed #1669, Export from Actions pulldown not working on dev1 branch

Accepted Pull Requests: 7

• Fixed #1653, Generates PM Import file name based on date
• Fixed #1655, Fixed the angular-sanitize semantic versioning
• Fixed #1658, Fix Migration for Production Data
• Fixed #1659, Major mapping improvements
• Fixed #1662, Return inventory records with only the columns specified
• Fixed #1666, Data Quality Checks Returned 500
• Fixed #1670, Fix Inventory Export and Displaying of Extra Data Fields in Inventory

SEED Version 2.3.2

Closed Issues: 80

• Fixed #28, Show source data file of unmatched records in Building Detail
• Fixed #60, In record list shown in matching, only show fields present in the data file
• Fixed #93, MAPPING: Add a "clear mapping" button
• Fixed #209, Checkboxes are too small
• Fixed #217, Add export to Matching screen
• Fixed #269, Add date of import to building detail list
• Fixed #270, Add Matching functionality to Building List
• Fixed #308, UI for Log Files for Duplicate Data
• Fixed #445, Normalize BE endpoint success responses
• Fixed #506, Data cleansing criteria additions and issues
• Fixed #527, Bugs related to recently implemented caching utilities
• Fixed #538, Updating master record with multiple PM files - auto vs hand matching
• Fixed #543, When should program overwrite existing data when matching records?
• Fixed #579, Add ability to view different fields on each side of matching screen
• Fixed #631, Investigate the options for automatically downloading Custom Reporting Template data from Portfolio Manager
• Fixed #636, Improvements to Matching Screen
• Fixed #639, Matching view still has 'active' filter inputs.
• Fixed #647, Add ability to delete unmatched records from the matching screen
• Fixed #677, Two Building records can't both match to one PM record
• Fixed #707, Can't map files
• Fixed #807, Review Mapped Data doesn't show all mapped fields
• Fixed #839, Server error searching by date fields on seed production but not seedtest
• Fixed #844, Thoughts about UI for Timeseries feature
• Fixed #845, Field is added to Master Building record even if it is unchecked in mapping
• Fixed #898, Don't automatically make unmatched records into new buildings
• Fixed #927, Change Read the Docs subdomain
• Fixed #937, DB Refactoring -- Audit Logs and Data Migration
• Fixed #962, Date filtering not working in Mozilla Firefox
• Fixed #1027, Can't delete data in extra_data fields in Building Detail
• Fixed #1035, Stay in the same place in the building list when coming back from building detail
• Fixed #1039, Swagger is inelegant when user isn't logged in
• Fixed #1048, Figure out what SEED is using prefinery.com for
• Fixed #1142, Update rest framework swagger
• Fixed #1160, Mapping Review screen is empty possibly when all fields are extra data
• Fixed #1191, Return display names from the backend
• Fixed #1198, Authentication is broken when using an api key
• Fixed #1229, Issue with Mapping a second time
• Fixed #1235, Add option to save display settings across org, so it isn't just for your account / browser
• Fixed #1260, Default checked fields in List and Detail settings to fields that have been mapped?
• Fixed #1265, Program is automatically mapping Energy score to ENERGY STAR Score but it doesn't display in mapping
• Fixed #1277, Importing sample test files, many issues -- can break into smaller issues as needed
• Fixed #1297, Data quality errors when typecasting data (TypeError Str -> Float)
• Fixed #1302, Add number of records imported to Import "Successful" dialog box
• Fixed #1314, Hand matching / unmatching for migrated data
• Fixed #1337, SEED Header input box in Mapping -- need to be able to make column wide enough to see long field names
• Fixed #1340, Can't Create new organization as superuser with existing email
• Fixed #1362, DQ Check - Allow sorting by column in DQ results modal
• Fixed #1403, List Settings are tedious to rework
• Fixed #1406, List views - wrap text or show text in bubble
• Fixed #1423, Spinner needs to display longer when program is working to display Matching Detail screen
• Fixed #1450, Need spinner when changing cycles in Inventory list for large datasets
• Fixed #1464, Field mapping -- Letter after number gets capitalized
• Fixed #1495, Mapping / List Setting issues
• Fixed #1532, Auto ESPM import doesn't add data to correct Cycle
• Fixed #1543, Export not returning all data when exporting from taxlot view
• Fixed #1547, Matching Review -- 0 tax lots when there should be 9
• Fixed #1549, Add UBID to Mapping screen explanation for matching fields
• Fixed #1560, Can't "deselect" the filter buttons AND/OR/EXCLUDE
• Fixed #1566, Need to be able to save different List Setting configurations
• Fixed #1567, Show labels in List view
• Fixed #1570, Show records most recently imported from ESPM
• Fixed #1573, Upload your data modal tweaks
• Fixed #1574, Inventory List View -- Default List Settings should show mapped fields
• Fixed #1577, Admin Function -- 403 error removing user
• Fixed #1578, Admin Function -- Error adding existing user to existing organization
• Fixed #1583, Unable to log into ESPM account from SEED
• Fixed #1586, Cycle range for new orgs is incorrect
• Fixed #1588, Columns with the same name in different tables should correctly differentiate the data
• Fixed #1596, Add Lat/Long to PropertyState
• Fixed #1603, Unable to view swagger page when not logged in
• Fixed #1606, Save List Settings in List and Detail View
• Fixed #1613, Associated tax lot ID in Mapping Review is confusing to users
• Fixed #1621, PM Report Template list -- not all the reports are listed in SEED
• Fixed #1627, Tax Lot list Settings Profile Saving -- internal server error
• Fixed #1632, Units are off for Energy Use and EUI when using the ESPM Login from SEED to import data
• Fixed #1633, Pairing between 1 Tax Lot ID and Multiple UBIDs does not seem to be working
• Fixed #1634, Mapping hangs at 100% complete -- organization ID doesn't exist
• Fixed #1635, ValueError: Cannot assign "269": "DataQualityCheck.organization" must be a "Organization" instance.
• Fixed #1639, Unmerge only works once on a given property record
• Fixed #1649, Importing Data with the Same Address on Multiple Rows do not track lot_numbers

Accepted Pull Requests: 30

• Fixed #1581, Improved error messages for admin.html
• Fixed #1597, Allow the mapping columns to be resizable
• Fixed #1598, Add export issues script
• Fixed #1599, Show only populated columns
• Fixed #1602, Updated translation files
• Fixed #1604, Fix data quality typeerror
• Fixed #1605, Fix swagger access
• Fixed #1610, Add libffi-dev and libssl-dev to docker and documentation
• Fixed #1611, Remove unneeded auth classes. Fix BuildingSync and HPXML API endpoints
• Fixed #1618, Add Latitude and Longitude to Database Fields
• Fixed #1622, Add column display names to the database
• Fixed #1623, List Settings Profiles + Display Names Refactor
• Fixed #1624, New Oganization Cycle Range
• Fixed #1625, Fix portfolio manager child data request
• Fixed #1628, Fixed missing pinned parameter when the value is undefined
• Fixed #1629, Fix race condition on creating DataQualityCheck objects
• Fixed #1630, Superuser improvements
• Fixed #1631, Fix Only Show Populated to use the current cycle
• Fixed #1636, Fix organization in DataQualityCheck
• Fixed #1637, Use kBtu during imports for PM
• Fixed #1638, Fixed showing of default pairing columns
• Fixed #1650, Allow import of multiple ubids, single taxlot in CSV
• Fixed #1651, Ensure mapping to both TaxLot and PropertyState columns is enforced

Accepted External Pull Requests: 5

• Fixed #1536, Quantity (aka. Pint) fields to accommodate metric and US Customary energy/area data
• Fixed #1609, Added oauth, add_columns endpoint, and adjusted pint handling
• Fixed #1616, filterset update to find PropertyView by various PropertyState building
• Fixed #1617, Made PropertyStateWritableSerializer fields not required
• Fixed #1620, Fix add_columns endpoint

SEED Version 2.3.1

Closed Issues: 4

• Fixed #1289, Filter on numeric fields
• Fixed #1321, Hand Matching screen -- Fix field headers, add vertical scroll bar, other UI improvements
• Fixed #1524, Editing record in inventory view corrupts the record
• Fixed #1576, Rework Exporting from Hamburger view

Accepted Pull Requests: 8

• Fixed #1551, Added UBID to the mapping instructions
• Fixed #1552, Fixed the count for the imported number of mapped tax lots
• Fixed #1556, Add date to PM import filename
• Fixed #1557, Release 2.3
• Fixed #1558, Notes Improvements
• Fixed #1559, Cleanup Travis
• Fixed #1562, Added UBID to the mapping instructions
• Fixed #1564, Temporarily hid the Upload Green Button Data button

SEED Version 2.3

Closed Issues: 21

• Fixed #148, For PM mapping, add feature to remember user defined mappings
• Fixed #179, Auto-connect to Portfolio Manager
• Fixed #1125, Mapping suggestions are improved but could still be improved
• Fixed #1231, Inventory Detail: Add Log & Notes back
• Fixed #1238, Add option in mapping to map all fields to original file field names
• Fixed #1298, Add Import Date as a viewable field in List and Detail view
• Fixed #1328, Filter operators -- make them the same for numeric and strings
• Fixed #1385, Hand Matching -- need to be able to match multiple records together (V 1.5 feature)
• Fixed #1396, Add Unique Building ID as a matching field
• Fixed #1499, Functionality different between two servers with same deployment
• Fixed #1501, migrate django password reset to class based views
• Fixed #1509, Mapped fields with underscore are transformed to a field name without underscore
• Fixed #1510, Export all data as CSV file not working as expected
• Fixed #1512, Export has (primarily) internal field names not SEED user mapped field names
• Fixed #1525, merging code caused merging issue
• Fixed #1527, non-deterministic test
• Fixed #1529, requires_member when viewing organization
• Fixed #1549, Add UBID to Mapping screen explanation for matching fields
• Fixed #1550, UBID Upper/lower case field name in mapping
• Fixed #1554, Add UBID to Pairing screen
• Fixed #1555, Unmerging Tax Lots doesn't unpair the records paired when records were merged

Accepted Pull Requests: 25

• Fixed #1491, BRICR Support - BuildingSync, Measures, Scenarios, etc.
• Fixed #1492, OGBS - French (Canada) localization
• Fixed #1507, removing instruction to python setup.py install
• Fixed #1513, Integration with Portfolio Manager
• Fixed #1515, 1298 import date field
• Fixed #1517, Bricr buildingsync upload
• Fixed #1519, save pm mapping changes to database.
• Fixed #1520, Translation example
• Fixed #1521, Add UBID
• Fixed #1526, Update ubid in example files
• Fixed #1528, view history
• Fixed #1530, Shared Field Settings Page
• Fixed #1531, Add Queued State to Analysis State
• Fixed #1533, Fixed the selected cycle for PM imports
• Fixed #1534, Combined text/numeric filtering
• Fixed #1535, display analysis state string instead of int
• Fixed #1537, Re-sorts angular localization files
• Fixed #1538, Updated copyrights
• Fixed #1539, Add Notes Field
• Fixed #1540, Hand-merge multiple records
• Fixed #1541, upgrade some dependencies to the latest versions
• Fixed #1542, fix serialization of quantity
• Fixed #1544, CSV Export Header
• Fixed #1545, remove unused view methods and remove bricr flipper
• Fixed #1546, Add Sentry to Frontend

Accepted External Pull Requests: 6

• Fixed #1492, OGBS - French (Canada) localization
• Fixed #1514, Simplify API auth docs
• Fixed #1516, HPXML Integration
• Fixed #1518, Tightens up check for whether celery's running in dev
• Fixed #1522, Fixes HTML error in sub-org submit button
• Fixed #1537, Re-sorts angular localization files

SEED Version 2.2.1

Closed Issues: 5

• Fixed #1486, Upgrade to Django 1.11
• Fixed #1502, Fix password reset
• Fixed #1363, DQ Check - Add export to Inventory DQ Results modal
• Fixed #1397, DQ Admin: add indication of field source (tax lot or property)
• Fixed #1398, DQ: Add labels for exported records
• Fixed #1404, Inventory Detail - Related Properties - need to display more fields
• Fixed #1439, Strftime fails for buildings older than 1900
• Fixed #1496, Export data from inventory (including labels)
• Fixed #1482, Remove the concept of projects
• Fixed #1483, Added Custom ID 1 field for Related Properties
• Fixed #1484, Added a mapping button to Map SEED fields to imported file fields
• Fixed #1481, Hides *_pint columns in Property List Settings view
• Fixed #1487, Improved Column Saving
• Fixed #1490, Export DQ from Inventory
• Fixed #1493, Removes node_modules from fine-uploader after building
• Fixed #1473, Improved Angular unit tests
• Fixed #1479, Disable all client-side caching when the dev profile is used

SEED Version 2.2

Closed Issues: 25

• Fixed #558, Label pulldown gets too small to read label text when browser window shrinks
• Fixed #598, Adding a label to 16,000+ records is a bit slow
• Fixed #781, Mapping hangs if there is a duplicate field name in the data
• Fixed #908, Changing the name of the label currently being filtered on
• Fixed #928, Blank field name in imported file causes error
• Fixed #1144, Mapping Review Screen: View by Property tab displays when mapped Tax Lot file has Jurisdiction Tax Lot ID
• Fixed #1219, One property record added when only tax lot data is mapped
• Fixed #1239, Mapping Review screen doesn't always show data
• Fixed #1257, Field name with apostrophe capitalized the next character
• Fixed #1269, Check Matching results screen to make sure information is correct
• Fixed #1275, Save Mapping for PM file with lots of fields -- Browser unresponsive message
• Fixed #1280, Not all fields show data in Mapping Review but are in Inventory list
• Fixed #1283, View by Property: Address Line 1 (tax lot) doesn't display unless Address Line 1 (property) is also selected
• Fixed #1311, Matching Results dialog box -- make the information there more informative for the user
• Fixed #1312, Hand Matching screen -- keep "state" going from detail back to list
• Fixed #1320, Display Names in List Settings not always displayed
• Fixed #1323, Spinner needs to spin longer (!) before matching screen is displayed
• Fixed #1329, Normalization of Tax lot ID -- may cause problems for some cases
• Fixed #1347, 502 Bad Gateway area when matching Portfolio Manager file
• Fixed #1372, Import sample data issue
• Fixed #1387, DQ Check -- Optimize checking for large datasets
• Fixed #1394, Matching List and Detail View -- Add List Settings
• Fixed #1407, Matching -- sorting takes a while, need a spinner
• Fixed #1432, Add fields (list settings) to Pairing screen - can't see enough info to do the pairing
• Fixed #1470, Can't create new user from admin page

Accepted External Pull Requests: 7

• Fixed #978, Adding ansible provisioning within AWS
• Fixed #1304, WIP: 1124 linux installation docs
• Fixed #1440, Org-level units preference
• Fixed #1443, Makes start-seed run a bit easier under Vagrant
• Fixed #1453, Fix typo, remove spurious 301 redirect.
• Fixed #1454, Fixes startup warning on seed.NonCanonicalProjectBuildings.projectbuilding
• Fixed #1457, Lay foundations for pint Quantity objects for EUI, Areas on PropertyStates

SEED Version 2.1.2

Closed Issues: 11

• Fixed #1220, Hide Column doesn't persist state in List View, only when set in List Settings
• Fixed #1224, List Settings are not saved after closing and reopening browser
• Fixed #1242, Add a clear filters button to the Inventory List view
• Fixed #1291, Save Changes does not appear to work in Detail View
• Fixed #1341, Check for duplicate records on import and don't import them
• Fixed #1395, Matching List view - add filter line
• Fixed #1401, Add a Not "Label" option to filtering
• Fixed #1410, Filtering in PM Property ID field doesn't do "contains" filter
• Fixed #1416, Can't filter on dates using operators
• Fixed #1418, Date sometimes does not display correctly in the Detail view
• Fixed #1428, Add Pagination to Matching Detail View

Accepted External Pull Requests: 0

SEED Version 2.1.1

Closed Issues: 77

• Fixed #16, Clear Type ahead history and restart with clean default list
• Fixed #18, Admin function to change % confidence setting
• Fixed #47, Fix case sensitive sort in Mapping edit column
• Fixed #53, Save intermediate state of mapping
• Fixed #54, The same user can be added to an organization multiple times
• Fixed #101, MATCHING: Sorting by confidence across entire dataset
• Fixed #133, Edit Columns in mapping -- only show fields in the dataset currently being mapped
• Fixed #199, PM JSON mapping field doesn't handle case (?)
• Fixed #213, Case sensitivity in mapping
• Fixed #231, Filter parameters being saved
• Fixed #271, Address sort -- alpha sort on street number (?)
• Fixed #272, Client-side build tool?
• Fixed #277, SEED incorrectly sees Firefox on OSX as old version
• Fixed #278, Modal dialogs should not show dismissable alerts
• Fixed #280, Dropdowns are not auto-showing scrollbars
• Fixed #283, Use standard (Bootstrap) modal dialog for delete project and delete data set
• Fixed #284, Use better label for "Successful Upload!" dialog
• Fixed #298, Missing asset: bg_first_td.png
• Fixed #321, List Settings in Building View has case sensitive sort
• Fixed #322, Field name display inconsistencies
• Fixed #350, Creating Sub Orgs seems to be broken
• Fixed #357, Deleting Building snapshot records when deleting data sets
• Fixed #363, missing backgound image
• Fixed #371, Duplicates in matching using PM web services field names
• Fixed #431, Delete records when click "Back to Mapping"
• Fixed #439, Mapping -- storing mapping results in cache
• Fixed #443, Add JS tests to travis build
• Fixed #450, 403 error posting to /data/upload/
• Fixed #455, Remove javascript:void(0); in href tags
• Fixed #498, Expand filtering to include multiple criteria
• Fixed #529, Fix outdated browser code
• Fixed #552, Label filter should be case insensitive
• Fixed #570, Address debt related to building search
• Fixed #588, /static/landing/js/landing.js missing
• Fixed #603, AttributeError: 'int' object has no attribute 'strip'
• Fixed #625, Add javascript tests to Travis-CI
• Fixed #637, Small correction needed for comments
• Fixed #641, Refactor directive names
• Fixed #658, Number of matching records seems to depend on import order
• Fixed #666, Font in Log and Notes Action field has changed
• Fixed #682, Add more help text for Cancel button on Confirm Save Mappings modal
• Fixed #691, Program doesn't allow mapping even if duplicate fields are unchecked
• Fixed #698, Add column sorting to detailed matching screen
• Fixed #813, Matching shows 0% progress, but is actually matching (on a large dataset)
• Fixed #814, Matching design issues
• Fixed #828, 2nd step in Mapping seems to either hang or take a very long time
• Fixed #852, Uploading large data set, problem with matching
• Fixed #872, Display of files is slow if the list of files is long
• Fixed #886, UI Updates for DB Refactoring
• Fixed #907, After applying labels on page > 1, program goes back to showing page 1 list
• Fixed #911, local_untracked has changed
• Fixed #954, Fix Django deprecated warnings.
• Fixed #975, Data migration to put extra data fields into column mappings
• Fixed #1022, Cancel button on Change Password page appears to have no effect
• Fixed #1072, Filter by label state is lost going from list to detail and back to list
• Fixed #1141, Inventory List: put multiple tax lots in numeric order
• Fixed #1143, Problems with Matching
• Fixed #1162, Keep sort & filter when coming back to List view from Detail View
• Fixed #1208, Jurisdiction Property ID -- add it to the list of matching fields
• Fixed #1218, Extra Data sorting -- should sort all fields alpha-numerically (?)
• Fixed #1222, Add ability to Set Campus field state in Detail Edit
• Fixed #1228, Need funtionality equivalent to "Lot Number" in PM data for Unique Building ID in PM data
• Fixed #1247, Don't merge duplicate records
• Fixed #1255, After mapping is saved, some fields are set to unmapped in the Mapping Screen
• Fixed #1258, Verify the behavior of mapping Tax Lot ID to Lot Number if Tax Lot ID doesn't exist in Tax Lot table
• Fixed #1267, Enable Django File Compression for Cache Busting
• Fixed #1276, Error running docker-compose
• Fixed #1279, Manage Available cycles -- doesn't always work
• Fixed #1288, Recognize / as a delimiter for multiple tax lot IDs
• Fixed #1300, Hand matching: Spinner needs to persist until hand matching view is displayed
• Fixed #1313, UI for cases where multiple records are matched -- improve
• Fixed #1334, If field order is changed by moving field in list view, when coming back from detail view, list settings are lost
• Fixed #1368, DQ check - getting errors for Address Line 1 even if it isn't in the rules
• Fixed #1376, Hand matching is very slow
• Fixed #1383, Matching list and detail view -- add back in column filtering and field list settings (in V 1.5)
• Fixed #1384, Matching detail list -- add column sorting (like the list view)
• Fixed #1412, Blank data in matching fields causes records to be merged that shouldn't be

Accepted External Pull Requests: 12

• Fixed #1199, Basic authentication uses base64 encoded, not plain strings
• Fixed #1241, Fixes Python build failures in Docker
• Fixed #1366, Tests data quality
• Fixed #1373, Fix develop tests
• Fixed #1378, GBR merge 01 residential cert models
• Fixed #1379, GBR merge 02 api helpers
• Fixed #1381, GBR merge 03 residential cert endpoints
• Fixed #1382, GBR merge 04 a org mixin cycle
• Fixed #1386, Filter matching
• Fixed #1388, 90 code cov
• Fixed #1389, GBR merge 05 properties

SEED Version 2.1.0

Closed Issues: 29

• Fixed #69, Remember the unchecked fields
• Fixed #79, Separate Mapping from Matching
• Fixed #430, Potential crash in map_row_chunk
• Fixed #580, Add Label Feature to Data Cleansing view
• Fixed #582, Add Data Cleansing functionality to Inventory (Property and Tax Lot) View
• Fixed #785, Add Clear Filter to Data Cleansing modal
• Fixed #787, Additional functionality to add to Data Cleansing Admin feature
• Fixed #1105, Slow display of data
• Fixed #1151, Mapping for PM files need some improvement
• Fixed #1171, List Settings - Multiple field names still there in some cases
• Fixed #1236, Is seed-platform-dev google group dead?
• Fixed #1243, Dismiss button on Matching Progress bar
• Fixed #1274, Deleting organizations doesn't seem to work -- Disable until fixed
• Fixed #1287, Data Cleansing Export button doesn't export file
• Fixed #1307, Chrome ran out of memory trying to display the matching screen
• Fixed #1309, Error unmerging merged record
• Fixed #1324, Mapping Review only shows Tax Lot field if Address Line 1 mapped to Property table
• Fixed #1342, Keep Label filters when moving between tabs
• Fixed #1343, 500 Error when clicking on Data Quality Checks from right hand link in organizations
• Fixed #1345, DQ checking -- put new rule at top of list
• Fixed #1346, DQ Checking -- Not all rules are alphabetized
• Fixed #1350, DQ - Text String checking
• Fixed #1351, DQ - Select / Deselect All button in DQ Admin
• Fixed #1352, DQ - Default rules for Energy Star seem to hang (?)
• Fixed #1353, DQ - Energy Star Score rule seems to hang (?)
• Fixed #1354, DQ Check - Program doesn't label null records when set to Required and Not Null
• Fixed #1355, DQ Check -- Alphabetize field list in field pulldown in Admin Screen
• Fixed #1359, DQ Check -- Error adding labels in Admin Screen
• Fixed #1364, DQ - Not all error records are getting labels

Accepted External Pull Requests: 2

• Fixed #1331, Old data quality
• Fixed #1333, Cleanup

SEED Version 2.0.2

Closed Issues: 49

• Fixed #23, Type ahead in Mapping sometimes doesn’t keep your choice
• Fixed #82, Batch processing during import causes lost records
• Fixed #103, Improving the mapping functionality
• Fixed #122, Linked fields in Mapping
• Fixed #149, Click on field or record to edit
• Fixed #370, Move Filtering and Sorting to Front End
• Fixed #462, Add wildcards to filtering
• Fixed #518, Server error on Delete Building
• Fixed #542, Changes to PM mapping not shown in mapping "review" screen after save
• Fixed #620, Wrong number of matched buildings reported in dialog box
• Fixed #633, Program Doesn't Always show the right number of matches
• Fixed #643, Add double date filters to matching screen
• Fixed #657, Number of matches reported in modal is not always correct
• Fixed #659, Add/Remove filter buttons stacked not side by side
• Fixed #661, Add/Remove filter buttons stacked not side by side
• Fixed #665, Deleting buildings from list doesn't delete all records
• Fixed #827, Program renames data import file
• Fixed #874, Save GreenButton Request button doesn't save deletion of input in URL and Subscription fields
• Fixed #931, API Refactoring
• Fixed #933, Build Migration Scripts to move data from old to new tables
• Fixed #953, Edited data in Building Detail view is not saved
• Fixed #980, Imported files have a sequential number appended onto them
• Fixed #1107, Program merges records during matching if addresses match but Tax Lot IDs are different
• Fixed #1108, Program doesn't handle updated PM records in the same file properly
• Fixed #1112, Matching hangs importing the same file under 2 different cycles
• Fixed #1139, Show import history in the Inventory Detail view
• Fixed #1159, Getting Bower errors matching data
• Fixed #1203, Changing mapping doesn't seem to get saved
• Fixed #1206, Mapping to Lot Number -- can't view Lot Number field explicitly - it becomes Associated Tax Lot ID (?)
• Fixed #1207, Mapping error checking -- require at least one field is a matching field
• Fixed #1215, Display of mapping list is very slow when there are many fields (250)
• Fixed #1221, Replicate V1.5 feedback for matching results
• Fixed #1259, No fields displaying in Mapping Review
• Fixed #1261, Settings not saved on Detail View
• Fixed #1262, Data doesn't always appear in Mapping Review, even if it is displayed in Inventory view
• Fixed #1263, A few mapped Tax Lot fields are not showing data in the Property List view (City, State, Postal Code)
• Fixed #1264, Test and Document -- Mapping Lot Number to Property in file with both Tax Lot and Property Data
• Fixed #1278, How to unpair a Property from a Tax Lot
• Fixed #1285, Problem importing 2 records with fields mapped to Tax Lot and Properties
• Fixed #1290, Mapping error: Cannot handle more than one to_column returned for
• Fixed #1293, Detail View error -- 'NoneType' object has no attribute 'state'
• Fixed #1294, Timeout viewing detail from View by Tax Lot
• Fixed #1295, Importing 2nd file -- no data displayed in Matching Review
• Fixed #1299, Mapping to Lot Number in Property table -- normalize data the same way as for Jurisdiction Tax Lot ID
• Fixed #1305, Program defaults to "empty" Cycle record in Inventory view
• Fixed #1306, Server error 500 clicking on Detail icon from View by Property, 502 from View by Tax Lot
• Fixed #1308, 1 Portfolio Manager record not getting added to Property list
• Fixed #1310, Program seems to stall on Mapping
• Fixed #1315, Manage Available Cycles on New Data Set not working

Accepted External Pull Requests: 3

• Fixed #1284, Seed merge api helpers
• Fixed #1286, fix for pairing page, didn't like scope() syntax
• Fixed #1322, 135787765 test updates

SEED Version 2.0.1

Closed Issues: 18

• Fixed #138, Add cancel button to data import modal
• Fixed #618, Decouple list settings in different views
• Fixed #632, Add Cancel button to View/Hide Columns / Save Settings on Matching screen
• Fixed #650, Year built displayed with commas in matching
• Fixed #871, Add date/time of import for uploaded files in the Data Files section
• Fixed #910, Update filtering in the Matching detail view
• Fixed #1007, DB Migration cleanup -- DC and 2015-2016
• Fixed #1087, List settings contains multiple versions of the same field -- don't know which to pick
• Fixed #1118, Imported files don't always show extension
• Fixed #1128, Matching with Tax Lot & Property Data in one file
• Fixed #1165, Saved mapping is not always correct
• Fixed #1168, In existing org, importing new files, Mapping Review screen doesn't show data
• Fixed #1170, List Settings: Property and Tax Lot indicators are not always correct, depending on the mapping
• Fixed #1178, Detail Settings (both Tax Lot and Property) doesn't show extra data fields
• Fixed #1183, Extra Data doesn't display in Inventory List or Detail View
• Fixed #1204, Custom ID 1 is not displayed in Mapping Review or Property List Settings
• Fixed #1213, Some data getting mapped is not displaying in detail and list view
• Fixed #1217, 403 Forbidden Error in matching_results

Accepted External Pull Requests: 2

• Fixed #1135, Import changes
• Fixed #1253, added taxlot_view_id to related property returned in getProperties

SEED Version 2.0.0 (2016-10-01 to Release)

Closed Issues: 76

• Fixed #78, MATCHING: Unmatched PM records are not made into master building records
• Fixed #98, Concatenation isn't working -- can't control field order
• Fixed #110, Address Line 1 mapping not working
• Fixed #114, Scale building list records viewed based on total # of records
• Fixed #248, Problem deleting buildings
• Fixed #314, "File Content Error" during data load but system still loads data
• Fixed #397, Display error message when creating label if it already exists
• Fixed #407, Order of fields in Building List for existing records
• Fixed #420, Put display # records pull down at the top of the list
• Fixed #585, If no matching fields mapped, can't get to Building Details
• Fixed #587, Missing {{STATIC_URL}}seed/images/DOE-SEED-Logo_v4.jpg
• Fixed #597, Labels take a long time to load if there is a lot of data
• Fixed #906, Clear filters goes back to Show All state, but pulldown doesn't reflect that state
• Fixed #917, Label list doesn't appear on first click into the input box
• Fixed #967, Sentry errors from trying to display building list
• Fixed #971, Error mapping
• Fixed #973, Unchecked fields in Mapping screen are imported but not available in Building List Settings #972
• Fixed #984, In superuser organization list (under Admin) show the Organization ID from the database in a column
• Fixed #990, Can't export just one record
• Fixed #991, Investigate sentry errors
• Fixed #999, Add Associated Tax Lots to UI for new db refactoring
• Fixed #1000, Angular Grid UI - Add field display on/off, persistence of UI state
• Fixed #1010, Table layout inconsistencies
• Fixed #1030, import file into new data model
• Fixed #1031, Investigate Sentry error
• Fixed #1033, Add link to Swagger on front end
• Fixed #1049, Testing filtering in Blue Sky
• Fixed #1084, Mapping grid only shows extra data and no data for the records
• Fixed #1085, Duplicate Fields in Mapping -- can't assign them to a Tax Lot or Property table
• Fixed #1086, Program doesn't save "state" of mapping after saving (the table assigned to the field)
• Fixed #1089, Not all records imported into View by Property
• Fixed #1090, Program automatically creates duplicate mapping even though the original fields names are unique
• Fixed #1091, Import, Map and Match Sample Data - Record Pairing doesn't seem to be working
• Fixed #1092, Mapping for some fields is changed in the List view
• Fixed #1094, Data displayed in Inventory View by Property list is associated with the original field name, not mapped field name
• Fixed #1095, Error trying to add label from View by Tax Lot tab
• Fixed #1096, Failed to load resource: api/v2/projects/count/?organization_id
• Fixed #1097, Importing PM file using Portfolio Manager Tab doesn't work
• Fixed #1099, Mapping: Back to Mapping button doesn't seem to work
• Fixed #1100, Mapping: extra data fields shown in Mapping Review screen with field name not display name
• Fixed #1101, Mapping: Show both Tax Lot and Property fields in Mapping Review screen
• Fixed #1103, Mapping Review: only show fields that were mapped
• Fixed #1104, Sluggish UI performance
• Fixed #1110, Browser runs out of memory displaying large data set
• Fixed #1111, Server times out mapping large data set
• Fixed #1120, Unicode Error in Address
• Fixed #1126, Mapping review screens doesn't display mapped fields properly
• Fixed #1127, Error loading page in mapping
• Fixed #1129, Not all Property Data is displayed in Tax Lot rolled up view
• Fixed #1131, Deleting user gets "unsupported media type" error
• Fixed #1134, Importing junction table for Tax Lot and PM Property ID - Relationships not correct
• Fixed #1138, Matching -- progress bar doesn't close even though records are all matched and in inventory list
• Fixed #1146, Issues with Portfolio Manager File mapping
• Fixed #1147, Program allows user to Map Your Data when it has already been merged
• Fixed #1148, Mapping error trying to import data
• Fixed #1149, 404 error -- buildings_reports_controller.js
• Fixed #1150, Change password failing
• Fixed #1153, Make sure Portfolio Manager JSON file is completely populated with PM fields
• Fixed #1161, 403 Forbidden error on log off
• Fixed #1163, Problem uploading data with filesystem mode
• Fixed #1164, Mapping for Address Line 1 in Tax Lot is wrong
• Fixed #1173, A few field names are getting automatically mapped to another name
• Fixed #1174, Can't import a file with only one field
• Fixed #1176, Bad Gateway error when trying to add label (upper limit for number of records to add labels to?)
• Fixed #1177, List Settings -- dragging fields to change their order doesn't seem to work
• Fixed #1182, Can't create new data set for new organization
• Fixed #1184, Strange set of characters are appended on to imported filename
• Fixed #1186, Reports don't seem to be working
• Fixed #1187, Inventory List records don't display the first time the page is loaded - have to change cycles for display
• Fixed #1189, Error 415 - Unsupported Media Type -- when trying to delete user in an Organization view
• Fixed #1193, 403 Forbidden error trying to make a Cycle in a new org without any Cycles
• Fixed #1194, Error trying to edit an existing Cycle
• Fixed #1195, When Creating a new cycle, the cycle list disappears until browser is refreshed
• Fixed #1196, Importing Property file without Matching fields (?) only shows one record in View by Property
• Fixed #1210, All labels are displayed in Detail view, not just the ones associated with the record
• Fixed #1212, Removing Labels in Detail view doesn't update the label list for that record

Accepted External Pull Requests: 11

• Fixed #1041, Fix for #1031 cut against release 1.5.0
• Fixed #1042, Fix for 1035 backported from tallus-selenium-test-836
• Fixed #1043, Fix can't delete data in extra_data fields in Building Detail #1027
• Fixed #1069, migrate_labels manage command now uses property.labels etc
• Fixed #1076, Bugfixes for labels (and tests)
• Fixed #1080, New Projects API
• Fixed #1081, Column migration bugfix
• Fixed #1121, Added models for Green Assessments (Verifications/Certifications)
• Fixed #1169, Nyc migration issue dec 2016
• Fixed #1181, 135787537 performance updates
• Fixed #1211, 134551255 new pairing page

SEED Version 2.0.0 (2016-06-11 to 2016-10-01)

losed Issues: 21

• Fixed #30, Multiple Data Files per Building Record
• Fixed #59, Column Reordering allowed in Matching Edit Columns view
• Fixed #66, Add Ability to handle multiple years of data
• Fixed #508, Finish/Polish ReadTheDocs
• Fixed #760, The last label does not appear in Building List pulldown
• Fixed #793, Very long data strings should wrap
• Fixed #836, Stay in the same place in the building list when coming back from building detail
• Fixed #878, Set up a release server that replicates production with latest updates
• Fixed #889, Fix migrations from clean db
• Fixed #959, UI for Blue Sky Test Release in June
• Fixed #963, Generate list of all fields in extra data
• Fixed #965, Bar chart section of report not working
• Fixed #968, Develop field order for Blue Sky test view
• Fixed #976, simple_modal_service is broken
• Fixed #979, Specs for UI for DB refactoring
• Fixed #982, Building Detail Column width control doesn't work properly in IE
• Fixed #989, List of labels in building list is not showing all the labels
• Fixed #998, UI Grid interface for choosing fields to display is a bit flakey
• Fixed #1005, Error in number of pages calculation
• Fixed #1008, catch invalid organization id
• Fixed #1025, Breakup Bluesky Model

Accepted External Pull Requests: 23

• Fixed #977, fixes #976
• Fixed #981, Fixes js error in getAggChartData
• Fixed #983, Fix for #982 + modifications to Selenium test
• Fixed #987, Tallus 982 better tests
• Fixed #1002, In superuser organization list (under Admin) show the Organization ID…
• Fixed #1003, 954 - Added selenium test to check year ending can be edited.
• Fixed #1015, Added Selenium Test Infrastructure
• Fixed #1017, Revert "Ftr/primarysecondary taxlots"
• Fixed #1023, 996 ui updates
• Fixed #1034, Fix for #1031 Investigate Sentry error
• Fixed #1037, Tallus selenium test 836
• Fixed #1038, Fix for #10131 cut against master
• Fixed #1046, Tallus tests consolidation
• Fixed #1047, Dmcq fresh detail after update
• Fixed #1051, Add search_properties and search_taxlots as equivalents to search_buildings
• Fixed #1054, Revert "Major UI Refactor"
• Fixed #1055, Tallus fix tests remove building views
• Fixed #1056, fix typos in test
• Fixed #1058, bug fix for buiding detail history views
• Fixed #1059, Add BE for Reports
• Fixed #1060, Tallus data cleansing
• Fixed #1062, Demo data with audit logs
• Fixed #1064, API backend for updating property/taxlot labels
• Fixed #1066, fix incorect url