Online classes video recording, screen sharing and screen recording software

Hi friends,

Here are the list of online classes video recording and screen sharing apps that can help you

1. VSee
2. Record your Skype Calls with these tools
3. 14 day trail, Go To Meeting
4. Apache Open Meetings

If you want to have just the screen recordings of your session from your end. You can use the following

1. ScreenRecordings
2. Microsoft Powerpoint recording of your slides
3. Camtasia
4. Screenflow

Please send your feedback and comments to psrdotcom@gmail.com

Compress folders/files and create .tar.gz (Tar archive with GunZip Compression) and .zip (ZIP compression) file in Java

Hi friends,

Today I will explain how easily we can compress files and folders in java.

I have used a third part library which so simple to use.

Download the .jar from the following URL
https://rauschig.org/jarchivelib/download.html

Now, create a java class and create .tar.gz and .zip files.

Sample source code

package gunziptest;

import java.io.File;
import java.io.IOException;
import java.util.logging.Level;
import java.util.logging.Logger;
import org.rauschig.jarchivelib.ArchiveFormat;
import org.rauschig.jarchivelib.Archiver;
import org.rauschig.jarchivelib.ArchiverFactory;
import org.rauschig.jarchivelib.CompressionType;

/**
 *
 * @author psrdotcom
 */
public class GunZipTest {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        // Archive file name
        String archiveName = "archive";
        // test is destination folder
        File destination = new File("test");
        // source folder has files and sub-folders
        File archive = null;
        
        // zip compression
        Archiver archiver = ArchiverFactory.createArchiver(ArchiveFormat.ZIP);
        try {
            archive = archiver.create(archiveName, destination, source);
            if(archive != null && archive.isFile()) {
                System.out.println("gunziptest.GunZipTest.main()" + "zip file created");
            }
        } catch (IOException ex) {
            Logger.getLogger(GunZipTest.class.getName()).log(Level.SEVERE, null, ex);
        }

        // tar.gz compression
        archiver = ArchiverFactory.createArchiver(ArchiveFormat.TAR, CompressionType.GZIP);
        try {
            archive = archiver.create(archiveName, destination, source);
            if(archive != null && archive.isFile()) {
                System.out.println("gunziptest.GunZipTest.main()" + "zip file created");
            }
        } catch (IOException ex) {
            Logger.getLogger(GunZipTest.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
}

Hope, you will find this useful.

Please send your review and feedback to psrdotcom@gmail.com

Prevent from WannaCry Ransome attack by disabling SMB protocol on Windows 10

Hi friends,

I want to share my knowledge on disabling SMB protocol on Windows 10.

Procedure

1. Click on Start Menu
2. Type "Turn Windows Features On or Off"
3. Uncheck the "SMB 1.0/CIFS File Sharing Support" as shown below
4. 
5. Click on "OK"
6. It will take some time to apply the changes
7. You will be prompted with "Restart"
8. Save your any unsaved work and restart the machine
9. This is disable the SMB protocol, which is main reason to spread the WannaCry Ransome Attack

Please send your review and feedback to psrdotcom@gmail.com

Eclipse reset/enable workspace preference on startup

Hi all,

Today, I have come across a situation where I want to choose the one of the workspaces i have worked before.

In general, eclipse will prompt for workspace location on startup
But, if you have checked "Consider this as default workspace and don't ask again" option, then next time when you start eclipse, you won't get the prompt for workspace selection.

Re-enable/Reset workspace preference on eclipse startup

1. Click on eclipse "Window->Preferences"
2. Go to "General->Startup/Shutdown->Workspaces"
3. Check "Prompt for workspace on startup" or use keyboard shortcut "Alt+w" 
4. 
5. Now, exit the eclipse
6. Start the eclipse

You should be able to see the workspace selection on eclipse startup screen.

Happy coding!!

Please send your comments and feedback to psrdotcom@gmail.com

Windows: Find which port is getting used/mapped by which process/program with details from task manager

Hi friends,

Today, I have come across with a situation of finding the port-program mapping.

Procedure

• Open command prompt
• Enter the following command
• Syntax: netstat -aon | find ":"
• Example: netstat -aon | find ":80"
• Get the PID (Process Id) from the list

• Execute the following command
• Syntax: tasklist "PID eq "
• Example: tasklist "PID eq 9192"

Please send your queries and feedback to psrdotcom@gmail.com

Windows Oracle startup issue

Hi friends,

When your Oracle is unable to connect, do the following procedure

Open command prompt
Connect as sysdba
cmd> sqlplus "/ as sysdba"
sql> startup
Once the command executed successfully, then you should be able to login to Oracle

Please send your comments and feedback to psrdotcom@gmail.com

Capture localhost (127.0.0.1) system packets using RawCap

Hi friends,

Today I am going to share the knowledge of capturing network packets in local system i.e. localhost.

Using RawCap utility, you can capture the loopback adapter packets which are our localhost packets.

Procedure

Download the RawCap.exe from Netresec website url
http://www.netresec.com/?page=RawCap
Once you download it
Open command prompt with administrator privileges
You have the following options while running the RawCap.exe

Syntax

RawCap.exe
-c <-> Stop capturing after the specified packet count reached
-f <-> Flush each packet without buffering
-s <-> Stop capturing after the specified time limit

Example 1:
RawCap.exe 127.0.0.1 dump.pcap
Note: Ctrl + C to stop the capturing

Example 2:
RawCap.exe -c 1000 127.0.0.1 dump.pcap
After 1000 packets, the capturing will stop

Please send your feedback and comments to psrdotcom@gmail.com

Change currency (Rupees and Euros) to English text in Microsoft Excel

Hi Friends,

Today I'll discussing about converting currency (Rupees and Euros) to textual representation which I have found by googling and updated to cover 2 currencies.

Source

The VBA Macro code is available on my public GIST
ConvertCurrencyToEnglish.txt

Usage

• Add this in your excel module using developer options
• Two functions
• ConvertRupeesToEnglish - Which converts numeric data to rupees with pre-pending "Rupees " and appending " Only"
• ConvertEurosToEnglish - Which converts numeric data to rupees with pre-pending "Euros " and appending " Only"
• Note: If number has precisioin, it will add "Paise" and "Cent" to respective currency.

Please send your review and feedback to psrdotcom@gmail.com

Oracel Database: Delete all user objects (Tables, Views, Procedures, Functions, Sequences, Types, Packages)

Hi friends,

I have come across a situation, where I need to delete all the user objects i.e. Tables, Views, Procedures, Functions, Sequences, Types, Packages.

Please find the link below for the SQL script, which does the job for you.

It's my public GitHubGist URL, where anyone can share the code snippets.

https://gist.github.com/psrdotcom/b61f8b401d4992428ecd8fb8225436c4

Advantage:
You can delete the user after deleting all user objects by logging into SYSTEM user.

Please send your review and feedback to psrdotcom@gmail.com

Tomcat issue "windows could not start apache tomcat on local computer" after java update issue with resolution

Hi friends,

Today I have faced an issue with Tomcat service starting. I would like to share with you the resolution as well. Please find the details below.

Root cause

Updated java version

Resolution

• Navigate to you apache installed folder
• Go bin folder
• Double click on "Tomcat(X)w.exe" where X the version of tomcat.
• In my case it is "Tomcat8w.exe" because the version is 8
• 
• Select "Use Default". So that, it uses the JAVA_HOME version by default.
• Click on OK
• Start the Tomcat service and enjoy deploying

Please send your comments and feedback to psrdotcom@gmail.com

Consolidate / Merge all your PF accounts

Hi friends,

Today, I have come across one useful website which consolidates all your PF accounts under one roof.

Pre-requisite

1. You should have one active and current PF account
2. You should have UAN created and activated
3. You should have your old PF account numbers

Important Information

If you have changed organization, then wait till the previous employer update your "Date of Exit (DoE)"
After that your current employer details should be available
To verify that, please login to your UAN services account
https://unifiedportal-mem.epfindia.gov.in/memberinterface/
Go to "View" -> "Service History"
You should be able to see your present and previous employers
Note: You wait for atleast 3 months, after you exit from your previous organization

Procedure

1. Visit http://oeoea.epfoservices.com/UANDEDUP/index.jsp site
2. Enter your registered mobile number
3. Enter your UAN number
4. Enter your current active PF account
5. Once you login, you should be able to view your all registered and linked PF accounts
6. Consolidate all PF accounts by selecting and further processing

Please send your comments and feedback to psrdotcom@gmail.com

Change EOL (End Of Line) Character from Windows to Unix/Linux for all the files in current working directory

Hi all,

For a single file, you can do the change of EOL using notepad++.
Reference: http://psrdotcom.blogspot.in/2017/01/change-eol-end-of-line-character-from.html

But it would be difficult, if you want to do for multiple files in one go.

I have found a solution to update EOL for all files in the current directory.

Pre-requisite

Make sure that, working directory contains only the files which you want to change EOL.

Note: If not, copy the files to a new directory and change the EOL for all the files in that directory.

Procedure

1. Download dos2unix utility from sourceforge https://sourceforge.net/projects/dos2unix/
2. Extract the zip file
3. Tip: Make sure that the extracted path doesn't contain spaces.
4. Keep the bin directory available in your PATH environment variables
5. Download the customized batch file from GIST https://gist.github.com/psrdotcom/d73ff9590c3010253b5b2a886704b26b
6. Extract if needed, and place the "dos2unixfolder.bat" in the same directory where the "dos2unix" is placed.
7. Tip: If you place the batch file in the same folder of dos2unix.exe. You no need to add again the patch of batch file in environment PATH.
8. Navigate to your folder, where you want all the files EOL to be changed
9. Press "Right Click on Mouse" in empty area
10. 
11. Select "Open Command Prompt Here"
12. Type the batch file name "dos2unixfolder.bat"
13. You will able to see the conversion process
14. Once the conversion is completed, you can check the EOL coversion in notepad++.
15. If you need to help in checking, refer to http://psrdotcom.blogspot.in/2017/01/change-eol-end-of-line-character-from.html

Please send your comments and feedback to psrdotcom@gmail.com

Change EOL (End Of Line) Character from Windows to Unix/Linux using Notepad++

Hi all,

Today I will explain about updating/converting EOL for a single file from windows format to unix/linux format.

1. In Windows, the EOL (End-Of-Line) character is \r\n (CR LF) (Carriage Return, Line Feed)
2. In Unix/Linux, the EOL character is \n (LF) (Line Feed)

Check for EOL

If you open the file in notepad++, you will be able to see the EOL character by following below steps:

• Type the content and hit enter button on keyboard
• Choose menu "View -> Show Symbol"
• Check the "Show End of Line" option

• Now, you will be able to view "CR LF" special symbols in you file at every line end as show below

Update EOL

To convert the EOL from Windows (CR LF) to Unix (LF), do the following

• Click on "Edit" menu
• Choose "EOL Conversion"
• Select "Unix(LF)"

• Now, you can check the update EOL character in your file. Example conversion show below

This type of conversion useful, when you are updating file in windows and using the same file in U/Linux environment.

Batch File Update

For all files in one folder, you can follow my blog.
Reference: http://psrdotcom.blogspot.in/2017/01/change-eol-end-of-line-character-from_20.html

Send your comments and feedback to psrdotcom@gmail.com

Asus Zenfone 5 Clear Cache to speed up your phone

Hi all,

Today I will describe about clearing cache in Asus Zenfone 5 to speed up/boost your phone performance.

Pre-requisite:

• Take backup on your internal storage (Ex: Pics, docs, your important info)

• Make sure that, you have enough battery level or keep the phone in charging mode

Procedure:

1. Switch off your phone
2. Wait for 15 seconds
3. Press the power button and volume up button simultaneously until Asus logo appears on your mobile screen
4. 
5. By default, it will show "Normal Boot"
6. 
7. By pressing volume up/down button, you will be able to see the following options
8. Normal Boot, Power Off, Recovery Mode, Restart Bootloader
9. Select "Recovery Mode"
10. 
11. Press power button
12. Phone will automatically reboots
13. You will be able to see "No Command" on screen
14. 
15. Press and hold power button and volume up button simultaneously for 2 seconds and leave it
16. Now, you will be able to a screen with following options
17. reboot system now, apply update from adb, wipe data/factory reset, wipe cache partition, reboot to bootloader, power down, view recovery logs
18. Navigate by clicking volume down button to highlight "wipe cache partition"
19. 
20. Select using power button
21. You will be able to see fomatting cache message
22. 
23. Wait till the format completes
24. Once, it shows the format complete, select "Reboot system now" option

Enjoy the speedy Android flavor now.

Please send your comments and review to psrdotcom@gmail.com