This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
Importing excel to multiterm - applying a batch status
Thread poster: Wendy Cummings
Wendy Cummings United Kingdom Local time: 23:01 Member (2006) Spanish to English + ...
Nov 22, 2011
I have an excel spreadsheet that I wish to convert then import into a new termbase. The spreadsheet just has 2 columns, source and target.
The termbase definition that I will be using has a "status" field, one of the options for which is "client approved". When I import the spreadsheet, I want every single item from that spread sheet to have the status "client approved".
What is the best way to do this?
Thanks.
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Martina Klett Germany Local time: 00:01 Member Italian to German + ...
Insert an additional column in the excel file
Nov 22, 2011
Dear Wendy,
there may be other solutions, but I would simply insert an additional column in excel called "status" and containing the value "client approved" for each term before converting the excel file. If you want to add the status to both source and target terms, then you should add said column after the source term column and after the target term column.
HTH Martina
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
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.
The leading translation software used by over 270,000 translators.
SDL Trados Studio 2021 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2021 transforms how new users get up and running and helps experienced users make the most of the powerful features.