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

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

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

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