Thursday, November 12, 2015 1:06 PM
Many institutions have videos in their collections, but searching these videos for specific content can be challenging and time-consuming for staff and users alike. You can catalogue the contents of videos so that they are more searchable, but that can take a lot of staff time.
That’s why YouTube’s automated transcription feature is potentially helpful for institutions to have in their repertoire of tools. With a simple click of a button, a timecode synced transcript can be created for videos that you have uploaded to YouTube. While the transcript will definitely have errors, it gives you a great starting point. After editing the transcript can be added to the video’s database record giving your users a way to search the video’s actual contents.
When videos with speech are uploaded to YouTube, closed captions or subtitles are automatically generated. You can see if they are available by looking for the CC button in the bottom right. If the quality of the audio is reasonable, YouTube will also automatically make a text transcript which is accessible under the More hyperlink. This transcription can be copied and pasted into a field in your DB/TextWorks database and corrected while listening along to the video. This text can then be made fully searchable by your WebPublisher PRO or Andornot Discovery Interface software.
Even if you don’t want the videos to be permanently or publicly available on YouTube, you can still take advantage of YouTube’s transcript option. Videos can be uploaded privately, the transcripts generated and then copied and saved elsewhere, before the videos are then removed.
The accuracy of the transcript will depend on several factors, including the quality of the audio, the clarity of the speech and whether the subject matter contains many proper names. Apparently Scottish accents in particular can be problematic, but you can easily review the text first to check the quality.
As always, contact us for assistance to discuss possibilities for adding video transcriptions to your databases and search engines.
Friday, October 07, 2011 11:35 AM
Do you find yourself in a rut – using the same old tools or even the same old hardware - over and over again and wondering if there is a better way to do that multi-step task? Here is a list of a few utilties that we use regularly and that IMHO will change the way you work.
Sending large files:
We often ask our clients to send us large files. We can accept very large files via email attachment or if they are very, very large, we ask our clients to drop them onto our FTP site. However, the limitation for sending large files as email attachments is often at the client end. Have you ever noticed how those emails with largish file attachments (maybe only 2MB) never go out? YouSendIt provides an easy way to send files to us or to your friends or colleagues. Again, it is a web-based solution, which has some limitations in the no charge version, but even with that you can send one file – up to 50MB - at a time. No need to send that file via CD in the mail, any more. As soon as it is sent via YouSendIt, your intended recipient receives an email and clicks on a link to download it.
Do you have to need to access documents or upload documents to remote servers and are you finding that the security on those systems is tightening up more and more? For most folks, you probably have a familiar old FTP program that have used for years, but these just don’t cut it anymore. And if you use your Windows Explorer, you may find yourself locked out of certain systems too. We recommend that you upgrade to one of the newer FTP clients that can handle these new secure systems. There is certainly no need to purchase a package; there are plenty of open source packages that are excellent. We recommend FileZilla.
Perhaps you have created a document electronically and need to fax it to someone else, yes fax... I know, so yesterday, right? So you print it and locate the only fax machine in your building left and you dial the number, load the document, the right way up without it being slanted, press the Send button and hope that at the other end they get it without a long black strip through the middle. Well, I’m here to tell you that there is a better way, without leaving your desk. Well, some of you probably have this technology already in place, but for those who do not, here is a great site, that allows you to send the document over the web to a fax machine. The site is FaxZero.
Of course there are other alternatives to those mentioned above and you might want to check out sites like LifeHacker for reviews and recommendations. Send us some of your suggestions and we’ll test them. We are always trying new stuff and we might even include them in our next newsletter or in a blog post.
Tuesday, June 07, 2011 12:25 PM
I have a home server running Amahi on Fedora Linux. I tell everyone it’s for backups and media, but it’s really so I can tinker with it and have to something to complain about. While prepping it this weekend for an upgrade, I got careless and decided to merge a partition that wasn’t being used with the boot partition.
Except it was being used. Imagine my surprise when it wouldn’t boot. And after some poking around, I was able to phrase the question that was to determine my course of action for the next 12 hours: “Er… where’s the operating system?”
To cut a long story short, I was able to recover the deleted partition with TestDisk, which comes with the handy handy HANDY Parted Magic CD. Both are free and indispensable.
TestDisk is open source data recovery software for recovering lost partitions and making non-booting disks bootable again.
PhotoRec is open source file recovery software that finds lost files from hard disks and digital cameras, even if the file system has been damaged or reformatted.
PartedMagic is an open source suite of programs for disk, partition and file system management. It includes TestDisk and PhotoRec (and many others). It runs from a CD, no install required.
- Format internal and external hard drives.
- Move, copy, create, delete, expand & shrink hard drive partitions.
- Clone your hard drive, to create a full backup.
- Test hard drives for impending failure.
- Test memory for bad sectors.
- Benchmark your computer for a performance rating.
- Securely erase your entire hard drive, wiping it clean from all data.
- Gives access to non-booting systems allowing you to rescue important data.
Tuesday, May 24, 2011 5:00 PM
We feature a cool tool in almost every issue of the Andornot Newsletter, but here’s one that just couldn’t wait for the next issue: Screencast-0-matic! Not only does it have a fabulous name, it’s a great tool too.
Here’s the 411 on it:
- It’s a screen recorder – it records the motions, clicks and actions you make on your computer, whether using software or browsing the web. It’s like pointing a video camera at your screen.
- You can limit the recording to just a portion of your screen (e.g. to avoid capturing personal information).
- You can also record audio, or video from a webcam.
- You can upload the result to YouTube immediately after recording, or export it to a video file on your computer.
- It’s Java-based and launches directly from the Screencast-o-matic website, so there’s no software to download and install.
- It’s free (though there’s a Pro version that doesn’t apply a logo overlay to the video).
I particularly appreciated that it didn’t require a software install, just Java, and that I could upload the result to YouTube right away (though of course I wouldn’t do that if the video showed anything confidential or proprietary). With just a few clicks, I can record something and send it to a client to illustrate a point, almost effortlessly. I often make screenshots, drawings and diagrams to help convey information, but sometimes a video is better.
Wednesday, April 15, 2009 10:34 AM
If you're attempting to use Microsoft's Database Publishing Wizard
you might run into an error like the following (if you're running SQL Server Express 2005 - don't know if you will run into it with SQL Server 2005 Standard etc.):
This wizard will close because it encountered the following error:
Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=18.104.22.168, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.ConnectionInfo)
If you do, just download the x64 version of Microsoft SQL Server 2005 Management Objects Collection located here
. This post pointed me in the right direction
as the possible solution suggested does in fact resolve the issue.