Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2013-04-05 22:24:34
- DogLover
- Member
- Registered: 2013-04-04
- Posts: 26
Creating a Audio Database
Hi!
I am in charge of a website that has archives of audio files. I was asked to make a database that would contain the following features:
1. Searchable so that people can find the audio file they want.
2. Display the most recent audio files on the front page and then automatically move them to a archive when ever a certain number of files on the main page.
Those are the most important features that I am wanting to incorporate. Does anyone know of a good tutorial(s) that can show me how to do this?
Thanks!!!
Offline
Re: Creating a Audio Database
Hi and welcome to txp
What you need is very doable. The audio iles will need to be uploaded in the files tab but as files are not searchable, the easiest way would be to have them embedded on a per article basis with all their meta information contained in the article. By default txp would list the latest articles on the front page.
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: Creating a Audio Database
Hi and welcome, DogLover!
The main problem, imo, is the file upload if you have many files. Doing it by hand is tedious, and I am not aware of a reliable batch file upload/metadata extraction plugin. Once you have overcome this, the things are easy. You are even not obliged to embed files in articles, file_download_list should suffice for display, and etc_search can search in any table.
Offline
Re: Creating a Audio Database
For metadata extraction, getid3.sourceforge.net/ looks interesting.
Offline
#5 2013-04-06 12:14:29
- DogLover
- Member
- Registered: 2013-04-04
- Posts: 26
Re: Creating a Audio Database
I have a site already created with a editor provided by my hosting service. That site has a bunch of audio files already uploaded. Is there a way to have Textpattern reference the files that are already there? I don’t really want to have to upload them to Textpattern as well. Also their average size exceeds the size limit that Textpattern says I can upload. Thanks!
Last edited by DogLover (2013-04-06 12:43:26)
Offline
#6 2013-04-06 13:02:17
- DogLover
- Member
- Registered: 2013-04-04
- Posts: 26
Re: Creating a Audio Database
Also, do I have to have my entire site on textpattern? I am wanting to incorporate it right now, not have the whole site on it. Thanks!
Offline
Re: Creating a Audio Database
DogLover wrote:
Also, do I have to have my entire site on textpattern? I am wanting to incorporate it right now, not have the whole site on it. Thanks!
Just install Textpattern in a sub-sub-directory and run it from the sub-directory.
www.mainsite.tld/ for existing structure
www.mainsite.tld/music-files/textpattern for Textpattern
www.mainsite.tld/music-files/ for the new structure run by TextpatternCheck code.google.com/p/textpattern/source/browse/releases/4.5.4/source/README.txt
Get all online mentions of Textpattern via OPML subscription: TXP Info Sources: Textpattern RSS feeds as dynamic OPML
Offline
Re: Creating a Audio Database
DogLover wrote:
That site has a bunch of audio files already uploaded. Is there a way to have Textpattern reference the files that are already there
Check out smd_remote_file. I never needed to use the plugin but it should/might be of help.
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: Creating a Audio Database
DogLover wrote:
I have a site already created with a editor provided by my hosting service. That site has a bunch of audio files already uploaded. Is there a way to have Textpattern reference the files that are already there? I don’t really want to have to upload them to Textpattern as well. Also their average size exceeds the size limit that Textpattern says I can upload. Thanks!
Check the standards first: www.google.de/search?q=mult+file+upload+textpattern
… to have Textpattern reference the files that are already there?
You can try hard or soft linking the files or the file-directory.
The files will then show up as ‘existing files’ in the admin/content/files dropdown and can be added to Textpattern.
Edit: Yes, smd_remote_file looks quite promising.
Last edited by merz1 (2013-04-06 14:57:58)
Get all online mentions of Textpattern via OPML subscription: TXP Info Sources: Textpattern RSS feeds as dynamic OPML
Offline
#10 2013-04-06 15:28:05
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,315
Re: Creating a Audio Database
Re file upload limitations: Have a look at this post by Jukka, one of TXPs developers.
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline
#11 2013-04-07 19:47:42
- DogLover
- Member
- Registered: 2013-04-04
- Posts: 26
Re: Creating a Audio Database
I found a thread (http://forum.textpattern.com/viewtopic.php?id=27836) and saw the post by Renobird about the tablesorter with jQuery. I looked into jQuery and it appears to be able to sort the table so that the latest appears on the top, but I can’t get it to work. This is the code I have:
<script src=“http://mysite.com/jQuery/jquery-1.9.1.js”></script>
<script src=“http://mysite.com/jQuery/jquery.tablesorter.js”></script>
<script>
$(document).ready(function()
{
$(“#myTable”).tablesorter();
}
);
</script>
I then just copied the table that the jquery tablesorter page has as a example. I can’t seem to see anything that is wrong. Any ideas? Thanks!
Offline
Re: Creating a Audio Database
Without seeing the page source, my only thought is that tablesorter does not work with jQuery 1.9.
Offline