Migrate Asset History from OP to OD as an Attachment.

Migrate Asset History from OP to OD as an Attachment.

Currently, there is no option to transfer asset history from the OP instance to the OD instance. As a workaround, a Python script retrieves history data, generates a readable PDF file, and uploads it as an attachment to the corresponding asset in the OP instance. This attachment is then migrated along with the asset during the OP to OD migration.

The script requires specific configurations in config.json. In PostgreSQL, the database port,user and password must be set. Asset history data is fetched from the CIHistory table, while resource state and ownership history are retrieved from ResourceStateHistory and ResourceOwnerHistory. The CIHistory data is generated as a separate PDF, and ownership history is also stored in a separate PDF. Additionally, an authentication token and  URL of to access applicatoin must be configured in config.json to invoke the asset API and upload the attachments.


Info
Required Packages to run the script:
Notes
psycopg2: For connecting to and interacting with a PostgreSQL database.
weasyprint: For generating PDF files from HTML content.
requests: For making HTTP API requests.

Command to Install the Packages :
Windows:
pip install psycopg2 weasyprint requests

Linux:
pip install psycopg2-binary 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.