Change internal object to external object (addresses)

Dear M-Files community

We had an internal object type (external data synched by REST API) and need to change the source to external object type since there was a change of ERP system.

I checked that in the external source, the object ID is exactly the same as the internal M-Files object ID before (ObjVer.ID). However, when I activate the synch from the SQL database, the existing objects in that object type are deleted and new objects are created.

Is this a use case which does not work at all and do you have other recommendations how to change from internal to external object source (ODBC connector) without loosing all the object relationships?

Thanks a lot for your help.

Kind regards

Dario

Parents
  • If the external ID from the new system is the same as the external ID of the object in M-Files then from recollection it should work.  The trick, though, is to make sure those existing objects have an external ID and that it matches.

    I know that the external ID can be set using the API.  I don't recall whether there's a trick here for doing it any other way... I will ask around.

Reply
  • If the external ID from the new system is the same as the external ID of the object in M-Files then from recollection it should work.  The trick, though, is to make sure those existing objects have an external ID and that it matches.

    I know that the external ID can be set using the API.  I don't recall whether there's a trick here for doing it any other way... I will ask around.

Children