Processing A Plain Bilingual Excel File for Reviewing Stage in Trados

Introduction

Editing a prepared file as an xliff file is relatively easy. We only need to edit the file and send it back as a return package or target format. But, what if the file is a plain bilingual Excel file with a thousand rows, and you need to check the translation against a glossary in another Excel file?

Manually checking a translation against the glossary is very time-consuming and will possibly leaving the inconsistencies untouched.

So, how do we import the Excel files (the translated and glossary files) to CAT tools such as Trados to effectively and quickly check the translation using the built-in spellchecker, segment verifier, and terminology checker? Read More

Selecting Specific Excel Rows To Be Translated In MemoQ

Have you ever experienced the following scenario?

  1. You are using MemoQ (or a client wants you to use MemoQ);
  2. Assuming you get an Excel file contains a lot of rows. There are 2 columns there: column A is for the source text and column B is for the target text. It can also contain more than 2 columns: column A is for the source text, column B is for the target text (Arabic), column C is for target text (Italian), column D is for target text (Indonesian), etc;
  3. You want to translate specific rows because the other rows are already translated, or because you add more texts that need to be translated. You don’t want to create another Excel file that contains the new text only to be imported to MemoQ—and later, the translation is imported/copied back to the original Excel file—so you need to use the original file and select only the rows you need;
  4. How do you select those specific rows from the original file so they—those specific rows only—can be displayed in MemoQ?

Here I show you how to select the specific rows so they can be displayed in MemoQ and the other rows are hidden: Read More

Using ReNamer App To Solve “Failed To Import WorldServer Return Package” In SDL Trados

Failed to Import WorldServer Return Package to Trados?

As I mentioned in my previous post that a return package is basically a zip file, it means that a return package can be manually extracted using WinRar, Winzip, or similar apps to see the contents (which are xliff files). So, knowing that the return package contains xliff files, later, we can manually put them into SDL Trados’ project folder to update the project files.

After extracting the contents of the return package file, we will find that the file name contains language code. Example: sampletranslation.idmlid-ID.xliff, where the id-ID is the language code for Indonesian. Yours might be different, depends on the language pair you work on.

Read More

Failed To Import “sdlrpx.wsxz” File Into SDL Trados

Background

A few days ago, one of my colleagues asked for help from me. He got a revision job, but he couldn’t open an <sdlrpx.wsxz> file, a Worldserver return package he received from an agency he worked for. When he tried to import the file after opening the original package, he got a warning: “The translation package doesn’t contain necessary information. The package you are importing may be a return package.”

The PM had no idea how to open it. Later, he only sent the <.xliff> files so my colleague could check the translation by opening those files one by one without updating the main package.

My colleague asked me if there was any possible way to open the return package, so he could update the package and send back the file in return package format. He had tried to Googling the tricks but found no relevant information. Read More

Online Profile vs. Online Presence Di Dunia Freelancing (Bag. 2)

Bagaimana kita bisa sukses dengan mengandalkan online presence?

Setelah di tulisan sebelumnya saya sedikit bercerita tentang pengalaman saya soal profil daring dan kehadiran daring, kali ini saya ingin menjawab beberapa pertanyaan yang mungkin muncul di benak rekan-rekan pembaca. Misalnya:

  1. Setelah saya aktif di LinkedIn, apakah pekerjaan saya terus mengalir?
  2. Apakah tingkat view pada profil dan postingan saya terus meningkat serta berakhir dengan menghasilkan kesepakatan-kesepakatan yang menguntungkan (baca: mendapat job baru)?
  3. Apakah hanya di LinkedIn kita bisa “sukses”?

Jawaban untuk pertanyaan pertama

Pekerjaan saya terus mengalir bukan semata-mata karena saya aktif di LinkedIn. Tapi kesempatan-kesempatan baru memang terus bermunculan setelah saya benar-benar aktif di LinkedIn (terhubung dan berinteraksi dengan banyak sesama penerjemah serta staf agensi penerjemahan).

Jika saat ini usaha pemasaran rekan-rekan ada di posisi stagnan, entah belum punya akun di LinkedIn ataupun sudah punya akun tapi belum aktif di LinkedIn, maka mulai sekarang cobalah untuk aktif di LinkedIn. Banyak peluang akan muncul ketika kita terhubung dan berinteraksi dengan lebih banyak orang.

Bila sebelumnya Anda telah membaca artikel saya tentang 50.000+ agensi penerjemahan sedang mencari freelancer, saya yakin Anda telah menghubungi begitu banyak agensi. Nah, jika belum ada yang merespons, jika perlu, lakukan pendekatan baru melalui LinkedIn. Cari tahu siapa saja staf agensi tersebut yang memiliki akun LinkedIn (PM, vendor manager, business development manager, atau siapa saja), lalu jalin pertemanan dengan mereka. Anda bisa menghubungi mereka melalui fitur obrolan (chat), atau lakukan posting secara teratur agar mereka “melihat” siapa Anda. Bila perlu, libatkan mereka dalam postingan Anda. Hanya saja, lakukan perlahan, jangan tiba-tiba secara serampangan menandai (tag) mereka atau menyebut (mention) mereka dalam postingan maupun komentar. Pastikan dulu mereka mau di-tag atau di-mention.

Nantinya, semakin sering Anda berinteraksi dengan mereka, semakin mereka melihat siapa Anda. Bukan tidak mungkin mereka akan menawarkan kerja sama. Malah sepengalaman saya, ada yang baru lihat profil saya, minta berteman, lalu menawarkan kesempatan untuk menjadi freelancer mereka. Usut punya usut, jauh-jauh hari sebelum mereka melihat profil saya, mereka sudah sering melihat postingan saya (yang di-like atau dikomentari oleh koneksi mereka sehingga secara otomatis mereka juga bisa melihat postingan saya).

How to Translate <.ini> Files in SDL Trados

Last September, I got a task to translate some UI files from one of my clients based in the USA. The client said that there would be so many repetitions across the files, so I thought that the process would be super fast. Unfortunately, the client asked me to use their own developed translation tool (not strictly required, but it would be good if I used it, the client said). Read More

Memulihkan File SDL yang Rusak Karena Proses Batch Find and Replace

Kita sedang menyunting satu paket file <.sdlppx> yang berisi 24 file <.sdlxliff>. Setelah melakukan QA di Xbench, ditemukan banyak ketidakkonsistenan pada segmen repetisi dan harus diseragamkan menggunakan SDL Batch Find and Replace.

Bagaimana jika proses find and replace di SDL Trados seperti pada tulisan saya yang terdahulu ternyata “merusak” file yang sedang kita kerjakan (dengan catatan bahwa opsi Create backups for changed files diaktifkan)? Read More