|
|
Daly City : itil devops
- Кабринский Эдуард |
|
Отправлено: 2021-05-13 23:48 FairfieldBupe (Отправить почту)
|
<b>Кабринский Эдуард - Vsts query - Рдуард Кабринский
<h1>Vsts query</h1>
<p><youtube></p>
Vsts query <a href="http://remmont.com">News highlights</a> Vsts query
<h1>Work with VSTS (or TFS) Work Items from Excel without installing Team Explorer</h1>
<p style="clear: both"><img src="https://blog.brianrandell.com/content/images/size/w100/2020/07/BrianRandell-Small-Head.png" /></p>
<h2>Brian A. Randell</h2>
<p>Husband. Dad of 2. Son. Brother. Developer. ALM/DevOps Consultant. MSFT MVP. Writer. Love fast cars & hard rocking music. ///M Power. Love cuddles with my kids.</p>
<p>More posts by Brian A. Randell.</p>
<p style="clear: both"><img src="https://blog.brianrandell.com/content/images/size/w100/2020/07/BrianRandell-Small-Head.png" />
</ul></p>
<h4>Brian A. Randell</h4>
<p style="clear: both"><img src="https://blog.brianrandell.com/content/images/size/w2000/2017/08/bulk-modify-excel-blank-list.png" /></p>
<p><strong>TLDR; If you just want the step-by-step on how to work with Excel and work items <em>without</em> installing Team Explorer, jump down to the Non-Developer's Short Guide to Using Excel with TFS/VSTS Work Items on this page.</strong></p>
<p>For years, if you wanted to work with Team Foundation Server (TFS) Work Items from Excel, you had to install the Team Explorer package which basically gave you the Visual Studio Shell plus the extra bits to integrate with Office. However, starting with the 2015 release of TFS, Microsoft starting providing an installer package with just the bits you need to make Excel (and God forbid Microsoft Project) work with TFS or VSTS.</p>
<p><strong>That said, do you still need Excel integration?</strong></p>
<p>The web interface in TFS and Visual Studio Team Services (VSTS) has become rather amazing, so you won't often need to use Excel. For example, if you wanted to change a common field on multiple work items, you can select them in the UI (say a few Tasks on the Sprint Backlog, and select <strong>Edit</strong>:</p>
<p style="clear: both"><img src="https://blog.brianrandell.com/content/images/2017/08/BulkEditviaWebUI.png" /></p>
<p>This will open the <strong>Edit work items</strong> dialog where you can modify multiple fields at the same time as well as add <strong>Notes for History</strong>.</p>
<p style="clear: both"><img src="https://blog.brianrandell.com/content/images/2017/08/EditWorkItems-Web.png" /></p>
<p>However, Excel provides two nice advantages.</p>
<p><ol>
<li>You can work offline. By pulling down a group of work items, you can work when you don't have Internet access to your TFS server or VSTS.</li>
<li>Excel can be faster when you're editing and making changes to lots of fields or copying in data from another source.</li>
</ol>
</p>
<p><em>In those cases, it makes sense to use Excel.</em></p>
<p>For developers who install Visual Studio, you're good to go. However, often there are non-developers on your team who need to work with lots of work items. For them it's easy to get the Excel features <em>without</em> installing Team Explorer or Visual Studio.</p>
<p>The basic steps are:</p>
<p>Install Office 2007 or later <strong>on Windows</strong> (Sorry no support macOS versions)</p>
<p>Download and install the Team Foundation Server OfficeВ® Integration 2017</p>
<p>Connect to our TFS instance or VSTS account</p>
<p>To download and install the <strong>Team Foundation Server Office Integration 2017</strong>, head over to the Visual Studio Downloads page and scroll down to the section labeled <strong>Team Foundation Server 2017 Update 2</strong>. You'll find both a <em>Web Installer</em> and an <em>ISO</em> download.</p>
<p style="clear: both"><img src="https://blog.brianrandell.com/content/images/2017/08/DownloadOfficeIntegration.png" /></p>
<p>The Web Installer is great if you have good Internet where as the ISO file is great when you have multiple machines or bandwidth is at a premium and you only want to pay the download cost once.</p>
<p>Once you've got enough of the installer downloaded or you've mounted the ISO, run it and you'll get a simple install screen. You'll need to have local Administrator rights to install. Click <strong>Install</strong>, accept the UAC prompt and it will take a few moments depending on the speed of your computer and whetehr or not you downloaded the whole package.</p>
<p style="clear: both"><img src="https://blog.brianrandell.com/content/images/2017/08/OfficeIntegrationSplash.png" /></p>
<p>Once you've installed the package, start Excel, and you should see a <strong>Team</strong> tab on the Ribbon.</p>
<p style="clear: both"><img src="https://blog.brianrandell.com/content/images/2017/08/TeamTabExcel2016.png" /></p>
<p>On the Team tab, choose the <strong>New List</strong> command and the <strong>Connect to Team Foundation Server</strong> dialog will open. Use it to connect to your Team Project.</p>
<p style="clear: both"><img src="https://blog.brianrandell.com/content/images/2017/08/ConnecToTfsDialog.png" /></p>
<p>Once you're connected, you will see the <strong>New List</strong> dialog, where you can choose an existing <em>Work Item Query</em> or create a new <em>Input List</em>.</p>
<h2>Vsts query</h2>
<h3>Vsts query</h3>
<p><youtube></p>
Vsts query <a href="http://remmont.com">Headlines today</a> Vsts query
<h4>Vsts query</h4>
Work with VSTS (or TFS) Work Items from Excel without installing Team Explorer Brian A. Randell Husband. Dad of 2. Son. Brother. Developer. ALM/DevOps Consultant. MSFT MVP. Writer. Love
<h5>Vsts query</h5>
Vsts query <a href="http://remmont.com">Vsts query</a> Vsts query
SOURCE: <h6>Vsts query</h6> <a href="https://dev-ops.engineer/">Vsts query</a> Vsts query
#tags#<replace> -,-Vsts query] Vsts query#tags#</b>
<b>Эдуард Кабринский</b>
<a href=http://remmont.com>headline news</a>
Имя: FairfieldBupe
|
|
Ответы и Комментарии на сообщение "Daly City : itil devops
- Кабринский Эдуард": |
|
Ответов нет
|
|
|
|
|
|
