Visualstudio Online: Kanban basics


Visualstudio Online: “Kanban basics”

kanban

To maximize a team’s ability to consistently deliver high quality software, Kanban emphasize two main practices. The first, visualize the flow of work, requires you to map your team’s workflow stages and configure your Kanban board to match. The second, constrain the amount of work in progress, requires you to set work-in-progress (WIP) limits. You’re then ready to track progress on your Kanban board and monitor key metrics to reduce lead or cycle time.

Your Kanban board turns your backlog into an interactive signboard, providing a visual flow of work. As work progresses from idea to completion, you update the items on the board. Each column represents a work stage, and each card represents a user story (blue cards) or a bug (red cards) at that stage of work.

Sample KANBAN Board

Kanban board, Agile template

User stories and bugs correspond to types of work items. You use work items to share information, assign work to team members, update status, track dependencies, and more.

You open your Kanban board using one of these URLs that connects you to your team project:

Visual Studio Online: http://AccountName/DefaultCollection/TeamProjectName/_backlogs/board/

On-premises Team Foundation Server (TFS): http://ServerName:8080/tfs/DefaultCollection/TeamProjectName/_backlogs/board/

If you don’t have a team project yet, create one in Visual Studio Online or set one up in an on-premises TFS. If you don’t have access to the team project, get invited to the team.

Kanban core practices

What is Kanban?  http://kanbanblog.com/explained/

Having worked through the above four steps, you’re well on your way to implementing most of Kanban’s “six core practices”.

  1. Visualize your workflow. Teams track their work using a Kanban board that maps to how they work. Teams discuss how to best focus their resources to deliver the most important work.
  2. Limit work in progress. Teams set and adhere to WIP limits they set for each stage of work. They use WIP limits to maintain focus on completing what they started and to identify bottlenecks occurring in their processes.
  3. Manage flow. Teams monitor the overall work in progress and lead time, which gives them an idea of the speed of their delivery.
  4. Make policies explicit. Teams spell out the standards and processes they agree to follow and make them readily accessible. For example, by making the team’s Definition of Done for each work stage explicit, they can avoid wasted time and effort.
  5. Create opportunities for feedback. Teams meet periodically to reflect on what’s working and what needs improvement.
  6. Improve collaboratively, evolve experimentally. Teams determine how to improve the continuous flow of delivery over time based of key metrics. They involve the entire team to gather insights and ideas. And, when persistent bottlenecks arise, they determine the changes that will alleviate them.

Over time, Kanban can provide your team insight as to how well their current processes work end-to-end and how to improve them. Incremental adoption of Kanban practices tends to yield greater success and builds on the sixth practice, to evolve experimentally. These practices arose from principles of Lean Manufacturing and Systems Thinking.

source  https://msdn.microsoft.com/Library/vs/alm/work/kanban/kanban-basics

Plan and track work, Keep the team focused

A good set of tools will help know which is the status of a given task, how does it contribute to the overarching story or what work has been done until today. Make sure your team checks the tools included on your Visual Studio Online account.

Keep (and honor) your backlog. It wi l help you define the work that needs to be done.
Track task completion on the Kanban board, a visualization that helps the team know what’s in progress, who’s doing what, what needs to be done next and what’s been done.
Break down the work in sprints.
Let the information flow in the team rooms.

source https://msdn.microsoft.com/en-us/Library/vs/alm/Work/overview

Advertisements

Monitoring and troubleshooting NAV Services – Using Windows PowerShell to check and search the Application Log


Coffee Break – Monitoring and troubleshooting NAV Services – Using Windows PowerShell to check and search the Application Log

..another very useful post by NAV Team Blog (Jasminka & c.), good for multi server environments.

“Windows PowerShell is very well suited for monitoring services because tasks can be repeated and they can run remotely. In this post we will look at how to check the Application Log via Windows PowerShell, locally as well as remotely, to look for errors or for certain words in the log. The customer story this time is that users report a problem and you need to find the cause. The first place to look (at least in some cases): the Application Log.” ….

Get-WinEvent -ListProvider *nav* | Format-Table

Get-WinEvent -ProviderName “MicrosoftDynamicsNavServer`$DynamicsNAV80”

Source http://blogs.msdn.com/b/nav/archive/2015/06/23/coffee-break-check-the-application-log.aspx

Export Data from MS Project “.MPP” files to others systems


Export Data from MS Project “.MPP” files to others systems

project

Integration Tecnology Available
– OLEDB
– ADO
– XML
– C/SIDE NAV (Oledb .NET Integration)
– SQL IIS using OLE DB Data Source\Destination > Project fields Mapping
– Project Server (Integrated SQL Technology) > Best Practice for my opinion!

… some links about exporting data using ADO and OLE DB Provider

project 2

OLEDB
Microsoft Project OLE DB Provider Information

This document is intended to provide the information necessary to access Microsoft Project
data through the Microsoft Project 9.0 OLE DB Provider.
In addition to describing the OLE DB table structures,
this document details some of the limitations and idiosyncrasies of the provider,
how to access the table structure using data access pages, and sample ActiveX Data Objects (ADO) code.

link http://www.msproject.com/OLEDB.htm

ADO

Export MS Project Data to Excel
Here is a simple routine to export most MS Project task information to Excel.
Due to the 256 column limit of ODBC, the limit to the number of exported columns is 256

Function ProjectToExcel2007()
Dim cnnProj As New ADODB.Connection ‘Ado connection to ms project
Dim rs As New ADODB.Recordset ‘Project tasks table

cnnProj.Open “Provider = Microsoft.Project.OLEDB.11.0; Project Name =” & ActiveProject.Path & “\” & ActiveProject.Name
rs.Open “SELECT * FROM Tasks”, cnnProj, adOpenKeyset, adLockOptimistic
‘If InStr(0, ActiveProject.Path & “\” & ActiveProject.Name, “.mpp”) > 0 Then
Dim objXL As New Excel.Application
objXL.EnableEvents = False

Dim objWkb As New Excel.Workbook
Dim objSht As Worksheet
Dim j, colIndex As Integer
Dim rng As Range
‘DoCmd.Hourglass True

Set objWkb = objXL.Workbooks.Add

‘trick to enable Excel 2007 ability to have morethan 255 columns (save as xlsx and repoen)

objWkb.SaveAs TempFolder() & “tmp.xlsx”
objWkb.Close
objXL.Workbooks.Open TempFolder() & “tmp.xlsx”

Set objWkb = objXL.ActiveWorkbook
Set objSht = objWkb.ActiveSheet
With objSht
.PageSetup.Orientation = Excel.XlPageOrientation.xlLandscape
.PageSetup.CenterHeader = “My Report Header”
.PageSetup.CenterFooter = “My report footer”
.PageSetup.PaperSize = Excel.XlPaperSize.xlPaperA4
.PageSetup.BlackAndWhite = False
.PageSetup.Zoom = False
.PageSetup.FitToPagesWide = 1
.PageSetup.FitToPagesTall = 500
.Rows(1).Font.Bold = True
.Rows(1).Borders.ColorIndex = 1
.Rows(1).Interior.ColorIndex = 45
.Rows(1).HorizontalAlignment = xlCenter
.Rows(1).Borders.Color = vbBlack
.Rows().NumberFormat = “@”
‘ Freeze Window
.Application.ActiveWindow.SplitRow = 1
.Application.ActiveWindow.FreezePanes = True

End With

objXL.Visible = True
For colIndex = 0 To rs.Fields.Count – 1
objSht.Cells(1, colIndex + 1) = rs.Fields(colIndex).Name
objSht.Cells(1, colIndex + 1).EntireColumn.AutoFit
objSht.Cells(1, colIndex + 1).NumberFormat = “@”
Next

‘Transfer the data to Excel
objSht.Range(“A2″).CopyFromRecordset rs

‘End If

If rs.State = 1 Then
rs.Close
End If
‘Blank out all Ado null date values
For Each objSht In objWkb.Worksheets
objSht.Cells.Replace What:=”1/0/1900″, Replacement:=””, _
LookAt:=xlPart, SearchOrder:=xlByColumns, _
MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
Next

End Function

Function TempFolder() As String
Dim objFSO, objFolder
Set objFSO = CreateObject(“Scripting.FileSystemObject”)
Set objFolder = objFSO.GetSpecialFolder(2)

TempFolder = objFolder.Path & “\”
End Function

link https://officetechsupport.wordpress.com/2010/05/21/export-ms-project-data-to-excel/

ADO connecting to a .mpp file or similar – Microsoft Project Developer
make a direct ADO connection to a .xls file

Sub ConnectLocally()
Dim conData As New ADODB.Connection
Dim rstAssigns As New ADODB.Recordset
Dim intCount As Integer
Dim strSelect As String
Dim strResults As String
Dim FILE_NAME As String

FILE_NAME = “C:\Mes Doents\MS Project 2K\StockProjets\Projet B.mpp”

conData.ConnectionString = “Provider=Microsoft.Project.OLEDB.9.0;PROJECT
NAME=” & FILE_NAME
‘ To connect to a Microsoft SQL Server or Oracle Server file, you must also
supply User ID and Password arguments
‘ conData.ConnectionString = “Provider=Microsoft.Project.OLEDB.9.0;User
ID=jsmith;Password=MyPass5;PROJECT NAME=” & FILE_NAME

conData.ConnectionTimeout = 30
conData.Open

strSelect = “SELECT ResourceUniqueID, AssignmentResourceID,
AssignmentResourceName, TaskUniqueID, AssignmentTaskID, AssignmentTaskName
FROM Assignments WHERE TaskUniqueID > 0 ORDER BY AssignmentTaskID ASC”
rstAssigns.Open strSelect, conData

Do While Not rstAssigns.EOF
For intCount = 0 To rstAssigns.Fields.Count – 1
strResults = strResults & “‘” & rstAssigns.Fields(intCount).Name
& “‘” & _
Space(30 – Len(rstAssigns.Fields(intCount).Name)) & vbTab &
_
CStr(rstAssigns.Fields(intCount).Value) & vbCrLf
Next
strResults = strResults & vbCrLf
rstAssigns.MoveNext
Loop

conData.Close

Open “C:\Mes Doents\Results.txt” For Output As #1
Print #1, strResults
Close #1

Shell “Notepad C:\Mes Doents\Results.txt”, vbMaximizedFocus

End Sub

XML
Project “SaveAS” .XML file
Saving and Opening Projects in XML Format
link https://msdn.microsoft.com/en-us/library/bb968621(v=office.12).aspx

The Microsoft Office Project 2007 XML Data Interchange Schema (mspdi_pj12.xsd) defines how Project 2007 reads and writes project data in XML format. This article describes how to work with Project 2007 XML Data Interchange files, and contains the following sections:

– Saving Project Files as XML
– Opening Project XML Files
.. we can use NAV XML Ports to import\export data in NAV reading from XML saved from Project

C/SIDE NAV
.. example of integration between NAV & Project using C/SIDE

Automations Objects
‘Microsoft Scripting Runtime’.FileSystemObject
“Automation Your MS Project Release”.Project
“Automation Your MS Project Release”.Tasks
“Automation Your MS Project Release”..Resource
“Automation Your MS Project Release”.TaskDependencies

Tables
TblJobNAV  table  Job
tblJobTasks tabel Job Task
tblJobTasksResource table Job Planning Line

Variabiles
prjPrj
prjApp
prjTasks
prjDependiences
prjResources
…..

Function SendTasksToProject
WITH JobTask DO BEGIN
CREATE(prjApp);
FileExist:=FALSE;
IF KeepFileCopy THEN BEGIN
File_Name:=FileName;
IF EXISTS(FileName) THEN BEGIN
prjApp.FileOpenEx(FileName);
prjPrj :=  prjApp.ActiveProject;
FileExist:=TRUE;
END;
END ELSE
IF EXISTS(FileName) THEN ERASE(FileName);
…..
…..

IF NOT FileExist THEN BEGIN
prjApp.FileNew;
prjPrj :=  prjApp.ActiveProject;
prjPrj.”Custom Job No.”:= Rec.”No.”;

JobTask.SETRANGE(“Job No.”,Rec.”No.”);
JobTask.SETFILTER(“Job Task Type”,'<>%1&<>%2′,”Job Task Type”::Total,”Job Task Type”::”End-Total”);
IF FINDFIRST THEN BEGIN
k:=0;
REPEAT
k+=1;
Wnd.UPDATE(1,ROUND(k/JobTask.COUNT*5000,1));
AddTask(JobTask,prjApp);
UNTIL NEXT=0;
END;
End Function

Function ReceiceTasksFromProject
JobTask.INSERT;
prjTask.”Custom Job No.”:=JobTask.”Job No.”;
prjTask.”Custom Job Task No.” :=JobTask.”Job Task No.”;

IF prjTask.OutlineChildren.Count()<>0 THEN BEGIN // Internal Project function
JobTask.”Job Task Type”:=JobTask.”Job Task Type”::”Begin-Total”;
JobTask.MODIFY;
JobTask.”Job Task No.”:=PADSTR(COPYSTR(JobTask.”Job Task No.”,1,(prjTask.OutlineLevel)*2),MaxOutlineLevel*2,’9′);
JobTask.”Job Task Type”:=JobTask.”Job Task Type”::”End-Total”;
JobTask.Description:=COPYSTR(Text005 + ‘ ‘ + prjTask.Name,1,MAXSTRLEN(JobTask.Description));
JobTask.Indentation:=prjTask.OutlineLevel-1;
JobTask.”Starting Date”:=prjTask.Start;
JobTask.”Ending Date”:=prjTask.Finish;

IF NOT JobTask.INSERT THEN;
….
….
….
End Function

Function AddTask(VAR JobTask: record:”Job Task”, PrjApp:Project Automation.”Application”)
WITH JobTask DO BEGIN
prjPrj:= PrjApp.ActiveProject;
prjTask := prjPrj.Tasks.Add(Description);
prjTask.”Custom Job No.”:=JobTask.”Job No.”;
prjTask.”Custom Job Task No.” :=JobTask.”Job Task No.”;

IF “Starting Date”<>0D THEN
prjTask.Start    := (CREATEDATETIME(“Starting Date”,”Starting Time”));
IF “Ending Date”<>0D THEN
prjTask.Finish   := (CREATEDATETIME(“Ending Date”,”Ending Time”));

IF “Due Date”<>0D THEN
prjTask.Deadline := (CREATEDATETIME(“Due Date”,”Due Time”));

….
End Function

“From Navision To Microsoft”, The history of Dynamics NAV / Navision


From Navision To Microsoft, The history of Dynamics NAV / Navision

… some links about history of Dynamics NAV!  1984..2015

Have fun !

Torben Wind, Peter Bang, Jesper Balser , 1984

Torben Wind, Peter Bang, Jesper Balser

Denmark Data Museum
From Navision To Microsoft (Michael Nielsen, Product Unit Manager)
http://datamuseum.dk/site_dk/20040213/navision/

http://datamuseum.dk/site_dk/20040213/navision/sld001.htm

PPT Presentation
http://datamuseum.dk/site_dk/20040213/navision/navision.ppt

nav menu

Starting with Navision, Timeline since 1983
http://embed.verite.co/timeline/?source=0AoEsgYypDSCGdE90RGo2TkJwNlNjYnJybGpReXVvX0E&font=Bevan-PotanoSans&maptype=toner&lang=en&height=650

nav oldjpg

Blogs & Wikipedia
The history of Dynamics NAV / Navision – Dynamicsuser.net
http://dynamicsuser.net/wikis/navdev/the-history-of-dynamics-nav-navision.aspx

Microsoft Dynamics NAV –  Wikipedia.org
https://en.wikipedia.org/wiki/Microsoft_Dynamics_NAV

History of Microsoft Dynamics NAV – Vjeko.com
http://vjeko.com/blog/history-of-microsoft-dynamics-nav

microsoft

Microsoft Acquires Navision, COPENHAGEN, Denmark, July 11, 2002
http://news.microsoft.com/2002/07/11/microsoft-acquires-navision/

Free Online Scrum Master Training and Scrum Master Manifesto


Free Online Scrum Master Training and Scrum Master Manifesto

Free Online Scrum Master Training: The fun way to learn about Agile/Scrum, prepare for Scrum Master certification / Agile certification (CSM, CSPO, PSM, or PMI-ACP), and debunk popular misconceptions.

http://scrumtrainingseries.com/

scm logo

Introduction to Scrum

Backlog Refinement Meeting

Sprint Planning Meeting

Daily Scrum Meeting

Sprint Review Meeting

Sprint Retrospective Meeting

 

Scrum Master Manifesto

http://www.scrummastermanifesto.org/scrummaster-manifesto/A_ScrumMaster_Manifesto.html

“We believe the ScrumMaster is a full-time position for one person on one Scrum team”

scrum master

12 ScrumMaster Pocket Principles…

1.    Dedicated Delivery Improver

2.    Foster Continuous Improvement

3.    Help Continuous Improvement

4.    Empower Coach Deliver

5.    Nurtures The Team

6.    Transparent Team Helper

7.    Commitment To Excellence

8.    Empathetic Evangelistic Guide

9.    Resistant Persistent Dedicated

10.  Help The Team

11.  Awareness Then Improvement

12.  Agile Driving Force

Top 10 things a ScrumMaster usually forgets to focus on (but is not SOLELY responsible for) …

1.    Redefining career paths and goals to be more scrum focussed

2.    Missing Product Backlog items

3.    Team issues aren’t being discussed because they are too uncomfortable

4.    Appropriate balance between end-to-end system test and unit tests

5.    Playing back the team’s progress against the proposed release plan

6.    All tests roll up into the continuous integration results

7.    Team members realise the benefits of refactoring

8.    Code is regularly peer reviewed

9.    Pair programming is being utilised

10.  Definition of done is being expanded

SQL SERVER REPORTING SERVICES (SSRS) LINKS AND NAV DEMO REPORTS


SQL SERVER REPORTING SERVICES (SSRS) LINKS AND NAV DEMO REPORTS

LINKS

Developing Report Navigation and Drilldown

https://technet.microsoft.com/en-us/library/aa964132(v=sql.90).aspx

Migrating from Business Objects Crystal Reports to SQL Server 2005 Reporting Services

https://technet.microsoft.com/en-US/library/aa964127(v=sql.90).aspx

Migrating Crystal Report Sections to SQL Server 2005 Reporting Services

https://technet.microsoft.com/en-US/library/aa964127(v=sql.90).aspx

Reporting Services Tutorials

https://msdn.microsoft.com/en-us/library/ms170246.aspx

Reporting Services Samples

https://msdn.microsoft.com/en-US/library/ms160954(v=sql.105).aspx

Reporting Services (SSRS)

https://msdn.microsoft.com/it-it/library/ms159106.aspx

DEMO REPORTS & DATABASES

STANDARD DEMO

Microsoft SQL Server Community Projects & Samples

http://sqlserversamples.codeplex.com/

NAV FREE DEMO REPORTS

22 Free Reporting Services Reports for Dynamics Nav available

http://blogs.msdn.com/b/clausba/archive/2006/04/03/567113.aspx

Best Practices Tips and Tricks for Upgrading to Dynamics NAV 2013 R2 or Dynamics NAV 2015 – Microsoft Dynamics NAV Team Blog – Site Home – MSDN Blogs


Best Practices Tips and Tricks for Upgrading to Dynamics NAV 2013 R2 or Dynamics NAV 2015 – Microsoft Dynamics NAV Team Blog – Site Home – MSDN Blogs.

Microsoft Dynamics NAV 2015 – BI Business Intelligence White Paper


Microsoft Dynamics NAV 2015 – BI Business Intelligence White Paper

“Maximising value through business insight”, Business Intelligence White Paper, December 2014

Sales Dshboard

Download link http://www.wise.is/images/Lausnir/Dynamics_NAV/Skjol/BIwhitepaper_MicrosoftDynamicsNAV2015.pdf

NAV 2015 ITALIAN FLYER


NAV2015 ITALIAN FLYER

Microsoft Dynamics NAV è una soluzione di gestione aziendale innovativa che offre alle persone la libertà di svolgere attività mirate al raggiungimento degli obiettivi aziendali:

Gestione Finanziaria, Produzione, Gestione della Supply Chain, Business Intelligence e Reporting, Customer Relationship Management, Collaborazione interna, Gestione delle Risorse Umane, Gestione Commesse, applicazioni verticali, ecc.

Microsoft Dynamics NAV consente di automatizzare i processi manuali ripetitivi e di ridurre il tempo dedicato alle procedure consuete e a quelle amministrative per aumentare la produttività individuale e migliorare l’integrazione dei dati.

Grazie all’accesso semplificato a informazioni aggiornate in tempo reale, tutti i dipendenti dell’organizzazione sono dotati degli strumenti adeguati per far crescere il business. Microsoft Dynamics NAV include un’interfaccia utente intuitiva simile a quelle di altri prodotti Microsoft (Outlook like style).

Attraverso Microsoft Dynamics NAV è possibile ottenere informazioni dettagliate navigando in profondità i dati con accesso a report di sintesi aggiornati in tempo reale, mantenendo in questo modo il controllo sulle operazioni aziendali.

La funzionalità multilingua consente agli utenti di inviare fatture e conferme di ordini nella lingua del cliente e di comunicare efficacemente con i partner commerciali in altri paesi.

NAv 2015

NAV2015 ITALIAN FLYER

Link http://www.soluzioniedp.it/admin/public/articolo/9f8e89cdc3e55c820ba8b6017cf1b842/files/NAV2015_Flyer.pdf

NAV 2015 TRACKING SESSIONS, USERS ACTIVITY, CHANGE LOG


NAV 2015 TRACKING SESSIONS, USERS ACTIVITY, CHANGE LOG

A simple post about NAV 2015 Tracking Technology, based on MSDN NAV Online Help.

 1) TRACKING SESSIONS

NAV 2015 Active Sessions Table

“Active Session”  Table

Specifies sessions that are currently active and are connected to a Microsoft Dynamics NAV Server instance. An active session can be in use or idle.

This table can contain sessions that are not active, before those are removed from the table. For example, if a Microsoft Dynamics NAV Server instance stops responding, then the table can contain sessions that are not active. When the Microsoft Dynamics NAV Server instance restarts, it deletes from the table the sessions that are not active. If the Microsoft Dynamics NAV Server instance never restarts, then other the Microsoft Dynamics NAV Server instances delete the sessions that are not active.”

https://msdn.microsoft.com/en-us/library/hh895997(v=nav.80).aspx

Field Location
Session ID Field, Active Session Table Using Microsoft Dynamics NAV
Database Name Field, Active Session Table Using Microsoft Dynamics NAV
Login Datetime Field, Active Session Table Using Microsoft Dynamics NAV
User ID Field, Active Session Table Using Microsoft Dynamics NAV
User SID Field, Active Session Table Using Microsoft Dynamics NAV
Server Computer Name Field, Active Session Table Using Microsoft Dynamics NAV
Client Computer Name Field, Active Session Table Using Microsoft Dynamics NAV
Client Type Field, Active Session Table Using Microsoft Dynamics NAV
Server Instance Name Field, Active Session Table Using Microsoft Dynamics NAV
Server Instance ID Field, Active Session Table Using Microsoft Dynamics NAV

 “Active Sessions List” Page > based on “Session” Table

Client Type

> Windows Client, Web Client, Tablet  Client, Web Services (& Odata Access), Background Services (NAV Server Service or NAS Service)

 NAv 1

2) TRACKING USERS ACTIVITY & CHANGE LOG

Standard NAV By Design functionalities

Actually NAV has 2 separate tables to track user activities  (only NAV activities handled by NAV Server)

>  User Time Registers Table > login\logout with user activities timing

“Specifies how much time an individual user works on the accounts.

The User Time Register table is useful for accounting firms that want to register the amount of time spent working on each company. You may also want to see who has worked on the companies in which period.

To use the User Time Register table, two conditions must be fulfilled: the user must be set up with a personal User ID in the security system and there must be a check mark in the Register Time field.

The program registers time in whole minutes, rounding up or down.”

https://msdn.microsoft.com/en-us/library/hh169225(v=nav.80).aspx

NAV 2

User Time Registers Table Detail

Field Location
User ID Field, User Time Register Table General Ledger
Minutes Field, User Time Register Table General Ledger
Date Field, User Time Register Table General Ledger

>  Change Log Table > data modifications (insert, delete, modify, previous record before modify)

By Default these tables are not configured & tracking isn’t active, user can activate these functions On-Demand

“The change log in Microsoft Dynamics NAV logs changes that are made to data in the tables that you track. In the change log, entries are chronologically ordered and show changes that are made to the fields on the specified tables.

The change log collects all changes that are made to the table.”

https://msdn.microsoft.com/en-us/library/hh167300(v=nav.80).aspx

nav 3

Field Location
Primary Key Field, Change Log Setup Table General Ledger
Change Log Activated Field, Change Log Setup Table General Ledger