This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Exporting Data from Excel to M-Files

Former Member
Former Member
I am trying to export data from an excel sheet to m-files fields. I was able to export all the data into the fields I previously set in m-files except the data in cells mapped to  multi-select fields in m-files. I used the connection to the external database tool and my excel cells mapped to the multi-select fields in m-files look something like this:

12, 15, 26

where the numbers are the ids of the names in the value list. I also tried semi-colon instead of commas with no luck.
Parents
  • When using the connection to external database feature there is currently no direct way to read multiple values to a multi-select lookup property. When this is supported, multiple values of a property need to appear as separate records in the record set.
Reply
  • When using the connection to external database feature there is currently no direct way to read multiple values to a multi-select lookup property. When this is supported, multiple values of a property need to appear as separate records in the record set.
Children
No Data