Category: V1 Document Management
DBAuthorise View offscreen or offmonitor
With multiple screen setups (Laptop where a docking station has a different screen size to the laptop), the version of DBAuthorise client we have used sometimes displayed the window off the screen. If you can’t get the screen on your display (Shift right click the program in the task bar and click Move, or Restore…
Use TSQL to extract V1 DBArchive Blobs
Using TSQL it is very easy to automate extraction from Version One’s DBArchive product with its dbremoteblob program (It does require a username and password to access DBArchive and the program comes with DBArchive). With a 4 core CPU I extracted 72000 documents a day, a limitation found was the programs used did not return…
V1 DBAuthorise grab a list of Purchase Orders
V1 DBAuthorise can be setup to have multiple Purchase orders, so I use a Common Table Expression in a view for any time I need to get a list of Purchase Orders and Sage Company that is not in ~Accepted and State OK (1024). user5 for us is the PO number and user7 the Sage…
Powershell script to manage V1 dbadeposit issues in pull config
Credits: Superuser Microsoft Docs V1 dbadeposit can exit and stop working when in a pull configuration (Normally V1 dbadeposit is setup in a push to configuration) if a tag file (Metadata) is not produced along with the arq file and binary blob file. If you check and find you are actually missing no scans like…
Rebuild a V1 DBCapture Database Queue
We have an issue where on a rare occasion a scan from V1 DBScanner to DBCapture can corrupt the queue and cause DBCapture Admin to state it is unable to open a document rendering the whole application unusable. I have a batch script to perform some maintenance. Over time I have commented out lines which…