Greetings all:

I'm trying to find a way to export the database of events in our Couch website, as well as another database called Initiatives and one called News, and cannot find those databases anywhere in the file directory. Can someone point me in the right direction? Thanks!

Lex Alexander
Director of Communications
Greensboro College
lex.alexander@greensboro.edu

[KK]

Hello Lex,

If I got it right, your Couch based site has 'events', 'initiatives' and 'news' sections and now you wish to export the data from these sections (templates as we call them in Couch) to another system. Right?

If so, I am afraid you won't find that data within the file directory. Rather, it'd be found in the MySQL database used by your site.

You may use a utility like phpmyadmin to browse through that data but that again won't allow you to export it in the format you might desire.

One way of exporting the data would be to convert it into an intermediary format e.g. CSV (comma separated values in a text file).

We have an addon that actually does the reverse of this - it takes a CSV file and 'imports' it into Couch - viewtopic.php?f=5&t=8803
I think, you can tweak it to do the opposite but it will require some programming chops on your part.

Hope it helps.

Outstanding, KK. Thanks very much for the advice. I'll pass it on to our developer.

[trendoman]

A good option would be to use DataTables, with simple code make all pages listed as you desire. Export options are CSV, PDF, EXCEL. Additional features are quick filter/ordering, instant pagination etc.

ScreenCut-01-25---02-19-59-.jpg (65.07 KiB) Viewed 1889 times

Of course, if your data doesn't need to be displayed nicely and only quickly exported - SQL script can be written and pasted to a phpmyadmin or, much better, freeware software HeidiSQL. Export options of prepared data include html, csv etc.

ScreenCut-01-25---02-26-50-.png (100.14 KiB) Viewed 1889 times