LAW Turbo - New processed data written to new storage location

For turbo import cases that have additional data processed, changes are required in the case SQL database

There are four queries that must be completed on the Turbo case SQL database to ensure that new processed data files are written to the new storage location. You will need to replace the items in BOLD with your site and case specific information.

1. SQL Query one in the case database:

UPDATE dbo.CaseProperties set value = 'NEWCASEDIR' where name = 'lawcasedir'

 

2. SQL Query two in the case database:

UPDATE Exports SET Config = REPLACE(Config, '<LawCaseIni>ORIGINAL CASE LOCATION\project.ini</LawCaseIni>', '<LawCaseIni>NEW CASE LOCATION\project.ini</LawCaseIni>') WHERE ID=1

GO

 

3. SQL Query three in the case database:

UPDATE Exports SET Config = REPLACE(Config, '<ExportDirectory>ORIGINAL CASE LOCATION\$EdaDirectImport\LAW_Direct</ExportDirectory>', '<ExportDirectory>NEW CASE LOCATION\$EdaDirectImport\LAW_Direct</ExportDirectory>') WHERE ID=1

GO

 

4. SQL Query four in the case database:

Delete from dbo.ExportLocations