• State Verified Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 432 subscribers
  • Views 561 views
  • Users 0 members are here
Options
Related

Excelが翻訳メモリに変換できない

Hiromi M

Excelを翻訳メモリに変換しようと以下の公式サイトを確認しつつ試みたのですが、うまくできません。

https://www.trados.com/jp/blog/excel-to-tm/

問題点：

・エクセルを取りこんだ後、トラドスの「エディタ」ビューをみると、エクセルにある訳文列がすべてトラドスの原文列に取り込まれてしまう状態です。※添付ファイル参照

　→トラドスの訳文列は空欄、1行目にはエクセルのシート名(sheet1など）が入ってしまうようです（特に不要）

・上記サイトに記載の［ファイル］>［オプション］>［ファイルの種類］の設定や、［ファイルの種類］>［バイリンガルExcel］>［全般設定］の設定は実施済みです。

以前はエクセルから翻訳メモリに変換できていたのですが、先日Tradosのアップデートをしたせいなのか、何か自分で設定を変えてしまったのか、

これまで取り込みできていたはずのエクセルも上記の現象になっていまい、うまく翻訳メモリとして取りこめなくなってしまいました。

もし解決策がありましたら教えていただけると嬉しいです。すみませんがよろしくお願いいたします。

Excel spreadsheet with three columns labeled A, B, and C. Column A has numbers 1 to 9, Column B has 'Sample' in English, and Column C has 'Sample' transliterated from Japanese.Trados Studio Editor view showing the 'Sheet1' label in the first row, followed by rows with source text from the Excel file. The target column is empty, and there are checkboxes on the right.

Generated Image Alt-Text
[edited by: RWS Community AI at 4:40 AM (GMT 1) on 27 May 2024]
emoji
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents
  • +1

      

    The problem appears to be that you may have configured the Bilingual Excel filetype, but this is not the one being used to parse the file.  This is clear because the source column contains both Japanese and English.

    Make sure that you have either deselected the Excel filetype in your options (or project template), or made sure that the Bilingual Excel filetype is above the Excel filetype in your list of filetype before you create your project.

    I have shown both solutions one after the other in this video (no sound)... I hope that helps:

    Play this video

    It's also explained in the blog article you shared in case this is clearer:

    Screenshot of Trados Studio file type settings showing a list of file types with 'Bilingual Excel' highlighted and positioned below 'Microsoft Excel 2007-2019' in the list.

    Paul Filkin | RWS Group

    ________________________
    Design your own training!
    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

    emoji


    Generated Image Alt-Text
    [edited by: RWS Community AI at 7:28 PM (GMT 1) on 30 May 2024]
Reply
  • +1

      

    The problem appears to be that you may have configured the Bilingual Excel filetype, but this is not the one being used to parse the file.  This is clear because the source column contains both Japanese and English.

    Make sure that you have either deselected the Excel filetype in your options (or project template), or made sure that the Bilingual Excel filetype is above the Excel filetype in your list of filetype before you create your project.

    I have shown both solutions one after the other in this video (no sound)... I hope that helps:

    Play this video

    It's also explained in the blog article you shared in case this is clearer:

    Screenshot of Trados Studio file type settings showing a list of file types with 'Bilingual Excel' highlighted and positioned below 'Microsoft Excel 2007-2019' in the list.

    Paul Filkin | RWS Group

    ________________________
    Design your own training!
    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

    emoji


    Generated Image Alt-Text
    [edited by: RWS Community AI at 7:28 PM (GMT 1) on 30 May 2024]
Children