Hi there everybody,
I have created an interesting Excel file for a Sports database that have Media column (names of images) and of course I know how to create a proper Media termbase. Every time I try to convert this to a termbase I get errors like the attached, and the process fails! I inspected everything, including proper media names, making sure there are not strange characters and everything is perfect, but I keep getting those errors! I did everything from asking ChatGPT to researching the web, but I could not get a clue! What surprised me is that when I split the Excel file into two files (50 k rows), I managed to convert both termbases without a single error, and that raises a big question mark really! Unfortunately, I can not share the Excel file because it is proprietary data, but if you can really help explaining why this error happens, that would be really appreciated.
Thanks again. It is almost 3:am here and I have been battling with this for the past 4 hours, believe it or not!
Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.
Source: Microsoft JET Database Engine
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at Sdl.MultiTerm.Tools.GlossaryConverter.Filters.PicklistEditor.WriteSchema(XmlDocument schema)
at Sdl.MultiTerm.Tools.GlossaryConverter.Filters.PicklistEditor.UpdateCollectedFields()
at Sdl.MultiTerm.Tools.GlossaryConverter.Filters.SdlTbWriter.Finalise()
at Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.Converter.Convert(List`1 inputFilters, List`1 inputPaths, IFilter outputFilter)
at Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.FileHandler.HandleMultipleFiles(List`1 files)
at Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.FileHandler.ProcessFiles(List`1 files)
Program version 6.4.9138.36048
Windows version: Windows 10, Build 19045, 64 bit (English (United States))
.net versions:
v2.0.50727 2.0.50727.4927 SP2
v3.0 3.0.30729.4926 SP2
v3.5 3.5.30729.4926 SP1
Client 4.8.09037
Full 4.8.09037
Client 4.0.0.0
MultiTerm version: MultiTerm 18.0.0.0
<Settings version="4">
<Fields>
<Field>
<FieldName>Player ID</FieldName>
<FieldType>EntryField</FieldType>
<FieldContent>Text</FieldContent>
<Ignore>false</Ignore>
</Field>
<Field>
<FieldName>JS Player ID</FieldName>
<FieldType>EntryField</FieldType>
<FieldContent>Text</FieldContent>
<Ignore>false</Ignore>
</Field>
<Field>
<FieldName>Sport</FieldName>
<FieldType>TermField</FieldType>
<FieldContent>Text</FieldContent>
<Ignore>false</Ignore>
</Field>
<Field>
<FieldName>National Team</FieldName>
<FieldType>TermField</FieldType>
<FieldContent>Text</FieldContent>
<Ignore>false</Ignore>
</Field>
<Field>
<FieldName>National Team Number</FieldName>
<FieldType>TermField</FieldType>
<FieldContent>Text</FieldContent>
<Ignore>false</Ignore>
</Field>
<Field>
<FieldName>Club</FieldName>
<FieldType>TermField</FieldType>
<FieldContent>Text</FieldContent>
<Ignore>false</Ignore>
</Field>
<Field>
<FieldName>Club Number</FieldName>
<FieldType>TermField</FieldType>
<FieldContent>Text</FieldContent>
<Ignore>false</Ignore>
</Field>
<Field>
<FieldName>Weight (kg)</FieldName>
<FieldType>TermField</FieldType>
<FieldContent>Text</FieldContent>
<Ignore>false</Ignore>
</Field>
<Field>
<FieldName>Height (cm)</FieldName>
<FieldType>TermField</FieldType>
<FieldContent>Text</FieldContent>
<Ignore>false</Ignore>
</Field>
<Field>
<FieldName>Position</FieldName>
<FieldType>TermField</FieldType>
<FieldContent>Text</FieldContent>
<Ignore>false</Ignore>
</Field>
<Field>
<FieldName>Preferred Foot</FieldName>
<FieldType>TermField</FieldType>
<FieldContent>Text</FieldContent>
<Ignore>false</Ignore>
</Field>
<Field>
<FieldName>Age</FieldName>
<FieldType>TermField</FieldType>
<FieldContent>Text</FieldContent>
<Ignore>false</Ignore>
</Field>
<Field>
<FieldName>Date of Birth</FieldName>
<FieldType>TermField</FieldType>
<FieldContent>Text</FieldContent>
<Ignore>false</Ignore>
</Field>
<Field>
<FieldName>Nationality</FieldName>
<FieldType>TermField</FieldType>
<FieldContent>Text</FieldContent>
<Ignore>false</Ignore>
</Field>
<Field>
<FieldName>Media</FieldName>
<FieldType>TermField</FieldType>
<FieldContent>Media</FieldContent>
<Ignore>false</Ignore>
</Field>
<Field>
<FieldName>English</FieldName>
<FieldType>Language</FieldType>
<FieldContent>Language</FieldContent>
<Ignore>false</Ignore>
<LanguageCode>en</LanguageCode>
</Field>
<Field>
<FieldName>Arabic</FieldName>
<FieldType>Language</FieldType>
<FieldContent>Language</FieldContent>
<Ignore>false</Ignore>
<LanguageCode>ar</LanguageCode>
</Field>
</Fields>
<Windows>
<Settings>
<Left>889</Left>
<Top>189</Top>
<Width>660</Width>
<Height>599</Height>
</Settings>
<MainWindow>
<Left>905</Left>
<Top>238</Top>
<Width>390</Width>
<Height>390</Height>
</MainWindow>
<ContentType>
<Left>1092</Left>
<Top>439</Top>
<Width>400</Width>
<Height>245</Height>
</ContentType>
<ChooseLanguage>
<Left>961</Left>
<Top>176</Top>
<Width>400</Width>
<Height>240</Height>
</ChooseLanguage>
<PicklistValues>
<Left>1235</Left>
<Top>480</Top>
<Width>400</Width>
<Height>220</Height>
</PicklistValues>
</Windows>
<AlwaysShowFieldsDialog>false</AlwaysShowFieldsDialog>
<CheckForUpdates>true</CheckForUpdates>
<PlaySound>false</PlaySound>
<PerformanceMode>false</PerformanceMode>
<XpathAllowRedundantFields>false</XpathAllowRedundantFields>
<PlainExcelMode>false</PlainExcelMode>
<ExcelHistory>false</ExcelHistory>
<ExcelTags>true</ExcelTags>
<CollapseExcelFields>true</CollapseExcelFields>
<RawMode>false</RawMode>
<DetectWebLinks>true</DetectWebLinks>
<MergeFiles>false</MergeFiles>
<SkipReorgTermbase>false</SkipReorgTermbase>
<UseTermbaseTemplate>false</UseTermbaseTemplate>
<UseMasterTermbase>false</UseMasterTermbase>
<MergeLanguages>false</MergeLanguages>
<MergeSubLanguages>false</MergeSubLanguages>
<ExportEntryNumber>false</ExportEntryNumber>
<MasterTermbase></MasterTermbase>
<MergeField></MergeField>
<TermbaseTemplate></TermbaseTemplate>
<Synonyms>
<Type>OneLine</Type>
<Column></Column>
<Repeat>false</Repeat>
<Separator>|</Separator>
</Synonyms>
<MultiFieldMode>MultipleFields</MultiFieldMode>
<DefaultOutputFilter>MultiTerm Termbase</DefaultOutputFilter>
<UiLocale>en</UiLocale>
<UiTheme>Default</UiTheme>
<SettingsPage>TabFormats</SettingsPage>
<EmptyOutput>false</EmptyOutput>
<IgnoreUnknownFields>false</IgnoreUnknownFields>
<CreateEmptyFields>false</CreateEmptyFields>
<WriteDocType>true</WriteDocType>
<VerifyXml>true</VerifyXml>
<SkipVerify>false</SkipVerify>
<CreationUser>glossaryconverter</CreationUser>
<TbCopyright></TbCopyright>
<TbDescription></TbDescription>
<UseContentFilter>false</UseContentFilter>
<RegexContentFilter>false</RegexContentFilter>
<ContentFilterText></ContentFilterText>
<Tbx>
<XcsSupport>false</XcsSupport>
<XcsAsk>false</XcsAsk>
<V2Basic>false</V2Basic>
<Dialect>Core</Dialect>
<ResolveNote>true</ResolveNote>
<MappingFile></MappingFile>
<Tbx3Mode>Pragmatic</Tbx3Mode>
<UseMappingFile>false</UseMappingFile>
</Tbx>
<TbxHistory>false</TbxHistory>
<BilingualSourceLanguage></BilingualSourceLanguage>
<BilingualTargetLanguage></BilingualTargetLanguage>
<ForceBilingual>false</ForceBilingual>
<ForceBilingualHeader>false</ForceBilingualHeader>
<OutputChangeFolder>false</OutputChangeFolder>
<OutputFolder></OutputFolder>
<SilentOverwrite>false</SilentOverwrite>
<OpenOutput>false</OpenOutput>
<UseLibreOffice>false</UseLibreOffice>
<UseMultiterm>true</UseMultiterm>
<UseStudio>true</UseStudio>
<SortMode>Source</SortMode>
<ResolveXmlEntities>false</ResolveXmlEntities>
<SdltmWaitMinutes>20</SdltmWaitMinutes>
<ExportTradosTmx>false</ExportTradosTmx>
<RemoveEmptyColumns>false</RemoveEmptyColumns>
<PicklistSeparator>,</PicklistSeparator>
<MultiFieldSeparator>~</MultiFieldSeparator>
</Settings>
in: H:\VIP Translation Resources\All Terminology\Kooora\kooora-Player_Names_Termbase.xlsx
out: H:\VIP Translation Resources\All Terminology\Kooora\kooora-Player_Names_Termbase.sdltb
Conversion start: 5/18/2025 2:24:55 AM
**** There has been an error writing entry #61945. English = Matisse Samoise
System.Data.OleDb.OleDbException (0x80004005): Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at Sdl.MultiTerm.Tools.GlossaryConverter.Filters.SdlTbWriter.AddMediaToDatabase(String blob, String name)
at Sdl.MultiTerm.Tools.GlossaryConverter.Filters.SdlTbWriter.ProcessMedia(GlossaryField field)
at Sdl.MultiTerm.Tools.GlossaryConverter.Filters.SdlTbWriter.CreateFieldXml(GlossaryField field)
at Sdl.MultiTerm.Tools.GlossaryConverter.Filters.SdlTbWriter.CreateTermXml(GlossaryTerm term)
at Sdl.MultiTerm.Tools.GlossaryConverter.Filters.SdlTbWriter.CreateLanguageXml(GlossaryLanguage language)
at Sdl.MultiTerm.Tools.GlossaryConverter.Filters.SdlTbWriter.CreateEntryXml(GlossaryEntry entry)
at Sdl.MultiTerm.Tools.GlossaryConverter.Filters.SdlTbWriter.Write(GlossaryEntry entry)
at Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.Converter.ConvertOneFile(IFilter inputFilter, IFilter outputFilter, String inputPath, FieldReader fieldReader)
Total entries: 61945
Total terms: 123879
Errors: 1
Written: 61944
Filtered: 0
Conversion end: 5/18/2025 2:26:15 AM
Conversion time: 00:01:06.0109312
**** There was an error creating the output file.
System.Data.OleDb.OleDbException (0x80004005): Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at Sdl.MultiTerm.Tools.GlossaryConverter.Filters.PicklistEditor.WriteSchema(XmlDocument schema)
at Sdl.MultiTerm.Tools.GlossaryConverter.Filters.PicklistEditor.UpdateCollectedFields()
at Sdl.MultiTerm.Tools.GlossaryConverter.Filters.SdlTbWriter.Finalise()
at Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.Converter.Convert(List`1 inputFilters, List`1 inputPaths, IFilter outputFilter)
at Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.FileHandler.HandleMultipleFiles(List`1 files)
at Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.FileHandler.ProcessFiles(List`1 files)

Translate