Title: Sermon Data Import Last modified: July 25, 2019 --- # Sermon Data Import * [Dave Duerksen](https://wordpress.org/support/users/davdue/) * (@davdue) * [6 years, 8 months ago](https://wordpress.org/support/topic/sermon-data-import/) * I am in the process of converting an asp website to wordpress. It’s not live yet but I want to have it all setup first. We have years and years of lines in a table that contains the links and data for the sermon recordings (mp3) and sermon notes (pdf). Can someone help me with the import data file format so I can reformat the html code into a format that sermon manager can import. I think I can read the current data into Excel and then use a macro to format it so it can then be exported into the correct file format. The current format for each sermon entry in our table is like this: * ``` Do This and Live Interim Pastor Bob Hartmann 7/21/2019 PM Genesis 42:18-28 ``` * The wordpress sermon page is in the link above to see what it looks like and what data fields are currently being used. * Thanks in advance. - This topic was modified 6 years, 8 months ago by [Dave Duerksen](https://wordpress.org/support/users/davdue/). - This topic was modified 6 years, 8 months ago by [Dave Duerksen](https://wordpress.org/support/users/davdue/). * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fsermon-data-import%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 7 replies - 1 through 7 (of 7 total) * Thread Starter [Dave Duerksen](https://wordpress.org/support/users/davdue/) * (@davdue) * [6 years, 7 months ago](https://wordpress.org/support/topic/sermon-data-import/#post-11833379) * Can anyone help me with this? * [chrisbaker85](https://wordpress.org/support/users/chrisbaker85/) * (@chrisbaker85) * [6 years, 7 months ago](https://wordpress.org/support/topic/sermon-data-import/#post-11900702) * Hi, Dave, I’m just getting started with this plugin myself, and I’ll be trying to create an file to import 860 sermons with dozens of preachers, series and other data. * It looks like you have yours partially built now, so I’m sorry we couldn’t collaborate! * Thread Starter [Dave Duerksen](https://wordpress.org/support/users/davdue/) * (@davdue) * [6 years, 7 months ago](https://wordpress.org/support/topic/sermon-data-import/#post-11917932) * I haven’t gotten anything really done yet. My testing wasn’t very conclusive. I couldn’t get it to consistently import the data. I guess I will just have to wait until we go live with WordPress and then pay the $99/yr fee for Sermon Manager Pro since I haven’t gotten any response from Sermon Manager. However we could still collaborate. The only thing I have tried was to export some sermons I have added manually to see what data is there and try to create my one file with my data by hand. Once I figured out how to do it my plan was to work on a macro to modify my html data into the correct format. * [almcnicoll](https://wordpress.org/support/users/almcnicoll/) * (@almcnicoll) * [6 years, 6 months ago](https://wordpress.org/support/topic/sermon-data-import/#post-12005322) * I’m posting here in case others run into the problem (or in case the OP is still trying!) * I went the excel route too. The key here was to create a couple of dummy speakers, series, and sermons on the website. Then go to Import/Export and run an export. You’ll get the data of what you’ve just created as a long XML file. * From that, I could easily search for my sermons, series, and speakers (use recognisable names!) and fish out the relevant XML segments. * My technique was then to go through the XML segments, replacing everything with tokens. So the sermon title became %%title%%, series became %%series%%, post id became %%id%%, and so on. I found that there was one tag per speaker, one per series, and two per talk (one for the talk “post” itself, one for the mp3 attachment). * When I had those segments templated, I pasted them into Excel cells, and created tables where each speaker / series / talk was a row, and a SUBSTITUTE(SUBSTITUTE( SUBSTITUTE(…))) formula gave me the XML fragment with all the tokens replaced. I used VLOOKUP to make sure I could get IDs of speakers and series from the talks. I then strung together all the resulting XML, pasted it back into the original export file, replacing the existing fragments, and imported it. To my utter amazement, it worked first time! * NB – I also uploaded the sermon mp3s and ensured that the URLs pointed to the right location. I don’t know if that was necessary, or if the import would have fished them from the old location. * Can send the spreadsheet if would be any help! * Thread Starter [Dave Duerksen](https://wordpress.org/support/users/davdue/) * (@davdue) * [6 years, 6 months ago](https://wordpress.org/support/topic/sermon-data-import/#post-12005920) * [@almcnicoll](https://wordpress.org/support/users/almcnicoll/) * I haven’t had a chance in awhile to try and work on this. In fact I may not import the complete set like I was once wanting to do. I have since found out I can’t just use FTP to copy the files from my old webserver (Microsoft based) to the new new webserver (WP based) because of how my provider has set it up as a managed WP (they keep WP updated). However for a smaller subset of sermons I would like to still work on it. I would really like to see your spreadsheet. * Thanks, [@davdue](https://wordpress.org/support/users/davdue/) * [almcnicoll](https://wordpress.org/support/users/almcnicoll/) * (@almcnicoll) * [6 years, 6 months ago](https://wordpress.org/support/topic/sermon-data-import/#post-12006826) * Hi Dave, Email me on **al.mcnicoll [at] wheatleycommunitychurch [dot] org** and I’ll send it over 🙂 * [michelleclaire](https://wordpress.org/support/users/michelleclaire/) * (@michelleclaire) * [6 years, 2 months ago](https://wordpress.org/support/topic/sermon-data-import/#post-12353580) * For anyone else struggling with this, a really easy solution is to use the plugins WP All Export (if you have data in a current install that you need to move) and WP All Import. The heading fields of your columns don’t matter because you specify how to map the information during the import process. Viewing 7 replies - 1 through 7 (of 7 total) The topic ‘Sermon Data Import’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/sermon-manager-for-wordpress_688896. svg) * [Sermon Manager](https://wordpress.org/plugins/sermon-manager-for-wordpress/) * [Frequently Asked Questions](https://wordpress.org/plugins/sermon-manager-for-wordpress/#faq) * [Support Threads](https://wordpress.org/support/plugin/sermon-manager-for-wordpress/) * [Active Topics](https://wordpress.org/support/plugin/sermon-manager-for-wordpress/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/sermon-manager-for-wordpress/unresolved/) * [Reviews](https://wordpress.org/support/plugin/sermon-manager-for-wordpress/reviews/) * 7 replies * 1 participant * Last reply from: [michelleclaire](https://wordpress.org/support/users/michelleclaire/) * Last activity: [6 years, 2 months ago](https://wordpress.org/support/topic/sermon-data-import/#post-12353580) * Status: not resolved