CafeTran

 Hello!

I'm totally new to Cafetran, although I have been using other CAT tools for a while.

I was wonder if Cafetran is able to import CSV files and translate one column of them.

My files have the following format

"//Comment 1"
"//Comment 1"
"$_Languages"
"16(1) Italiano (Italia)";"512(32) $_Undefined"
"$_Typ(InterfaceComment)"
"//Max. text: 00 char"
"//$_Date 22/08/2017 10.39.12"
"TRANSLATE THIS 1";"TRANSLATE THIS 1"

"TRANSLATE THIS 2";"TRANSLATE THIS 2"

"TRANSLATE THIS 3";"TRANSLATE THIS 3"

"TRANSLATE THIS 4";"TRANSLATE THIS 4"

"TRANSLATE THIS 5";"TRANSLATE THIS 5"

Etc.

As you can see the first few lines do not have a column separator

Additionally, should Cafetran be able to import this type of files, is there any way I can export an interchange format (XLIFF, for instance) and reimport it into Cafetran (so I can do the translation in a CAT I am familiar with and for which I have 20 years of TMs)?

Thanks a lot for any advice!!!!

You can translate CSV via Excel file format. You can then determine which columns you want to translate and where they should be positioned.

All CafeTran projects are XLIFF, so yes, you can translate them in your other tool.

If you don't mind me asking, why go via CafeTran?

Thanks for getting back to me so quick!
A number of reasons
My other tool requires me to mark red the column I don't want translating (in this case column A).
In this project I have over 40 small files, and soon-coming projects will include upwards of 200 separate files.
With my other tool, I'd have to open each file, mark the first column red, save as XLX, translate, export, and reconvert each file to CSV....
I was hoping CafeTran could just import the second column of all files in one fell swoop, and re-export them as CSV and that's it

 

So you're using Déjà Vu? ;)

>I was hoping CafeTran could just import the second column of all files in one fell swoop, 

It can

>and re-export them as CSV and that's it

Not sure what you're trying to do here. Re-import in the other tool via CSV?

BTW:

>My other tool requires me to mark red the column I don't want translating (in this case column A).
In this project I have over 40 small files, and soon-coming projects will include upwards of 200 separate files.

(it's not forbidden to mention other CAT tools here, we're not like that here ;) )

This workflow sounds like a candidate for a macro. It's not that difficult to assign the read colour to the nth column of all open worksheets or even to all worksheets in a folder.

There are Excel VBA gurus in the Déjà Vu YahooGroup!

:-))
Yes, I use DejaVu, and in this project I did consider writing a VBA macro, but time was a little short, so I just set the first column red and saved as XLSX manually. Faster than messing about with VBA, for now.

Since this sort of work is expected to be quite frequent and regrettably DVXn cannot import CSV files other than as text files, my idea was to find a CAT with an affordable license (ie CafeTran), import all the CSVs, export the XLIFF to translate with DVX3 (for which I have 20 years of TMs), reimport into CafeTran, and export the CSVs without having to go through Excel.

Having said that, I have been trying to import a test file into a CafeTran trial version but I don't seem to be able to understand how I can tell CafeTran to import Column B (or A, it does not matter) and export the translation to Column B.

Anyway, not urgent at the moment...

Lorenzo

 

Perhaps it's good to mention that CafeTran can leverage Déjà Vu TMs perfectly, since they have the same principle (no formatting garbage, placeholders for tags) ...

Anyway, here's an example of a worksheet:

Import it in CafeTran and instruct the tool to insert the translation in the 2nd column:

Now we're cooking:

Not exactly an answer to your question, but perhaps you find it interesting nevertheless ;).