DVD Burning on OS X

dvd

There are many great pay ware cd and dvd burning programs out there for OS X, however ones that are willing and able to burn DVD video are few and far between. Often video is either an afterthought or requires buying additional plugins. This is not so for a great little application that I just found today, Burn for OS X.

While it appears a little rough around the edges, and the documentation leaves a little bit to be desired, one of the many features include the ability to burn DVD video. It also will convert files over to the required MPEG2 format. I found that it worked wonders for my .mov file encoded with H264 in 720p glory.

burn-osx

Great Plains Dynamics 2011 year end update… error!

Train Wreck, Steam Locomotives

This week we ran the GP updates for the end of year that also happened to have SP 5 included in the roll-up. The install finished successfully, however after running the GP Utilities we came up with the following errors when upgrading our company. The solution was that the CRM integrator was still running and needed to be forced to quit.  After that all the problems went away!
The following SQL statement produced an error:
set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2’  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSChangedCustomerKey1’
The following SQL statement produced an error:
set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2’  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSChangedPriceLevelKey1’ in the database.
The following SQL statement produced an error:
set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2’  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSChangedSalespersonKey1’ in the database.
The following SQL statement produced an error:
set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2’  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSCustomer1’ in the database.
The following SQL statement produced an error:
set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2’  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSPriceLevel1’ in the database.
The following SQL statement produced an error:
set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2’  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSSalesperson1’ in the database.
Upgrade of database: SG failed! Microsoft Dynamics GP Utilities will now shutdown.

The following SQL statement produced an error: set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2’  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSChangedCustomerKey1’
The following SQL statement produced an error: set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2’  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSChangedPriceLevelKey1’ in the database.
The following SQL statement produced an error: set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2’  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSChangedSalespersonKey1’ in the database.
The following SQL statement produced an error: set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2’  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSCustomer1’ in the database.
The following SQL statement produced an error: set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2’  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSPriceLevel1’ in the database.
The following SQL statement produced an error: set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1’  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2’  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSSalesperson1’ in the database.
Upgrade of database: NN failed! Microsoft Dynamics GP Utilities will now shutdown.

Merry Christmas

It is yet again time for the annual tradition of the family Christmas cards and along with that comes the family Christmas Card Letter and Photo. This year the photo is a selection from our 1 year anniversary visit to Las Vegas and the Grand Canyon.

Hopefully the Christmas Cards will be going out in the mail soon, and those of you who are on our list should be getting them shortly after that. If you don’t get one, either we forgot you, didn’t have your address, or just didn’t send you one 🙂 (Hey, postage is expensive!)

Christmas Letter 2011
Andy and Jess at the Grand Canyon

Winter Driving

With the winter travel season upon us yet again it is always handy to call 511 to check road and weather conditions before you venture out. For those who don’t know 511 is the shortcut to your state’s road weather and hazard hotline. However, what do you do if you want the next state over? Of course the first choice is to look it up online, google is always your friend. But if you are on the road and don’t have access to the net there still are the old fashioned 800 numbers that still work.

Below are a selection of the regional numbers from the Iowa State University mesonet.

Iowa : 800-288-1047
Illinois : 800-452-4368
Kansas : 800-585-7623
Minnesota : 800-542-0220
Missouri : 800-222-6400
Nebraska : 402-471-4533
South Dakota : 605-367-5707
Wisconsin : 800-762-3947

Of course, while you are at it you can always check out my weather summery page.

Google Mobile Exchange “Password Incorrect” on iOS

Gmail en OME

If you are using Google Mobile in “Microsoft Exchange” mode for your iphone, you will occasionally run into an odd error informing you that your password is not correct, it will say:

Password Incorrect
Enter the password for the exchange Account “Account Name”

Don’t worry, your password is still correct. For some reason you have caught the ire of google’s security captcha.  To cure your ills, go to a computer and point your web browser to https://www.google.com/accounts/UnlockCaptcha (or if you are feeling lazy http://goo.gl/phGwL)

You should find that all your problems go away and the nag screen will go away.