O1 Migration Scripts

---

This repository consist of scripts for data extraction/modification for O1

📝 Table of Contents

• About
• Getting Started
• Usage
• Authors

🧐 About

These Scripts aims to help with the data migration process making it more efficient in the modification and extraction process:

1. O1_Selenium_Migration.py; This script uses Python Selenium to help solve the limitation posted by Bentely API. By using Selenium to extract form data from the frontend.
2. O1_Migration_Script_Bentley_API.py; This script uses Bentley API to extract forms, audit log, attachments and comments.
3. Bentley_API_Reassigner.py; This script uses Bentley API to change the form status and reassign it to another user.
4. Bentley_API_Size_Tracker.py; This script uses Benley API to download the froms, audit logs, attachments and comments from specific projects so the user can estimate the project size
5. PDF_Creation_Date_Extractor.py; This script extracts the form creation date from the PDFs

🏁 Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes.

Prerequisites

What needs to be installed beforehand: Selenium needs to bee installed before running the Selenium Migraation script

1. Selenium

Installing

A step by step series of examples that tell you how to get a development env running.

Using Python pip install to install selenium

pip install selenium

🎈 Usage

Run the scripts using the command:

python [Script_Name]

Note: Scripts that uses Bentley's API must have new token once in a while, to generate a new token:

1. goto Bentley_Dev
2. Click on "Try it out"
3. Click on the dropdown box "No auth"
4. Select "authorizationCode"
5. Copy the whole line from Authorization under Headers, it starts with "Bearer"
6. Replace the old "Bearer" in the script with the new one in "Authorization" under "HEADERS"

✍️ Authors

• @XiangHui