Uploading video files using Dreamweaver

I wish to allow users to upload video files in a web page using access.mdb to store the file names and paths.

I am considering uploading the files using FileFields and a Dreamweaver extension PureAspUpload.

The files at this stage are large and I thought it may be a good idea to use the Sorenson Squeeze on the server to reduce the file sizes.

However when these files are produced they are saved as say test1.flv and test1.swf

I now understand that the name that is placed in the database in this case must be test1 ie with no extension.

I wondered if there is a better method to get the the files uploaded, to the right size, with the correct name in the database?

Thanks
John
johnhardyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RouchieCommented:
Hi John

Other than getting users to do the resize themselves (which isn't user-friendly at all) then you're a bit stuck for alternatives.  There is a large degree in complexity in achieving what you've done so far so if you've got it to work, well done!

If the Sorenson plugin can be used with a command-line approach, then you could get ASP to run it when a file is uploaded.  This will allow you to either assign a file name dynamically, or use the existing file name.

It's a bit risky running programs from ASP, but it can be done.  Here's some more information:
http://classicasp.aspfaq.com/general/how-do-i-execute-a-dos-command/batch-file/exe-from-asp.html
0
johnhardyAuthor Commented:
Thanks Rouchie
I had a look at the page you mention, I regret that coding is too advanced for me, however theres lots of info there and I have book marked it for future reference.
0
RouchieCommented:
There are other code samples around that show ASP executing files.  No way seems any more secure/easy than the rest, but it's good to have a general read around anyway...

http://p2p.wrox.com/topic.asp?TOPIC_ID=5624
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_22976500.html

Because you want the whole process to be in one operation (for reliability and ease-of-use), it would seem that ASP would have to fire up Sorenson after the upload had finished and do the conversion before the database filename entry was created.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

johnhardyAuthor Commented:
Sorry to be slow in coming back Rouchie

Sorenson indicate the application may no be available for my OS windows server 2003, I am trying to find out further information
0
johnhardyAuthor Commented:
Thanks
Would you please let me know how to open a .tar.bz2 file.
I am using windows xp
0
RouchieCommented:
Sadly this is a Linux file format.  You'll need to get a Windows binary (.exe) version...

Had a look around and found one here: http://www.videohelp.com/tools/ffmpeg
0
johnhardyAuthor Commented:
Thanks
Sorry to be a pain but if I go to http://www.videohelp.com/tools/ffmpeg and select down load it takes me back to the page http://ffmpeg.mplayerhq.hu/ where I downloaded the .tar.bz2 file previously  I tried a few others but I could not find a  .exe download
0
RouchieCommented:
Go here http://ffdshow.faireal.net/mirror/ffmpeg/ and get the latest revision.

Then get the free 7Zip decompression utility and extract it using that (http://www.7-zip.org/)

Then on this page there seems to be a few instructions on how the command line tool works:
http://wiki.videolan.org/Fixing_.flv_to_.avi_with_Ffmpeg
0
johnhardyAuthor Commented:
Thanks Rouchie
I never had success with the last idea in fact I seemed to get into a muddle with it and  in the end  did a system restore so all is well again now.

I have had some success with a Sorenson Squeeze Trial but this works only on the local machine which in effect means a lot of downloading and uploading over the internet.

Sorenson produce another item called Squish which I think allows the client page to process and therefore is much faster. However it is too expensive.

Do you know of any other products which could be used?
0
RouchieCommented:
Afraid not because I use Flash directly to do the converting and only on my own files.

I would post a question in the Flash topic area asking if anybody knows of any "Windows-based flash video converters that can run from a command line prompt."

Failing that look to Google...!
0
johnhardyAuthor Commented:
0
RouchieCommented:
It seems to do what you need, but if you look at the Buy Now link, there's a huge price increase for the command line licence.  I presume that's because they know people will be converting in bulk.  Have a good look round before you buy anything.  Definitely fire a post into the Flash area because those guys do this sort of thing all the time.  Also maybe crosspost in this topic area too http://www.experts-exchange.com/Software/MultiMedia_Applications/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
johnhardyAuthor Commented:
Thanks Rouchie
Yes I did notice the price hike but I suppose we all have to make a living or at least try to.

I have had a go at  the eval and at first glance it look very good.

So thanks for all the good advice it has helped a great deal
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Multimedia Programming

From novice to tech pro — start learning today.