Contents

Configuring 1E Catalog connection to 1E Cloud

Summary

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.

On this page:

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:

ValueDescription
0no synchronization
1uni-directional synchronization
2bi-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

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:

ValueDescription
TrueDownload will be enabled.
FalseDownload 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

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 master copy.
  2. Catalog will then pull content.
  3. Push content if enabled.
  4. Catalog will then index the content.

1E Catalog data files

The 1E Catalog data files, both installed and downloaded from the 1E Cloud during a synchronization, are stored in the following locations:

DataLocation
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