How can I overwrite the source segment with the target segment in a CSV file, with Studio 2011
Thread poster: Séverine Paolozzi

Séverine Paolozzi  Identity Verified
France
Local time: 18:09
English to French
+ ...
Aug 8, 2013

Hello,

I translated a csv file with Studio 2011.

When saving the .sdlxliff file as the target format, the result in the CSV file is not the same as with other file formats. In the target csv file, the segments are duplicated, that is I have the English segment (source segment) followed by the French segment (target) on the same line.

I thought the translated segment would have overwritten the source segment.

Where can I specify that I want only the target text in the final file? Thanks a lot!


 

Soonthon LUPKITARO(Ph.D.)  Identity Verified
Thailand
Local time: 23:09
Member (2004)
English to Thai
+ ...
File type setting Aug 8, 2013

Séverine Paolozzi wrote:

When saving the .sdlxliff file as the target format, the result in the CSV file is not the same as with other file formats. In the target csv file, the segments are duplicated, that is I have the English segment (source segment) followed by the French segment (target) on the same line.

I thought the translated segment would have overwritten the source segment.

Where can I specify that I want only the target text in the final file? Thanks a lot!


You can select the column as target texts by setting the file type options in Studio 2011 Option menu item [*.csv and *.txt files have similar settings]

Soonthon Lupkitaro


 

Séverine Paolozzi  Identity Verified
France
Local time: 18:09
English to French
+ ...
TOPIC STARTER
I configured the settings in the Options Window but the target column keeps display in the final csv Aug 8, 2013

Thanks Soonthon,

I selected Source column : 1
Target colum : 1,

as advised in the help sections, to have only the target column, but the source text keeps diplaying, with the target text next tot it.

Same thing in the TXT format options (I changed the csv extension to the TXT extension).

The settings are as follows:

separator: tab - checked
source column: 1
target colum: 1
minimum column number: 1

text between quotes: checked

Are my settings correct ?

Thanks for your help!

Séverine


 

SDL Community  Identity Verified
United Kingdom
Local time: 18:09
English
The settings look correct... Aug 8, 2013

... perhaps you have not parsed the file again and are simply changing the settings on the existing project? You have to make the changes to the filetypes before you open them for the first time or add them to your Project. So make the changes in Tools -> Options and not Project Settings and then try again.

Regards

paul


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

How can I overwrite the source segment with the target segment in a CSV file, with Studio 2011

Advanced search







Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search