Is it possible to import data from a spreadsheet to update existing objects in M-Files?

Hello, take a look at these addons catalog.m-files.com/.../, maybe one fits your needs. Another option is to develop your own application.
​

Hi Kelly,

This isn't my area of expertise, but I checked with someone much more clever than I and they said that it should be possible to do this with M-Files Importer.  They pointed me at this support article which uses the duplicate flag to identify when an update should occur: M-Files Importer - Importing document versions (site.com)

If you're still struggling then perhaps reach out to the team who support you - your reseller or M-Files account manager - to see whether they can give you some guidance.

Craig.

Thanks Craig appreciate that

Craig Hawker's comment is spot on.  We use the Import Tool to bulk upload several documents at once, as well as updating metadata only on several existing documents.  Each of those two tasks requires a different CSV file that's created for you by your M-Files Solution Architect.  You fill out the CSV file first, and then use the Import tool on the server to load the data.  You do need your M-Files Solution Architect's help in creating the appropriate CSV file, however, because it needs to jive with your M-Files Importer executable file on your server.

Thanks Jan, I reached out to our contact after Craig's advice

Hi Craig, I know it's a quite late reply, but I was wondering can the same be applied for only updating the existing documents in the system? I have around 300 documents which metadata card need to be updated but I'm not really sure how to properly map the configuration file for this to work.

If you already have a list of those documents with something that can act as unique identifiers in the Duplicate configuration it should be relatively simple to update the needed properties via Importer.

Otherwise, if you can create a filter that will provide a list of the relevant documents in a View, then you can export that list and use it as a base for creating the import list with edited/added property values.

I do have a list with ID references, everything is ready, I am just missing the part on how to map the object ID so it knows which documents to update