MDB Viewer Plus

Administrator
2019-08-15 15:51

Hi All, FYI
If you’re dealing with old db’s like 2.6 there is a possibility that after update the DB schema export won’t work. Because of Export table missing.

If you want to solve it you need to update DB by adding new table.

CREATE TABLE ExportImage (
ImageID GUID NOT NULL,
Annotation INTEGER NOT NULL DEFAULT 0,
DicomID VARCHAR(64) NOT NULL,
Exported INTEGER NOT NULL DEFAULT 0,
ExportedTime DATETIME NOT NULL,
ParentImageID GUID NULL
);
ALTER TABLE ExportImage ADD CONSTRAINT ExportImage_PK PRIMARY KEY(ImageID, Annotation);
CREATE UNIQUE INDEX ExportImage_IDX1 ON ExportImage(DicomID);

The Db looks untouched by installer therefore we need to apply whole set
Plus, if you want to run this script
use this

ALTER TABLE [Session] ADD COLUMN [MWLStudyUID] TEXT(64);
ALTER TABLE [Session] ADD COLUMN [MWLAccessionNum] TEXT(64) ;
ALTER TABLE [Session] ADD COLUMN [MWLReferPhyName] TEXT(64) ;
ALTER TABLE [Session] ADD COLUMN [MWLRequestedProcID] TEXT(64) ;
ALTER TABLE [Patient] ADD COLUMN [MWLOtherPatID] TEXT(64) ;
ALTER TABLE [Session] ADD COLUMN [PamVersion] TEXT(255) ;
ALTER TABLE [Session] ADD COLUMN [ProductVersions] TEXT(255) ;

semicolon tells to MDPlus tool that ther're few commands.

 RESET ARCHIVE DATA BEFORE RUNNING BULK EXPORT

Update [Image] SET [PArchiveStatus]=0;
Update [Image] SET [SArchiveStatus]=0;
Delete * from [ImageStorage]

*Registry Path to check: HKEY_LOCAL_MACHINE\SOFTWARE\OPTOS\Apllications\Common\Data Connections\Standard


Convert 2.11 to 3.x Schema:

ALTER TABLE [Session] ADD COLUMN [ProductVersions] TEXT(255);
Tags: Archive, Database, DB, Export, MDBPlus
Average rating: 0 (0 Votes)

You cannot comment on this entry