corrupt TM

Question

Hi, I cannot repair my TM, I tried the plugin but the result was an e tehnic us-ro.zip mpty TM, could you please help? 
 Regards, 
 Anca

Paul · Accepted Answer

Anca TOLEA I couldn't resist playing with this and in the end redid what I sent you as I found some problems with the content. So for the benefit of anyone else with a corrupt TM that SDLTM Repair won't fix because it's beyond repair, this is what I did. Opened the SDLTM in the DB Browser for SQLITE Exported the "Translation Units" table to a csv Added a BOM to the csv(very important if you don't want to corrupt characters using diacritics when you import to Excel... I had to do this exercise twice because I didn't realise this would be a problem the first time) Imported the csv to Excel Deleted all the columns I didn't want... in this case I just kept the source and target content. So I have this sort of stuff: I deleted all the ones that were missing target and copied the content of both source ad target into a text editor so I could clean them up.I used this expression... Search for: (?:"?(.+?).+?"?( )"?(.+?).+?"?) Replace with: $1$2$3 The regex may seem unnecessary in places but as I was cleaning the text I had to adapt this for some odd segments. Eventually this seemed to do the trick. This got me a clean tab delimited text for source and target (for example... the screenshot above becomes this) I pasted that back into Excel as it's easier to clean up in there Creating the TMX and then an SDLTM from this is trivial at this point. I'm 100% certain there will be a few problems with the quality of the alignment of all the data (there were some carriage returns within a segment and I'm sure I didn't find them all) and it should be thoroughly checked, but I think this is a useful exercise to be able to recover what would otherwise be over 100k TUs of many years work completely lost. So better than nothing at all!

Paul · Answer

Anca TOLEA 
 If your TM is corrupt then none of these solutions is going to help you. You need to try and repair it. Use this tool from the appstore: https://appstore.rws.com/plugin/41/ 
 There is no guarantee here because your TM may be damaged beyond repair, but this is your best bet. 
 Going forward it's a good idea to back up your TM at least weekly, and in my opinion you should also export to TMX when you do this. If the worst comes to the worst it's far easier to recover a text based file like a TMX than it is a database,

Paul · Answer

Anca TOLEA 
 I also had a play with your sdltm (just noticed you provided it). SDLTM repair cannot recover the data. So I had a play with the sql and get the same result no matter what I try. I then tried a slqite recovery tool that gives me mixed results but sometimes I can get something out and I did notice you seem to have TUs created from multiple users so I wondered if you are sharing this TM with others in some way? This is always a risky business and you should either take sensible precautions to never write to the same memory, or use a TM designed for sharing such as a server-based TM in GroupShare, or maybe use Language Cloud. File-based TMs are not designed to be worked on by multiple users. 
 The recovery tool also failed after some hours processing. So then I went old fashioned and I did manage to get the translation units from the table just with DB Browser for SQLITE. It'll need some cleaning up but at least you have the data if you want to try and clean it up and recreate a TM for use. I'll drop you an email with the link because now the data in it could be seen.

RWS AppStore > 2. RWS AppStore Applications

corrupt TM

Top Replies