The Qdabra DBXL Administration Tool (DAT) allows you to quickly delete all documents from a document type:
1. Open the configuration for the document type by clicking the Edit icon
2. Select the Documents tab and click on the Delete All button.
However, you may encounter an error due to timeout if your document type contains too many documents (usually in the order of thousands).
The good news is that you can use Document Deployer to delete the documents one by one so that the timeout does not occur. Here is how you do it:
1. Copy the Scenario File to Document Deployer’s Scenario folder. (Click Download, above, to obtain this file.)
2. Open the Migration Tool UI.
3. Make sure DBXL Server Root is set to your DBXL, usually http://<servername>/QdabraWebService.
4. Select the Custom tab, select the desired scenario from the Scenario path dropdown and click Load.
5. Scroll down in the scenario variables list and set docType to the document type you want to empty.
6. Scroll down the Scenario Variables list and change sourceDBXL and targetDBXL to the same value entered in step 3.
7. Select RemoveDocuments in the scenario runs and click Run. This will delete all the documents from the specified document type.
In the log window, you will see a message like this:
2008-08-21 01:15:40 Executing action RemoveDocuments...
2008-08-21 01:15:44 Removing document with id 104...
When execution is complete, you will receive a confirmation message indicating success.
Note that if you have set up shredding for your form, this action will remove the documents from both DBXL and your SQL table(s).
