...
The day we've all been waiting for!
Tuesday Feb 14
1700 hours
01) Confirm that we have the latest AVS dump on the FTP site.1
2) DT will run a specific set of jobs. These are listed here.
http://sfgovdt.jira.com/wiki/display/MAD/scheduled+jobs
For each job marked with an X in the "GO LIVE" column, you must do the following
Disable the job from being run automatically.
Starting at 1700, run the jobs manually, in the temporal order.
Do not enable the automation of these jobs until the following day.shall Insure that all jobs on the scheduled jobs page
/wiki/spaces/MAD/pages/5308417
- with a "2" in the notes column must be turned off permanently
- all other jobs shall be disabled over night
3) DT will run the run_jobs.bat
The AVS Load will write a file to ftp://esfftp.sfgov.org/dbi-external/avsEasLoadResults.csv.
This will be used later.
24) DBI shall modify portions of their ETL from the Assessor into the AVS.
2 4.1) stop loading addresses into AVS
2 4.2) continue to load ownership information
35) DBI shall disable the AVS address editing form
3 5.1) should an "orphaned" address need to be retired, counter staff shall contact MIS.
Feb 15
0730 hours
4
6) DBI DBA/developer shall do the following
4 6.1) backup the AVS addresses table
4 6.2) add the eas_id column to the addresses table
4 6.3) download the "AVS To EAS Load" results file from the FTP server (ftp://esfftp.sfgov.org/dbi-external/avsEasLoadResults.csv)
4 6.4) use the avs load results data to update the eas_id column
56) DT shall Insure that all the parcel and streets jobs on this pagehttp://sfgovdt.jira.comthe /wiki/displayspaces/MAD/scheduled+jobs
with a "2" in the notes column must be turned off permanantly.pages/5308417 page shall be enabled.
0800 hours
7) DBI shall make a PROD path available on their web server for the change notifcations.
XXX
Right now we use
| Code Block |
|---|
dbiweb.sfgov.org/dbiws_eas_qa/eas_to_dbi.asmx/postAddressXMLtoDBI.
|
I think we need to an different path, something like
| Code Block |
|---|
dbiweb.sfgov.org/dbiws_eas_prod/eas_to_dbi.asmx/postAddressXMLtoDBI.
|
8) Whatever the path is in the item above, we need to add that to this line of EAS code
http://sfgovdt.jira.com/source/browse/MAD/trunk/web/settings_env/live/environments.py?r=3114#to67and DT shall test the integration to make sure it is working.