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
"16(1) Italiano (Italia)";"512(32) $_Undefined"
"//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"
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?
So you're using Déjà Vu? ;)
>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
Not sure what you're trying to do here. Re-import in the other tool via CSV?
>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!
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 ;).