Posts

Showing posts from May, 2016

Dont underestimate experience

Image
A critical gearbox failed and no one could fix it. So they brought in a bloke with great trouble-shooting experience. He inspected the gear drive very carefully. After looking things over, the guy reached into his bag and pulled out a small tool. He gently tapped something. Before long, the gearbox was back working! The owners got his bill for $10k. "What?!" the owners said, "You hardly did anything. Send us an itemized bill.” The reply simply said: 
Tapping with a hammer. .$50 
 Knowing where to tap. .$9950 

 Don't underestimate experience.

Generate SEO URL from String - Excel Formula

=LOWER(substitute(substitute((SUBSTITUTE (SUBSTITUTE(SUBSTITUTE(SUBSTITUTE (SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE (SUBSTITUTE(SUBSTITUTE(SUBSTITUTE (TRIM(SUBSTITUTE(SUBSTITUTE( SUBSTITUTE(B3,"'","")," - ","-")," / ","-") ),"/",""),"+",""),"®",""),"™",""),":",""),")",""),"(","" ),"&",""),".",""),"""",""),",",""))," ","-")," & ","")

Export user details from ATG

Use the following query to export user details from database directly

SELECT CORE.dps_user.id as User_ID, CORE.dps_user.first_name, CORE.dps_user.email, CORE.dps_user.realm_id, CORE.dps_user_org.organization
FROM CORE.dps_user
INNER JOIN CORE.dps_user_org 
ON  CORE.dps_user.id= CORE.dps_user_org.user_id
ORDER BY CORE.dps_user.realm_id