OMG! How To Burn AVI Files In iDVD On A Mac For Free!

I know! The title has the word MAC in it! What is wrong with me? Well sometimes you have to use all of the tools at your disposal. I have PCs and Macs and sometimes the Mac is the tool for what I'm trying to do. Right now, I'm doing some Android development. I could do this on a PC, but I have to be honest - the emulator just works more quickly on a Mac. There....I said it!

Anyway, I recently decided to burn some videos using iDVD. However, the videos were .AVI files. That shouldn't be a problem right? WRONG! iDVD doesn't allow you to burn .avi files to DVD right out of the box - at least not the version I have. So what is a girl with .avi files to do when she wants to burn them to DVD using iDVD? DOWNLOAD THE CODEC THAT WILL ALLOW ME TO DO IT! :-)

I found a lot of misinformation out there about how to burn .avi files on a Mac. Some people suggested that I would need to download Toast, which is not free. They also suggested other programs which were not free. Since I have PCs, I'm used to not paying extra for ordinary things like burning .avi files and I'm not going to change that trend. Anyway, follow these instructions to burn your. .avi files using iDVD.


Before you begin, close iDVD if it is open.

1. Download the Divx codec using this link. http://www.divx.com/en/software/download This link will send you to the Divx download page that offers everything you need. Just download it. It is going to contain some things that you likely aren't going to use, but it is all in one package.

2. Once the package has been downloaded, double-click it and walk through the install process.

3. Download Perian's software. This will allow you to hear your videos - which is a nice thing. Go to http://www.perian.org/.

4. Once the software downloads, double-click it and walk through the Perian installation process.

5. After the install process has completed, restart your machine.

6. After you restart your machine, go to iDVD and start a new project.

7. Now select File/Import/Video and select your .avi file.

8. Create the rest of your menu.

9. Check your movie to see if it works the way you think it should. This isn't a tutorial on how to use iDVD, so if you don't know what to do, follow the tutorial inside of the iDVD help area to learn how to make your movie menu, etc.

10. Burn your dvd.

There you have it! Now, here are a few things to remember. You CAN import .avi files into iDVD without doing a thing, however, if you don't have the correct codec installed, you won't see anything more than a green chromakey screen when you try to view your videos. DON'T make the mistake of importing the video and then just burning a DVD. If you can't watch the video in iDVD, then it WILL NOT show up correctly on the DVD you create. You will see the menu and be able to select the movie, however, it will just show up as a green screen on your DVD player. If you do not install Perian, you will not be able to hear your videos. You will be able to see them with Divx, but the audio codec that will allow you to hear the audio encoded into most .avi files will not be present - so make sure you install Perian.

If you are having trouble burning the DVD directly, you might need to create an image first using iDVD and then burn the image to dvd using Disk Utility. If you need to burn an image, select that option on the File menu in iDVD.

IMPORTANT NOTES:
MAKE SURE THAT YOU WATCH THE MOVIE BEFORE YOU BURN IT TO DVD! IF THERE ARE ANY ISSUES, SEEING BEFORE YOU WASTE A DVD IS ALWAYS PREFERABLE.

MAKE SURE THAT YOU DELETE ANY ENCODED ASSETS IF YOU ARE NOT CREATING A NEW PROJECT. (IN IDVD CLICK ON ADVANCED/DELETE ENCODED ASSETS)

MAKE SURE THAT THE SYSTEM OUTPUT VOLUME IS NOT DOWN LOW OR ON MUTE. CLICK ON THE APPLE SYMBOL IN THE UPPER RIGHT HAND CORNER OF THE SCREEN AND SELECT SYSTEM PREFERENCES. UNDER HARDWARE, SELECT SOUND. AT THE BOTTOM OF THE SCREEN, YOU WILL SEE OUTPUT VOLUME. MAKE SURE THAT IS ALL THE WAY UP AND NOT ON MUTE.

Have fun burning your .avi files using iDVD on a Mac for free!

Smooches,

Kila

I HATE Microsoft Excel And That Darn Ribbon!

Whew! There! I said it! I just had to get that off of my chest. I'm so sick of the ribbon that I could cry. I have long since abandoned Microsoft Office in favor of Open Office because of the ribbon and the decrease in productivity I had from having to search for things that were no longer where they should be. However, I'm currently working on a project with a company that uses Excel and I absolutely can't stand it! From a user perspective, why on EARTH would Microsoft think that it was a good idea to FORCE people to relearn how to use Excel, Word and all of the other Office items that now use the Ribbon WITHOUT PROVIDING A WAY TO SEE THINGS USING THE CLASSIC VIEW? The Office products are now such crap that I absolutely refuse to use them unless I'm forced to. I don't have the time to hunt and peck to find what I need. I don't have the time to click through mind numbing icons that don't mean crap to me when I need to go to File/Save. Why would ANYONE think that an icon based menu would be better than words? Why would ANYONE WHO ISN'T HIGH OR DRUNK think that removing ALL of the words in favor of pics would be OK with everyone. I can't stand it! I wish that I could get that ONE GUY or GIRL who came up with the ribbon idea and give that person a good thrashing!

Or.......maybe I'll quit my ranting and raving and just go develop a classic menu for Excel myself. Darn, if only I had the time! Microsoft, I'm really upset with you for this. Using MS Office used to be quick and efficient. Now, using it means hunting for the things I want to do and resting my mouse pointer over things to figure out if something is what I want. I spent 3 minutes trying to find the word count feature before I finally just went online to a word count website and used that tool instead! How is that better than what we had with the classic menu? You can't tell me that I'm alone here.

I KNOW I'm not alone. Productivity With MS Office - WAY DOWN! Frustration Level - WAY WAY UP!!!

http://www.exceluser.com/explore/surveys/ribbon/ribbon-survey-results.htm

How To Drop All Stored Procedures In Your Database When Using Sql Server

Ever have the need to drop all of the stored procedures in your database? Well if you do, you are in luck! Here is a script that will drop all of the stored procedures in your Sql Server database for you. Just open a new query window, enter the script, type your database name in the Use statement and press F5!

USE YourDatabaseNameHere
GO

declare @storedProcedureName sysname

declare procCursor cursor for
select name from sysobjects where type = 'P' and objectproperty(id, 'IsMSShipped') = 0

open procCursor
fetch next from procCursor into @storedProcedureName
while @@FETCH_STATUS = 0
begin
exec('drop proc ' + @storedProcedureName)
fetch next from procCursor into @storedProcedureName
end

close procCursor
deallocate procCursor
go

That is it! Now you can delete all of the stored procedures in your database quickly and easily!

Smooches,

Kila

How To Use Html.Action With Areas

Microsoft created Areas to make our lives easier. The sad thing is that some little details can make your life worse. We are going to take a look at one of those things - Html.Action. When you are using Areas in your application, Html.Action can generate errors. The typical error you will see is "The controller for path '/whateverpath/' was not found or does not implement IController".

That is real helpful isn't it? You can tell a lot from that error right? NOT!!!! That error might lead you to believe that some controller is having an issue. That is not the case! Instead, that error means that you have not set up your Html.Action item correctly. To get your areas to cooperate with Html.Action, you have to set your link up like this.:

Html.Action("YourMethod", "YourController", new { area = "YourArea" })

You might be wondering what you should do if you are using Html.Action and you are using a controller that is NOT in an area. Well let me tell you so you can stop wondering. You set up the action method like this:

Html.Action("YourMethod", "YourController", new { area = "" })

And that is it!!

Smooches,

Kila Morton

Problem:

"The controller for path was not found or does not implement IController"

Solution:

Use
Html.Action("YourMethod", "YourController", new { area = "YourArea" })
if you are referencing something inside of an area.

Use
Html.Action("YourMethod", "YourController", new { area = "" })
if you are not referencing something outside of the areas

How To Reset The Canon MP 190 So You Can Scan If You Have No Ink! Eliminate The Canon MP 190 Scan Blues!

I hate companies that try to force you into using their products or.....companies that force you to refill their empty ink cartridges just to use a scan feature. OK - hate is a strong word. I will say that I strongly dislike that. Anyway, I have so many printers and scanners that it should be easy for me to print and scan whenever I like. However, that is not always the case. Today I needed to scan something using my Canon MP190. The MP 190 isn't a great all in one, but it does work appropriately in most cases. The one thing that I don't like about it is that the printer will not scan if you do not have ink in there. The reason is that Canon has an initialization process for this printer that checks if there is adequate ink. If there isn't, that process fails and you can't do much else - until now. I figured out a way to bypass this "system fault" so that you can scan again. The solution and is a VERY simple one.

Ready? Hold down the Stop/Reset button for about 30 seconds! There you go! I wish I could make it more intense. There just isn't anything else to it. Holding down that button will allow you to go back and scan documents even if you are completely out of ink. (SEE BELOW)

Don't you just love it?

UPDATE 3/22/2011

I feel compelled to update this post with a few more details.

First, you must have the MP Navigator software installed to use my little trick.

Second, the printer needs to be ON. I didn't specify this when I first posted this and I see that a few people had problems.

Third, you need to hold the Stop/Reset button down UNTIL THE LIGHTS START BLINKING. So hold the button down, let the lights come on and start to blink and then after the lights stop blinking, then let go. That may be MORE than 30 seconds. That is why I said "about" 30 seconds above.

That should get you going.

If it doesn't, please don't post that it didn't work. Instead, post what you did and what happened! That is something that I can investigate. It doesn't work means nothing because it does and did work for me. So help me to help you!

Smooches,

Kila

Why Do I Love Cheating On Dot Net As Much As I Do With.....Ruby(LOL)!

I try to keep this site clear of anything other than my love for .Net, but I am the biggest cheater I have ever known. You know why? I really, really love Ruby on Rails! There.... I said it! I mean I REALLY love Ruby on Rails! I'm telling you this for a few reasons. First, as you move through the programming world, it is important to keep your mind open. A programmer should know multiple languages. It helps you on a number of levels. Professionally, it helps if you can demonstrate your flexibility in learning new things. Second, if you ever need to find a new job, you have more than one programming language under your belt which can open up more programming opportunities for you. Third, knowing more than one language helps you to see deficiencies more clearly in the languages you use. I can tell you from experience that learning .Net and then learning Ruby made me clearly see some key deficiencies in .Net - even though I still love .Net.

I'm not saying that you need to learn every language under the sun, but knowing additional languages can only be a good thing. If you are a .Net programmer, I HIGHLY suggest that you add Ruby on Rails to your arsenal. As a plus, you can likely create a fully functioning program in Ruby in less time than it took you to read this.

Smooches,

Kila

Finding The .SQL Mime Type SQL Server Mime Type

OMG! Why are some things so much more difficult than they need to be? I am creating a database application to make my life simpler. The application allows you to enter class file information once and then the application automatically, or should I say automagically, creates the class .cs file, Fluent NHibernate mapping files in your choice of AutoMap or ClassMap files (AutoMap and overrides are my preference) and the database .sql script. Creating the files and saving them to the database is simple. The problem came when I needed to download the files from the database. The system was adding a .txt file to the end of the file - Example: FileName.sql.txt. This was making me very sad.

I decided to get the actual mime type for a sql file so that the file would download appropriately without adding .txt to the file. Well you would think that I was trying to find how to get into Fort Knox or something. The general consensus is that most people just want to use text/plain. Not I said the mouse! Well I decided to use something I had used before - the Gnome Mime Type database. This database had allowed me to find a mime type that worked properly with some other Microsoft files that I was saving and retrieving from a database (for example, the mime type for a .cs file in the Gnome library is text/c-sharp and it works perfectly). Sooooo back to my good old friend.

The mime type for a .sql file is text/x-sql. The Gnome mime library is pretty extensive. The goal is to be a resource and standard way of using and finding mime types.

This is a simple thing, but since Google wasn't the easiest resource for finding the mime type for .sql files, I thought you might find this useful.

PROBLEM:

What is the .sql mime type? Where can I find the .sql mime type? Should I use text/plain or another mime type for .sql files?

SOLUTION:

You can use text/x-sql and you can use the Gnome library to find out more mime types as needed.

Smooches,

Kila Morton