Archive for November, 2011

Moving Internet Explorer Favorites to the Network

I’ve been using this little trick ever since my early XP days and still using it with Windows 7, and was surprised that this wasn’t a more common tip/trick

This registry hack moves your IE Favorites off to the network (your home drive) and allows you to have your favorites follow you no matter which computer you are sitting at

The H:\ Drive is my network drive.  Move your Favorites folder from your Profile and to the Network drive, then change the registry keys bellow.

That’s it, any computer you log into, you must also edit the same keys to point to the network drive, but then again, you will never have to email yourself links.  (I’ve never tried this using Dropbox, but I bet it would work)

Yeah this post is not going to win any awards for innovation, but hey, who knows, it might just help someone out.

Facebook Twitter Email Linkedin Digg Delicious

How To Factory Reset Samsung Galaxy S2 SkyRocket

Just a quick post for those looking for the same thing….

I had to factory reset my new Galaxy S2 SR, I tweaked something that made the device completely unstable, and the instructions for the regular Samsung Galaxy S2 dont work.

  1. Turn off the Phone (or Pull the battery)
  2. Hold down the Vol + AND the Vol – keys AND the Power Key until the First Samsung Splash Screen comes up and quickly let go of the keys
  3. This will bring you to the Android recovery menu
  4. Use the Vol + and Vol – keys to move up and down the menu, and use the Home key (the one under the “SAM” in the Samsung logo at the bottom of the phone) to select the menu options
  5. Pick the Factory Reset Option
  6. Next Menu will have a bunch of No’s and one Yes, Scroll down to the Yes
  7. Hit the Home Key
  8. After the Reset, Pick Reboot Phone

Done, Nice and Clean

And yes, I know the Settings menu has a reset option, but the phone wouldn’t even work well enough to get to the menu

 

Facebook Twitter Email Linkedin Digg Delicious

Set the FROM Email when using the Linux MAIL command

The Linux / Unix command line has a command called “mail”.  The problem with mail is that all the emails will come from root@localhost or whatever user you are using to run the “mail” command.

In order to override the from email, you must invoke the “sendmail options, which is done by doing a double dash (–) and then the -f command like so

That’s all there is to it, the -f is the sendmail option for “From” which will get set when the email goes out

Refer to the mail and the sendmail man pages for more info

Facebook Twitter Email Linkedin Digg Delicious

Converting Julian Date to Gregorian Date

So if you work with JD Edwards Enterprise One, you know that the dates in the database are saved as Julian Date. Probably not a big deal, until someone requires that you create some sort of view or report based on the database tables for JDE. Well, in order to convert the fantastic Julian date to Gregorian (the dates we are used mm/dd/yyyy) so it’s human readable, then you have have to use a formula or stored procedure, or, you can use the following SQL

 

Now you can quit reading right here if you are happy with just the formula, or you can keep reading and read my explanation on how the SQL works!!

 

Ok so you decided to keep reading…Now Lets assume that we have a table, and the table is structured like so

ID Name Unit Description JlnDate

Now In order to query that table, we can use a simple Select Query, but then again, the field named “JlnDate” has the Julian date value, and that’s what we want to convert, so we modify our query from this

to this

 

And here is the break down of what exactly the SQL is doing…

Lets assume our JlnDate field has a value of 111089

dateadd(d,(convert(int,JlnDate) % 1000)-1,convert(datetime,(convert(varchar,convert(int,JlnDate) /1000 + 1900) + ‘/1/1’))) as GrgDate This Part takes the Julian Date Column and Divides it by 1000 then Adds 1900 to the result

Sample: 111089 / 1000 = 111.089 but since its an Interger, It becomes 111, so 1900 + 111

Final Value 2011

dateadd(d,(convert(int,JlnDate) % 1000)-1,convert(datetime,(convert(varchar,‘2011’ + ‘/1/1’))) as GrgDate This Part takes 2011 as a String and Adds /1/1 making it a valid SQL Date String (2011/1/1) ie Jan 1, 2011
dateadd(d,(convert(int,JlnDate) % 1000)-1,convert(datetime,’2011/1/1′)) as GrgDate This Part turns the Date String to an Actualy Date Time (‘2011/1/1 00:00:00’)
dateadd(d,(convert(int,JlnDate) % 1000)-1,‘2011/1/1 00:00:00’) as GrgDate This part takes the Julian Date Column which is 111089 and does something called MOD or “remainder” (that’s what the % stands for) so it will return 111089 % 1000 = 89
dateadd(d,(89)-1,’2011/1/1 00:00:00′) as GrgDate Now Finally, the DateAdd function will Add (89-1) days (d) to ‘2011/1/1’

The reason for the Minus (-) one is because you cant have a date of zero (0) so the 89th day of the year is actually 88 days after Jan 1st

3/31/2011 And Finally we come up with March 31st, 2011

Thats it. Now you not only have working SQL code to convert Julian Date, but you also know exactly how it works.

Facebook Twitter Email Linkedin Digg Delicious
Go to Top