Support for SermonSpeaker 5.x is in bugfix mode only, the same as it is for Joomla 3.10.
I will not add any new features to this releases.
Please upgrade to SermonSpeaker 6.x and Joomla 4.x, which is better anyway.

Exporting sermon data

More
04 Jan 2022 21:49 #7830 by Richard Papworth
Exporting sermon data was created by Richard Papworth
Thomas, we have 17 years of sermons in our SermonSpeaker 5x database and wish to export the sermon data for use on another platform that will not use SermonSpeaker. Is it possible to export the sermon data in a standard format like CSV?

Richard
 

Please Log in or Create an account to join the conversation.

More
04 Jan 2022 21:55 #7831 by Thomas Hunziker
Replied by Thomas Hunziker on topic Exporting sermon data
Hi Richard
If you have access to the database, you can easily export it directly from there using database tools like PhpMyAdmin or similar. The data is stored in the tables that have with "_sermon_" in its name.
The sermons itself are stored on your server in the place where you uploaded them. If you used the ID3 tags, it may be even possible to just read those Tags in the new platform. Depending what information you need.

Please Log in or Create an account to join the conversation.

More
04 Jan 2022 21:59 #7832 by Richard Papworth
Replied by Richard Papworth on topic Exporting sermon data
Thank you. Will I be able to export the data in a common file format like CSV. The new platform is not Joomla.

Please Log in or Create an account to join the conversation.

More
04 Jan 2022 22:01 #7833 by Thomas Hunziker
Replied by Thomas Hunziker on topic Exporting sermon data
Sure, PhpMyAdmin and the like allow this and also other formats (like SQL, Excel)

Please Log in or Create an account to join the conversation.

More
04 Jan 2022 22:10 #7834 by Richard Papworth
Replied by Richard Papworth on topic Exporting sermon data
Very good. Thank you for your excellent support. You can close this ticket.

Richard

Please Log in or Create an account to join the conversation.

Time to create page: 0.099 seconds
Powered by Kunena Forum