SQL files: how do you process those files or isolate the string content for translation?
Thread poster: Alaina Brantner
Alaina Brantner
United States
Local time: 09:57
Spanish to English
Jul 17

Hi all,

I have some SQL files that the client has requested a quote on. How do folks generally process those files or isolate the string content for translation within? I've tried importing into both Trados and memoQ with no luck.

Thanks!


Direct link Reply with quote
 

Meta Arkadia
Local time: 21:57
English to Indonesian
+ ...
MySQL Jul 18

Probably the easiest way - though still not very easy - would be to install MySQL, or (a lot easier) a MySQL browser/viewer. I use Sequel Pro, but it's Mac only, so you may have to find another one.

  • Run MySQL or the browser
  • Open ("connect to") the .sql file
  • Convert to Excel
  • In Excel, select the column with the strings to be translated and do your counting

    Same procedure if you get the job, translate the Excel file, convert it back to .sql (you may have to adjust "Fields escaped by").

    Have fun,

    Hans

    Direct link Reply with quote
     


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


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

    SQL files: how do you process those files or isolate the string content for translation?

    Advanced search






    WordFinder
    The words you want Anywhere, Anytime

    WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

    More info »
    Across v6.3
    Translation Toolkit and Sales Potential under One Roof

    Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

    More info »



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