Seeking advise for data migration from legacy system

ERPNext
1

Hi All,

Currently migrating from a legacy ERP to ERPNext, the export in legacy ERP does not include all the fields in most of the cases and I’m stuck in migrating PO’s and SO’s. Managed to migrate masters as the export was having majority of the fields and data importer in ERPNext did the job.

There are about say 1500+ SO’s in the legacy system and the response of clicking each SO’s is a HTML page with all the data for that SO, so I was thinking the option scrape the data put it in an excel and import ( have no experience of this in the past )

Seeking opinions to handle this task if there is any solution already available and has succeeded for anyone :slight_smile:

Thanks,
Navin

2

There is multiple tables will affect while you export data through excel.

Export and import in the excel is the only option available.

Thanks.

1 Like
3

If you could get to the legacy ERP database… you can create a py script to read from the legacy db and insert SO/PO into your erpnext instance using frappe client…
Else your py script can open the links, scrape out data and insert into erpnext

1 Like
4

Hi Vijay,

Thanks for your suggestions. unfortunately don’t have access to the legacy DB. I will surely try the scraping approach for now and see how it goes :slight_smile:

Thanks.
Navin