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: 09:55
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: 17:55
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
Local time: 16:55
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: 09:55
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: 09:55
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: 17:55
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: 09:55
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: 17:55
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: 09:55
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: 17:55
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: 09:55
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: 17:55
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: 09:55
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 MultiTerm 2019
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2019 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2019 you can automatically create term lists from your existing documentation to save time.

More info »
Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »



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