Hi @wallstreet,
This post is a duplicate of:
https://forum.epe.si/d/5351-eksport-historii-w-phpmyadmin-do-nowej-tabeli-utils_attachment_data_1
Each recordset in Epesi stores data in several tables. Main data is stored in module name_data_1
but exporting from phpMyAdmin will give you raw data only. You should use Epesi's export function, which will substitute values from related recordset and especially Common Data. This way you will get:
Joe, Doe, USA, Pennsylvania
where USA and Pennsylvania are values from Common Data, instead of:
Joe, Doe, 45, 17
Record history is stored in modulename_edit_history and modulename_edit_history_data
edit_history_data table contains only old values of fields:
edit_id, field, old_value
However you are not trying to export Contacts' record history, but history of attachments. This is a completely different story. Utils_Attachment module links notes and/or attachments to a single record in any recordset.
Do you want to export history of all notes/attachments created by a particular user?
You can take a look at User Activity Report that comes with Epesi by default to see how you can obtain a very detailed activity of every user. You will need to write a custom module to do what you want - just to get data out. But then what? Do you have an application that can consume this data format/structure?
FYI: There is no command in SQL that can be easily executed in phpMyAdmin to get what you want.
More info about Epesi database structure:
https://forum.epe.si/d/1256-a-methodical-question-is-there-an-er-diagram
Regards,
Janusz Tylek
Epesi Team
