Posts

Image
If you had gone through my blog entry here, i would have talked about using UDML as a way for automating migration from dev to test/prod environments. But the major problem with UDML is that one cannot update the passwords of Connection Pools, Users etc since the UDML expects them to be encoded. In such a case, for updating passwords alone we can use an undocumented command line switch option for the AdminTool. For example, look at the screenshot below.

If you had gone through my blog entry here, i would have talked about using UDML as a way for automating migration from dev to test/prod environments. But the major problem with UDML is that one cannot update the passwords of Connection Pools, Users etc since the UDML expects them to be encoded. In such a case, for updating passwords alone we can use an undocumented command line switch option for the AdminTool. For example, look at the screenshot below.

Open Dev_Machine.rpd Administrator Administrator

SetProperty "Connection Pool&…

Using a Dashboard Prompt as a Column Selector for Multiple Reports

Image
Dashboard prompts are typically used for filtering data values in reports, but you can also use Dashboard prompts to switch out columns on multiple reports, similar to the way a column selector would work on an individual report, but on a broader scope. Here is an example along with the high level steps:

1.Identify the names of the columns to include in the Dashboard Prompt Column Selector, in this example: Region and Market
2.Create a logical column that will produce these values:
CASE WHEN Paint.Periods."Year" < '2001' THEN 'Region' ELSE 'Market' END
Create a new Dashboard Prompt that contains this column and populates a Presentation Variable based on this column:


Create your reports that will be affected by this Dashboard Prompt. For the specific report column that will be switched out, use the Presentation Variable in the column formula to dynamically change the column data based on the Dashboard Prompt:







1.It’s a good idea to specify a default v…

Automated RPD updates using UDML (Unix or Windows Env)

Some Useful Excel Macros

Replace Line in a text file
Sub OpenEditSaveCloseTextFile()     Dim fso As Object     Dim fil As Object     Dim txt As Object     Dim str_path As String     Dim str_change As String
    str_path = "e:\test"     Set fso = CreateObject("Scripting.FileSystemObject")     MsgBox ("Starting Replacement")     For Each fil In fso.GetFolder(str_path).Files         'If fil.Type = "Text Document" Then             Set txt = fil.OpenAsTextStream(1)             str_change = txt.ReadAll             txt.Close             str_change = Replace(str_change, "FIND_WHAT", "REPLACE_WITH", , , vbTextCompare)             With fil.OpenAsTextStream(2)                 .Write str_change                 .Close             End With         'End If     Next fil     MsgBox ("Replacement Completed") End Sub
#Remove beginning “-“ from the cell content
Sub Test() For Each cell In ActiveSheet.UsedRange On Error Resume Next     If Left(cell.Formula, 2) = "=-" The…

ROOT ARC S [4.1.B.0.587] eRoot v1.3.4

There is method for ROOT your Xperia ARC S in few steps with eRoot

1. First download and extract DooMLoRD ADB drivers

2. From DIR /Files execute file ADB.exe and wait to install 

Without this drivers your SE xperia ARC S was not been recognized...

3. Connect your Xperia ARC S with USB cable 
In your Xperia ARC S must be checked installation from UNKNOWN SOURCES and USB DEBUGGING, also phone must be in state MSC MODE

SETTINGS>XPERIA>CONNECTIVITY>USB CONNECTION MODE>MSC MODE

SETTINGS>SECURITY>UNKNOWN SOURCES

SETTINGS>DEVELOPER OPTIONS>USB DEBUGGING

Dont allow PC Companion to be installed on your PC at this step, however install PC companion in the beginning to install ADB drivers for your mobile if you not done already.

4. Download and start eRoot v1.3.4

5. Press -root and wait to process be compete.

For confirmation of succeeded ROOT-ing Super User app has been installed

How To Unlock Bootloaders on your Xperia Arc S

UPDATE: Before you proceed, please visit this link to check if your phone’s boot loader can be unlocked or not? NOTE: If the light above the USB port on your phone doesn’t turn blue when you connect your phone using the USB cable to your PC while holding the “MENU” button (on Xperia Arc. For Xperia Play – “SEARCH” button), then it means that you cannot connect to fastboot, and hence you cannot unlock the boot loader. Here’s a Step by Step guide (w/ video) on how to unlock bootloaders on your Xperia Arc, Play, Neo & Pro. [info]Although this guide is made using Xperia arc, I can assure that it would work perfectly with Xperia Play, Neo & Pro too. NOTE: Xperia Play users should press the “Search” button instead of “Menu” button in Step 8th of this tutorial.[/info] [warning]The methods and procedures discussed here are considered risky and you should not attempt if you don’t know completely what it is. If any damage occurs to you or your device, we won’t be held liable. You only wil…

Inherited Colour Vision Deficiency

Image
Red/green colour blindness is a common hereditary condition which means it is usually passed down from your parents. Colour blindness is usually passed from mother to son on the 23rd chromosome, which is the sex chromosome. Chromosomes are structures which contain genes – these contain the instructions for the development of cells, tissues and organs. If you are colour blind it means the instructions for the development of your cone cells are wrong and the cone cells might be missing, or less sensitive to light or it may be that the pathway from your cone cells to your brain has not developed correctly. The X chromosome is the sex chromosome: males have an X chromosome and a Y chromosome and females have two X chromosomes. For a male to be colour blind the faulty colour blindness gene only has to appear on his X chromosome. For a female to be colour blind it must be present on both of her X chromosomes. This is why red/green colour blindness is far more common in men than women. Blue c…