Download the PHP package divineomega/uxdm-excel without Composer
On this page you can find all versions of the php package divineomega/uxdm-excel. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download divineomega/uxdm-excel
More information about divineomega/uxdm-excel
Files in divineomega/uxdm-excel
Package uxdm-excel
Short Description Excel package for the UXDM data migrator
License LGPL-3.0-only
Informations about the package uxdm-excel
:twisted_rightwards_arrows: 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.
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.
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.
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.
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.
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.