🔀 UXDM Excel

This package provides Microsoft Excel source and destination objects for the UXDM data migrator.

Installation

To install the UXDM Excel package, just run the following composer command.

composer require divineomega/uxdm-excel

UXDM Excel Source

The UXDM Excel source allows you to source data from a Microsoft Excel spreadsheet. This can be useful to directly import data from a spreadsheet into a bespoke web application database or other file format.

Creating

To create a new Excel source, you must provide it with the path to the spreadsheet file (*.xlsx) that you wish to use.

The following example creates a Excel source object, using a Users.xlsx file within the same directory.

$excelSource = new ExcelSource(__DIR__.'/Users.xlsx');

Assigning to migrator

To use the Excel source as part of a UXDM migration, you must assign it to the migrator. This process is the same for most sources.

$migrator = new Migrator;
$migrator->setSource($excelSource);

UXDM Excel Destination

The UXDM Excel destination allows you to migrate data into a Microsoft Excel spreadsheet. This can be useful if you wish to export data from your database powered system into a spreadsheet, or simply convert from one format to another.

Creating

To create a new Excel destination, you must provide it with the path to the spreadsheet file (*.xlsx) that you wish to use.

The following example creates a Excel destination object, using a Users.xlsx file within the same directory.

$excelDestination = new ExcelDestination(__DIR__.'/Users.xlsx');

Assigning to migrator

To use the Excel destination as part of a UXDM migration, you must assign it to the migrator. This process is the same for most destinations.

$migrator = new Migrator;
$migrator->setDestination($excelDestination);

Alternatively, you can add multiple destinations, as shown below. You can also specify the fields you wish to send to each destination by passing an array of field names as the second parameter.

$migrator = new Migrator;
$migrator->addDestination($excelDestination, ['field1', 'field2']);
$migrator->addDestination($otherDestination, ['field3', 'field2']);