...
The day we've all been waiting for!
1) DT will run the "AVS to To EAS load Load" one last time (PROD to PROD)
1.1) This job writes a file to ftp://esfftp.sfgov.org/dbi-external/avsEasLoadResults.csv
2) DBI will DBA/developer shall do the following
2.1) backup the AVS addresses table
2.2) add the eas_id column to the addresses table
2.3) get the avs load results data download the "AVS To EAS Load" results file from the FTP server (ftp://esfftp.sfgov.org/dbi-external/avsEasLoadResults.csv)
2.4) use the avs load results data to update the eas_id column
3) DBI shall modify portions of their ETL from the Assessor into the AVS.
3.1) stop loading addresses into AVS
3.2) continue to load ownership information
3.3) stop loading streets?
3.4) stop loading parcels?
4) DBI will also disable the AVS GUI for data entryshall do the following to AVS
4.1) disallow editing for non-supervisor roles
4.2) allow supervisor role to retire but not to edit
5) All the jobs on this page
...
with a "2" in the notes column must be turned off.
6) DBI shall add PROD configurations to the DBI their web server for the change notifcations.
Right now we use
Code Block |
---|
dbiweb.sfgov.org/dbiws_eas_qa/eas_to_dbi.asmx/postAddressXMLtoDBI. |
I think we need to an additional URLdifferent path, something like
Code Block |
---|
dbiweb.sfgov.org/dbiws_eas_prod/eas_to_dbi.asmx/postAddressXMLtoDBI. |
7) Whatever the path is in the item above, we need to add that to this line of EAS code
...