Category Archives: Tips & tricks

software Tips & tricks Utils

Bulk Rename Utility

Bulk Rename Utility is an easy to use file rename program (a.k.a. file renamer). Renaming multiple files has never been easier! It has a small memory footprint so it can be left running all the time without consuming all your memory. It started as a freeware Visual Basic tool, but as its popularity has grown it has been completely rewritten in C++ to be robust and lightweight – and very, very fast! It can easily handle folders/discs containing well over 100,000 entries… and it can batch rename 1,000s of files in seconds.

The software is freeware and gets downloaded very frequently. It has a large base of regular users. Most of the features have originated from other users’ suggestions. As such, it is continually being enhanced and improved.

As well as being “recommended” by a number of web sites, Bulk Rename Utility has also appeared on many magazine cover-discs, from Brazil to Sweden.

If you have a suggestion for a new feature, get in touch and it could appear in a future release of the software!

http://www.bulkrenameutility.co.uk/Download.php

Tips & tricks Tutorials

Break lines at specific character in Notepad ++

  1. In Notepad++, click Search > Find.
  2. Click the Replace tab.
  3. Under the Search Mode group, select Regular expression.
  4. In the Find what text field, type ],\s*
  5. In the Replace with text field, type ],\n
  6. Click Replace All.

read more »

Tips & tricks wordpress

WordPress Pretty Permalinks on IIS 7.0

Just create a web.config  in wordpress root dir:


<?xml version="1.0"?>

<configuration>

    <system.webServer>
        <rewrite>
            <rules>
                <rule name="Main Rule" stopProcessing="true">
                    <match url=".*" />
                    <conditions logicalGrouping="MatchAll">
                        <add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" />
                        <add input="{REQUEST_FILENAME}" matchType="IsDirectory" negate="true" />
                    </conditions>
                    <action type="Rewrite" url="index.php" />
                </rule>
            </rules>
        </rewrite>
     </system.webServer>
</configuration>

Read more:

WordPress Pretty Permalinks on IIS 7.0


http://codex.wordpress.org/Using_Permalinks

Backup MySQL Security SQL Tips & tricks Tutorials web services Windows server

Schedule Mysql Backups to Amazon S3 in Windows server 2008 R2

1 – Access Amazon Services, S3
2 – Create a New Bucket if there’s no one.
3 – Create credentials in  IAM Amazon Services
4 – Download the tool s3.exe for windows, from s3.codeplex.com

read more »

Microsoft Tips & tricks Windows 8

How to close Apps in Windows 8

There are 4 ways you can close metro apps in the new Windows 8:

  1. If you have a touch screen tablet or laptop, touch your finger on the top of the screen and drag it all the way to the bottom. It will minimize and move the app from your way.
  2. If you don’t have a touch screen but you use a mouse, do the same with the mouse. Point your mouse on the top of the screen and drag it all the way down. When you point the mouse to the top of the screen, you can see the cursor is changing.
  3. Press ALT key + F4. This will still work just like the traditional Windows programs.
  4. The killer option: use ALT+CTRL+DEL and kill the app using the task manager.

 

Microsoft Tips & tricks Windows 8

Windows 8 Activation Error: DNS name does not exist Error Code: 0x8007232B

Depending on where the installation media was obtained from (MSDN, TechNet subscription download,..) the activation wizard  by default will look for a Key Management Service (KMS) host on your internal network. It will not try to activate using the internet to reach Microsoft Activation servers.

The solution is to manually change the product key to a Multiple Activation Key (MAK) most likely provided with your MSDN or TechNet subscription.

To change the product key, use the slmgr.vbs script included with your Windows installation.

  1. Run the command prompt as an administrator
  2. Enter slmgr -ipk xxxxx-xxxxx-xxxxx-xxxxx-xxxxx where xxxxx-xxxxx-xxxxx-xxxxx-xxxxx is your product key.
Tips & tricks

Excel – How to make first character Uppercase, the rest lowercase?

make a quick test file
see what this is going to do. if its what you want, then try it in your original

– Right Click on your sheet1 tab and choose View code (or just hit Alt F11)
– cut and paste this


Sub SentenceCase()
 For Each cell In Selection.Cells
 s = cell.Value
 Start = True
 For i = 1 To Len(s)
 ch = Mid(s, i, 1)
 Select Case ch
 Case "."
 Start = True
 Case "?"
 Start = True
 Case "a" To "z"
 If Start Then ch = UCase(ch): Start = False
 Case "A" To "Z"
 If Start Then Start = False Else ch = LCase(ch)
 End Select
 Mid(s, i, 1) = ch
 Next
 cell.Value = s
 Next
 End Sub

– then highlight your column (or whatever you want to change)
– then run the macro
– click tools
– click macro
– choose sentance case and run

Code Snippets .NET Tips & tricks

Code Translation for .NET (C#<->VB.NET)

This service will translate the code for you, just start typing the code or upload a file to convert it.
For now it only supports from VB.NET to C# and from C# to VB.NET.
To use it you can either:

  1. Start typing your code.
  2. Copy and Paste the code in the Code Text Box.
  3. Translate an entire file using the file upload.

Disclaimer: No copy is done whatsoever of the code that you either type, or upload for translation. Everything is processed in the server in memory and returned immediately to the browser.
If you want to give feedback on the translation, please send me an email including the code you used and the desired translation to me@carlosag.net.

http://www.carlosag.net/Tools/CodeTranslator/

see also:

http://www.developerfusion.com/tools/convert/csharp-to-vb/

Tips & tricks Tutorials

What is a PAD file?

PAD stands for Portable Application Description, and a PAD file is a clear and easy way for software authors to provide online sources with information about their products. The advantage of using a PAD file is that it enables you to store all the descriptions and specifications in one single place – system requirements, price, contact info, file names, download URL’s and more.

Another great thing about PAD files is that they’re so easy to create – and that it doesn’t cost you anything! The Association of Shareware Professionals have put together a range of totally free tools that allow you to create and modify your PAD files. Here at SoftwarePromotions, we have also created our own PAD file tools to make life easier for software authors – check out our guide to using PADGen and our PAD validation tool.

Once you have created your PAD file, you should put it in two different places. First in your ZIP file, so that the people who distribute your software can access all the information that they might need. Second, you also want to put your PAD file on your own website, since this is what many of the download sites will ask you for.

Since June 2001, SoftwarePromotions has been working exclusively with PAD files. This is because the PAD format allows us to get your software listed on as many sites as possible, in the shortest amount of time.

source info: http://www.softwarepromotions.com/glossary/pad_file.asp

Code Snippets Tips & tricks Utils

Using Character Encoding in ASP.NET

Open the file named web.config in the ASP.NET project. The value of requestEncoding attribute in globalization element is “utf-8”. It means the requested texts were encoded as UTF-8 character set. Because SCO5.05 does not support UTF-8, therefore the requested texts where changed.

VB:

Public Shared Function unicode_iso8859(ByVal src As String) As String
Dim iso As Encoding = Encoding.GetEncoding(“iso8859-1”)
Dim unicode As Encoding = Encoding.UTF8
Dim unicodeBytes As Byte() = unicode.GetBytes(src)
Return iso.GetString(unicodeBytes)
End Function

Public Shared Function iso8859_unicode(ByVal src As String) As String
Dim iso As Encoding = Encoding.GetEncoding(“iso8859-1”)
Dim unicode As Encoding = Encoding.UTF8
Dim isoBytes As Byte() = iso.GetBytes(src)
Return unicode.GetString(isoBytes)
End Function

label1.Text = iso8859_unicode(MyString)

more details in http://www.codeproject.com/KB/aspnet/Encoding_in_ASPNET.aspx