WinSPM DataBase 1

[Pepperz]

Does anyone know the database structure of the WinSPM program, specifically, how to sort the list of names of sites on the "Available Sites" window?

Pepperz@charter.net

 

[BobbR]

I had wondered that also but never took the time to look, until now. Paradox opens all the WinSPM\Data (.db) files. The file with the Site info is, surprise, Site.db. I opened it in Paradox, shuffled the site names around and saved. Next, opened up WinSPM, connected to one of the changed sites. Surprise again, correct site was identified as it connected but \SiteData ([View] [Browse Reports]) is for the "other" Legend. These are .txt files and remain in the correct subdirectory under WinSPM but somewhere is an index file that is pulling in the "wrong" information. Swapping the .txt files in the subdirs has no effect. So far have found no .db file with the SiteData info. I will change things back around until I get a better handle of how things are structured.

The only fields visible in the Site.db table are SiteID, SiteName, ContactName, ContactPhoneNumber, whereas the table structure info reports 24 fields. Anyway, have fun playing around.

 

[BobbR]

Followup: Site.db is keyed on SiteID, thus establishing sequence in which site names are displayed. Also, all SiteData data (text files in my case as that is the form I save them in) is linked with the SiteID number. So, I unkeyed the table so that the SiteIDs would not be sorted numerically by the ID number. Bingo. Sites are now displayed in order of the changed table and links pull in correct data via SiteID number. One can now order the sites in whatever sequence as the field is unkeyed and will not re-sort. Remaining to be seen is if the unkeyed table will create problems later on when additional sites are added.
Also discovered the remaining fields in Site.db, which is merely the other data on the site setup form. One could make changes to that info also within Paradox.
If one did not have a large amount of data downloaded from the [Print] command you could simply delete all sites and enter in the order you want them displayed, but that probably is not an option, wasn't for me.
BTW, I run WinSPM 8.0 in Standard SPM. You will be on your own if running the fancier Windows stuff and all that data.

 

[Pepperz]

Thanks!!

Pepperz@charter.net