Extracting payroll data

Before extracting payroll data, make sure you’ve installed the OLDEB driver for Visual FoxPro and Adapt Uploader.

Types of payroll migration data

For every payroll migration, you need to use Adapt Uploader to extract two types of data:

• Static data – things like reference data, pay items, etc. that don't change after a pay run.

• Dynamic data – things like  entitlement adjustments, pay history, etc. that do change after a pay run.

After extracting data, you can use Adapt Desktop to edit the data and upload it to your customer's MYOB Advanced site.

List of dynamic data

The table below lists dynamic data for Australia and New Zealand.

Dynamic data
Data type	Can be migrated
	Australia	New Zealand
Entitlement Adjustment Details
Entitlement Adjustments
Pay History for Pay Groups		N/A
Pay History-Pay Groups		N/A
Pay History Details	N/A
Pay History	N/A
Pay Details-Distribution Other		N/A
Pay Details-Distribution Final		N/A
Pay History for terminated employees	Coming soon	N/A

Order of data extraction

Because your customer doesn't stop running their business while you're working on their migration, their dynamic data will frequently change. That's why we recommend extracting and working on static data first, then doing dynamic data second, when the site is ready to go live.

You can extract both data types as many times as you need. If you need to re-extract both static and dynamic data at the same, always start with static data.

Here's an overview of the extraction, editing and uploading process the first time you go through it.

1. Start a new migration by extracting static data.

2. Edit and upload static data.

3. When the migrated site is ready to go live, configure pay history settings in Adapt Desktop. You only need to do this once for each migration.

4. If there's new static data in the source product, re-extract it.

5. Extract dynamic data.

6. Edit and upload dynamic data, including pay history. If you re-extracted static data, edit and upload that as well.

Extracting data with Adapt Uploader

Extract dynamic data

Before extracting dynamic data for the first time, ensure pay history is configured.

1. Open MYOB Adapt Uploader.

2. In the Email Address and Password fields, enter your MYOB Adapt online portal login details.

3. Click Login.

4. In the Migration Item field, select the migration you want to extract data for.

5. In the Extra Data Type dropdown, select Dynamic Data.

6. Click Extract and Upload.

   

   
   The extract and import process is finished when you see All data uploaded in the Progress section.
   

   

What's next?

After extracting data, you can edit the data and upload it to your customer's MYOB Advanced site.