Answers

• kthorngren Posts: 20,269Questions: 26Answers: 4,765

  February 2020 Answer ✓

  This thread might help you get started.

  Kevin
• bfarkas Posts: 181Questions: 48Answers: 0

  February 2020

  Thanks Kevin! That did the trick, I had searched a couple of times and never came across that.

  Now onto trying to see if i can auto select if names match.
  Thanks again!
• kthorngren Posts: 20,269Questions: 26Answers: 4,765

  February 2020

  I had searched a couple of times and never came across that.

  I knew that thread was there and it took a few tries for me to find

  auto select if names match.

  Please post your solution for this. Sounds like a good idea.

  Kevin
• KhanBoupha Posts: 1Questions: 0Answers: 0

  July 2020 edited July 2020

  This is what I do to map csv fields to the editor fields. Also provide a means to default to blank if no match found. The match is case insensitive by way of toLowerCase function. Perhaps someone will have a more efficient approach. In the meantime, hope this helps.

      function selectColumns(editor3, csv, header) {
          var selectEditor = new $.fn.dataTable.Editor();
          var fields = editor3.order();
          var csvFields = [];
          //csv field names must be in same order as editor3
          csvFields[0] = "FirstName";
          csvFields[1] = "LastName";
          csvFields[2] = "Salary";
          csvFields[3] = "City";
  
          var hfields = [];  //convert headers to all lowercase
          for (var i = 0; i < header.length; i++) {
              hfields[i] = header[i].toLowerCase();
          }
  
          header.push("");  //provide default blank
          for (var i = 0; i < fields.length; i++) {
              var field = editor3.field(fields[i]);
  
              var c = "";
              var a = hfields.indexOf(field.name().toLowerCase());
              if (a == -1) a = hfields.indexOf(csvFields[i].toLowerCase());
              if (a >= 0) c = header[a];
  
              selectEditor.add({
                  label: field.label(),
                  name: field.name(),
                  type: 'select',
                  options: header,
                  def: c
              });
          }
  
• bfarkas Posts: 181Questions: 48Answers: 0

  October 2020

  Hi KhanBoupha,
  I'm giving a modifed verison of this a try and it seems to be working, but when I leave a field set to the added 'none', it enters data of a number, in my case 3, which I'm guessing is the value of the multiset/none choice.Are you seeing that same behavior or do you have a solution for this?