Hands On With the GP Power Tools – System Module: Configure Email Settings

● Ian Grieve ●  ● 0 Comments   ● 

Winthrop DCThis post is part of the Hands On With the GP Power Tools (GPPT) – System Module series in which I am taking a hands on look at the varioues tools offered by GPPT.

There is functionality in GPPT which allows screenshots to be taken and emailed to the administrator. However, before this is used, there are some email settings which need to be configured. To configure the email settings, open the Email Settings window (GP Power Tools area page >> Setup >> Email Settings).

Email Settings

In the Administrator Email field, enter the email address which should receive the emails.

Default settings can be defined for the subject and body of the emails. I have entered the text Issue Report in the Default Subject. If a default body is required, click the Edit Bidy text button.

A signature can be added to the email by clicking the Edit Signature button.

Email Server Settings are required fields; these are details of the SMTP server which will send the emails. Depending on which Email Mode is selected, different fields will be enabled.

Once you are finished, click the OK button

Click to show/hide the Hands On With the GP Power Tools - System Module Series Index

● Categories: Dynamics, GP, GP Power Tools, Microsoft, Third Party Add-on ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Hands On With the GP Power Tools – System Module: Using Manual Logging Mode

● Ian Grieve ●  ● 0 Comments   ● 

Winthrop DCThis post is part of the Hands On With the GP Power Tools (GPPT) – System Module series in which I am taking a hands on look at the varioues tools offered by GPPT.

All of the logging modes I covered in the overview are activated by default when Manual Logging Mode is switched on, and this can be done with very few clicks. The Logging Settings window (GP Power Tools area page >> Setup >> Logging Settings).

To switch on Manual Logging Mode, open the GP Power Tools Logging Control window from one of the three access points:

  1. Microsoft Dynamics GP menu >> Tools >> GP Power Tools Logging Control
  2. GP Power Tools area page >> Transactions >> GP Power Tools Logging Control
  3. GP Power Tools Logging Control button on the standard toolbar

Click the Turn on Manual Logging Mode button:

GP Power Tools Logging Control

The same button is used to switch off Manual Logging Mode.

Each time Manual Logging Mode is activated, the log files contain the user, company, date and time so no log files are overwritten. The log files are created in the GPPT data folder which is selected during the installation of the GP Power Tools.

  • DEXSQL_{Date}_{Time}.LOG contains the SQL Logging results.
  • Trace_{User}_{Company}_{Date}_{Time}_{Mode}.trc contains the SQL Profile Tracing results.
  • Script_{User}_{Company}_{Date}_{Time}.log contains the Dexterity Script Logging results.
  • Profile_{User}_{Company}_{Date}_{Time}.txt contains the Dexterity Script Profiling results.
  • Macro_{User}_{Company}_{Date}_{Time}.mac contains the Macro Recording results.

{User} will be substituted with the current User ID and {Company} will be substituted with the current Company ID code (InterCompany ID).
{Date}_{Time} will contain the date and time at which the logging was started in the format YYYYMMDD_HHMMSS.
{Mode} will be replaced with a letters A to E depending on the SQL Profile Trace mode used.

Due to the overhead on the processing when the Manual Logging Mode is switched on, it is recommended to minimise the time logging is enabled and also to minimise the amount of information which is captured in the logs. This can be done by getting the user to perform all actions until just before the point at which the issue arises and then enable logging and perform the final actions. Once these actions have been performed and the error produced, switch off the logging.

Click to show/hide the Hands On With the GP Power Tools - System Module Series Index

Hands On With the GP Power Tools - System Module
Introduction
Manual Logging Mode Overview
Configuring SQL Profile Tracing With Recommended Settings
Enable Capture Macro Recording
Using Manual Logging Mode
Using Manual Logging Mode
Using Manual Logging Mode
Using Manual Logging Mode
Configure Email Settings
Configure Email Settings
Configure Email Settings
● Categories: Dynamics, GP, GP Power Tools, Microsoft, Third Party Add-on ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Hands On With the GP Power Tools – System Module: Enable Capture Macro Recording

● Ian Grieve ●  ● 0 Comments   ● 

Winthrop DCThis post is part of the Hands On With the GP Power Tools (GPPT) – System Module series in which I am taking a hands on look at the varioues tools offered by GPPT.

In the overview of Manual Logging, Macro Recording was mentioned. This records, as a macro, all of the actions of the user in the application. This is very useful when it comes to reproducing the steps taken by the user.

However, Macro recording is not enabled in GPPT by default, although it is very simple to enable it.

Open the Logging Settings window (GP Power Tools area page >> Setup >> Logging Settings) and mark the Capture Macro Recording checkbox (ringed in red):

Logging Settings

Click the OK button to save the changes and close the Logging Settings window.

Click to show/hide the Hands On With the GP Power Tools - System Module Series Index

● Categories: Dynamics, GP, GP Power Tools, Microsoft, Third Party Add-on ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Hands On With the GP Power Tools – System Module: Configuring SQL Profile Tracing With Recommended Settings

● Ian Grieve ●  ● 0 Comments   ● 

Winthrop DCThis post is part of the Hands On With the GP Power Tools (GPPT) – System Module series in which I am taking a hands on look at the varioues tools offered by GPPT.

In the last post, I gave an overview of the Manual Logging Mode and mentioned that the SQL Profile Tracing tool needs to be configured before it can be used.

There are recommend settings for the SQL Profile Tracing, which are configured as follows in this post.

The first step is to create a folder on a local drive of the SQL Server to store the traces as they are being produced:

Windows Explorer

I have created a folder called Dynamics Central and then a sub folder called SQL Profile Tracing as there are other files which will be shared with users.

Continue reading → Hands On With the GP Power Tools – System Module: Configuring SQL Profile Tracing With Recommended Settings

● Categories: Dynamics, GP, GP Power Tools, Microsoft, Third Party Add-on ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Hands On With the GP Power Tools – System Module: Manual Logging Mode Overview

● Ian Grieve ●  ● 0 Comments   ● 

Winthrop DCThis post is part of the Hands On With the GP Power Tools (GPPT) – System Module series in which I am taking a hands on look at the various tools offered by GPPT.

The first tool is the Manual Logging Mode. This tool allows easy enabling of several types of logging:

  1. SQL Logging – SQL Logging tracks all communication between the Microsoft Dynamics GP client and the SQL Server. The default file in which the SQL communication is stored is named DEXSQL.LOG.

    When enabled, SQL Logging is on a workstation basis. On a standalone PC, this logging is easy to use and interpret, but on a terminal or Citrix server, all instances of a running client will be recorded, which can make debugging a specific issue for a single user much harder.

    Other methods of communicating with the SQL Server, such as ADO (ActiveX Data Objects) which is used by Visual basic for Applications (VBA), are not logged.

  2. SQL Profile Tracing – SQL Profile Tracing can be used to log all activity at the SQL Server, including commands from inside Stored Procedures. The default file in which the SQL Profile Trace is stored is named Trace.trc.

    SQL Profile Tracing will capture all activity at the SQL Server for the current user in the system database (typically called DYNAMICS) and the current company database; this means that, unlike SQL Logging, SQL Profile Tracing will record all communication with the SQL Server, including ADO as used by VBA.

    SQL Profile Tracing is not enabled by default, but needs to be configured first; in the next post, I will cover the configuration using recommended settings.

  3. Dexterity Script Logging – Dexterity Script Logging tracks all Dexterity event script, procedure and function calls, including the script hierarchy. The default file in which the script log is stored is named Script.log.
  4. Dexterity Script Profiling – Dexterity Script Profiling tracks the number of calls to each event script, procedure and function and how much time the calls have taken. It also tracks all table activity initiated by Dexterity and the time taken. The default file in which the script profile is stored is named Profile.txt.

  5. Macro Recording – Macro Recording captures all activity performed by the user in the application. this activity is stored in a file called Macro.mac which can be opened in Notepad, which allows for analysis of the users actions and is useful in showing steps which the user didn’t relay when reporting the problem.

    Macro recording will only work foe a single user; in a shared client environment, such as on a terminal or Citrix server, this means the first instance launched.

    Macro recording is only available in the desktop client.

The logging is not provided by GPPT, but is standard functionality which GPPT allows to be easily enabled; without GPPT, enabling them involves several Dex.ini switches.

UPDATE: Winthrop DC have reminded me that the SQL Profile Tracing is functionality provided by GPPT; it is the other four types of logging are standard.

Logging is a functionality which should be used sparingly, as there is a processing “overhead” which can cause speed issues; logging should only be used when investigating a specific issue.

Click to show/hide the Hands On With the GP Power Tools - System Module Series Index

● Categories: Dynamics, GP, GP Power Tools, Microsoft, Third Party Add-on ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Hands On With the GP Power Tools – System Module: Introduction

● Ian Grieve ●  ● 1 Comment   ● 

Winthrop DCGP Power Tools (GPPT) is split into four modules. The module I am going to cover in this series of posts, is the System Module. This module is included in the licence when any of the other three modules is purchased.

These tools are the ones which provide the basic debugging and support tools:

  1. Logging Control including Manual Logging Mode – Manually turn on SQL Logging and Dexterity Logging and Profiling
  2. ScreenShot – Capture and either email or save Screenshots and System Status information
  3. Send Email – Send Email messages from within the application
  4. Dex.ini Settings – Change System and Debugger Dex.ini Settings for the current workstation
  5. Configuration Export/Import – Export and Import settings
  6. Administrator Password Setup* – Create optional separate password to be used when accessing Advanced mode features
  7. Logging Settings* – Change system wide Logging Settings such as shared path location, default logs and SQL Profile Trace setup
  8. Email Settings* – Change system wide Email Settings controlling the email engine used by the tool
  9. Configuration Maintenance* – Clear GP Power Tools data tables
  10. Setup Backup and Restore* – Backup all data in SQL Tables to Debuggger.xml file and restore from Debugger.xml to SQL Tables

Tools listed with an asterisk (*) is an Advanced Mode tool.

Click to show/hide the Hands On With the GP Power Tools - System Module Series Index

● Categories: Dynamics, GP, GP Power Tools, Microsoft, Third Party Add-on ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Hands On With the GP Power Tools – System Module: Series Index

● Ian Grieve ●  ● 10 Comments   ● 

Winthrop DCThis post is a continuation of the Hands On with the GP Power Tools (GPPT) series. I have split it out into a separate series as there may be a large number of posts.

This is the series index for the Hands on with GP Power Tools – System Tools. These are the tools which become available when you purchase any of the other three modules of GPPT.

Continue reading → Hands On With the GP Power Tools – System Module: Series Index

● Categories: Dynamics, GP, GP Power Tools, Microsoft, Third Party Add-on ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Hands On With the GP Power Tools: Navigating the GP Power Tools

● Ian Grieve ●  ● 0 Comments   ● 

Winthrop DCWith GP Power Tools (GPPT) installed and configured, it is now available for use.

Before starting to cover the functionality of GPPT, I thought it might be useful to give a quick oversight of where GPPT is accessible.

Firstly, from an Administrators point of view. Generally administrators will require access to all of the functionality of GPPT. While traditional drop down menus can be used to navigate, they are not the most user friendly method:

Microsoft Dynamics GP Transaction menu

Continue reading → Hands On With the GP Power Tools: Navigating the GP Power Tools

● Categories: Dynamics, GP, GP Power Tools, Microsoft, Third Party Add-on ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Hands On With the GP Power Tools: Initialising the GP Power Tools

● Ian Grieve ●  ● 1 Comment   ● 

Winthrop DCIn the last post, I installed GP Power Tools (GPPT); in this post I am going to initialise it in on one client machine (the initialisation will be global on all installations).

The initialisation process requires elevated privileges on SQL Server as the settings are stored centrally in the GP database and GPPT creates its own tables. So to complete the initialisation we need to log in as the sa account, or preferably another account which has been given eleveted privileges:

Welcome to Microsoft Dynamics GP

Once you have logged into a company, GPPT will deploy all of the database objects and create some default settings. These settings include some Security Tasks and Roles. The roles which will be created are:

  • GP POWER TOOLS USER grants access to Standard Mode features.
  • GP POWER TOOLS ADMIN grants access to all areas of GPPT.
  • GP POWER TOOLS PASSWORD grants access to maintain the GPPT System Password.
  • GP POWER TOOLS SERVICES is created only in Microsoft Dynamics GP 2015 and later.

Continue reading → Hands On With the GP Power Tools: Initialising the GP Power Tools

● Categories: Dynamics, GP, GP Power Tools, Microsoft, Third Party Add-on ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Hands On With the GP Power Tools: Installing the GP Power Tools

● Ian Grieve ●  ● 4 Comments   ● 

Winthrop DCWith a licence for GP Power Tools we can now download it. Versions are available for Microsoft Dynamics GP 2010, 2013, 2015 and 2016 so make sure you select the correct version.

Once you’ve downloaded the installer, you need to install GP Power Tools on every machine with the Microsoft Dynamics GP client installed.

Do this, by running the installer and clicking Next on the Welcome step:

GP Power Tools: Welcome

Continue reading → Hands On With the GP Power Tools: Installing the GP Power Tools

● Categories: Dynamics, GP, GP Power Tools, Microsoft, Third Party Add-on ● Tags: , , , , ,  ● Permalink ● Shortlink ●