Skip to main content
Skip table of contents

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 Acumatica 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

Adapt extract and upload flow chart (1).jpg

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 static data
  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 upload.

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

  6. Click Extract and Upload.

    Extract and upload static data.png


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

    All static data uploaded.png
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.

    Extract and upload dynamic data.png


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

    All dynamic data uploaded.png

What's next?

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.