Set up the CrudeSync import service

In this section you will learn: How to configure the CrudeSync import service.

The CrudeSync import service files are contained in a folder called <date>_CrudeSyncImportNoDB_<VersionNumber>.<build>, for example 20201203_CrudeSyncImportNoDB_2021.1.20338.15_2021.1. This folder is referred to as <CrudeSyncImportFolder> in the remainder of this manual.

1. Copy the <CrudeSyncImportFolder> folder into a suitable location, for example \Web\SpiralSuite\CrudeSyncImport.

2. In the Release folder, create an appSettings.Production.json file with the following contents:

   {
   "Serilog": {
   "WriteTo": [
   {
   "Name": "Async",
   "Args": {
   "configure": {
   "FileSink": {
   "Args": {
   "path": "D:\\logs\\CrudeSyncImporter.log"
   },
   "Name": "File"
   }
   }
   }
   }
   ]
   },
   "AppConfig": {
   "CrudeSyncConnectionString": "Data Source=<ServerName>;Initial Catalog=CrudeSync;Integrated Security=SSPI;",
   "DataLayerServer": "https://<DataLayerServerURL>"
   }
   }
   

   Make the following changes:

   • Replace the value of path with the desired path to your log file.

   • Replace <ServerName> with the SQL server name, including the instance if appropriate. Make sure to escape any backslashes: for example, write Data Source=.\\SQL2017 instead of Data Source=.\SQL2017.

   • Replace <DataLayerServerURL> with the URL, ending in /DataLayer, of your DataLayer web service. This can be done later once the DataLayer setup is complete.

   • If you have chosen not to enable SQL Server TLS, add Encrypt=False; to the CrudeSyncConnectionString string.

     Also, beware of line breaks in the printed version of this document: the strings between double quotes must not have any line breaks. Note that Initial Catalog is two words separated by a space.

3. Set the NTFS permissions of the parent CrudeSyncImport folder as follows:

   1. Open the properties of the CrudeSyncImport folder (Web\SpiralSuite\CrudeSyncImport).

   2. Select the Security tab, click the Edit button and click Add.

   3. Click Locations and select the host server name, then click OK.

   4. Enter Network Service and click Check Names.

   5. Click OK.

      Note: Additionally, it is possible to use a named service account here, however this document does not cover that scenario. Please contact support if you would like to know more.

      

   6. Grant Network Service the following permissions on the folder:

      • Modify

      • Read & Execute

      • List Folder Contents

      • Read

      • Write