Configuration

Enable the file upload feature:

  1. Open the File Upload settings in the Web Admin Tool at Setup > System Settings > System Settings File Upload
  2. Select the Use File Upload Functionality setting.

Set the upload directory:

  1. Edit the appsettings.Production.json file in the RestAPI folder.
  2. Set the FileUpload:FileBasePath value to your preferred upload location.

    For example:

    Absolute path: '"FileBasePath": "C:\\Uploads"'

    Relative path: '"FileBasePath": ".\\Uploads"'

Configure upload restrictions:

In the File Upload settings in the Web Admin Tool, configure the following:

  1. **File upload maximum file size**: Set the maximum allowed file size (default: 10 MB).

  2. **File upload allowed file extensions**: Specify which file types are permitted (default: .xlsx, .xls).

Configure File Scanner Type (Optional) (ClamAV/Disable Security Scanning):

If you select **ClamAV**:

  • Set the **File Scanner Service Server** to the hostname/IP address of your ClamAV server.
  • Set the **File Scanner Service Port** to the port number for Clam AV (typically 3310).
  • Ensure that the ClamAV antivirus service is installed, running, and available from your server.
    Important: You should configure the use of ClamAV to ensure that files are scanned for malware.

You can then run the Excel file import mapping.