Wednesday, December 31, 2014

Sync iTunes to Android

After hours of trying other solutions, I finally found how to synch music to an android device from my iTunes list.

- Install this app, Sync iTunes to android-windows

- Download the Windows app on the computer you have iTunes installed on.
- Change the location if you want them to be on an SD card. Follow the guide for this question, "How to sync to external sdcard?" here.

By default it will store to location recommended by your phone manufacturer. However we provide a setting in synctunes android app where you can change the location to external sdcard. To do that your first step should be to unsync/delete any music from phone you’ve previously synced, if you do not, it will take up space unnecessary disk space, because we are now defining new location and all music would now go there. To set the new location open synctunes on your phone then go to Settings -> Service uncheck it. The change the sdcard location and check the service again. Press back button to come back to main screen. Now when you sync again your files will go to external sdcard.If you can not locate the sdcard settings please contact us for help 
- Find the IP address of your Android device through the Wifi app. Select the connection, and tap it to see the details. It will show the IP address.
- Enter the IP address when you set up the windows app. This guide will show you how.


Friday, December 19, 2014

Get a DB Diagram in PDF from SQL Server Managment Studio

Here is a way to save a database diagram into a file format so that you can easily pan without it trying to refresh from the DB.

open the diagram and right click somewhere in the middle and you'll have there the option to "Copy diagram to clipboard". From here you paste to MSPaint or another image creator and save to wanted format; (http://dba.stackexchange.com/questions/34132/how-export-a-sql-server-2008-diagram-to-pdf-filetype)
From there just paste into MsPaint or some other program and save it.

Wednesday, December 17, 2014

Plex Media Server

Last January, I set up Plex Media Server for my home media system.

Here is a guide to having it actually start up like a real service in windows so you don't have to login to have it work.

Plex Queue

I just figured out how to use the Plex Queue. Now I don't have to download videos and store them locally.

At http://plex.tv/web/app#!/playlist/queue/help you see
1 - a button you can drag to your bookmark bar. It contains the following javascript
javascript:%20var%20s=document.createElement("script");s.type="text/javascript";s.src="//plex.tv/queue/bookmarklet_payload";var%20h=document.getElementsByTagName("head")[0];h.appendChild(s);void(0);
When you click this bookmarklet on a page with a video, it will add it to your plex queue. It does this by connecting through to your plex account and the plex account your plex server is using.

2 - A generated email address after the pattern, queue+[generatedKey]@save.plex.tv. If you email a link to a page that has a video you would like to watch later, just email the url to it.

So far, I have been able to queue from these sites, youtube, gc.lds.org, lds devotionals. Facebook videos that are public do not seem to work.