Migrating NowShortUrl of QR-codes from old company to new company in FSM

[Shinelin]

There are NowShortUrl of QR-codes for equipment generated in old FSM company with SAP B1 as underlying ERP system, while a new FSM company was created from a new Data Base of SAP B1 system as a replacement to the old company. Full data backup & restore was not executed due to concern on synchronization issue of the new company, as the master data and field settings are not identical between the old and new data bases of underlying SAP B1 systems.

We want to remain the NowShortUrl of QR-codes generated in the old FSM company and migrate them to the new FSM company, but selected data backup & restore for the NowShortUrl is not allowed from presently available Admin functions.

Is there any solution to migrate unpaired NowShortUrl of QR-Codes from old company to new company in FSM? 

[marcfroehlich · Accepted solution]

Data API provides full read/write access to most of the data in a company, including NowShortUrlDTO. It is theoretically feasible with Data API to GET all NowShortUrlDTO objects from the old company A, and PUT them into the new company B.

However, there are two major caveats:

• If the object reference of a NowShortUrlDTO is set to an object that belongs to company A, it will be invalid in company B, unless company B has been restored from a full data backup of company A.
• The actual URLs of the the NowShortUrlDTO are permanently linked to the company they are originally created in. In practice, scanning such a QR-code will always direct the user to the Self-Service Portal of company A. This hard link cannot be changed via Data API (or any other available API).

[Shinelin · Accepted solution]

The solution works by using Data API to migrate the old URLs and then change the Company ID assigned to the URLs. We applied it and the outcome met our expectation. - PUT the URLs from the old company A to the new company B with reference Object IDs belong to the company B. By this way, the migrated N would be valid in the new company B, thus the first caveat as mentioned could be circumvented. - Change the Company ID linked to the migrated URLs in company B (this needs to be done with one-off assistance from FSM Technical Support team), then scanning the QR-Code will direct the user to Self-Service portal of company B and information of reference object in company B will be displayed.

[Shinelin · Accepted solution]

Thanks Marcfroehlich for your reply. In the case that the NowShortUrl is unpaired and NOT linked to any object, e.g. equipment in company A, whether the first caveat you mentioned can be circumvented, so that the unpaired NowShortUrl will be valid in company B after migration? If the UUID of the URL is stored together with the Account ID and Company ID, whether can change the linked Company ID of company A to company B for the URL, with certain permission of technical or product support on the table or central place where URL is data stored? Is it a possible workarounds solution to address the 2nd caveat?

[Shinelin]

Thanks Marcfroehlich for your reply.

In the case that the NowShortUrl is unpaired and NOT linked to any object, e.g. equipment in company A, whether the first caveat you mentioned can be circumvented, so that the unpaired NowShortUrl will be valid in company B after migration?

If the UUID of the URL is stored together with the Account ID and Company ID, whether can change the linked Company ID of company A to that of company B for the URL, with assistance of technical or product support on the table or central place where the URL is stored? Is it a possible workarounds solution to address the 2nd caveat?