The following approach deviates from the conventional method of restoring a case in Venio. Therefore, we recommend initially performing this process on a small test case. This will provide you with a better understanding of the procedure before proceeding with your actual case, allowing you to approach it with greater confidence.
When creating a new project from the UI, upon pressing the finish button, two actions occur: a project database is created, and a row is inserted into VenioPCD..tbl_pj_projectsetup. Essentially, this method involves reverse engineering the process. We will restore the project database and then insert the row into VenioPCD.
1. First restore your database backup file.
2. Then run the following script in VenioPCD. The script inserts a row in tbl_pj_projectsetup. Make sure to go through the xml settings. The major items that has to be set correctly in the following xml are as follows, rest can later be changed form the UI Edit Project Settings.
- <ProjectID></ProjectID>
- <clientid></clientid>
- <ProjectName></ProjectName>
- <DatabaseInstanceName></DatabaseInstanceName>
- <HashAlgorithm> </HashAlgorithm>
- <FileServerLocation></FileServerLocation> --the path to your project location
- <IndexLocation></IndexLocation>--the path to your index location
- <SSID></SSID> -- Found in VenioPCD..tbl_pj_searchserverinfo. You can check other projects for reference for example: select Projectid, ProjectName, SSID, FSID, IFSID, DSID, ISID from tbl_pj_projectsetup
- <DSID></DSID> -- Found in VenioPCD..tbl_pj_DatabaseServerInfo
- <FSID></FSID> --Found in VenioPCD..tbl_pj_fileserverinfo
- <IFSID></IFSID> -- Same as FSID
SET IDENTITY_INSERT [dbo].tbl_pj_ProjectSetup ON
GO
DECLARE @ProjectSettings xml =' <WIHT><ProjectID>11</ProjectID>
<ClientName> ProjectAfterPatch</ClientName>
<clientid>1</clientid>
<ProjectName>ProjectAfterPatch</ProjectName>
<DatabaseInstanceName>prj_ProjectAfterPatch_11</DatabaseInstanceName>
<DedupingFlag>1</DedupingFlag>
<HashAlgorithm>MD5</HashAlgorithm>
<DeNistingFlag>1</DeNistingFlag>
<IndexingFlag>1</IndexingFlag>
<RemoveSysFileFlag>1</RemoveSysFileFlag>
<FullTextSearchLevel>1</FullTextSearchLevel>
<FileServerLocation>\\WSAMZN-4MIGK3IC\Repo\2024-02-15 10.01.24_PM\ProjectAfterPatch</FileServerLocation>
<IndexLocation>\\WSAMZN-4MIGK3IC\Repo\2024-02-15 10.01.24_PM\ProjectAfterPatch\VenioIndexLoc</IndexLocation>
<CreatedDate>2021-06-02T18:15:26.283</CreatedDate>
<UpdatedDate>2021-06-24T00:27:08.917</UpdatedDate>
<CreatedBy>1</CreatedBy>
<UpdatedBy>1</UpdatedBy>
<IndexFullText>1</IndexFullText>
<IndexMeta>1</IndexMeta>
<SSID>1</SSID>
<ISID>1</ISID>
<DSID>1</DSID>
<MatterNumber>1786703-0002</MatterNumber>
<AttorneyName />
<Notes>Test</Notes>
<LanguageIdentification>1</LanguageIdentification>
<OCRTextMinimumThreshold>0</OCRTextMinimumThreshold>
<DefaultFullTextContent>FULLTEXT NOT AVAILABLE</DefaultFullTextContent>
<AllowEmailAnalysis>0</AllowEmailAnalysis>
<CreatedMachineName>DM76VOCONSOLE01</CreatedMachineName>
<FSID>1</FSID>
<IngestTimeoutPerFile>20</IngestTimeoutPerFile>
<EmailAlertEnabled>0</EmailAlertEnabled>
<BackupStatus>0</BackupStatus>
<AllowOCR>1</AllowOCR>
<AutoQueueOCR>1</AutoQueueOCR>
<HighlightPrivilegedTermForDesktop>0</HighlightPrivilegedTermForDesktop>
<HighlightPrivilegedTermForWeb>0</HighlightPrivilegedTermForWeb>
<EdocEmbeddedFilter>EXLUCDE_ALL_EMBEDDED_IMAGE_AND_UNKNOWN_FILES</EdocEmbeddedFilter>
<EmailEmbeddedFilter>EXLUCDE_ALL_EMBEDDED_IMAGE_AND_UNKNOWN_FILES</EmailEmbeddedFilter>
<PPTEmbeddedFilter>EXLUCDE_ALL_EMBEDDED_IMAGE_AND_UNKNOWN_FILES</PPTEmbeddedFilter>
<HighlightSearchTermForDesktop>1</HighlightSearchTermForDesktop>
<HighlightSearchTermForWeb>1</HighlightSearchTermForWeb>
<RestrictMediaUpload>0</RestrictMediaUpload>
<RestrictExport>0</RestrictExport>
<AllowLocalStorageToMediaUpload>0</AllowLocalStorageToMediaUpload>
<AllowLocalStorageToExport>0</AllowLocalStorageToExport>
<WorkingMachineName>DM76VOCONSOLE01</WorkingMachineName>
<AllowTiff>1</AllowTiff>
<AllowColorTiff>0</AllowColorTiff>
<EmailFreqWeight>0.600</EmailFreqWeight>
<EmailNonGarbageWeight>0.200</EmailNonGarbageWeight>
<EmailSimilarityWeight>0.200</EmailSimilarityWeight>
<NonGarbageChars>_''.-"" ,@;</NonGarbageChars>
<MaxPageLimit>0</MaxPageLimit>
<TimeoutMultiplier>120</TimeoutMultiplier>
<GroupDatePriority>MeetingDate</GroupDatePriority>
<maxOcrTryCount>2</maxOcrTryCount>
<PCTagPropagationsetting>0</PCTagPropagationsetting>
<DuplicateTagPropagationSetting>2</DuplicateTagPropagationSetting>
<ReviewDatabaseInstanceName>prj_1786703_0002_Boy_Scouts_of_America_242</ReviewDatabaseInstanceName>
<ReviewDSID>1</ReviewDSID>
<DefaultReviewerHourlyRate>5.000000000000000e+001</DefaultReviewerHourlyRate>
<PropagateTagToEmailThread>0</PropagateTagToEmailThread>
<FileExtensionFilterLevel>FIRST_LEVEL</FileExtensionFilterLevel>
<ApplyFileExtensionFilterOnContainer>0</ApplyFileExtensionFilterOnContainer>
<FileTypeFilterLevel>FIRST_LEVEL</FileTypeFilterLevel>
<ApplyFileTypeFilterOnContainer>0</ApplyFileTypeFilterOnContainer>
<NativeTiffExtOption>0</NativeTiffExtOption>
<OCRTextThresholdValue>20</OCRTextThresholdValue>
<LocalTimeZone>UTC</LocalTimeZone>
<NsfDateTimeFormat>MM/DD/YYYY</NsfDateTimeFormat>
<ShowEmailHeaderInFulltext>1</ShowEmailHeaderInFulltext>
<TzTimeZone>Etc/GMT</TzTimeZone>
<ReviewerRateType>$/hr</ReviewerRateType>
<BlankThreshold>1.000000000000000e+002</BlankThreshold>
<LittleContentThreshold>9.984999999999999e+001</LittleContentThreshold>
<AutoQueueNative>0</AutoQueueNative>
<TiffPrintDocLimit>25</TiffPrintDocLimit>
<TiffPrintPageLimit>25</TiffPrintPageLimit>
<AutoQueueNDDSig>0</AutoQueueNDDSig>
<SlipSheetSettings>
<SlipSheetSettings>
<SlipSheet Generate="False">
<Criteria CreatePlaceholder="False" FileType="MULTIMEDIA" />
<Criteria CreatePlaceholder="False" FileType="SYSTEM" />
<Criteria CreatePlaceholder="False" FileType="DENIST" />
<Criteria CreatePlaceholder="False" FileType="PASSWORDPROTECTED" />
<Criteria CreatePlaceholder="False" FileType="CORRUPTED" />
<Criteria CreatePlaceholder="False" FileType="ZEROBYTE" />
<Criteria CreatePlaceholder="False" FileType="UNKNOWN" />
<Criteria CreatePlaceholder="False" FileType="UNSUPPORTED" />
<Criteria CreatePlaceholder="False" FileType="PROCESSINGERROR" />
<Criteria CreatePlaceholder="False" FileType="FILEEXTENSION" />
<Criteria CreatePlaceholder="False" FileType="FILETYPEGROUP" />
</SlipSheet>
<CreateSlipSheetOnFirstPage>False</CreateSlipSheetOnFirstPage>
<ReplaceExtractedTextWithSlipsheetText>False</ReplaceExtractedTextWithSlipsheetText>
<SlipSheetMessage>The number of imaged pages exceeds limit of %pagelimit%</SlipSheetMessage>
<CreateSlipSheetForTimeOut>True</CreateSlipSheetForTimeOut>
<RemoveRedactedTiffOCRTextIfSlipSheet>False</RemoveRedactedTiffOCRTextIfSlipSheet>
<TimeOutMessage>Time out error occured during imaging for this file.</TimeOutMessage>
</SlipSheetSettings>
</SlipSheetSettings>
<NDDSettings>
<NDDSettings>
<AutoQueueNDDSig>False</AutoQueueNDDSig>
<MinThreshold>80</MinThreshold>
<MinCharacters>512</MinCharacters>
<IncludeMetadataForNDD>False</IncludeMetadataForNDD>
<DisclaimerText />
<LastUpdatedOn>2021-06-02 22:15:26.149</LastUpdatedOn>
</NDDSettings>
</NDDSettings>
<EnableNativeAutoPrefetch>1</EnableNativeAutoPrefetch>
<UseDedicatedServerOnly>0</UseDedicatedServerOnly>
<MinCharForLangId>100</MinCharForLangId>
<MaxCharToReadForLangId>5000</MaxCharToReadForLangId>
<AutoTiffOCRForNoTextFiles>1</AutoTiffOCRForNoTextFiles>
<AdvancedTiffOption>
<AdvancedTiffOption>
<GenerateBates Value="False" />
<AutogenerateTiff>False</AutogenerateTiff>
<IgnoreAutoTiffJobsForMediaProcessingStatus>False</IgnoreAutoTiffJobsForMediaProcessingStatus>
<FallbackToStellent>False</FallbackToStellent>
</AdvancedTiffOption>
</AdvancedTiffOption>
<ProjectCreatedVersion>8.2.0.0</ProjectCreatedVersion>
<ProjectUpdatedVersion>8.4.0.0</ProjectUpdatedVersion>
<MinValidDateTime>1969-12-30T08:00:00</MinValidDateTime>
<MinFreeSpaceRequiredForTempLocationInGB>5</MinFreeSpaceRequiredForTempLocationInGB>
<MinFreeSpaceRequiredForProjectLocationInGB>10</MinFreeSpaceRequiredForProjectLocationInGB>
<IgnoreStateError>0</IgnoreStateError>
<EmailNotificationTimeoutInMinute>60</EmailNotificationTimeoutInMinute>
<AutoCopyCrashedDocument>1</AutoCopyCrashedDocument>
<IsImageTypePDF>0</IsImageTypePDF>
<ContentAccessVersion>8.5.3.0</ContentAccessVersion>
<CleanContentVersion>2015.1.3</CleanContentVersion>
<ShowIngestionErrorsWarningInExport>1</ShowIngestionErrorsWarningInExport>
<IncludePartialOCRedFile>1</IncludePartialOCRedFile>
<ExtractTextFromMasterViewInPowerpoint>1</ExtractTextFromMasterViewInPowerpoint>
<TrackChangesOptionForFulltext>IncludeTrackChangesInline</TrackChangesOptionForFulltext>
<ProjectCreatedFromVoD>0</ProjectCreatedFromVoD>
<AllowAutoLaunchEmailThreading>0</AllowAutoLaunchEmailThreading>
<DoNotComputeLanguageIdentificationForSpreadsheets>1</DoNotComputeLanguageIdentificationForSpreadsheets>
<HashAlgorithmSecondary>SHA1</HashAlgorithmSecondary>
<FileCopyOption>COPY_CREATE_SECONDCOPY_OF_SCANNED_FILES</FileCopyOption>
<LangIDFactoryType>NaiveBayesLanguageIdentifierFactory</LangIDFactoryType>
<ExtractInternetEmailHeader>1</ExtractInternetEmailHeader>
<IndexEmailHeader>1</IndexEmailHeader>
<PopulateCustodianDedup>1</PopulateCustodianDedup>
<AutoSearchTagSettings>
<Search AllowAutoSearch="False" />
</AutoSearchTagSettings>
<DefaultTiffTimeout>5</DefaultTiffTimeout>
<CreateDefaultRedactionSets>0</CreateDefaultRedactionSets>
<ExtractNSFView>1</ExtractNSFView>
<ComputeDedupeBasedOnCustodianPriority>0</ComputeDedupeBasedOnCustodianPriority>
<AutoComputeInclusiveEmail>0</AutoComputeInclusiveEmail>
<DefaultTiffColorOption>BLACK_AND_WHITE</DefaultTiffColorOption>
<NDDTagPropagationSetting>0</NDDTagPropagationSetting>
<SearchDuplicateOption>3</SearchDuplicateOption>
<ExcludeDisclaimerDuringIndexing>0</ExcludeDisclaimerDuringIndexing>
<HashFieldSettings>
<HashFieldSettings>
<HashFields>
<HashField>EmailAttachmentName</HashField>
<HashField>EmailBCC</HashField>
<HashField>EmailCC</HashField>
<HashField>EmailFrom</HashField>
<HashField>EmailSubject</HashField>
<HashField>EmailTo</HashField>
<HashField>EmailDateSentGMT</HashField>
<HashField>ChildCRC32Hash</HashField>
</HashFields>
</HashFieldSettings>
</HashFieldSettings>
<AutoPopulateDuplicateFilePath>1</AutoPopulateDuplicateFilePath>
<IFSID>6</IFSID>
<MaxDSJobRetryCount>
<MaxDSJobRetryCount>
<Job Name="CG">2</Job>
<Job Name="HTML Conversion">2</Job>
<Job Name="Indexing">2</Job>
<Job Name="Scan">2</Job>
<Job Name="Ingestion">2</Job>
<Job Name="NSF">5</Job>
<Job Name="Ingestion For File Replacement">2</Job>
<Job Name="Language Identification">2</Job>
<Job Name="Native Pre-fetch">2</Job>
<Job Name="Near Duplicates">2</Job>
<Job Name="OCR Generated Tiff">2</Job>
<Job Name="OCR Redacted Tiff">2</Job>
<Job Name="Predict">2</Job>
<Job Name="RTF Conversion">2</Job>
<Job Name="TF">2</Job>
<Job Name="TIFF">2</Job>
<Job Name="TIFF Pre-QC">2</Job>
<Job Name="Search">2</Job>
<Job Name="Print">2</Job>
<Job Name="Distributed Service Search">2</Job>
<Job Name="Promote Data-Work Product">2</Job>
<Job Name="Promote Data-File Copy">2</Job>
<Job Name="Promote Data-Document Information">2</Job>
<Job Name="Inclusive Email Identification">2</Job>
<Job Name="Production-Copy">2</Job>
<Job Name="Production-Fulltext">2</Job>
<Job Name="Production-Image">2</Job>
<Job Name="Production-Native">2</Job>
<Job Name="Production-PDFConversion">2</Job>
<Job Name="Production-PrepareData">2</Job>
<Job Name="Transcribing">2</Job>
</MaxDSJobRetryCount>
</MaxDSJobRetryCount>
<AutoQueueTranscribing>0</AutoQueueTranscribing>
</WIHT>'
DECLARE @hdoc int
EXEC sp_xml_preparedocument @hdoc OUTPUT, @ProjectSettings
INSERT INTO tbl_pj_ProjectSetup (ProjectId, [ClientName]
,[clientid]
,[ProjectName]
,[DatabaseInstanceName]
,[DedupingFlag]
,[HashAlgorithm]
,[DeNistingFlag]
,[IndexingFlag]
,[RemoveSysFileFlag]
,[FullTextSearchLevel]
,[FileServerLocation]
,[IndexLocation]
,[CreatedDate]
,[UpdatedDate]
,[CreatedBy]
,[UpdatedBy]
,[IndexFullText]
,[IndexMeta]
,[SSID]
,[ISID]
,[DSID]
,[MatterNumber]
,[AttorneyName]
,[Notes]
,[LanguageIdentification]
,[OCRTextMinimumThreshold]
,[DefaultFullTextContent]
,[AllowEmailAnalysis]
,[CreatedMachineName]
,[FSID]
,[IngestTimeoutPerFile]
,[EmailAlertEnabled]
,[BackupStatus]
,[AllowOCR]
,[AutoQueueOCR]
,[HighlightPrivilegedTermForDesktop]
,[HighlightPrivilegedTermForWeb]
,[EdocEmbeddedFilter]
,[EmailEmbeddedFilter]
,[PPTEmbeddedFilter]
,[HighlightSearchTermForDesktop]
,[HighlightSearchTermForWeb]
,[RestrictMediaUpload]
,[RestrictExport]
,[AllowLocalStorageToMediaUpload]
,[AllowLocalStorageToExport]
,[WorkingMachineName]
,[AllowTiff]
,[AllowColorTiff]
,[EmailFreqWeight]
,[EmailNonGarbageWeight]
,[EmailSimilarityWeight]
,[NonGarbageChars]
,[MaxPageLimit]
,[TimeoutMultiplier]
,[GroupDatePriority]
,[maxOcrTryCount]
,[PCTagPropagationsetting]
,[DuplicateTagPropagationSetting]
,[ReviewDatabaseInstanceName]
,[ReviewDSID]
,[DefaultReviewerHourlyRate]
,[PropagateTagToEmailThread]
,[FileExtensionFilterLevel]
,[ApplyFileExtensionFilterOnContainer]
,[FileTypeFilterLevel]
,[ApplyFileTypeFilterOnContainer]
,[NativeTiffExtOption]
,[OCRTextThresholdValue]
,[LocalTimeZone]
,[NsfDateTimeFormat]
,[ShowEmailHeaderInFulltext]
,[TzTimeZone]
,[ReviewerRateType]
,[BlankThreshold]
,[LittleContentThreshold]
,[AutoQueueNative]
,[TiffPrintDocLimit]
,[TiffPrintPageLimit]
,[AutoQueueNDDSig]
,[SlipSheetSettings]
,[NDDSettings]
,[EnableNativeAutoPrefetch]
,[UseDedicatedServerOnly]
,[MinCharForLangId]
,[MaxCharToReadForLangId]
,[AutoTiffOCRForNoTextFiles]
,[AdvancedTiffOption]
,[ProjectCreatedVersion]
,[ProjectUpdatedVersion]
,[MinValidDateTime]
,[MinFreeSpaceRequiredForTempLocationInGB]
,[MinFreeSpaceRequiredForProjectLocationInGB]
,[IgnoreStateError]
,[EmailNotificationTimeoutInMinute]
,[AutoCopyCrashedDocument]
,[IsImageTypePDF]
,[ContentAccessVersion]
,[CleanContentVersion]
,[ShowIngestionErrorsWarningInExport]
,[IncludePartialOCRedFile]
,[ExtractTextFromMasterViewInPowerpoint]
,[TrackChangesOptionForFulltext]
,[ProjectCreatedFromVoD]
,[AllowAutoLaunchEmailThreading]
,[DoNotComputeLanguageIdentificationForSpreadsheets]
,[HashAlgorithmSecondary]
,[RemoveRedactedTiffOCRTextIFSlipSheet]
,[FileCopyOption]
,[LangIDFactoryType]
,[ExtractInternetEmailHeader]
,[IndexEmailHeader]
,[PopulateCustodianDedup]
,[AutoSearchTagSettings]
,[DefaultTiffTimeout]
,[CreateDefaultRedactionSets]
,[ExtractNSFView]
,[ComputeDedupeBasedOnCustodianPriority]
,[AutoComputeInclusiveEmail]
,[DefaultTiffColorOption]
,[NDDTagPropagationSetting]
,[SearchDuplicateOption]
,[ExcludeDisclaimerDuringIndexing]
,[HashFieldSettings]
,[AutoPopulateDuplicateFilePath]
,[IFSID]
,[MaxDSJobRetryCount]
,[AutoQueueTranscribing])
SELECT *
FROM OPENXML (@hdoc, '/WIHT' , 1)
WITH(
[ProjectID] [bigint] 'ProjectID',
[ClientName] [varchar](200) 'ClientName' ,
[clientid] [bigint] 'clientid',
[ProjectName] [varchar](200) 'ProjectName',
[DatabaseInstanceName] [varchar](200) 'DatabaseInstanceName',
[DedupingFlag] [bit] 'DedupingFlag',
[HashAlgorithm] [varchar](20) 'HashAlgorithm',
[DeNistingFlag] [bit] 'DeNistingFlag',
[IndexingFlag] [bit] 'IndexingFlag',
[RemoveSysFileFlag] [bit] 'RemoveSysFileFlag',
[FullTextSearchLevel] [int] 'FullTextSearchLevel',
[FileServerLocation] [nvarchar](2000) 'FileServerLocation',
[IndexLocation] [nvarchar](2000) 'IndexLocation',
[CreatedDate] [datetime] 'CreatedDate',
[UpdatedDate] [datetime] 'UpdatedDate',
[CreatedBy] [int] 'CreatedBy',
[UpdatedBy] [int] 'UpdatedBy',
[IndexFullText] [bit] 'IndexFullText',
[IndexMeta] [bit] 'IndexMeta',
[SSID] [bigint] 'SSID',
[ISID] [bigint] 'ISID',
[DSID] [bigint] 'DSID',
[MatterNumber] [nvarchar](2000) 'MatterNumber',
[AttorneyName] [varchar](100) 'AttorneyName',
[Notes] [varchar](max) 'Notes',
[LanguageIdentification] [bit] 'LanguageIdentification',
[OCRTextMinimumThreshold] [int] 'OCRTextMinimumThreshold',
[DefaultFullTextContent] [varchar](100) 'DefaultFullTextContent',
[AllowEmailAnalysis] [bit] 'AllowEmailAnalysis',
[CreatedMachineName] [nvarchar](200) 'CreatedMachineName',
[FSID] [int] 'FSID',
[IngestTimeoutPerFile] [bigint] 'IngestTimeoutPerFile',
[EmailAlertEnabled] [bit] 'EmailAlertEnabled',
[BackupStatus] [bit] 'BackupStatus',
[AllowOCR] [bit] 'AllowOCR',
[AutoQueueOCR] [bit] 'AutoQueueOCR',
[HighlightPrivilegedTermForDesktop] [bit] 'HighlightPrivilegedTermForDesktop',
[HighlightPrivilegedTermForWeb] [bit] 'HighlightPrivilegedTermForWeb',
[EdocEmbeddedFilter] [nvarchar](50) 'EdocEmbeddedFilter',
[EmailEmbeddedFilter] [nvarchar](50) 'EmailEmbeddedFilter',
[PPTEmbeddedFilter] [nvarchar](50) 'PPTEmbeddedFilter',
[HighlightSearchTermForDesktop] [bit] 'HighlightSearchTermForDesktop',
[HighlightSearchTermForWeb] [bit] 'HighlightSearchTermForWeb',
[RestrictMediaUpload] [bit] 'RestrictMediaUpload',
[RestrictExport] [bit] 'RestrictExport',
[AllowLocalStorageToMediaUpload] [bit] 'AllowLocalStorageToMediaUpload',
[AllowLocalStorageToExport] [bit] 'AllowLocalStorageToExport',
[WorkingMachineName] [nvarchar](200) 'WorkingMachineName',
[AllowTiff] [bit] 'AllowTiff',
[AllowColorTiff] [bit] 'AllowColorTiff',
[EmailFreqWeight] [decimal](4, 3) 'EmailFreqWeight',
[EmailNonGarbageWeight] [decimal](4, 3) 'EmailNonGarbageWeight',
[EmailSimilarityWeight] [decimal](4, 3) 'EmailSimilarityWeight',
[NonGarbageChars] [nvarchar](max) 'NonGarbageChars',
[MaxPageLimit] [int] 'MaxPageLimit',
[TimeoutMultiplier] [bigint] 'TimeoutMultiplier',
[GroupDatePriority] [nvarchar](50) 'GroupDatePriority',
[maxOcrTryCount] [bigint] 'maxOcrTryCount',
[PCTagPropagationsetting] [bit] 'PCTagPropagationsetting',
[DuplicateTagPropagationSetting] [int] 'DuplicateTagPropagationSetting',
[ReviewDatabaseInstanceName] [nvarchar](200) 'ReviewDatabaseInstanceName',
[ReviewDSID] [bigint] 'ReviewDSID',
[DefaultReviewerHourlyRate] [float] 'DefaultReviewerHourlyRate',
[PropagateTagToEmailThread] [bit] 'PropagateTagToEmailThread',
[FileExtensionFilterLevel] [nvarchar](100) 'FileExtensionFilterLevel',
[ApplyFileExtensionFilterOnContainer] [bit] 'ApplyFileExtensionFilterOnContainer',
[FileTypeFilterLevel] [nvarchar](100) 'FileTypeFilterLevel',
[ApplyFileTypeFilterOnContainer] [bit] 'ApplyFileTypeFilterOnContainer',
[NativeTiffExtOption] [bit] 'NativeTiffExtOption',
[OCRTextThresholdValue] [int] 'OCRTextThresholdValue',
[LocalTimeZone] [nvarchar](100) 'LocalTimeZone',
[NsfDateTimeFormat] [nvarchar](50) 'NsfDateTimeFormat',
[ShowEmailHeaderInFulltext] [bit] 'ShowEmailHeaderInFulltext',
[TzTimeZone] [nvarchar](100) 'TzTimeZone',
[ReviewerRateType] [nvarchar](50) 'ReviewerRateType',
[BlankThreshold] [float] 'BlankThreshold',
[LittleContentThreshold] [float] 'LittleContentThreshold',
[AutoQueueNative] [bit] 'AutoQueueNative',
[TiffPrintDocLimit] [int] 'TiffPrintDocLimit',
[TiffPrintPageLimit] [int] 'TiffPrintPageLimit',
[AutoQueueNDDSig] [bit] 'AutoQueueNDDSig',
[SlipSheetSettings] xml 'SlipSheetSettings',
[NDDSettings]xml 'NDDSettings',
[EnableNativeAutoPrefetch] [bit] 'EnableNativeAutoPrefetch',
[UseDedicatedServerOnly] [bit] 'UseDedicatedServerOnly',
[MinCharForLangId] [int] 'MinCharForLangId',
[MaxCharToReadForLangId] [int] 'MaxCharToReadForLangId',
[AutoTiffOCRForNoTextFiles] [bit] 'AutoTiffOCRForNoTextFiles',
[AdvancedTiffOption] xml 'AdvancedTiffOption',
[ProjectCreatedVersion] [nvarchar](200) 'ProjectCreatedVersion',
[ProjectUpdatedVersion] [nvarchar](200) 'ProjectUpdatedVersion',
[MinValidDateTime] [datetime] 'MinValidDateTime',
[MinFreeSpaceRequiredForTempLocationInGB] [bigint] 'MinFreeSpaceRequiredForTempLocationInGB',
[MinFreeSpaceRequiredForProjectLocationInGB] [bigint] 'MinFreeSpaceRequiredForProjectLocationInGB',
[IgnoreStateError] [bit] 'IgnoreStateError',
[EmailNotificationTimeoutInMinute] [bigint] 'EmailNotificationTimeoutInMinute',
[AutoCopyCrashedDocument] [bit] 'AutoCopyCrashedDocument',
[IsImageTypePDF] [bit] 'IsImageTypePDF',
[ContentAccessVersion] [nvarchar](100) 'ContentAccessVersion',
[CleanContentVersion] [nvarchar](100) 'CleanContentVersion',
[ShowIngestionErrorsWarningInExport] [bit] 'ShowIngestionErrorsWarningInExport',
[IncludePartialOCRedFile] [bit] 'IncludePartialOCRedFile',
[ExtractTextFromMasterViewInPowerpoint] [bit] 'ExtractTextFromMasterViewInPowerpoint',
[TrackChangesOptionForFulltext] [nvarchar](100) 'TrackChangesOptionForFulltext',
[ProjectCreatedFromVoD] [bit] 'ProjectCreatedFromVoD',
[AllowAutoLaunchEmailThreading] [bit] 'AllowAutoLaunchEmailThreading',
[DoNotComputeLanguageIdentificationForSpreadsheets] [bit] 'DoNotComputeLanguageIdentificationForSpreadsheets',
[HashAlgorithmSecondary] [nvarchar](10) 'HashAlgorithmSecondary',
[RemoveRedactedTiffOCRTextIFSlipSheet] [bit] 'RemoveRedactedTiffOCRTextIFSlipSheet',
[FileCopyOption] [nvarchar](200) 'FileCopyOption',
[LangIDFactoryType] [nvarchar](50) 'LangIDFactoryType',
[ExtractInternetEmailHeader] [bit] 'ExtractInternetEmailHeader',
[IndexEmailHeader] [bit] 'IndexEmailHeader',
[PopulateCustodianDedup] [bit] 'PopulateCustodianDedup',
[AutoSearchTagSettings] xml 'AutoSearchTagSettings',
[DefaultTiffTimeout] [int] 'DefaultTiffTimeout',
[CreateDefaultRedactionSets] [bit] 'CreateDefaultRedactionSets',
[ExtractNSFView] [bit] 'ExtractNSFView',
[ComputeDedupeBasedOnCustodianPriority] [bit] 'ComputeDedupeBasedOnCustodianPriority',
[AutoComputeInclusiveEmail] [bit] 'AutoComputeInclusiveEmail',
[DefaultTiffColorOption] [nvarchar](100) 'DefaultTiffColorOption',
[NDDTagPropagationSetting] [int] 'NDDTagPropagationSetting',
[SearchDuplicateOption] [int] 'SearchDuplicateOption',
[ExcludeDisclaimerDuringIndexing] [bit] 'ExcludeDisclaimerDuringIndexing',
[HashFieldSettings] xml 'HashFieldSettings',
[AutoPopulateDuplicateFilePath] [bit] 'AutoPopulateDuplicateFilePath',
[IFSID] [int] 'IFSID',
[MaxDSJobRetryCount] xml 'MaxDSJobRetryCount',
[AutoQueueTranscribing] [bit] 'AutoQueueTranscribing'
)
EXEC sp_xml_removedocument @hdoc
GO
SET IDENTITY_INSERT [dbo].tbl_pj_ProjectSetup OFF
GO
INSERT INTO tbl_pj_UserProjectAssociation(UserId,ProjectId)
select DISTINCT UserId,11 AS ProjectId from prj_ProjectAfterPatch_11..tbl_pj_UserProjectAssociation -- replace prj_ProjectAfterPatch_11 with your projectdatabase name
You will now be able to view the project in the list of projects from the user interface. Depending on your database version, you may receive a message indicating version incompatibility, which can be resolved by updating the project database.
- Navigate to your VenioDatabaseSetup.exe folder located where your console is installed.
- Navigate to "C:\Program Files\Venio\Venio Database\VenioDatabaseSetup.exe". Once the application opens, select the database and upgrade it.
QC your database pointers versus the physical filelocation:
- Check tbl_ex_fileinfo for the field Accesspath. This is the pointer to the native files.
- Check tbl_ex_FulltextFileLocation, tbl_ex_FullTextFileParts for the field FullTextFilelocation and PartLocation respectively. This is the pointer to your fulltexts.
- Similarly there are pointes for the OCR, TIFF etc files. They are listed in the following KB
Note: What information are you getting from your Access(native) paths\ Fulltext path?
In your Access path, the project name lies just before \NativeFiles, and \NativeFiles is followed by Projectid, Custodianid, Mediaid.
Same applies for Fulltext FileLocation: <ProjectName>\FulltextFiles\Projectid\Custodianid\Mediaid
Comments
0 comments
Please sign in to leave a comment.