Using Bulk Edit to modify many entries at once

This tutorial was created for FLEx 8.3

Steps to successful bulk editing in FLEx

  1. Display the columns with the data you need to edit/move
  2. Filter the data to automatically show as many target entries as possible
  3. Select the best bulk edit tab/tool for the job and configure it
  4. Preview the change with the preview button
  5. Select/Deselect the rest manually
  6. Perform the operation

* Some operations may need to be performed in multiple steps by using a cut and paste field--a field that you use for the purpose of copying data into, changing, and copying back.

Other operations can't be performed automatically, but you can set the Status field or other field to flag entries needing to be changed manually.

Task: Correct spelling errors

Tool: Spelling Errors Filter in List view

The definition fields contain spelling errors. We will review briefly how to turn spell checking on, then show you how to filter for spelling errors.

Task: Assign the category “Verb” to all verbs

Tool: Bulk Edit Entries - List Choice

  • Filter for RegEx:
  • In prose: Find all the definitions that words ending in “ing”, not including the word “meaning”.
  • Filter for stem (we will need to review phrases individually, as it is difficult to assign them to a grammatical category)
  • Preview applying the Grammatical category: Verb
  • After previewing, you can unselect words that are probably not verbs
  • Note: Preview persists even when changing the filter.
  • Look for similarities among all the stems.  Do you see something more reliable that indicates whether a word is a verb or not?  Look carefully, it should be obvious…
  • Now clear the existing operation and filter for stems with the characteristic you discovered.

Task: Select words to use in a children’s dictionary

Tool: Bulk Edit Entries – List Choice

  • Create a new dictionary type: Children’s Dictionary
    • ! For some reason all entries are tagged with the new dictionary by default.
      • Bulk remove all words from the children’s dictionary first
      • Make field visible: Publish Entry in…
      • List Choice, Select Children’s, Remove from.
  • Now, check the box next to each word to add to the children’s dictionary (do some sample words)
  • Change target to “Children’s Dictionary” and “Add to existing items”

Task: Find words with identical senses that need to be merged

Tool: Bulk Edit Entries – List Choice

  • In the Definition field, Filter for Regex:


  • In prose: any word of two letters or more that is repeated (in the combined senses).
    • Results when sorted on the lexeme form: 635
    • Results when sorted on the definition: 157
  • Why the difference?
    • Sorting on a sense level field creates a separate row for each sense
      • Our search found 157 repeating words within single senses
    • Sorting on an entry level field creates a separate row for each entry
      • Ours search found 635 repeated words in the combined senses of entries.
  • We will use the status field.  Create a new entry status in Lists that says “Merge Senses”
  • Now use List Choice to select the duplicates and tag them for merging senses. (You will do this later in the lexicon).

Task: Create reversal entries, Step 1

Tool: Bulk Copy all single word English glosses to the English reversal field

  • Using the Sena 3 Project, add the English gloss field to the lexicon pane.
  • Add the English reversal field to the Bulk Edit Entry pane
  • Filter for single word English glosses
    • RegEx: qqq
    • In prose: Find every entry that consists of a single word, not beginning with a number or a capital letter.
  • Copy from the English gloss to the English Reversal field

Task Create reversal entries, Step 2

Tool: Click Copy for multi-word English glosses

  • Filter for non-blank entries in the English Reversals. Now you see all the ones that didn’t get copied automatically.
  • Set Reversals as target field

Contributors to this page: dhigby .
Page last modified on Thursday May 3, 2018 04:10:51 GMT-0000 by dhigby.


Creative Commons License
All content on this LingTranSoft wiki are by SIL International are licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.