Convert PEM to PFX/PKCS12(.p12) using OpenSSL

 Hi folks,

To keep it simple with a single command to convert the .PEM format file to .p12/.pfx we can use the below information.

$ openssl pkcs12 -export -in domain.pem -out domain.p12

It will ask you to enter the export password (twice for confirmation).

It's up to you to choose to enter the password or keep it empty (just press enter) based on the use case what you have.

Hope this helps you to convert the certificate format and use in your application or server.

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

Microsoft Azure DevOps Boards move or copy tasks between projects

 Hi all,

Today we will go through the different ways to organize the work items in Microsoft Azure DevOps Boards.

Pre-requisites

User should have appropriate permissions in both the projects.

Moving the work items between projects

• Select the required items from Boards -> Work items
• Select the more options icon (...) from any one of the selected work item
• Choose "Open selected items in Queries" options
• 
• Queries page navigation will happen
• Select all the items from query results (Ctrl+A)
• Select the more options icon (...) from any one of the selected work item
• Choose "Move to team project" options
• 
• 
  
• Move work item dialog opens up
• 
• 
  
• Choose appropriate options and click Ok.
• All the items would be listed in moved project queries window.
• Click on "Save items" option.

Copy work items between projects

Export work items

• Select the required work items
• Select the more options icon (...) from any one of the selected work item
• Choose "Open selected items in Queries" options
• 
• Queries page navigation will happen
• Select all the items from query results (Ctrl+A)
• Export the work items to CSV file
• 

Import the work items

• Navigate to the required project boards section where the work items has to be created
• Click on "Import work items" option
• 
• 
  
• Queries page navigation will happen
• 
• 
  
• Choose the exported CSV file and click on "Import" button
• The work items would be listed in queries section
• Click on "Save items"
• Navigate to "Work items" section to view the added work items.

Request you send your comments and feedback below or send mail : psrdotcom@gmail.com

Markdown file convert/export to html, png, jpeg, pdf with images

Hi folks,

Today I will share about, how we can include the images in markdown file and export to pdf, html, png and jpeg formats.

You can do this with 2 Visual Studio Code extensions

Pre-requisites

Visual Studio Code with following MarkDown Extensions

1. To place images
• VS Marketplace Link: https://marketplace.visualstudio.com/items?itemName=yzhang.markdown-all-in-one
2. To convert the markdown to pdf, html, png and jpeg formats
• VS Marketplace Link: https://marketplace.visualstudio.com/items?itemName=yzane.markdown-pdf

Install the above 2 Visual Studio Code extensions.

Insert an image

Create images folder and keep all your images (Optional, but easy to maintain)

Syntax: 

Usages: 

By now, your image is part of your file.

Preview your file

Open Command Palette (View -> Command Palette OR Type F1 OR Ctrl+Shift+p)

Type "Markdown: Open Preview" OR Ctrl+Shift+v keyboard shotcut

Export Markdown

Open Command Palette (View -> Command Palette OR Type F1 OR Ctrl+Shift+p)

Type export and select below

• markdown-pdf: Export (pdf)
• markdown-pdf: Export (html)
• markdown-pdf: Export (png)
• markdown-pdf: Export (jpeg)
• markdown-pdf: Export (all: pdf, html, png, jpeg)

Change Markdown conversion settings

1. Select File > Preferences > UserSettings or Workspace Settings
2. Find markdown-pdf settings in the Default Settings
3. Copy markdown-pdf.* settings
4. Paste to the settings.json, and change the value

Hope this blog is useful to insert images in your markdown file and export to supported formats.

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

Take Nokia Phone Contacts (Phonebook) backup in Excel Spreadsheet or .csv file by using OVI PC Connectivity

Hi friends,

Today I have come up with phonebook backup in Nokia. I previously used very old nokia model which doesn't contain the Nokia PC/Ovi Suite connectivity. So, I used to take backup of my contacts in excel sheet by doing data entry. But now most of phones does have the facility to connect to Nokia Ovi/PC Suite to take the backup and maintain their data in Computer(PC).

Here, I have taken backup of my contacts in PC and converted that to Excel sheet to quick access of my contacts.

Pre-Requisites:

1. Make sure that, your phone does support Mobile to PC connectivity via Nokia Ovi/PC Suite
2. Download and install Nokia Ovi/PC Suite
3. Make sure that, you have the PC connectivity cable to the corresponding mobile
4. Make sure that, all your contacts are on device(mobile) memory instead of SIM

• Note: Copy all the SIM contacts to device(mobile)

Procedure:

• Connect your mobile to PC
• Select "Nokia Ovi PC Suite" connection from your mobile
• After successful connection, you will get the similar screen like below

• Select "Contacts" from the image icons on top of the window
• Now, all your contacts will be displayed on the 2nd pane(column) in the Window as shown below

• Select all the contacts (Note: First select any one of contact and do the any one of the below)
• Option 1: Use Keyboard shortcut Control + A
• Option 2: Right click on the contact and choose "Select All" option
• Option 3: Select "Edit" menu and choose "Select All" option
• Now, you can "Drag and Drop" the selected contacts to PC contacts  
• Hint: Drag and drop the content to "Contacts" (Red Circle)

By now, you have successfully taken the backup of your contacts to PC

View/Save the contacts in Spreadsheet/.csv file

• Download the file GrabMyContacts from this link 
• Install it in any folder
• Run the "grabmycontacts.exe", you will get the following screen

• Default "Step 1 - Search for your contacts file" tab will be selected
• Click the "Search for it" button, it will automatically searches your Nokia Ovi contacts database file as shown below

• Click on "Yes"
• Now, choose the "Step 2 - Choose and display your data" tab
• Click on "Push this button to display your contacts"
• Now, it will display all your contacts in the sheet
• Finally, Choose "Step 3 - Export to Excel" tab
• Click on "Finished ! Now Export to Excel !" button
• It will show, your file named "myovicontacts.xml" has been saved on desktop

• Click on "Yes"

• Then, it will ask you to open the file Excel, as shown in the below screen

• Click on "Yes"

• If the default program for the xml is not Excel then it will open with the default program. 
• Open the XML file in Excel:
• To see your contacts in excel, open the new Excel workbook and "Drag and Drop" the "myovicontacts.xml" in it
• Remove the unnecessary columns and save your contacts as "Excel Workbook"/".csv" file format