Currently, there is no option to transfer asset history from the OP instance to the OD instance. As a workaround, a Python script is used to retrieve the asset history, generate it as a readable PDF, and upload the PDF as an attachment to the corresponding asset in the OP instance. The attachment is then migrated along with the asset during the OP-to-OD migration.
The script requires the following configurations in the `config.json` file:
1.Application URL – Used to access the application and invoke the asset API.
2.API Key – Used for authentication while invoking the asset API and uploading the attachments.
3.Database Type – Specifies the database type to be used for executing the required queries.
Asset history data is retrieved from the `CIHistory` table, while resource state and ownership history are retrieved from the `ResourceStateHistory` and `ResourceOwnerHistory` tables, respectively.The `CIHistory` data and ownership history are generated as separate PDF files and uploaded as attachments to the corresponding asset. These attachments are then migrated along with the asset during the OP-to-OD migration.
Required Packages to run the script:
weasyprint: For generating PDF files from HTML content.
requests: For making HTTP API requests.
Command to Install the Packages :
Windows:
pip install weasyprint requests
Linux:
pip install weasyprint requests
sudo apt update
sudo apt install -y libpango-1.0-0 libpangoft2-1.0-0 libpangocairo-1.0-0 libcairo2
Sample History PDF will be attached for referrence.