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

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

Solved the problem of import project in eclipse

Hi users,

I had been facing this issue for sometime. I didn't concentrate much on this issue. Today finally it got solved.

Problem:
Unable to import projects into eclipse

Solution:

• Remove any projects from the workspace with the same name (Cut and Paste in some folder as backup)
• Check whether you have android-8 (min) in your project properties target platform

Note: You can view the existing projects (closed projects also) in your eclipse by clicking on package explorer

Remove the unused projects, name conflict projects.
Please restart the eclipse (File->Restart)
Now, you will be able to import your projects into eclipse.

Note: Please write your comments (or) mail to psrdotcom@gmail.com