We have hundreds of sermons in text form (html) that need to be uploaded to the site. It would take too long to copy and paste each sermon individually. Is there a way to upload a group of sermons into SMS? Initially, all we need is to populate the basic table.
Community
Web-Empowered Church User Community
Total Posts: 6 - Pages (1): [1]
It's definitely possible if you're not afraid to do some MySQL manipulation. You'll need to insert the various Resources correctly and then create the associated sermon files. However, there's no front-end method to do this as far as I know. My best recommendation would be to use a file type resource and upload those files separately, probably with YYYY-MM-DD as a date format if you're going to try to sort them. You can then hook up the Sermon records to those Resource records. May not be as elegant as putting into the sermon record, but it should work pretty well.
Thanks for your response Peter.
I am a developer and have worked with MySQL before, so I am not afraid of that. Do you know the database name and schema that the WEC SMS uses?
I am a developer and have worked with MySQL before, so I am not afraid of that. Do you know the database name and schema that the WEC SMS uses?
aimRandy,
Your best best will probably be poking around in a tool like phpMyAdmin. All of the wec_sermons tables are prefixed with tx_wecsermons_*.
About a year ago, there was a new wec_sermons version that changed the database schema and required a conversion script so that conversion script may give you some ideas on the type of queries you need. You can find it at typo3conf/ext/wec_sermons/class.ext_update.php, specifically in the INSERT queries within the updateTo* methods.
Hope that helps!
jeff
Your best best will probably be poking around in a tool like phpMyAdmin. All of the wec_sermons tables are prefixed with tx_wecsermons_*.
About a year ago, there was a new wec_sermons version that changed the database schema and required a conversion script so that conversion script may give you some ideas on the type of queries you need. You can find it at typo3conf/ext/wec_sermons/class.ext_update.php, specifically in the INSERT queries within the updateTo* methods.
Hope that helps!
jeff
Thanks for the quick fill-in, Jeff.
Randy,
I would have to dig into the schemas myself in order to get you the correct information and methods. I would recommend that you create a basic set of information up-front - Speaker(s), Topic(s), etc. Upload one sermon as a sample just to get you started, maybe two if you want to see the differences. Then follow that pattern. You'll need to create the resource records first, then either use those to tie in to the sermon records directly or match the sermons and resources after the fact. The good thing is that if you don't have a whole lot of topics/speakers you can get the insert details pretty quickly.
Randy,
I would have to dig into the schemas myself in order to get you the correct information and methods. I would recommend that you create a basic set of information up-front - Speaker(s), Topic(s), etc. Upload one sermon as a sample just to get you started, maybe two if you want to see the differences. Then follow that pattern. You'll need to create the resource records first, then either use those to tie in to the sermon records directly or match the sermons and resources after the fact. The good thing is that if you don't have a whole lot of topics/speakers you can get the insert details pretty quickly.
Thank you Jeff and Peter,
I will look at the php code.
I will look at the php code.
Total Posts: 6 - Pages (1): [1]