ERPNext Foundation ERPNext Cloud Chat Blog Discuss Frappé* Donate

Export all Doctypes with data


#1

Hi all

Is there any provision to Export all data/doctype from ERPNext on one click?

Getting all data in xslx format by clicking each doctype and Exportong from Data Import tool list is time consuming.

Is it possible in ERPNext?


#2

Not available out of the box!

You can take a db backup.


#3

I’m writing a bash script to do export all data to csv files and add them to a git repo (to enable migrating data from a potentially live site to a testing site) and was wondering if there is a way to get a lit of all available doctypes?


#4

Hi welcome to ERPNext!

Run ‘bench mysql’ and query the database for eg

MariaDB [1bd3e0294da19198]> select count(*) from tabDocType;
±---------+
| count(*) |
±---------+
| 569 |
±---------+
1 row in set (0.00 sec)

that count confirms this list here:


in this version instance

Installed Apps
ERPNext: v10.1.37 (master)

Frappe Framework: v10.1.36 (master)

edit: version 11 has 732± doctypes!


#5

Cheers @clarkej that’s perfect, SELECT name FROM tabDocType is exactly what I was after :+1:.


#6

Def a good working practice when deploying dev/staging branches :slight_smile: Its what I do… Run two mostly in sync instances at the same time. One live one local. You also have bench backup mysite.whatever as a tool to use.