Static Database (SDB) Updates

To update you PICS database to match your MODCOMP point database, follow the procedure outlined below.

1. Save the output from ANALST, DIGLST, and SMKLST (for ALL points) into a text file that may be read on a PC.
2. Find a copy of the CADP2CSV2.EXE program. There is usually a recent copy on the PICS display node in the C310 computer room, on the E: drive, I think. You will want the newest that you have.
3. Copy the text file from (1) to a place that CADP2CSV2 (found in (2)) can read it.
4. Open an NT command shell (C: prompt) and change drive/directory to the location of CADP2CSV2.EXE.
5. Execute CADP2CSV2 with the name of the ***LST text file as the only parameter.
6. You should get a set of .CSV files created in the current directory. (aAlarm, AlarmMst, dAlarm, Point, and RealTime)
7. Stop PICS. Yes, all of it.
8. While PICS is stopped, copy the files from the PMUX's folder named C:\PICS\Data.Base to a working location still ON PMUX.
9. Open an NT command shell on PMUX and change to the directory that contains your working copy of the PICS database.
10. Execute this command:
    dbio export -csv:. -sdb:.
    This should result in a complete set of current CSV files for the PICS database. Notice the trailing dots (after the colons), they are REQUIRED (they identify the current directory as the directory to be use, two dots signify the parent directory, and a directory name, well, that would signify itself, of course!)
11. Copy the newly created CSV files (from steps (5,6)) into the current folder.
12. Execute this command:
    dbio import -csv:. -sdb:. -tables:pt,rt,am,aa,da
    If you have any problem from this command, try running it like this:
    dbio import -csv:. -sdb:.
    Notice the trailing dots (after the colons), they are REQUIRED (they identify the current directory as the directory to be use, two dots signify the parent directory, and a directory name, well, that would signify itself, of course!)
13. Watch the output from dbio import. If there appear to be a large number of errors, run the command again and append:
    >dbio.txt
    to the end of the command line. When the command completes, use notepad to review the output captured in the file dbio.txt
14. If dbio appears to have worked OK, then you must run:
    sdbcc +F +D +P
    Again, if a large amount of output is generated, return to step (12) and append
    >sdbcc.txt
    to the sdbcc command line when you get here, then use notepad to review the captured output.
15. When dbio and sdbcc are satisfied that the database is usable, you may ZIP up the current file set in PMUX - C:\PICS\Data.Base and then replace them with the files you've created.
16. Delete the SdbCache.dat files from PMUX, PPDRS, PDARS, and PBRIDGE, to ensure that they rebuild their local caches. You might want to also delete the cache file from the displays as well, unless it is not critical they they be able to see the new point(s).
17. Restart PICS and keep your fingers crossed.