How to add client/subject info to a TM derived from an imported TMX file?
Thread poster: Olaf Reibedanz

Olaf Reibedanz  Identity Verified
Colombia
Local time: 07:38
Member (2003)
English to German
+ ...
May 9, 2012

Hi everybody,

Sometimes a customer sends me a TM (in TMX format) that lacks client/subject attributes. Does anybody know how I can add that info myself, after importing the TMX file into a Déjà Vu TM? Any fancy SQL command?

Many thanks in advance!

Olaf


 

Selcuk Akyuz  Identity Verified
Turkey
Local time: 15:38
Member (2006)
English to Turkish
+ ...
SQL statement May 9, 2012

Hi Olaf,

You can use these SQL statements:

UPDATE Translations SET Client = '***'
UPDATE Translations SET Subject = '###'

Described in detail at http://cattoolshelp.blogspot.com/2012/05/sql-statement-to-add-client-and-subject.html


 

FarkasAndras  Identity Verified
Local time: 13:38
English to Hungarian
+ ...
In TMX May 9, 2012

Alternatively, you can do this before importing by hacking the TMX file.
Replace
<tuv xml:lang="[code of language 1]">
with
<prop type="Txt::Client">[name of client]</prop>
<prop type="Txt::Subject">[subject area]</prop>
<tuv xml:lang="[code of language 1]">

Back up your TMX file beforehand, of course.


 

Olaf Reibedanz  Identity Verified
Colombia
Local time: 07:38
Member (2003)
English to German
+ ...
TOPIC STARTER
Thanks Selcuk and Farkas! May 10, 2012

I used the method suggested by Selcuk because it was faster, and it did indeed work like a charmicon_smile.gif

 

Olaf Reibedanz  Identity Verified
Colombia
Local time: 07:38
Member (2003)
English to German
+ ...
TOPIC STARTER
Tried to apply the method on another TM, but without success this time Mar 7, 2013

Hi everybody,

After nearly a year without using this method, I just tried to use it again on another TM (and with different client/subject info) but without success. I got the following error message: "There was a syntax error in the SQL WHERE clause you provided."

Has anybody got a clue what might be the reason?


 

Selcuk Akyuz  Identity Verified
Turkey
Local time: 15:38
Member (2006)
English to Turkish
+ ...
TM or TB Mar 7, 2013

Hi Olaf,

These 2 SQL statements are correct for TMs but is it a Translation Memory or Termbase?

Restart Windows, it will clear cache.

Selcuk


 

Olaf Reibedanz  Identity Verified
Colombia
Local time: 07:38
Member (2003)
English to German
+ ...
TOPIC STARTER
TM Mar 7, 2013

Hi Selcuk,

Thanks for your fast reply! I tried to execute this command in several TMs and with different client/subject info, but without success, even after rebooting my computer.

Any other ideas? I am befuddled because it worked flawlessly last year.


 

Selcuk Akyuz  Identity Verified
Turkey
Local time: 15:38
Member (2006)
English to Turkish
+ ...
Temporary files Mar 7, 2013

AFAIR, deleting temporary files was suggested by somebody at Yahoo list.

Selcuk


 

Olaf Reibedanz  Identity Verified
Colombia
Local time: 07:38
Member (2003)
English to German
+ ...
TOPIC STARTER
Deleting temporary files Mar 8, 2013

Hi Selcuk,

Just to make sure I am doing the right thing: Where and how exactly should I delete the temporary files?

Thanks,

Olaf


 

Selcuk Akyuz  Identity Verified
Turkey
Local time: 15:38
Member (2006)
English to Turkish
+ ...
temporary files Mar 8, 2013

Hi Olaf,

I use Windows XP and Disk Cleanup works for me. You can also use CCleaner
http://www.piriform.com/ccleaner

Found that message at Yahoo group http://tech.groups.yahoo.com/group/dejavu-l/message/119801


 

Olaf Reibedanz  Identity Verified
Colombia
Local time: 07:38
Member (2003)
English to German
+ ...
TOPIC STARTER
Problem continues after deleting temporary files Mar 9, 2013

Dear Selcuk,

I have Windows 7 installed on my computer and I regularly delete my temporary files using CCleaner, but I still can't execute the SQL command. Any other solutions that you can think ok?

I just updated DVX to the latest build, but that didn't solve the problem either. Only difference: The error message now reads: "SQL syntax error" (whereas previously it said: "There was a syntax error in the SQL WHERE clause you provided.")

Kind regards,

Olaf

[Edited at 2013-03-09 12:59 GMT]


 

Selcuk Akyuz  Identity Verified
Turkey
Local time: 15:38
Member (2006)
English to Turkish
+ ...
SQL but filter or command Mar 9, 2013

Hi Olaf,

Perhaps you are using the filter, it does not work of course. Commands should be inserted at Translation Memory > Execute SQL menu.

Selcuk


------------------

Are you using DVX or DVX2? Latest build? Please name it, currently 8.0611 for DVX2.


[Edited at 2013-03-09 13:07 GMT]


 

Olaf Reibedanz  Identity Verified
Colombia
Local time: 07:38
Member (2003)
English to German
+ ...
TOPIC STARTER
Problem solved! Mar 9, 2013

Shame on me, I did indeed click on the filter (instead of executing the SQL command through the menu bar via Translation Memory > Execute SQL)!

Silly mistake really, but I am glad the problem is sorted! I am going to make a screenshot of this immediately so that I won't repeat that mistake ever againicon_wink.gif

Thanks a lot for your help, Selcuk!

[Edited at 2013-03-09 13:28 GMT]


 


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

Moderator(s) of this forum
Pavel Tsvetkov[Call to this topic]

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

How to add client/subject info to a TM derived from an imported TMX file?

Advanced search






SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running, helps experienced users make the most of the powerful features, ensures new

More info »
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 »



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