Hi DGS

One possible reason springs to mind...

Did you translate the sheet names? If so, keep them as in the original sheets.

So, in English if the sheet name (i.e. the name on the tab at the bottom of the spreadsheet) is 'Sheet 1' in the source, keep it as 'Sheet 1' in the Target also.

Hope it's as simple as this...

All the best,

Ali

Hi Ali,

No, I didn't translate it. Thank you anyway.

Diana

Hi DGS

Could you post your common file settings so that we learn a bit more about your situation?

Daniel

Hi Daniel,

I have the following checked:

Headers and footers

Sheet names

and in Other settings:

Skip caracter spacing and kerning

Retan Studio target comments in target file

I could also send the error file, if you tell me how.

Thank you,

Diana

Hi DGS

You can post the error file (the "stack trace") like this:

(This is SDL's official image, which I grabbed from another thread.)

I share Alison Field's suspicion about Worksheet names.

What do the target segments of the worksheet names look like? You can get Studio to only show those lines by using the Advanced Display Filter:

I'd make sure to copy all source segment values to the target segments for the worksheet names.

Once you're done, just click on "Clear" in the Advanced Display Filter.

Does that help?

Daniel

Hi again,

The error file contents are:

<SDLErrorDetails time="12/08/2019 14:15:55">
<ErrorMessage>Failed to save target content: Object reference not set to an instance of an object.</ErrorMessage>
<Exception>
<Type>System.NullReferenceException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</Type>
<HelpLink />
<Source>Sdl.FileTypeSupport.Filters.Excel</Source>
<HResult>-2147467261</HResult>
<StackTrace><![CDATA[ at Sdl.FileTypeSupport.Filters.Excel.FilterControllerFramework.OfficeController.UpdateDocumentFile(XsltArgumentList argsList, XslCompiledTransform xslTransform, XPathNavigator child)
at Sdl.FileTypeSupport.Filters.Excel.FilterControllerFramework.OfficeController.IterateXsltFiles(XsltArgumentList argsList, FileMap rule, XPathNodeIterator iter, Boolean isUpdate, String targetFilePath)
at Sdl.FileTypeSupport.Filters.Excel.FilterControllerFramework.OfficeController.IterateContentType(String xslFileNamesPath, Boolean isUpdate, String filePath, String filterStr, String targetFilePath, Boolean isCalledByRelsTableIteration)
at Sdl.FileTypeSupport.Filters.Excel.FilterControllerFramework.OfficeController.serviceBackward()
at Sdl.FileTypeSupport.Filters.Excel.PlugInFilter.FileParser.DocumentParser.Update()
at Sdl.FileTypeSupport.Filters.Excel.PlugInFilter.FileParser.DocumentExtractImpl.Update(DocumentCollection srcCollection, String filename, String tgtFilePath)
at Sdl.FileTypeSupport.Filters.Excel.PlugInFilter.FileWriterAndPreviewFileWriter.WriterImpl.EndOfInput()
at Sdl.FileTypeSupport.Filters.Excel.PlugInFilter.FileWriterAndPreviewFileWriter.ExcelWriter.EndOfInput()
at Sdl.FileTypeSupport.Framework.Integration.NativeWriterMessagesProxy.EndOfInput()
at Sdl.FileTypeSupport.Framework.Integration.FileGenerator.CallEndOfInput()
at Sdl.FileTypeSupport.Framework.Integration.FileGenerator.FileComplete()
at Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.FileComplete()
at Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.FileComplete()
at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
at Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.FileComplete()
at Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReaderImpl.vv_Visit(TmfcReaderImpl* , FrameworkFileContainerField* field)
at FrameworkFileContainerField.vv_AcceptFrameworkVisitor(FrameworkFileContainerField* , FrameworkFieldVisitor* visitor)
at Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReaderImpl.vv_VisitStartEndField(TmfcReaderImpl* , StartEndField* startEnd)
at Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReaderImpl.b_VisitNext(TmfcReaderImpl* )
at Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReader.ParseNext()
at Sdl.FileTypeSupport.Framework.Integration.FileExtractor.ParseNext()
at Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.ParseNext()
at Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.Parse()
at Sdl.TranslationStudio.Editor.TranslationEditor.SaveMonolingualAsJobRequest.Execute(IJobExecutionContext context)
at Sdl.Desktop.Platform.Implementation.Services.Job.<_worker_DoWork>b__47_0()
at Sdl.Desktop.Logger.Log.Resources(Object message, Action action)
at Sdl.Desktop.Platform.Implementation.Services.Job._worker_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)]]></StackTrace>
</Exception>
<Environment>
<ProductName>SDL Trados Studio</ProductName>
<ProductVersion>15.0.0.0</ProductVersion>
<EntryAssemblyFileVersion>15.2.0.1041</EntryAssemblyFileVersion>
<OperatingSystem>Microsoft Windows 10 Home</OperatingSystem>
<ServicePack>NULL</ServicePack>
<OperatingSystemLanguage>3082</OperatingSystemLanguage>
<CodePage>1252</CodePage>
<LoggedOnUser>Diana\DianaG</LoggedOnUser>
<DotNetFrameWork>4.0.30319.42000</DotNetFrameWork>
<ComputerName>DIANA</ComputerName>
<ConnectedToNetwork>True</ConnectedToNetwork>
<PhysicalMemory>6171384 MB</PhysicalMemory>
</Environment>
</SDLErrorDetails>

And there's only one sheet and after filtering it looks like this:

My reply was considered "abusive" by the system. I'll try again (not including the error file contents and Trados Studio image after filtering).

There's only one Sheet and after filtering I can see Sheet1 in both the English and the target side. I Copied Source in that segment.

Hi agai,

Also I saved a *.sdladfsettings file, which I don't know how to send or check.

Thanks in advance.

Diana

You should be able to paste screenshots into these posts.

FIles should be zipped (covert to a zip archive).

... and if you use the @ character and type the recipient's name afterwards without a space, the person will get a notification, DGS:

Hi again. Let's see if it works now.

Any other ideas?

Thank you

DianaDg-error message and filter files.zip

Hi DGS

The settings file contained Advanced Display Filter settings...

I can't see from the stack trace what the problem is, but somebody with more expertise might well be able to. The old Excel filter type was a bit error-prone, but the 2016 is not.

Did you read this: https://multifarious.filkin.com/2019/01/09/wot-no-target/

I am quite sure you don't have to translate the whole project again. There are many options before that.

1. If you have the Professional version of Studio, you can do PerfectMatch, which did the job in my little test file (3 source segments with the same value but different translations):

Second project with the same source file, using the sdlxliff of the first project as bilingual match source:

2. There is a free app on the SDL AppStore called "Export to Excel". Maybe this is useful in your case although you can't re-import.

Daniel

Hi DGS

The settings file contained Advanced Display Filter settings...

I can't see from the stack trace what the problem is, but somebody with more expertise might well be able to. The old Excel filter type was a bit error-prone, but the 2016 is not.

Did you read this: https://multifarious.filkin.com/2019/01/09/wot-no-target/

I am quite sure you don't have to translate the whole project again. There are many options before that.

1. If you have the Professional version of Studio, you can do PerfectMatch, which did the job in my little test file (3 source segments with the same value but different translations):

Second project with the same source file, using the sdlxliff of the first project as bilingual match source:

2. There is a free app on the SDL AppStore called "Export to Excel". Maybe this is useful in your case although you can't re-import.

Daniel

Hi again,

I don't have the professional version. I'll try the app.

Thank your for your help.

Best regards,

Diana

Hi again,

I can't find the app  "Export to Excel" in SDL AppStore. Can anybody send me the link.

Best regards,

Diana

Hi DGS

Here's the link: Export to Excel

All the best,

Alison

I found that but It's not an App, but a "Correction to version 2.2 (2019)". I need the app.

Thank you,

Diana

DGS

It is an app.  The entire message says:

**Correction to version 2.2 (2019)**

- now signed so you don't get the warning message

Not the best English but it means the app was updated with a correction to ensure you don't get a warning message.  it was corrected in version 2.2.

Hi Paul,

I have it now supposedly installed. Now I need instructions to proceed. (I have no idea where it should be and how it works)

Can you help.

Best regards,

Diana

I found it myself. It's in Batch tasks.

Thank you all for your help.

Best regards,

Diana

DGS

Allow me to point out that the exported Excel file is NOT identical with the file you would have gotten had you "Saved as". But it might be a good source to reconstruct your translation from. 

Daniel

Good morning Daniel,

Yes it's a different format. Some columns appear as rows... I had to reconstruct it altogether, I'm afraid, that is to create a new project based on an older Excel version.

I also was able to "Export for bilingual review", which was also very helpful.

I usually export the target file before beginning to translate, but this time I forgot. It seemed so straightforward...

Anyway thank you very much for your help. I learned a lot.

Best regards,

Diana