How to Import Multiple Entries (Universal Importer)

You might wanna use this asset when you need to insert multiple entries at a dictionary. This my be used at the Synonyms Processor or at the following Recognizers: Regex, Advanced Regex, Simple Regex, Fragmented Regex, Best Bets, Entities, FAQ and Intent.

Step-by-step guide

Steps to use the Importer:

1. Locate the import icon at top left of the dictionaries window
   
2. It will display a formulary that contains the required fields for each component that looks like the first image bellow. Down the formulary there's also a component to browse or drag and drop the files you want to parse.
                                                
   
3. There 5 types of supported file extensions and multiple considerations to have at the files content.
   1. JSON: JSON files are meant for one single element to be inserted using the importer, this might be used as a format testing for the JSONL type because to inserts elements one by one is easier using the add button.
   2. JSONL: JSONL is a format where every single line of the file correspond to a JSON like element. This works to insert multiple elements at once.
   3. XML: for XML the format is very specific even though you don't need to name the tags with a specific format. XML required format is the following:
      
      
      1. mainTag: can have any name, it won't be used at the parsing all it does is to give the XML file a valid format to follow.
      2. parentTag: this field can also have any name but it must be specified at the formulary, this field represents each element that will be added.
      3. childTags: all the other fields contained between the parentTag, those fields represent the different fields needed for each type. Please notice the format for lists and JSON fields.
   4. XLSX: file extension for excel files allowed by this component. Only requisits are: parses only one Sheet at a time, make sure to create lists in one only cell separated by commas and JSON-like fields must be in a correct JSON format. The position of the columns at the sheet doesn't matter as long as the first row introducing the table has the name of each column, and the corresponding elements are bellow.
      
      1. SheetName: the name of the sheet to be processed. In this case FAQSaga.

      2. Columns: fill the other fields with the name of the columns that matches the element you want to map to it

   5. CSV: stands for "comma separated values" format of excel files, but it allows several separators delimited by a drop down (if the separator you require doesn't figures into the dropdown list, contact SAGA team).
      It requires the name of the columns at the first row and the following rows should follow this pattern, as it's illustrated in the following image:
      

      At any of those formats, "confidence" and "fields" fields are optional, if "confidence" is not included or doesn't have a value, 1 is automatically assigned to it. If "fields" is not included it stays blank.

4. Once you have filled the form and uploaded the files to parse, you can press the now enabled import button:

Related articles