Updating the comp_librarydir Library Path in the Demo Data

Less than one minute read time.

In the demo data there are a few company records that have entries in the comp_librarydir field that do not match the usual format of such data.

You can see some of these in the image below.

New company records that are added into the system will follow the correct pattern.

The inconsistency in the demo data can cause some inconvenience when testing extensions that have been developed around the Library entity.

To bring the inconsistent demo data into line the following SQL statement can be run against the CRM database


update company
set comp_librarydir = substring(comp_librarydir,0,2)+'\'+ltrim(comp_librarydir)
where comp_librarydir not like '%\%'