solved How to upload and search audio and video by date and location?

Hi JR Team,

We have many audio and video recordings of conferences, meetings etc from many many years ago (e.g. 1980, 1999, 2002 etc). All our audio and video recordings/files up to now are save with date and location.

We would like to publish them online on our JR site. How to upload and make them searchable by date?

Example:

In the upload process to have fields like this:

Day:
01
02
03
04
etc

Month:
01
02
03
04
etc

Year:
1980
1981
..
..
2000
2001
...
2014
2015
2016
...
2020
2021
etc

Or maybe to use an calendar with a date picker. (I don't know, just guessing)

or Another field to enter location, like this:

New York
California
Paris
South Africa
etc

Same apply with the search. How to make the audio and video files searchable by date and location?

e.g.: One can search for a specific conference of 02/05/1995 or search by location.

I don't know if the Form Designer will handle this. If so, How? Please tell me a good approach to achieve what i have explained above. (Please step by step)

Thanks in advance.
updated by @pch: 12/29/16 02:36:42AM

The form designer will do what you want.

Just add a date field, not a datetime field unless you need the time too, via the form designer and you should be able to search by date. You can do the same for the Location.

You may also need to rebuild the search index after creating new fields... ACP > Listing > Search > Tools > Rebuild Index.

If you need to show those fields on the profiles detail page, you'll have to modify the item_detail.tpl, ACP > Profiles > Audio > Templates, and add the variables for the new form fields where you would like them to show.

The variables will be the name of the field, ie. if you name the new field audio_publish_date, the variable used in the item_detail.tpl file will be {$item.audio_publish_date}.

Hope this helps!


--

Douglas Hackney
Jamroom Team - Designer/Developer/Support
FAQ-Docs-Help Videos

Hi Douglas,

Thanks a lot for the great support. It exactly what I was looking for. I am so happy. It works.

By the way, how to translate the date picker? e.g: Mon, Tue, Wed, etc... September, October ect

For the Location, what do you advise me? A "text" field or a "select_and_text" field?

Also, I have just remembered that "Conference" which is one of our audio and video categories has a speaker and one conference can have more than one speakers at a time (3 or 5 speakers per conference).

I would like to have a field like "speakers" in order to add many speakers to an audio or video. We know all our conference speakers (there are more than twenty of them).

Which field type would you recommend? A "checkbox" or a "select_multiple" field type?
Note: The speakers field will be searchable. One can search for a video of two or more speakers of the same conference.


Yes, I have done it and I added the audio_publish_date in the "Additional Search Fields" in the search module > Global config, but the date field is not showing as an option in the search pop-up window when you click on the search magnifying glass (I am using Elastic clone)

Should I put {$item.audio_publish_date} in the search template?


I have added {$item.audio_publish_date} in the item_detail.tpl file. Instead of outputting the date (e.g 24 Jun 2016) it displays this: 1272146400

Have I missed something?

Also i would like to output the audio_publish_date on the main Audio and video page (where all audio and video are listed) and on the Audio and video Album page. How to do it and which file to edit?

Same with the audio_description and video_description fields that I created. I would like to display them on the main Audio and video page and on the Audio and video Album page. I have already managed to display them on the Audio and video detail page.

Thanks for a lot for the support.

These are the docs you want to adjust how the time shows.

Docs: "{$variable|jrCore_format_time}"
https://www.jamroom.net/the-jamroom-network/documentation/development/1539/variable-jrcore-format-time

"Which template do I modify?"

What you want is the Template Name In Source setting turned on, then look at the page, it will tell you which template to modify.

Docs: "Developer Tools : Template Name in Source"
https://www.jamroom.net/the-jamroom-network/documentation/modules/932/developer-tools#template-name-in-source

Michael's documentation link is spot on - it shows you how to format a date variable in a template. Jamroom uses Smarty templates:

http://www.smarty.net/docs/en/

based on the number of posts you have posted in the forum, you're likely trying to customize a lot of your site, so make sure you have a really good understanding of Smarty.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Hi Michael,

My sincere apologies for my previous post and for too much questions. Sometimes i just get frustrated trying to understand and customize JR.

I will go through the link you post to try to understand how the date and time work and how to get it display in the template.

Thanks a lot.

Ok I will go through the documentation to understand it and get it work.


Well dear Brian, believe me, I am just trying to get JR to work for us according to our needs otherwise I wouldn't have even bordered you with too much questions or posts in this forum. Yes I know I am asking too much. I may sound anointing but sometimes I just need to ask for a question in order to understand or to seek for assistance with the system or the code. I have managed to customize and set up many things in JR myself. It's a learning curve for me but I am improving a lot. My apologies for the excess of the forum post. Yes, with time, I will do my best to make sure I understand how things work.

Thanks

No worries - I didn't mention that because of the number of topics posted was a problem - you'll just find that usually when customizing JR it's going to involve templates, so in your case becoming a smarty "expert" is going to go a long way for you in helping you get the result you want.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Ok Brian. Thanks

Hi Michael

I have managed to get the date diplayed well in the template after reading carefully the link you suggested me. Thanks a lot, it works.

I used this code:


and it outputs e.g:


I am sorry and I just can't understand how I completely missed your post content. Your explanation was so clear. Thanks

Now there is just a small issue. The date is showing in English. Since it is taken from the server, I think it was supposed to display in the user's language selected when browsering the site. E.g. if the site is being visited in Spanish, the date should be in Spanish, if the site language is french, the date should be in French etc.

Do you know ho to fix it? I have this problem in both audio and video item detail page and in the Audio and video creation and update page. Even in the calendar with the date picker when creating or updating an audio or video, the date is in english.



Thanks a lot for the "Template Name In Source" clue. I wasn't even aware of it. I will activate it. It will be of a great help for me in this JR customization process.

Thanks a for the support.

The way php's strftime() function works is by checking the servers local setting as is explained in a similar question on Stack Overflow

http://stackoverflow.com/questions/25718115/trying-to-display-a-date-in-spanish

Jamroom currently doesn't change the servers settings when the language is switched between created languages, it just switches the jamroom settings.

I will take a look and see if there is a way to change the server settings in the core when the language is switched. Not sure how feasible it is to change the server settings per visiting user, but will look into it.

If its not possible, I would recommend using a non-language derived date format 24-02-2016.

Hi Michael,

Thanks a lot for your reply. Have you managed to find a solution to this issue?

The non-language derived date format 24-02-2016 is fine but we really need to display the day because most of our meetings or conferences are day-based meetings (recurring meetings). E. g.: There is a meeting that takes place only on Thuesday, another one only on saturday. They are different meetings. Displaying the day (Monday, Tuesday etc) of the meeting is quite useful for our users.

Thanks

I don't believe anything has been done on this, but I can check it out. Looks like we need a setlocale() call before doing date format conversions, so will see if that is doable.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Thanks in advance Brian. I appreciate your help.

Try this - modify your modules/jrCore/lib/util.php and around line 2,750 you will see this:

Change it to this:
and let me know if that works for you.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Hi Brian,

Thanks a lot. I have tried it, but it didn't work, nothing changed.

Through ftp (Filezila) , I went to modules/jrCore/lib/
In my ftp client, it took me to /modules/jrCore-release-5.4.0b2/lib/

Then I uploaded the edited file (util.php) to my server, cleared my cache and checked the Integrity, but nothing changed in the frontend.

Thanks

I tested this here with the Spanish language file and I see it working.

How did you test it to see it did not work?


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

I have just double checked and I discovered where is the problem. The util.php file doesn't save the change made in it. I've tried many code editors on my computer, I have even tried to use the built-in code editor of my server cpanel, but without success.

Is the util.php file locked for edition? it is uneditable.

Please advise. Thanks

Its not locked by anything jamroom is doing. It may be locked by your server company for some reason.

One possible way that could happen would be if the FTP user is not allowed to access files written by the server. You'd need to contact your server company to understand why you cant edit files on your server.

Hi Michael.

Thanks for your reply. Changes made in the It util.php doesn't get saved. First I downloaded the file to my pc through ftp. Then, I tried to edit it locally on my computer using my code editor as I usually do. After saving the change and closing the file, when I re-open it the change is not there. I can edit and save any other php file locally using the same code editor without problem. Then I tried using the built-in code editor of my server cpanel, just for testing purposes. Same problem. changes doesn't get saved in util.php.

Is there any reason for that.? Do you have any idea? Are you able to download the util.php from your server and edit it locally? Does the change get saved?

Thanks

You download it to your pc, then can't edit it on your pc? I can't think of any way that could happen.

Unless the file was set to 'Read Only' file permissions, but that would be extremely unusual on a file you downloaded to your pc.

Things I would try:
* see if the file is set to read-only and try changing it to read/write
* try a different download program.

Yes I can download and no, I have no problems editing and saving the file.

@brian and @mischael

Hi,

I've found the problem. It was a caching issue. I have managed to edit the util.php file after clearing all the cache and the temporary files on my computer.

Thanks

Hi Brian

Big wowwwww!!!! Brilliant!!!! You are really smart. Heads off. It was something difficult but you definitely got it. It works. Thanks a bunch. The display of the full date name will come in handy for us. Thanks.

That is why I love JR. Whenever you can, you always search for a solution, and most of the time you get it. What great support!

There are just minor issues to address:

1) The day name is being cached. Whenever a user changes the site language, the entire site gets translated, but the day name language remains unchanged, unless I manually clear the cache from the Admin CP.

Is there a way to automatically get it to change whenever the site language changes without waiting for the caching period?

2) When translated in language with accents like spanish, french, portuguese etc, special characters display as garbage. Example in words like: Sábado or Août etc.

Any fix for special characters?

3) When the date name changes according to the site language, sometimes it gets capitalized, sometimes not. E.g. Domingo and domingo.

How to get the date name always in Capital like it shows in english?

4) The date name changes almost in the entire site including the Admin side when I change the site language but it doesn't change in Calander/date picker where the user uploads an audio or video.

Will it also be possible to apply this date name modification to the date picker as well?

5) The code change was made to modules/jrCore/lib/util.php

Will I loose the change if there is a JR Upgrade of that file?
Are you considering adding this date name modification code to the core?

Many thanks for the great support.

Hello Brian,

Any solution to the issues posted above?

Thanks in advance.

Probably better to ask each question in its own thread. That way people coming after can search and see the title is the same issue they are having and see the thread is marked solved and read it to answer their own question.

The above, at least one of them needs a lot more detail to answer:
What are the steps you are taking to set this up, because its working here for me.

Hi Michael

Thanks for your reply. Well, they are all related questions from the same topic that sometimes it's hard to post them in separate threads without losing focus.

About your question, I didn't do anything special. I've just applied the solution/mod provided by Brian above.

The problem is with special characters in the a date name. Eg.: Sábado or Août etc. which display as garbage.

In your dev site, if you apply the solution provided by Brian above, then change the audio or video date to Saturday August , then change your site language to Spanish or French (Sábado or Août), you will understand what I am talking about.

Thanks.
updated by @pch: 09/09/16 09:11:14AM

Hi Brian,

Have you found a fix?

Thanks

Nothing has been done (or will be done) in JR5. We have just kicked off the JR6 beta:

https://www.jamroom.net/the-jamroom-network/blog/88/jamroom-6-beta-kick-off

Upgrade and the setlocale stuff should be working.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Ok, Thanks I will check it out. I wasn't even aware that JR6 Beta was released.

Is it stable enough to be used on a production site?

Thanks
updated by @pch: 09/27/16 11:24:04AM

It is stable enough to be used in development - don't upgrade a "live" or production site. When it is ready for a production site it will no longer be beta.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Thanks Brian. Great Job!