Open Platform Migration Studio

Migration studio: your old data, in the new system, checked before it lands

Upload a spreadsheet or an export. Adon ERP matches your columns to its fields, checks every row, and tells you how many are good, before it writes anything.

See how an import runs

Now onboarding companies in Dhaka.

AdonERP
Nodi Polymer Industries

Open Platform / Migration Studio

Migration studio

  1. ✓Upload
  2. 2Map columns
  3. 3Check
  4. 4Import

Column mapping

customers.xlsx
  • Customer Name→Customer name100%
  • Cust_ID→Reference ID100%
  • Phone No→Phone96%
  • Addr→Billing address88%
  • Credit Days→Payment terms72%

Row check

Rows read
1,248
Valid
1,231
Flagged
17

Flagged rows are listed with the reason, such as a missing name or a duplicate reference. Fix them, or import the valid rows and keep the rest for later.

Import valid rowsDownload flagged rows

A partial preview of Migration Studio in Adon ERP. Company and figures are sample data.

An import, in four steps

The path is short, and you can stop at any step.

  1. Upload

    Bring the file

    Excel, CSV or an export from another accounting system.

  2. Map

    Match the columns

    Each column in your file is matched to a field, with a confidence. Low matches are for you to confirm.

  3. Check

    Then import

    Every row is checked. Valid rows can be imported, and flagged rows are returned with the reason.

What the page shows

The steps
Upload, map columns, check and import, with the current one highlighted.
Column mapping
Your column, the field it maps to, and the confidence.
Row check
Rows read, valid and flagged.
The reasons
Why a row was flagged.
Download
A file of flagged rows to correct.

Migration fills the lists the rest of the system uses

It writes customers, vendors, items and opening balances, and nothing else changes.

What it needs

What it fills

Where it shows up

Moving from spreadsheets and older systems

Most companies arrive with Excel sheets, and some with an older package. The studio is built for messy columns and half-clean data.

  • Excel and CSV first

    The file you already have.

  • Messy columns tolerated

    A column called Addr maps to Billing address.

  • Checked before written

    Nothing is imported until the rows pass.

  • Done in stages

    Customers today, items tomorrow.

One import, from file to list

A sample customer import, the way it usually runs.

  1. A customer sheet with 1,248 rows is uploaded.

  2. Columns are matched, and Credit Days needs a confirmation.

  3. 1,231 rows are valid and 17 are flagged.

  4. The valid rows are imported.

  5. The 17 are corrected and imported on a second pass.

How different trades use the migration studio

Questions we get about migration

What can I import?

Customers, vendors, items, accounts and opening balances, from Excel, CSV or another system.

Does it write anything before I confirm?

No. It checks first.

What if some rows are wrong?

They are flagged with the reason. Import the valid ones and fix the rest.

Do I need to rename my columns?

No. They are matched for you.

Can I import in stages?

Yes.

Where is Adon ERP available?

We are currently onboarding companies in Dhaka. Book a demo and we will walk through it with sample data.

Bring your current customer or item sheet. We will import it in the demo.

A live demo in English or Bangla, using sample books close to your own trade, with time for your accountant’s questions.

Explore Open Platform