Convert JSON file to CSV with Python

 Hi folks,

Today I will explain the code to implement the Json2CSV conversion.

Make sure you have valid JSON file with an array of objects.

Sample:

"Users":[

{"id": 1, "Name": "Suresh Raju", "Age": 35},

{"id":2, "Name": "PSR", "Age": 34}

]

I have chosen Python language to convert because of inbuilt library support for json and csv and command line execution with Notepad++ as editor.

Source Code Snippet: GitHub Gist

Please send your valuable 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

Pandoc - Easily convery file format from one markup to another markup language

Hi Friends,

Today I come across very useful tool for easily converting/creating different markup languages.

I personally interested in converting/creating HTML, PDF via Latex, MicroSoft Word .docx files

Try Online

To try the conversion online, please click on below link
http://johnmacfarlane.net/pandoc/try
 

Procedure

1. In "from" dropdown, you can select "Markdown" and "to" dropdown, select "HTML5"
2. Type the following content

• % PSR

  PSR Header
  ==========1234
  
  PSR Sub Heading
  ---------------
  sub heading contents

3. Click on "convert" button
4. Now you will be able to see content converted into HTML5 with appropriate tags.

References

http://johnmacfarlane.net/pandoc/

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

Converting Power Point Presentation (PPT) to Images and Conversion of Images to PPT

Hi all,
Today I was searching for converting the slideshow to images and doing some batch processing to the images like crop, resize, filename change and again making ppt with the modified images.

I followed the below procedure to convert my slides in ppt to images, cropping the images and finally making slideshow with edited images.

• Converting slides to images
1. (MS Office 2007) Office Button (Top-Left) -> Save As ->  Other Formats
2. Choose the corresponding destination folder
3. Choose "Save as type" as "JPEG File Interchange Format (*.jpg)"
4. One pop-up comes with the following options
• Every Slide: This option saves every slide to an individual image
• Current Slide: This option saves only the current slide to an image
5. Choose relevant option to you
• Batch Processing the images
1. I have seen one video from youtube and I was impressed with the Irfan View working with batch processing of images
2. Please see the below video and do the batch processing of images
• http://www.youtube.com/watch?feature=player_detailpage&v=Z_eEKD8AJz0
• Uploading images to PPT
1. (MS Office 2007) Click on "Insert" tab and select "Photo Album" -> "New Photo Album"
2. Select the image(s), which you would like to add in the presentation.

This kind of approach makes our lives easy.


If you have any queries, please mail to psrdotcom@gmail.com

xps to pdf conversion

Hi everyone,
There are many ways to convert XPS to PDF conversion.

1. Online site http://www.xps2pdf.org/
• Browse the .xps file and click on "Convert" button.
• It will convert the file to .pdf and gives a link.
• To save the file: Right click on the link and select "Save Linked Content As"
2. By using pdf printer
•  Open the .xps file in either Internet Explorer or XPS Viewer.
• Click on Print and select any pdf printer like Ayumini PDF Converter, novaPDF Converter etc.
• Give the output file name 
3. By using third party softwares
I am googling for trusted third party softwares. If I get I will share with you all

References:
http://www.verypdf.com/artprint/xps-to-pdf.htm
http://www.xpstopdf.com/
Get the xps viewer http://www.microsoft.com/korea/whdc/xps/viewxps.mspx