Answers

• tim-hitchins-ekkosense Posts: 5Questions: 2Answers: 0

  April 2023

  The best I've done is to get it from the node element select options but that really doesn't feel right:

  for (let j = 0; j < csv.length; j++) {
      let userValue = csv[j][mapped];
      if ('select' == field.s.opts.type) {
          option = $(field.node()).find('option').filter(( function () {
              return $(this).text() == userValue;
          }));
          userValue = option.val();
      }
      field.multiSet(j, userValue);
  }
  
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  April 2023 Answer ✓

  The problem is that "Organisation 1" is not a value in the list of options - it is a label. Editor can't select values based on the value - it does it on the value, so I think your workaround is probably correct at the moment.

  Allan
• tim-hitchins-ekkosense Posts: 5Questions: 2Answers: 0

  April 2023 edited April 2023

  Thanks.

  I've gone with the slightly more elegant solution of storing the initial load data and using that

  let loadData = {};
  table.on('init', (e, settings, json) => {
      loadData = json;
  });
  

              for (let j = 0; j < csv.length; j++) {
                  let userValue = csv[j][mapped];
                  if ('select' == field.s.opts.type) {
                      options = loadData.options[field.name()];
                      const match = options.find((element) => {
                          return element.label === userValue;
                      })
                      userValue = match.value;
                  }
                  field.multiSet(j, userValue);
              }
  

  I think the best solution would be for Editor to select values by label in this situation - although I understand that has edge cases when it's a select with numbers + the IDs don't line up.
  The middle ground would be a field.options() method so I wouldn't have to get them from the initial load.