Contents
/* 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:
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.
/* 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.
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:
- Catalog Registers with master copy.
- Catalog will then pull content.
- Push content if enabled.
- 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:
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 |