[EP-tech] Re: Conversion of images, videos into preview/thumbnail versions

Thu Aug 7 10:42:22 BST 2014

Hi Jacob,

This is to do with the encodings used by the database tables.

The latest version of eprints would create tables using UTF-8 encoding, 
but if you upgraded from an older version of eprints, you may still have 
the Latin encoding. UTF-8 characters will be messed up if you to save 
them into the a Latin encoding database table.

To check the encoding:
SELECT default_character_set_name FROM information_schema.SCHEMATA WHERE 
schema_name = "eprints_db_name";

If it is not UTF-8, you will need to convert your database tables to 
UTF-8 encoding manually. 
(http://stackoverflow.com/questions/6115612/how-to-convert-an-entire-mysql-database-characterset-and-collation-to-utf-8 
)

Make sure you backup your database before doing so!

Best
Jiadi

On 07/08/2014 09:57, Jacob Wenzel wrote:
> Perfect, it all works now.
>
> I did notice s small bug related to UTF8 I guess.
>
> If video file name contains special characters like "Æ, Ø, Å", no 
> preview will be generated. But I guess that would be bad practice to 
> do anyway.
>
> Thanks a lot for helping me out!
>
> Jacob.
>
> On 05-08-2014 23:19, Jiadi Yao wrote:
>> Hi Jacob,
>>
>> You first need to run
>>
>> $ bin/epadmin redo_mime_type
>>
>> then
>> $ bin/epadmin redo_thumbnails
>>
>> Technical details : document.media_video_codec in the database needs 
>> to be valid before thumbnails are generated. This field is populated 
>> after a video file is upload when ffmpeg is installed, otherwise you 
>> need to redo_mime_type to back-fill those videos uploaded before 
>> installing ffmpeg.
>>
>>
>> Best
>> Jiadi
>>
>> On 05/08/2014 18:56, Jacob Wenzel wrote:
>>> Great!
>>>
>>> I restarted apache and uploaded a video, and it now displays 
>>> correctly with a thumbnail.
>>>
>>> Now I only need to redo the ones I already uploaded.
>>>
>>> I tried "bin/generate_abstracts" and "bin/epadmin redo_thumbnails 
>>> [eprint id]" but neither had any effect.
>>>
>>> What am I missing?
>>>
>>> All the best
>>> Jacob
>>>
>>>
>>> On 05-08-2014 16:39, Jacob Wenzel wrote:
>>>> Thank you both!
>>>>
>>>> I have done what Jiadi toild me to. Was that what you meant by 
>>>> configure ffmpeg seb?
>>>>
>>>> If not, than what do I need to do now?
>>>>
>>>> If yes, what is the correct step for me now? Restart apache and 
>>>> regenerate thumbnails?
>>>>
>>>> I really appreciate your feedback!
>>>>
>>>> /Jacob
>>>>
>>>> On 05-08-2014 15:43, Jiadi Yao wrote:
>>>>> After you installed ffmpeg, you'll need to changed the codec 
>>>>> settings in Thumbnails.pm :
>>>>>
>>>>> 1. change  libfaac codec with libvo_aacenc
>>>>> 2. change  vorbis codec to libvorbis
>>>>>
>>>>> as those codes are no longer supported by ffmpeg.
>>>>>
>>>>> In addition, in lib/syscfg.d/invocations.pl
>>>>> "-vpre default" parameter need to be removed
>>>>>
>>>>>
>>>>> I'll update the github when I get a chance.
>>>>>
>>>>> Best
>>>>> Jiadi
>>>>>
>>>>>
>>>>> On 05/08/2014 14:27, Sebastien Francois wrote:
>>>>>> Hi,
>>>>>>
>>>>>> Yes - it's a core functionality: 
>>>>>> https://github.com/eprints/eprints/blob/3.3/perl_lib/EPrints/Plugin/Convert/Thumbnails.pm
>>>>>>
>>>>>> Do you have ffmpeg set-up?
>>>>>>
>>>>>> Seb.
>>>>>>
>>>>>> On 05/08/14 13:50, Jacob Wenzel wrote:
>>>>>>> Is it even possible to show image thumbnail previews of uploaded 
>>>>>>> videos and images in EPrints 3.3.12?
>>>>>>>
>>>>>>> I use coversheets and the youtube-dl packages from the Baza, 
>>>>>>> which generates a thumbnail preview from PDFs or imports a 
>>>>>>> screenshot from the video on Youtube and adds a link to the video.
>>>>>>>
>>>>>>> But if I upload actual image files or videos, the file is 
>>>>>>> depicted with and icon and no preview link is available.
>>>>>>>
>>>>>>> I found some guides/plugins that promise to do this, but they 
>>>>>>> all seem to be targeting different, older versions of EPrints, 
>>>>>>> and I haven't been able to find recent ones.
>>>>>>>
>>>>>>> Furthermore I would think that this was basic functionality that 
>>>>>>> any user would want, so I don't why this functionality shouldn't 
>>>>>>> be available "out the box".
>>>>>>>
>>>>>>> This is the most recent document i have been able to find, but 
>>>>>>> my "eprints_render" does not include the lines, that are 
>>>>>>> mentioned in the guide, so I suspect is is targeting an older 
>>>>>>> version.
>>>>>>> http://wiki.eprints.org/w/How_to_Create_Cover_Images_in_EPrints_3
>>>>>>>
>>>>>>> I also looked at PreviewPlus (only for older versions) and a few 
>>>>>>> other links
>>>>>>>
>>>>>>> Maybe my setup is wrong, but "epadmin test" shows "everything 
>>>>>>> seems OK", so any help or pointers would be greatly appreciated. 
>>>>>>> Where should I look, and how should I start.
>>>>>>>
>>>>>>> Thank you all in advance!
>>>>>>> -- 
>>>>>>>
>>>>>>> *Med venlig hilsen/Best regards*
>>>>>>>
>>>>>>> *JACOB WENZEL
>>>>>>> Projektleder*
>>>>>>>
>>>>>>> *ENERGIAKADEMIET*
>>>>>>> Strandengen 1
>>>>>>> 8305 SAMSØ
>>>>>>> +45 60 61 15 97
>>>>>>> jw at energiakademiet.dk <mailto:jw at energiakademiet.dk>
>>>>>>> www.energiakademiet.dk <http://energiakademiet.dk>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> *** Options:http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>>>>> *** Archive:http://www.eprints.org/tech.php/
>>>>>>> *** EPrints community wiki:http://wiki.eprints.org/
>>>>>>> *** EPrints developers Forum:http://forum.eprints.org/
>>>>>>
>>>>>>
>>>>>>
>>>>>> *** Options:http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>>>> *** Archive:http://www.eprints.org/tech.php/
>>>>>> *** EPrints community wiki:http://wiki.eprints.org/
>>>>>> *** EPrints developers Forum:http://forum.eprints.org/
>>>>>
>>>>> -- 
>>>>> Jiadi Yao
>>>>> jy2e08 at ecs.soton.ac.uk
>>>>> EPrints Services
>>>>> 3081, Building 32
>>>>> University of Southampton
>>>>>
>>>>>
>>>>> *** Options:http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>>> *** Archive:http://www.eprints.org/tech.php/
>>>>> *** EPrints community wiki:http://wiki.eprints.org/
>>>>> *** EPrints developers Forum:http://forum.eprints.org/
>>>>
>>>>
>>>>
>>>> *** Options:http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>> *** Archive:http://www.eprints.org/tech.php/
>>>> *** EPrints community wiki:http://wiki.eprints.org/
>>>> *** EPrints developers Forum:http://forum.eprints.org/
>>>
>>>
>>>
>>> *** Options:http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>> *** Archive:http://www.eprints.org/tech.php/
>>> *** EPrints community wiki:http://wiki.eprints.org/
>>> *** EPrints developers Forum:http://forum.eprints.org/
>>
>>
>>
>> *** Options:http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>> *** Archive:http://www.eprints.org/tech.php/
>> *** EPrints community wiki:http://wiki.eprints.org/
>> *** EPrints developers Forum:http://forum.eprints.org/
>
>
>
> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** Archive: http://www.eprints.org/tech.php/
> *** EPrints community wiki: http://wiki.eprints.org/
> *** EPrints developers Forum: http://forum.eprints.org/

-- 
Jiadi Yao
jy2e08 at ecs.soton.ac.uk
EPrints Services
3081, Building 32
University of Southampton

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20140807/2b07afa8/attachment.html 