Multilingual Bibliographic Data Integration for PMB

A PHP solution for integrating French/Arabic library records into PMB

---

Overview

Transform bibliographic datasets from French (buf.csv) and Arabic (bua.xls) into PMB-compatible formats with:

• Standardized inventory IDs (fsr_XXXXX)
• Multilingual field mapping (French/Arabic)
• Structural compliance with PMB database schema

---

Key Features

• ETL Pipeline: Automated data extraction, transformation, and loading
• Encoding Handling: Automatic UTF-8 conversion for Arabic text
• Data Validation:
  • Inventory ID format checks
  • Required field verification
• Error Logging: Detailed rejection tracking

---

Requirements

• PHP 8.x+ with extensions:
  • pdo_mysql
  • mbstring
• MySQL database (PMB-compatible)
• PhpSpreadsheet library (installation guide)

---

Installation

git clone https://github.com/aelmah/Data-integration.git
cd Data-integration
composer install