Skip to main content

1E 8.1 (on-premises)

Configuring 1E Catalog connection to 1E Cloud

Post-install configuration of 1E Catalog synchronization and AI Powered Auto-curation.

1E Catalog synchronization options

1E Catalog regularly synchronizes itself with the catalog curated by 1E in the 1E Cloud. Options are:

  • bi-directional synchronization (default) - pushes site-defined entries to the 1E Cloud Catalog for verification by the 1E curation team and pulls new content entries or updates from the cloud

  • uni-directional synchronization - pulls new content or updates from the 1E Cloud Catalog

  • no synchronization - no attempts to synchronize with 1E Cloud Catalog.

For each batch, the synchronization event writes the number of processed records to the log files.

Please refer below for details of Data sent from the 1E Catalog to the 1E Cloud.

1E Catalog can also be configured during installation to download the files related to the AI Powered Auto-curation feature. Please refer to AI Powered Auto-curation for more details.

Modifying 1E Catalog Cloud synchronization behavior post-installation

The following script can be used to modify the SubscriptionType setting in the Settings table of the 1ECatalog database. You can set the new value to be one of the following:

Value

Description

0

no synchronization

1

uni-directional synchronization

2

bi-directional synchronization (default)

After changing the value you will need to restart the 1E Catalog Update Service for your changes to take effect.

SQL script to configure SubscriptionType setting

/* Script to change 1ECatalog setting */
USE [1ECatalog]
GO 
DECLARE @setting nvarchar(max), @oldvalue nvarchar(max), @newvalue nvarchar(max);; 
SET @setting = 'SubscriptionType' 
SET @newvalue = '2' 

SET @oldvalue = (SELECT [Value] FROM [dbo].[Settings] WHERE [Key]= @setting) 

UPDATE [dbo].[Settings] SET [Value]=@newvalue WHERE [Key]=@setting 

SELECT @setting AS 'Setting', @oldvalue AS 'Before', [Value] AS 'After' FROM [dbo].[Settings] 
WHERE [Key]=@setting 
GO

232786263.png
Modifying 1E Catalog AI Powered Auto-curation file download post-installation

The following script can be used to modify the EnableAIPackageSync setting in the Settings table of the 1ECatalog database . You can set the new value to be one of the following:

Value

Description

True

Download will be enabled.

False

Download will be disabled.

After changing the value you will need to restart the 1E Catalog Update Service for your changes to take effect.

SQL script to configure EnableAIPackageSync setting

/* Script to change 1ECatalog setting */
USE [1ECatalog]
GO 
DECLARE @setting nvarchar(max), @oldvalue nvarchar(max), @newvalue nvarchar(max);; 
SET @setting = 'EnableAIPackageSync' 
SET @newvalue = 'True' 

SET @oldvalue = (SELECT [Value] FROM [dbo].[Settings] WHERE [Key]= @setting) 

UPDATE [dbo].[Settings] SET [Value]=@newvalue WHERE [Key]=@setting 

SELECT @setting AS 'Setting', @oldvalue AS 'Before', [Value] AS 'After' FROM [dbo].[Settings] 
WHERE [Key]=@setting 
GO

232786264.png
Viewing synchronization events in Catalog UI

View synchronization event history from the Updates screen, listing:

  • Sync Type – whether it was an upload or a download

  • Start Time

  • End Time

  • Result – success or failure - event details are written to log files typically located in C:\ProgramData\1E\Catalog\Catalog.Updateservice.log

  • Count - number of synchronized records.

Viewing synchronization events in Catalog UI
Reviewing the log file

The regular synchronization with the 1E Cloud Catalog is logged in Catalog.UpdateService.log. In general, the process is as follows:

  1. Catalog Registers with the master copy.

  2. The Catalog will then pull content.

  3. Push content if enabled.

  4. The Catalog will then index the content.

    232786260.png
1E Catalog data files

The 1E Catalog data files, both installed and downloaded from the 1E Cloud during synchronization, are stored in the following locations. These locations are not configurable in this version of 1E Catalog.

Data

Location

Catalog data

%ProgramData%\1E\Catalog

Installer data

%ProgramData%\1E\Catalog\CatalogSynchronization\Data

Synchronization data from the 1E Cloud Catalog

%ProgramData%\1E\Catalog\CatalogSynchronization\Sync

Lucene index

%ProgramData%\1E\Catalog\CatalogSynchronization\LuceneIndex

AI Powered Auto-curation files

%ProgramData%\1E\Catalog\CatalogSynchronization\PredictionModel

Data sent from the 1E Catalog to the 1E Cloud

The following show the tables of data sent from the 1E Catalog to the 1E Cloud to help improve the quality of the 1E Catalog data for all customers. The data is mainly related to software products and AI prediction models, no identifiable customer-related information is sent.

  • Add/Remove Programs data

  • Site-defined processor information

  • Device type (not including the device name)

  • Software bundling

  • Software category

  • Start/end dates

  • .exe to product mapping data.

PredictionModels

PredictionModelID

Version

VersionMajor

VersionMinor

VersionRevision

VersionBuild

FileName

FileHash

FileSize

SubmissionSource

SubmissionSourceValue

CreationDate

Is1EVerified

IsDeleted

IsDownloaded

PredictionResults

PredictionResultID

SourceVendor

SourceTitle

SourceVersion

SourceColloquialVersion

SourceEdition

Vendor

Title

Version

ColloquialVersion

Edition

SecondaryVendor

SecondaryTitle

SecondaryVersion

SecondaryColloquialVersion

SecondaryEdition

UpdateGuid

KBNumber

ServicePack

BitLength

Language

Confidence

ModelVersion

SubmissionSource

SubmissionSourceValue

IsComplete

CreationDate

Is1EVerified

IsDeleted

SimilarityResults

SimilarityResultID

SourceVendor

SourceTitle

SourceVersion

SourceColloquialVersion

SourceEdition

SourceSecondaryVendor

SourceSecondaryTitle

SourceSecondaryVersion

SourceSecondaryColloquialVersion

SourceSecondaryEdition

SourceUpdateGuid

SourceServicePack

SourceKBNumber

SourceBitLength

SourceLanguage

Vendor

Title

Version

ColloquialVersion

Edition

Confidence

ModelVersion

IsInCatalog

SubmissionSource

SubmissionSourceValue

CreationDate

Is1EVerified

IsDeleted

ProductMatches

ProductMatchID

Language

SourceProductID

Source

SourceVendor

SourceVendor_MD5

SourceTitle

SourceTitle_MD5

SourceVersion

SourceVersion_MD5

SourceColloquialVersion

SourceColloquialVersion_MD5

SourceServicePack

SourceServicePack_MD5

SourceEdition

SourceEdition_MD5

ProductID

Vendor

Vendor_MD5

Title

Title_MD5

ProductVersionID

Version

Version_MD5

ColloquialVersion

ColloquialVersion_MD5

ServicePack

ServicePack_MD5

ProductEditionID

Edition

Edition_MD5

SubmissionSourceLookup

SubmissionSourceValue

Is1EVerified

CreationDate

IsDeleted

PatchEnum

PatchIdentifier

ProductVariants

ProductVariantID

VendorID

ProductID

Language

Vendor

Title

ProductVersionID

Version

ColloquialVersion

ServicePack

ProductEditionID

Edition

VendorUniqueIdentifier

InstallerIdentifier

ReleaseDate

EndOfSupportDate

IsLicenseRequired

IsDistributable

IsBundle

IsDeleted

UNStandardProductServiceCode

CommonProcurementVocabularyCode

eCl@ss

GlobalProductClassification

CommonPlatformEnumeration

SubmissionSource

SubmissionSourceValue

Is1EVerified

CreationDate

Catalog_MD5

VendorLookupMD5

TitleLookupMD5

Win10CompatibilityStatus

MajorMinor

VersionPart