{"id":630,"date":"2012-05-12T12:29:28","date_gmt":"2012-05-12T11:29:28","guid":{"rendered":"http:\/\/wasaty.pl\/blog\/?p=630"},"modified":"2012-05-13T08:47:05","modified_gmt":"2012-05-13T07:47:05","slug":"modification-of-memoq-term-base-settings","status":"publish","type":"post","link":"https:\/\/wasaty.pl\/blog\/2012\/05\/12\/modification-of-memoq-term-base-settings\/","title":{"rendered":"Modification of memoQ term base settings"},"content":{"rendered":"
Tweet<\/a><\/div>\n

\"\"<\/a>memoQ 5 introduced the great feature of pre-defined term base settings for case sensitivity and prefix matching per language. Before importing some content into new TB, we just have to select right defaults. But what to do with older TBs? Or what to do if we want to change settings for some entries, but not all of them? You can either do a lot of clicking in the memoQ, modifying terms one by one, or use a quick workaround with the editing step in a spreadsheet.<\/p>\n

<\/p>\n

Actually Istvan Lengyel from Kilgray suggested a much easier solution than the one described below. To change attributes like Case sensitivity<\/strong> for the whole term base, one can just open the term base in the memoQ TB editor, select all entries by pressing Ctrl-Shift-A<\/strong> and set the desired value. There will be a dialog box with request for confirmation and that’s all.\u00a0 The procedure below can still be useful for groups of entries or some values which cannot be changed in editor, like creator ID.<\/p>\n

Changing term settings for an existing term base (Case sensitivity, Prefix matching<\/strong>) for all (or many) terms in a term base requires five steps: the content of a term base have to be exported into CSV format, imported into a spreadsheet (e.g. Excel or Calc), introduce required changes,\u00a0 save the content as a Unicode text and import it back into the term base.<\/p>\n

The procedure, step-by-step:<\/p>\n

I. Export from memoQ<\/h2>\n
    \n
  1. Select Tools > Resource console.<\/strong><\/li>\n
  2. In the Resource<\/strong> panel select Term bases<\/strong>.<\/li>\n
  3. Select the term base you want to modify and click Export to CSV<\/strong> command.<\/li>\n<\/ol>\n

    \"\"<\/a><\/p>\n

      \n
    1. Term base export settings<\/strong> window will be displayed.<\/li>\n
        \n
      1. Use the File<\/strong> field to select the location of exported file.<\/li>\n
      2. In the CSV settings<\/strong> pane select Tab<\/strong> for a Delimiter<\/strong> option.<\/li>\n
      3. Click Export<\/strong> button.<\/li>\n<\/ol>\n<\/ol>\n

        \"\"<\/a><\/p>\n

        II. Import into Excel<\/h2>\n
          \n
        1. Start Excel.<\/li>\n
        2. From Data<\/strong> ribbon select From text<\/strong>:<\/li>\n<\/ol>\n

          \"\"<\/a><\/p>\n

            \n
          1. In the Importing text file<\/strong> window select the file saved in step 4<\/strong> (file extension .csv).<\/li>\n
          2. Import text wizard \u2013 step 1 of 3<\/strong> window will be displayed. Click Next<\/strong>.<\/li>\n
          3. In the Import text wizard \u2013 step 2 of 3<\/strong> select correct column separator. By default it should be a Tab. If the text displayed in the preview panel is not separated into columns (see below), select other separator (e.g. comma), to achieve result like below:<\/li>\n<\/ol>\n

            \"\"<\/a><\/p>\n

              \n
            1. Click End<\/strong> button and in the Importing data<\/strong> window click OK<\/strong>:<\/li>\n<\/ol>\n

              \"\"<\/a><\/p>\n

              III. Modifying the settings<\/h2>\n

              You can freely edit colum content, e.g. changing term base metadata or the terms themselves.<\/p>\n

                \n
              1. To change the case sensitivity settings from Permissive<\/strong> to No<\/strong>, press Ctrl-H<\/strong> to invoke Search & replace<\/strong> window.<\/li>\n
                  \n
                1. In the Search<\/strong> field enter CasePermissive<\/strong>.<\/li>\n
                2. In the Replace to<\/strong> field enter CaseInsense<\/strong>.<\/li>\n
                3. Click Change all<\/strong>.<\/li>\n<\/ol>\n<\/ol>\n

                  For other settings, see reference table at the end of the post.<\/p>\n

                  IV. Modifying the settings<\/h2>\n
                    \n
                  1. Save changes by clicking File > Save as > Other formats<\/strong> and selecting Text unicode<\/strong> in the Save as type<\/strong> field.<\/li>\n<\/ol>\n

                    Two warnings windows will be displayed, you have to click OK in both.<\/strong><\/p>\n

                      \n
                    1. Close Excel (this is important).<\/li>\n<\/ol>\n

                      V. Importing modified file into memoQ<\/h2>\n

                      In the memoQ:<\/p>\n

                        \n
                      1. Select Tools > Resource console.<\/strong><\/li>\n
                      2. In the Resource<\/strong> panel select Term bases<\/strong>.<\/li>\n
                      3. Select term base the content of which was modified and click Import from CSV\/TMX<\/strong> command.<\/li>\n
                      4. Select the file saved in step 12<\/strong> (extension .txt). In case of error message, close Excel (step 13) and repeat steps 16 and 17. Term base export settings<\/strong> window will be displayed.<\/li>\n
                      5. Select Update existing entries based on ID<\/strong> check box.<\/li>\n<\/ol>\n

                        \"\"<\/a><\/p>\n

                          \n
                        1. Click OK<\/strong>. The term base will be updated with modified settings.<\/li>\n<\/ol>\n


                          <\/strong><\/p>\n

                          \u00a0<\/strong><\/p>\n

                          Table 1<\/strong>. Term base fields and permitted values<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
                          Field name<\/strong><\/td>\nField description and permitted values<\/strong><\/td>\n<\/tr>\n
                          Entry_ID<\/td>\nIdentifier, subsequent nubers starting from 0.<\/td>\n<\/tr>\n
                          Entry_Subject<\/td>\nMetadata Subject<\/strong> field. Free text.<\/td>\n<\/tr>\n
                          Entry_Domain<\/td>\nMetadata Domain<\/strong> field. Free text.<\/td>\n<\/tr>\n
                          Entry_Client_ID<\/td>\nMetadata Client<\/strong> field. Free text.<\/td>\n<\/tr>\n
                          Entry_ProjectID<\/td>\nMetadata Project<\/strong> field. Free text.<\/td>\n<\/tr>\n
                          Entry_Created<\/td>\nDate and time of entry creation. Format: M\/D\/YYYY H:MM:SS AM\/PM.<\/td>\n<\/tr>\n
                          Entry_Creator<\/td>\nThe ID of user, who created the entry. Free text.<\/td>\n<\/tr>\n
                          Entry_LastModified<\/td>\nDate and time of entry modification. Format: M\/D\/YYYY H:MM:SS AM\/PM.<\/td>\n<\/tr>\n
                          Entry_Modifier<\/td>\nThe ID of user, who modified the entry. Free text.<\/td>\n<\/tr>\n
                          Entry_Note<\/td>\nContent of the Note<\/strong> field. Concept level entry.<\/td>\n<\/tr>\n
                          Entry_Image<\/td>\nContent of the Image<\/strong> field. Concept level entry.<\/td>\n<\/tr>\n
                          Entry_ImageCaption<\/td>\nImage caption. Concept level entry.<\/td>\n<\/tr>\n
                          [Language]_Def<\/td>\nTerm definition for [Language] E.g. English_Def, Polish_Def. Term level entry.<\/td>\n<\/tr>\n
                          [Language]<\/td>\nTerm in the defined language. E.g. English, Polish. Term level entry.<\/td>\n<\/tr>\n
                          Term_Info<\/td>\nTerm information. Permitted values (separated by semicolon, order doesn\u2019t matter). Term level entry:CaseInsense \u2013 Case sensitivity NoCasePermissive \u2013 Case sensitivity Permissive<\/p>\n

                          CaseSense \u2013 Case sensitivity Yes<\/p>\n

                          HalfPrefix \u2013 Prefix matching 50% minimum<\/p>\n

                          Prefix \u2013 Prefix matching Yes<\/p>\n

                          NoPrefix \u2013 Prefix matching No<\/p>\n

                          Custom \u2013 Prefix matching Custom<\/p>\n

                          Masc \u2013 Gender: Masculine<\/p>\n

                          Fem \u2013 Gender: Feminine<\/p>\n

                          Neu \u2013 Gender: Neutral<\/p>\n

                          Sg \u2013 Number: Singular<\/p>\n

                          Pl \u2013 Number: Plural<\/p>\n

                          Noun \u2013 Part of speech: Noun<\/p>\n

                          Adj \u2013 Part of speech: Adjective<\/p>\n

                          Adv \u2013 Part of speech: Adverb<\/p>\n

                          Verb \u2013 Part of speech: Verb<\/p>\n

                          Other \u2013 Part of speech: Other<\/p>\n

                          NonTerm \u2013 Forbidden term<\/p>\n

                          Example: CaseInsense;Neu;Pl;Adj;NoPrefix<\/td>\n<\/tr>\n

                          Term_Example<\/td>\nExample of term usage. Free text. Term level entry.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                           <\/p>\n

                           <\/p>\n","protected":false},"excerpt":{"rendered":"

                          Tweet memoQ 5 introduced the great feature of pre-defined term base settings for case sensitivity and prefix matching per language. Before importing some content into new TB, we just have to select right defaults. But what to do with older TBs? Or what to do if we want to change settings for some entries, but … <\/p>\n

                          Continue reading<\/a><\/p>\n","protected":false},"author":2,"featured_media":632,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,6],"tags":[9,20,24],"class_list":["post-630","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-narzedzia","category-wskazowki","tag-cat","tag-memoq","tag-porady","item-wrap"],"_links":{"self":[{"href":"https:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/posts\/630","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/comments?post=630"}],"version-history":[{"count":5,"href":"https:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/posts\/630\/revisions"}],"predecessor-version":[{"id":647,"href":"https:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/posts\/630\/revisions\/647"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/media\/632"}],"wp:attachment":[{"href":"https:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/media?parent=630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/categories?post=630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/tags?post=630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}