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

Add custom user/system attributes in Active Directory

Hi folks,

Today I'll explain the procedure to add and verify the custom user attributes in Active Directory.

Mount the Directory Schema

1. Open Command Prompt in Administrator mode
• Start -> cmd -> Right click and select "Run as Administrator"
2. Mount the directory schema command
• cmd> regsvr32 schmmgmt.dll
3. You will be notified with command success pop-up
• Click on Ok

Creating Custom Attribute

• Open mmc (Management Console)
• Click on "File" menu and select "Add/Remove Snap in.."
• From "Available snap-ins" section, click "Active Directory Schema"
• Click on "Add"

• "Active Directory Schema" should be added to "Selected snap-ins" section and click "Ok"
• You will be viewing the "Active Directory Schema" in the console
• Expand and select "Attributes"
• Right click and choose "New" and select "Attribute" as shown below

• A warning pop-up shows, click Continue

• Create New Attribute pop-up opens up
• Enter the custom attribute details
• Enter the Object ID as per Reference 1

• Select the Syntax from the list

• Check Multi-Valued option based on your requirement
• Click Ok

Adding to User Class

• Newly created custom attribute has to be mapped to any one of the class (Computer, user etc)
• To add it to user
• (Classes -> User -> Properties -> "Add")
• Select the custom attribute

Restarting ADDS (Active Directory Domain Service)

• Open Services
• Start -> Run -> services.msc
• Navigate to Active Directory Domain Service
• Restart the service

Verification

• Open "Active Directory Users and Computers"
• Go to "Users"
• Click on any user and view properties
• Click on "Attribute Editor" tab
• Navigate to your custom tab

References

1. https://social.technet.microsoft.com/wiki/contents/articles/20319.how-to-create-a-custom-attribute-in-active-directory.aspx
2. https://www.youtube.com/watch?v=__92mHwyZ3Q

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

Display Flash SWF Object File in Max Width and Height of Browser (Autofit)

Hi coders,

Today I have come across a situation where I need to display some .swf file in browser by using 100% browser width and height irrespective of the screen resolution. Generally we will specify the object width and height while display the flash on browser.

But I want the flash content to get display in maximum (full) width and height of the browser to any screen resolution. i.e. Automatically it has to adjust the width and height of the flash object.

I have found the following method

• Please download the swffit from here 
• It has lot of custome functions which developers can use
• After downloading the zip file, please extract the content
• You can find lot of sample codes
• I have used example.html code and changed the fit method to 
• swffit.fit("my_flash", 1, 1, null, null, true, true);
• Now it will display the flash object in maximum width and height of the browser

Enjoy coding :)

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