Bulk import of csv, text file data into MS SQLServer 2012

Hi friends,

Today we have done bulk import of data using csv/txt format into MS SQLServer 2012.

Procedure

1. Right click on your database and select “Tasks -> Import Data”
2. Click the “Next>” button
3. For the Data Source, select “Flat File Source”.
4. Browse and select the CSV/TXT file
5. For the Destination, select the correct database provider (e.g. for SQL Server 2012, you can use SQL Server Native Client 11.0).  Enter the Server name; check Use SQL Server Authentication, enter the User name, Password, and Database before clicking on the Next > button. 
6. Change the options like delimiter, carriage return(new line), First row as header
7. Spend some time configuring how you want the data to be imported before clicking on the Next > button.
8. Change the table name
9. Change the columns datatype
10. Preview your table
11. On the Select Source Tables and Views window, you can Edit Mappings before clicking on the Next > button
12. Check Run immediately and click on the Next > button. 
13. Click on the "Finish" button to run the package
14. You data with the table will be selected

Enjoy the simple and useful bulk data import.

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

Blogger Labels: Bulk,text,data,SQLServer,Procedure,database,Tasks,Import,Click,Source,Flat,File,Browse,Change,options,carriage,header,Spend,columns,Preview,Finish,Enjoy

Windows: Copy all file names in a folder

Hi friends,

I’ve got a requirement like, I want to copy all the file names from a folder in Windows.

After searching from Google, I’ve got one of the quick solution which is being described below

Procedure:

Navigate to the folder where you want to copy all the file name in “Windows Explorer”

Select all the files (Key Board (KB) Shortcut: Ctrl + a)

Press and hold the “Shift” key on your keyboard

Right click your mouse by pointing to any one of the selected file

From the context menu, select the option “Copy as path”

Now, open “Notepad”

Paste the content (KB Shortcut: Ctrl + v)

Now, you will be able to see all the file name with full path

You can remove the folder path, if you don’t want the full path

Enjoy guys

Send your comments and feedback to psrdotcom@gmail.com

Blogger Labels: Windows,Copy,folder,requirement,Google,solution,Procedure,Navigate,Explorer,Select,Board,Shortcut,Ctrl,Shift,From,context,menu,option,path,Notepad,Paste,Enjoy,Send,feedback

Android Application Upload to Google Play Store Minimum Requirements

Hi Friends,
Today, I have prepared a simple document which required once your signed application is ready (.apk file)

Pre-requisites

Google Play Developer Console account

Procedure

• Login with your credentials to https://play.google.com/apps/publish/
• Click on "Add new application"

The following sections will explain the procedure of requirements

APK

In this section, you can upload the .apk for testing and production
We will have following tabs/sections for the following
1)   Production
2)   Beta Testing
3)   Alpha Testing 

Note:
For Beta and Alpha testing, tester e-mail ids shall be given to access the app)

• Click on “Upload new APK” to upload the .apk file

Store Listing

App Info

1)   Title (max 30 characters)
2)   Short description (max 80 characters)
3)   Full description (max 4000 characters)

Graphic Assets for Android App Upload

1. Screenshots
• Default – English (United States) – en-US
• JPEG or 24-bit PNG (no alpha). Min length for any side: 320px. Max length for any side: 3840px.
• At least 2 screenshots are required overall. Max 8 screenshots per type. Drag to reorder or to move between types.
2. Hi-res icon 
• Default – English (United States) – en-US
• 512 px x 512 px 32-bit PNG (with alpha)
3. Feature Graphic 
• Default – English (United States) – en-US
• 1024 w x 500 h JPG or 24-bit PNG (no alpha)

Categorization

1)   Application type
2)   Category
3)   Content rating

Contact Details

1)   Website (Optional)
2)   Email

Privacy Policy

If you wish to provide a privacy policy URL for this application, please enter the privacy policy URL in the specified text box.

Note:
If we don’t have the privacy policy currently, we can skip by selecting “ Not submitting a privacy policy URL at this time” option.

Services and APIs

Licensing and In-app billing

Licensing allows you to prevent unauthorized distribution of your app. It can also be used to verify in-app billing purchases. Learn more about licensing.

Your license key for this application

We will be able to see a Base64-encoded RSA public key to include in your binary. Please remove any spaces. Add it to the, licensing source code of your program for verification with Google Play Store.

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

Reverse Engineering .apk file (or) Getting Java source code from .apk by extracting

Hi friends,

Today we are going to see how the .apk can be reverse engineered to see the original source code

Procedure

1. Get the .apk file (Here I'm taking example apk called psr.apk)
2. Rename the extention from psr.apk to psr.zip file
3. Extract the psr.zip file
4. It will create folder named "psr" and contents will be inside that
5. Download the tool "dex2jar" from the official link
• https://dex2jar.googlecode.com/files/dex2jar-0.0.9.15.zip
6. Extract the downloaded "dex2jar" zip
7. Navigate to the "dex2jar" extracted directory
8. Execute the following command
• ./d2j-dex2jar.sh psr/classes.dex
9. Now it will generate classes-dex2jar.jar file
10. Extract the jar file, it will create "classes-dex2jar" folder
11. Now, open you "intelliJ IDEA"
• Install "Java Decompiler IntelliJ Plugin" in "intelliJ IDEA"
• In IDE, click "File->Open"
• Select the "classes-dex2jar" folder path
12. Now, click on any of the .class file, then you should be able to see the original java source code of it

Isn't it awesome guys :)

Keep enjoying the coding :)

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

Android Screencast Configuration Install in Ubuntu

Hi all,

Today, I am going to show you how to show the android screen on your Ubuntu.

Procedure

• Download the androidscreencast from the official link
• http://androidscreencast.googlecode.com/svn/trunk/AndroidScreencast/dist/androidscreencast.jnlp
• Just by running the jnlp, you won't be able to see the screen
• Java has security restictions
• Now we have to manually add Android screencast url to be allowed in Java Security in Ubuntu
• Go to jre folder
• Example: /usr/lib/jvm/oracle-(8/7)-java/jre/bin/
• Run the following command
• $ ./ControlPanel
• Select "Security Tab"
• Click on "Add" button
• Enter the following http address
• http://androidscreencast.googlecode.com

References

https://code.google.com/p/androidscreencast

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

Android insufficient permissions for device

Hi Friends,

I was having an issue when connected my friend's Micromax Doodle to my Ubuntu with the following error
"insufficient permissions for device"

Resolution

1. Open Terminal
2. Kill the server by typing the following command
• $ adb kill-server
3. Now, start the server
• $ adb start-server
4. On your device, a pop-up might come asking for granting the permission
5. Click on "Yes" for approving the access
6. Now, check your device status with the following command
• adb devices
7. With the above command, you should be able to see devive IMEI and device name

Enjoy the Ubuntu and Android combination :)

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