How to add client/subject info to a TM derived from an imported TMX file? Thread poster: Olaf Reibedanz
|
|---|
Olaf Reibedanz 
Colombia
Local time: 20:22
Member (2003)
English to German
+ ...
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
Türkiye
Local time: 04:22
English to Turkish
+ ...
|
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
Colombia
Local time: 20:22
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 charm
| | |
|
|
|
Olaf Reibedanz
Colombia
Local time: 20:22
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
Türkiye
Local time: 04:22
English to Turkish
+ ...
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
Colombia
Local time: 20:22
Member (2003)
English to German
+ ...
TOPIC STARTER
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
Türkiye
Local time: 04:22
English to Turkish
+ ...
| Temporary files | Mar 7, 2013 |
AFAIR, deleting temporary files was suggested by somebody at Yahoo list.
Selcuk
| | |
|
|
|
Olaf Reibedanz
Colombia
Local time: 20:22
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
Türkiye
Local time: 04:22
English to Turkish
+ ...
|
Olaf Reibedanz
Colombia
Local time: 20:22
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,
... See more 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] ▲ Collapse
| | | |
Selcuk Akyuz
Türkiye
Local time: 04:22
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
Colombia
Local time: 20:22
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 again
Thanks a lot for your help, Selcuk!
[Edited at 2013-03-09 13:28 GMT]
| | | |
Login to reply/comment 
