Budibase db full export faster solution? #11218
-
|
How can i export full full data from budibase db? if I use plain export it only exports 1000 lines. If I scroll down and select all of them it's fine but when I have 6-7 00 000 rows it's a bit time consuming. |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 3 replies
-
|
Hey @uzemelteteshj, I wasn't aware you go scroll down and select all the rows the way you are describing. The way which I would suggest would be implementing some form of script using the Budibase public API. You can query the rows in batches and then export each batch of 1000 rows to a CSV, from here this could then be imported into a different Budibase instance. I've actually put a node project together here which you could use to export your table rows to a CSV here; https://github.com/ConorWebb96/bb-export-table-to-csv. If you have any questions or queries on how to use this let me know. |
Beta Was this translation helpful? Give feedback.
-
|
It's work thank you!!! A hint would be to include in the description that you can specify a unique link at "fetchRows( |
Beta Was this translation helpful? Give feedback.
-
|
If you think it would be helpful I'll modify it, to include an env variable for self-host? It would just include the first part of that url you've shown https up to .com |
Beta Was this translation helpful? Give feedback.
-
|
does not necessarily have to be written to an .env file. Just refer to the github description if budi running self host, you may want to modify the url there. |
Beta Was this translation helpful? Give feedback.
Hey @uzemelteteshj,
I wasn't aware you go scroll down and select all the rows the way you are describing.
The way which I would suggest would be implementing some form of script using the Budibase public API. You can query the rows in batches and then export each batch of 1000 rows to a CSV, from here this could then be imported into a different Budibase instance.
I've actually put a node project together here which you could use to export your table rows to a CSV here; https://github.com/ConorWebb96/bb-export-table-to-csv. If you have any questions or queries on how to use this let me know.