Well, if I understand you correctly, this plugin will do what you want. In the admin there is the ability to add and edit records. You can also import existing record using a CSV file, but you have to get everything set up first.
Thanks for the quick answer. The data base is already contruceted with over 15,000 entries so the CSV has already been imported. All it has is one table and 6 fields. So basically, when he gets new songs I just need a way for him to add it into the database with the song info which would be like song title, artist, ect…
That would be great!!! Any hints or tutorials on how to set this up? It would be for admin use only…nothing public except the output of the database which I already have setup and displaying.
Thanks again
Mike
Ok, I activated your plugin and don’t see a way I can connect to an external database (database name, host, user, password) which is where I need to update and add in the information…so I am guessing your plugin only uses the wp database???
Let me know and thanks!
Mike
Mike, the plugin uses it’s own tables which it creates in the WP database. It’s not for managing another database.
If you want to use the plugin, you’ll have to set up the plugin database fields before you try to import your records. Go to the “manage database fields” page, delete all the fields you don’t need and create new ones for your database. Don’t try to import the database directly, it’s best to do it in the plugin using CSV. Once you’re familiar with how it stores the data, you can do it any way you want.
The plugin has two levels of admin access: one for administrators, and another for editors who can add or edit records only.