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.
Order of data extraction
![Adapt extract and upload flow chart (1).jpg](../__attachments/91259738/Adapt%20extract%20and%20upload%20flow%20chart%20(1).jpg?inst-v=0a9f74fc-52bb-4417-9d92-31d0022bf099)
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.
Start a new migration by extracting static data.
Edit and upload static data.
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.
If there's new static data in the source product, re-extract it.
Extract dynamic data.
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
What's next?
After extracting data, you can edit the data and upload it to your customer's MYOB Advanced site.