I hope this is not a stupid question. I love this tool and it works great. My predicament is that I have about 7 years of sermons, or in other words over 600 to put in; and that's going to take some time. Is there a way to import a formatted excel or csv file just to get it all in in one shot? If I could just get the titles, dates, speakers, and scripture references all loaded in - that would be very helpful. Then I could just go back through and add the media files. Any help would be greatly appreciated. As I said, this tool is a great blessing.

That's certainly possible. It's more of a import to the database thing - not something the component does. If it would help, I could provide a list of the fields and tables used, then you could format your csv then use PHPAdmin or something to import it into the com_biblestudy db.

Keep in mind that there are multiple tables that reference each other. So in the jos_bsms_studies table, for instance, the field teacher_id is actually just an integer. The actual text is held in the jos_bsms_teachers table.

I imagine what you'd want to do is decide that teacher_id = 1 is your main person - so you put that in the csv, then you go in through the component and create Pastor Tim, or whatever in the Teachers tab as teacher 1. Then the component will know to assign that study to that teacher.

you might want to install the component, then go into PHPAdmin and take a look at the jos_bsms tables. Studies is the main one you are going to use in the csv import.

You can always PM me or use the contact author link and we can discuss this offline.

Tom

I have just started to look at this component for our new web site ... and I too would like to be able to import past sermons. Do you have a data model or list of tables/fields you could publish to help me work out the data structures please? (Using the latest 6.1 RC5 release.)

+1 for this feature..

If you have access to phpMyAdmin you could see the schema - or I can post it here. Not sure if it will make sense though - but I'm glad to if it will help. As posted we are working on some tools now to import from csv or from SermonSpeaker - but there are only three of us actively developing in our spare time so you can understand it takes some time!

No probs - I can view the table structures and by oputting in some sample data will be able to work out the fields I need to populate including lookups.