Accela - Log into Accela

Phase 1 - Login to Accela

link: https://act.saccounty.net:3443/security/hostSignon.do?successUrl=https://act.saccounty.net:3443/portlets/spa/dashboard.do

Phase 2 - Create a snapshot

1 - in sasdpdb2.district execute the following code

select *
from (
    select top 100 *
    from log_batch_processing

    where batch_what='_Daily'
    order by Batch_When desc) b
order by b.batch_when

Select COUNT(*) from psd.Parcel_esds_v

2 - Using Access 2016 create an access 2007 database

ex (S:\z_App_Data\ESD_and_CUBS_Accounts\22021102_esds.accdb)

3 - Import the table called psd.Parcel_esds_v (use an odbc file dsn named u:\sasdpdb2_District.odbc)

5/14/2020 - use a DSN named u:\odbc\sasdpdb2_district.udl

4 - Rename that table to Parcel_esds_v

5 - import the queries contained in last months esds database

6 - Send a message permitservices@sacsewer.com indicating the file has been created.

Perhaps "A fresh copy of the ESDS database has been created ...

… and placed into

S:\z_App_Data\ESD_and_CUBS_Accounts

"