How do you move data between installations?

ERPNext
1

A csv exported by Data Export for DocType Item does not seem to be usable by Data Import for the same DocType. Modifiying the file (deleting comments and empty columns) didn’t help.

Am I missing something?

2

Are you moving data between ERPNext servers that are of the same version level?

If not, then there will be editing required of the CSV file.

Or is there some other problem?

There is not enough detail in your question to give a complete answer. What exactly is going wrong when you attempt to do the import?

BKM

3

If you are moving dd then you can use scp to copy db from demo to production. Once copied you can do bench restore of the db onto the production server bas bkm said both should be same version with same custom apps if you have.

For csv I just copy header from ERPNext and paste data in the column. Other option is to map the header in the data import doctype after uploading the csv file

In order to help you need to what you want to do, what you did and what error you are getting.

4

Just looked up versions and they are indeed quite different: 12.2 (docker containers from github) und 13.14.1 (in frappe.cloud).

Thanks for the hint, my bad! Will edit csv files until tender.

Cheers gentlemen,
kombi

5

Not very familiar with the restriction on frappe.cloud, but if you are a subscriber, you may be able to get them to help you restore in the old version and run the bench migrate command to get the entire database upgraded to the current version.

BKM

6

Thanks bkm, tweaking csv files is fine for now. Just need to move a few entities over to an otherwise fresh installation. I imagine there would be some tool to migrate an entire database (with those hefty 800+ tables:)

Cheers,
kombi