M-Files is a 2025 Gartner Peer Insights Customers' Choice for Document Management
➡️Download the report!

Options
  • Locked Locked
  • Replies 3 replies
  • Subscribers 10 subscribers
  • Views 412 views
  • Users 0 members are here
Related
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

Mass import/creation of Objects from external source

lcilliers
What is the best way to create/take on all the contacts/projects objects?

we currently have this data in either MS Access or SQL external databases and would like to run a routine that will automaticcally create a new object in M-files for each record in the external database and populate the properties mapped to the specific external fields.

Thanks
  • There is built in support for this in M-Files server. You can define object types as external when creating them in the M-Files Administrator. External object types have their objects fetched from any data source for which you are able to acquire a connection string. You also need to define the select statement which pulls the required fields from the database.

    It is also possible to define update and create statements so modifying the projects through M-Files is possible.

    Unfortunately I don't have that much experience with defining connection strings so hopefully someone else can help with that if there is need.

    - Mikko
  • I have been protoyping extensively with the connection strings, and had some success - especially with populating view lists - works quite well. I have not yet been successful to extract new objects in this way - will search more for an answer.
  • Seems like I have cracked it using a link to and excel spreadsheet - the key to it is that the routine must be run from the server machine.
M-Files
M-Files Support


© 2025 M-Files, All Rights Reserved.