Anna Moorby

Sorry to hear this... but if you can share the SDLTM with me (pfilkin@sdl.com) I'd be happy to take a look and see if I can recover something?  I spent some time playing around with corrupt TMs last week and eventually had some success.  No promises as it also depends on how badly it's corrupted, but it might be worth trying at least.

Thanks so much Paul. Am emailing it over to you now.

Anna Moorby

I have managed to recover some... not sure how many were in your original TM but I’ve created a new TM with around 65k Tus.  So better than nothing!  A few notes: 

1. The TM was completely corrupted but I was able to get at a few tables in the database and fortunately the translation_units was one of them.
2. I exported this table as a json file using sqlite browser and extracted the source and target content using the JSON filetype on the appstore in Studio
3. It was too large for one go so I had to split it a few times until I was able to save the sdlfliff to get at the content
4. I then converted the sdlxliff files to TMX and stripped the tags as the JSON contained so many you wouldn’t have been able to do anything sensible with it
5. I put the TMX files, the JSON files and the SDLTM I recreated into a zip and sent them to you

 Hope that helps.  It is a good idea to keep a regular backup, and also export to TMX and back that up too.  Worst comes to worst it’s always easy to recover from a TMX and as it’s a flat file you can work with it in a text editor.

Anna Moorby

I have managed to recover some... not sure how many were in your original TM but I’ve created a new TM with around 65k Tus.  So better than nothing!  A few notes: 

1. The TM was completely corrupted but I was able to get at a few tables in the database and fortunately the translation_units was one of them.
2. I exported this table as a json file using sqlite browser and extracted the source and target content using the JSON filetype on the appstore in Studio
3. It was too large for one go so I had to split it a few times until I was able to save the sdlfliff to get at the content
4. I then converted the sdlxliff files to TMX and stripped the tags as the JSON contained so many you wouldn’t have been able to do anything sensible with it
5. I put the TMX files, the JSON files and the SDLTM I recreated into a zip and sent them to you

 Hope that helps.  It is a good idea to keep a regular backup, and also export to TMX and back that up too.  Worst comes to worst it’s always easy to recover from a TMX and as it’s a flat file you can work with it in a text editor.

To non-techie linguists like myself, you are like a wizard! I honestly can't thank you enough. And yes I have learned my lesson re backing up TMs!! The silly thing is, I always back up my documents, just never thought to back up my TM!

Learned the hard way!

Have a great day

Anna