Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
maxLevel6
minLevel1
maxLevel6
include
outlinefalse
indent
exclude
stylesquare
excludetypelist
classprintabletrue

...

class

Service Purpose: To take files from a folder and upload them into the dashboard.

Configuration

It runs under a service named “BusinessGPTFileLoader” and has the following configurations:

...

Preparations: Must install FirewallAPI service in advance

Installation

Copy paste the desired version \\fs\Build Versions\Production\BGFileLoader or \\fs\Build Versions\Test\BGFileLoader to C:\Agat in the machine

Configuration

Open C:\Agat\BGFileLoader\Configuration\ApplicationSettings.config and configure the following:

  1. FolderPath - The folder from which the service will upload the files, can be local folder or UCN.

  2. ApiKey - See here

  3. UploadApiUrl - BusinessGPT upload service API URL- See here

  4. PerformanceFileCount - Help: After how many files to write into the log, the performance of the total number of files and process time. Default 50.

  5. DBPath - local Local path to SQLite DB file. In general, nothing should be changed except whether access is from disk D or C.

  6. RunningIntervalMinutes - the service scans the folder every interval for new files that were added to the folder

  7. ReprocessAllFiles - default False. Set to True to reprocess all the files in the folder and upload them again.

  8. Enable copilot eDiscovery data processing - Yet to be released

  9. CopilotDataFolderLocation - the location of the ZIP file from the eDiscovery

...

  1. - Yet to be released

Installing the service

Open cmd as administrator, go to the service installation folder, and run the following command:
>BusinessGPTFileLoader.exe install

To uninstall the service run the command:
>BusinessGPTFileLoader.exe remove

...

Note: Can run in console mode (not as a Windows Service) with the command:
>BusinessGPTFileLoader.exe console

How it works

Sanity test

Upload a file to the folder and check if it was successfully uploaded to the dashboard. The file can be found under Data Sources>Documents

...



Upload

Upload is done into a collection which is the name of the original folder + date of first run. Any files in this folder will be uploaded to the same collection.

Along with the file, also users and groups list which have read access to the file are uploaded as well.

If something is changed with one of these users or groups, an update is sent.

Error handling

In an upload error, the loader marks the record as failed in the status.

Each failed record goes through 3 retry attempts at intervals of 1 min, 10 min, and 1 hour.

In addition, you can configure to retry all failed by changing the configuration “RetryAllFailed,” which requires a restart of the service. Once restarted and configured to retry all, the service will mark all failed records at the first attempt

Specification

The service includes an SQL Light DB as part of the installation.

...

In next version, the service will update the ContentSourceName in the content info table to be “FileLoader” and the ContentSourceIP to the host's IP from which the service is running.

Measuring performance

The File uploader sends each document to the Firewall API. Once the Firewall API inserts the document into the content list, it returns to the loader to get the next file.

Based on AGAT typical files, it takes around 0.2 sec for a file
So, if you have 10,000 files, it would take around 0.5 hours.

Syncing performance to the dashboard

Every time (based on PrefromanceFileCount ), the service will write the performance into the log.

...

createdBy: File Loader (IP of the host machine)

Installing the service

Open cmd as administrator, go to the service installation folder, and run the following command:
>BusinessGPTFileLoader.exe install

To uninstall the service run the command:
>BusinessGPTFileLoader.exe remove

...

Note: Can run in console mode (not as a Windows Service) with the command:
>BusinessGPTFileLoader.exe console

Online tool for SQLite database access

https://sqliteonline.com/

...

You can see a list of DB tables and run SQL queries like SELECT/UPDATE/etc.

Copilot Auditing

When configured to process copilot- the file uploader can process the results of a manual export of the eDiscovery prompts.

...

“CopilotDataFolderLocation”. Each file is parsed, and the prompt and response are sent to the Firewapp API (the same as the proxy sends the data)

The FileLoader sends the user's API key manually updated in the config file.

If the user is missing, send it to Unknown@company.com.

The parser of CoPilot review sets is used by both the File Uploader and the ingestor

The CopliotReviewSetParser is a DLL that unzips the Review Set and extracts the prompt, responses, users, time, and files.