Academy

Welcome to the i2x Academy! Here you will find a variety of resources such as articles, video tutorials, and infographics. Our goal is to provide you with the tools and knowledge you need to succeed.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Resetting a LEA Air Password

November 29, 2023
  1. Open https://lea/i2xsolutions.com in a new tab and log in with your username and password.

Note. You must log in with an account that has been assigned the Task Manager role. Also, you cannot change the password for the account that is currently logged in.

  1. Click on the main menu, then select the 'Office" option.

  1. On the "Employees" tab, type part of the employee's name, then click the "Search" button and double-click the appropriate employee row listed in the grid below.

  1. On the Employee detail screen, type in a temporary password for the user and click the "Save" button.

Note. Passwords should be unique, at least 12 characters and must contain lowercase, uppercase and numbers.

How to Install EDI Notepad

March 24, 2023
  1. Use the following hyperlink by click on the text: i2x's shared folder.

  1. Click on EDINotepad8_Setup.zip.

  1. Click Download.

  1. Click on the magnifying glass located in the task bar in the bottom left corner.

  1. Type "File Explorer" into the search bar.

  1. Click on the File Explorer app.

  1. On the left-hand side of File Explorer, scroll down to This PC and click Downloads.

  1. Double-click on EDINotepad8_Setup.zip.

  1. Double-click on EDINotepad8_Setup.exe.

  1. If the User Account Control pop-up asks, "Do you want to allow this app from an unknown publisher to make changes to your device?" select Yes.

  1. When the InstallShield Wizard opens, click Next.

  1. When asked if you accept all the terms of the License Agreement, select Yes.

  1. When asked to select the type of setup you prefer, click Express Edition, then click Next.

  1. When asked to choose the destination location, click Next to proceed with the default location.

  1. When InstallShield Wizard is complete, determine if you would like to immediately open EDI Notepad. If you would like to open EDI Notepad, ensure that the Launch Liaison EDI Notepad checkbox is ticked. If you do not want to open EDI Notepad, uncheck the box.

  1. Click Finish.

Using EDI Notepad to Save EDI TXT Files as XML Files

March 4, 2023

Major Considerations

Consider a grouping of related EDI data to be a batch.

Each batch will be referenced by different control numbers. There may be multiple batches and, therefore, multiple control numbers in one file, such as if you have two different 820 Payment Orders (each with their own related data) in one file.

In EDI Notepad, this will look like the following:

If the EDI file you’d like to convert to an XML file has multiple control numbers, you’ll need to complete steps 1 through 5 for the first control number with data you’d like to convert to an XML file and steps 3 and 5 for the remaining control numbers with data you’d like to convert to XML files.

If EDI Notepad is not already installed on your computer, then download and install EDI Notepad 8.2 according to the instructions in the article titled “How to Install EDI Notepad” before following the steps below.

Steps

  1. Open the EDI Notepad application.

  1. Open an EDI file, then click file.

  1. Click Open.

  1. Navigate to the folder with the TXT version of the EDI file you’d like to convert to XML.

  1. Select All files (*.*) in the file explorer drop-down menu in order to preview the file names.

  1. Click the name of the EDI file you’d like to convert to XML.

  1. Click Open.

  1. If a pop-up asks if you would like to open in EDIT mode instead, click No.

  1. Click on the control number associated with the EDI transaction type you’d like to convert to XML.  

  1. Display the selected batch in XML view:
  • Click the down arrow next to HTML.
  • Click XML.

  1. Save the document as an XML file:
  • Click File.

  1. Click Save As...

  1. Click Yes when asked if you’d like to save EDI data as XML.

  1. Navigate to the folder you’d like to save the XML file in. In the file name box, type the name you’d like to give the XML file.

  1. Click Save.

How to Set Up an SSRS Project

January 23, 2023
  1. Open Microsoft Visual Studio.
  1. Select File > New > Project > Reporting Services.

Note. There are two ways to set up a new Project: Report Server Project Wizard and Report Server Project.

  • Report Server Project Wizard: Allows you to set up a new Project and a new report associated with a dataset. The Project contains folders for Shared Data Sources, Shared Datasets, and Reports. The Report folder will contain the new report.
  • Report Server Project: Allows you to set up a new Project. The Project contains folders for Shared Data Sources, Shared Datasets, and Reports, all of which are initially empty. New reports can be added by going into the Reports folder and adding either a new Report or new Report item.

Follow these steps for the Report Server Project Wizard:

  1. Select Report Server Project Wizard in the middle pane.

  • Enter the Project Name.
  • Enter or browse for the Directory/Location.
  • Select Create a new solution for the action.
  • Enter a Solution Name (this can be the same as the Project Name).
  • Click the Create directory for solution checkbox if it is a new directory.
  • Click OK.
  • Wait for Welcome to the Report Wizard to open.
  • Click Next.

  1. Wait for the Select the Data Source screen to open.
  • Enter a name.
  • Select Microsoft SQL Server for the Type.
  • Click Edit for the Connection String.

  1. Enter a Server Name.
  • Select Authentication.
  • Enter the username and password.
  • Select the Database name.
  • Click OK and wait for the Connection String to populate automatically.
  • Click Next.

  1. Select Query Builder.

  1. Select Edit as Text mode.

  1. Type in the SQL query you will use for your Data Set.
  • Click OK.
  • Click Next.

  1. Select Tabular for Report Type.

  1. Arrange the Available fields to be in the Displayed fields.
  • Select the fields.
  • Click the arrow button for each section.
  • Click Next.

  1. Enter a Report Name.
  • Click Finish.

  1. The new Project is created with all of the applicable elements displayed.

Follow these steps for the Report Server Project:

  1. Select Report Server Project in the middle pane.
  • Enter the Project Name.
  • Enter or browse for the Directory/Location.
  • Select Create a new solution for the action.
  • Enter a Solution Name (this can be the same as the project name).
  • Click the Create a directory for solution checkbox if it is a new directory.
  • Click OK.

  1. The new Project is created with all applicable elements displayed.

Changing Ports for the Remote Desk Protocol

January 18, 2023

Steps

  1. If you cannot connect to the server, then restart the server.

  1. Connect to the server.

Note. Recommended via web or VNC, or via RDP if necessary.

  1. Open the registry editor.
  • Go to: Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\WinStations\RDP-Tcp.
  • Double-click on PortNumber.
  • Click on Decimal.
  • Enter the new port number, then click OK.
  • Close the registry editor.

  1. Click on the Start button.
  • Open Windows Defender Firewall with Advanced Security.
  • Click on Inbound Rule.
  • Click on New Rule.
  • Select Port.
  • Click Next.
  • Choose either TCP or UDP.
  • Choose Specific local ports.
  • Enter the new local port number.
  • Click Next.
  • Choose Allow connections.
  • Give it a name.

Note. Make sure the new name has the new local port number in it.

  • Click Finish.
  • Repeat sub steps "Click on New Rule" through "Click Finish" using the other option from step "Choose either TCP or UDP."

Note. If you did TCP first, then do UDP second and vice versa. Skip this step if you have already completed this process for both TCP and UDP.

  1. Click on the Start button.
  • Open Azure and go to the VM you are currently editing.
  • On the left-hand side, select Networking (located under Settings).
  • Delete the old port.

  1. Add a new incoming port for the port you just added in the steps above.
  • Click on Add inbound port rule.
  • Fill in the information in the pop-up window.
  • Make sure the Destination Port Ranges is set to the port you added in step 4 "Enter the new local port number."
  • Click Add.

Note. If there is a port you want to change, then you can edit it instead of adding a new one.

  1. Type Services and press enter.
  • Right-click on Remote Desktop Service and select Restart.
  • Reconnect to the server.

  1. Go back to the Windows Defender Firewall with Advanced Security.
  • Delete the old port that got replaced.

  1. The process is now complete!

Connecting to an SSAS Database (Cube)

January 17, 2023

Major Considerations

  1. You must have the SSAS server name hosting the database and Cubes you would like to access.

  1. The login used for Windows must be granted security permissions to read the SSAS database on the SSAS server.

  1. You must be using a modern desktop version of Excel, newer than or equal to 2016. If you use older versions, you may be requred to install additional Microsoft features to connect to SSAS.

Note. The steps in this article may vary in their order or description.

Steps

  1. Open a new Excel document. You can start with either a new or existing document.

Note. Save this document and use it as an analysis tool. The Cube connection is active when this file is open and the Cube is accessible.

  1. Select the Data tab.
  • Select the From Other Sources menu.
  • Select the From Analysis Services option.

  1. Enter the SSAS server name.
  • Select Use Windows Authentication.
  • Click Next.

  1. Select SSAS_Analytics.
  • Select Insights.
  • Click Next.

  1. Click Finish.

  1. Click Yes.

Note. This pop-up window is similar to a warning when saving a Microsoft Word file with the same name as an existing file, except this file contains Cube connection details. It's technical, but safe to click Yes.

  1. Select cell B2.
  • Click OK.
  • Choose PivotChart for table+chart.
  • Choose Power View to load and analyze data using Excel data models (e.g., PowerBI).
  • Choose another location for your item.
  • Select the Properties button to apply advanced settings to the PivotTable.

  1. Click on the gear icon menu.
  • Select Collapse All.

  1. Expand+drag items to the right.
  • Measures: define numerical values like worked hours, fees, collected, etc. These are organized into "folders."
  • Dimensions: define text/data values to silce/filter the "measures," such as period, data, employee, office, etc.

  1. Drop+reorder items in squares.
  • Filters: defines the dimensions to use for selecting specific people, places, dates, etc.
  • Values: defines the list of items being measured on those dimensions.

How to Utilize PowerShell to Automate Email Alerts for Crashed Applications

January 17, 2023
  1. Open a text editor and copy the script below:

$proc = get-process -Name "<process name>"

if([bool]$proc) {

Write-Output "The process is present"

} else {

Write-Output "The process is not present"


$EmailFrom = "<from email>"

$EmailTo = "<to email list (semicolon separated)>"

$Body = "<email body>"

$Subject = "<email subject>"

$SMTPServer = "<SMTP server>"

$SMTPClient = New-Object Net.Mail.SmtpClient($SmtpServer, 25)

$SMTPClient.EnableSsl = $false

$SMTPClient.Send($EmailFrom, $EmailTo, $Subject, $Body)

}

To use the script, follow these steps:

  1. Change the "<process name>" to the name of the process you want to track. This name can be found in Task Manager or Process Monitor.

  1. Change each of the email properties enclosed in < > to your desired values.

  1. Save the script as a .ps1 file.

  1. Schedule the script to run by WIndows Scheduler, Schedule Manager, or any task scheduling application.

Comparing Report Builder and Microsoft Visual Studio

January 16, 2023

Report Builder

Visual Studio

Explanation

A noticeable difference between Report Builder and Microsoft Visual Studio is the complexity of their designs. Report Builder is a much simpler environment, containing fewer windows and options.

Report Builder is essentially a slimmed down version of Visual Studio. In Report Builder, there is no solution to load; thus, you do not connect to a Source Control like TFS as you would in Visual Studio. Also, you do not need to get the latest version or check in to save any changes in Report Builder, you simply save the report as you would saving any regular file.

Report Builder opens reports directly from the Report Server and saves the reports there; thus, no local files are managed.

In Visual Studio, a Report Solution is created to house all of the reports, then the solution is deployed to the Report Server.

Report Builder is a much quicker method for building and deploying reports as they are easily saved, and access can be distributed without having to install Visual Studio on every machine. The access is simply based on getting to the Report directory.

Performance wise, both Report Builder and Visual Studio run very similarly, processing the logic behind datasets and report objects, and producing error messages as they are encountered.

Report Builder Directory

Visual Studio Solution

Note. The Visual Studio Solution contains the reports.

Setting Up a Computer/Server to Use a Static IP

January 11, 2023

Major Considerations

  1. This article is intended for Windows users.

  1. Make sure you have the Static IP address information provided by your internet provider.

Steps

  1. Click on the Windows button and type "Control Panel."

  1. Open Control Panel.

  1. Click on Network, then Sharing Center.

  1. Click on Connections (located under Access Type).

  1. Click on Properties.

  1. Left-click on Internet Protocol Verion 4 (TCP/IPv4).

  1. Click on Properties.

  1. Under the General Tab, switch "Obtain an IP address automatically" to "Use the following IP address."

  1. Enter the IP address, Subnet Mast, and Default Gateway (sometimes called router) that was given to you by your internet provider.

  1. Switch the "Obtain DNS server address automatically" to "Use the following DNS server address" that was given to you by your internet provider.

  1. Click OK, then close.

Common Database Update Error #1: Invalid Syntax

January 10, 2023

The Problem

When applying a UDP as part of an upgrade for a database that contains custom database objects, the process will halt with an invalid syntax error if any of those custom database objects have names that contain a special character.

The Cause

Fundamentally, this issue is caused by missing '[ ]' around object names that the upgrade process reads from the data dictionary. Therefore, even if you are able to create an object with or rename an existing object to a name that contains an illegal character using '[ ]', the database upgrade process can fail.

The Resolution

The error message will contain the name of the DB object, which you can use to find the object in SSMS. Once you have access to the object, change its name to one that does not contain an illegal character. Once the upgrade is complete, you can return to SSMS and change the name back to its original form to minimize impact.

Exporting Data from SQL Into an Excel Document

January 3, 2023
  1. (Optional): Download and install the SQL Server Management Studio latest release from the following location:
    https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

  1. Open SQL Server Management Studio from your Windows desktop.

  1. On the Connect to Server pop-up window, enter the server, user, and password details.

  1. Once connected, locate the query you want to run to pull your data

Note. You may have been provided a .SQL file or you may have the query text stashed elsewhere, it is up to you to identify the appropriate SQL query.

  1. Open the .SQL file using the "Open" option in the "File" menu in SSMS OR click "New Query" in the toolbar and copy/paste in your query.
  1. (Optional): Modify your query with any filter, date, or other changes required.

  1. Highlight/select the portion of the SQL text you would like to execute OR if you want to execute the whole script, highlight/select nothing.

  1. From the toolbar and click on the "Execute" button.

  1. On the "Results" pop-up panel at the bottom, right-click any column header and select "Select All" from the menu.

  1. On the "Results" pop-up panel at the bottom, right-click any highlighted/selected cell and choose "Copy with Headers".

  1. Open a new blank Excel document.

  1. Select any empty cell and hit the Ctrl+A keyboard combination to select all cells.

  1. From the "Home" tab in the ribbon, change the number format from "General" to "Text" in the drop down of the "Number" section
Note. This step is critical to prevent Excel from changing your data (like removing leading zeroes, treating dates as numbers, etc.).

  1. Right-click on cell A1 and choose "Paste" from the menu.

DB Refresh for 81+ Services Framework Deployment

October 1, 2022

Major Considerations

  1. The Expert Database has several areas where environment resources could be "crossed," leading to some risk when performing a database refresh. Examples include:
  • CFM_CONFIGURATION_VALUE, and CFM_CONFIGURATION_NAME, where custom, environment-specific URLs or file paths can be stored.
  • DDM_PATHS, where environment-specific DocuDraft paths are stored.
  • SQL Service Broker queues managing business eventing messages.
  • Workflow data.

  1. Customization packages are stored in the database, and any customizations that are in the target DB (i.e., the database being overwritten) will be lost during the refresh.

  1. Database and domain customizations will also be lost in the refresh, so it is best to ensure tha there is a functioning DEV database that acts as the system of record for customization packages prior to refreshing the TEST database.

Steps

  1. Extract/Save all customization content or data in the target DB.

Note. See Major Considerations 2 and 3.

  1. If a TEST deployment already exists, save a copy of the environment manifest from Deployment Manager.
  • Run deployment manager as administrator.
  • Select target environment.
  • Choose Advanced Options from the ribbon bar.
  • Click on Export in the bottom left.
  • Save to an appropriate location on the disc: e.g., C:\AderantExpert\Install.
  • Exit out of dialogs and Deployment Manager.

  1. Back up the source DB.

  1. Back up the target DB.

  1. Back up any target destination deployment files:
  • ExpertSource, typically located at: C:\Aderant\Deployments\<Destination Deployment Files> on the deployment machine.
  • ExpertShare, located at the path indicated in the Environment tab of Deployment Manager.
  • Target Application Server Files, typically located at C:\AderantExpert on the application servers, but the direct path can be accessed from the "Role Servers" dialog on the Expert tab of Deployment Manager.

  1. Close all open files in the ExpertShare for the target environment.

  1. Remove the existing target deployment by opening Deployment Manager and selecting "Remove" from the Ribbon.

  1. Delete the ~\<Environment Name>\Services\Workflow directory on the test application servers, where "~" is the path from step 5c above.

  1. Clear all connections/transactions to the target DB.

  1. Restore the target DB from a backup of source DB created in step 3.

  1. Delete target ExpertSource files that were backed up in step 5a.

  1. Copy the source ExpertSource files into the target ExpertSource location.

  1. Run the clear environment SP, which ships with Expert:

  • exec ClearEnvironmentFromDatabase
  • @workflowDatabaseName='<TARGET DATABASE NAME>',
  • @preserveWorkflowData = 'Y'

Note. If you are not interested in preserving workflow definitions, you can also pass 'N' as the flag to @preserveWorkflowData.

  1. Ensure that the owner of the database is CMSDBO:
  • sp_changedbowner 'CMSDBO'

  1. Run SQL from Appendix 1 to clear Workflow instances.

  1. If the database has been restored form a different database server, remap the server logins using SQL from Appendix 2.

  1. Copy the workflow directory from one of the source app servers to all of thre target app servers.

e.g. \\SOURCEAPPSERVER\e$\AderantExpert\SOURCE\Services\Workflow to\\TARGETAPPSERVER\e$\AderantExpert\TARGET\Services\Workflow

  1. Deploy target environment.
  • Run deployment manager.
  • Select target environment from the ribbon bar or select Add if destination environment has not been set up before.
  • Click OK when manifest missing prompt appears.
  • When the environment wizard appears, click on Import and choose the environment file created in Step 2, or use the wizard if destination environment has not been set up before.
  • Select No when prompted to deploy.
  • Verify settings.
  • Correct Monitoring Database Name.
  • Deploy.

  1. Execute SQL script on the target database to link all workflow definitions to the new environment manifest:

Update WFM_WORKFLOW_DEFINITION set ENVIRONMENTID = (Select ID from FWM_ENVIRONMENT)

  1. Verify deployment by checking Service Monitor or using the Validate Environment button from the Deployment Manager ribbon menu.

  1. Check successful deployment:
  • Run configuration manager.
  • Run Expert Time.
  • Other Services Framework apps used by firm.

  1. Change DocuDraft paths using SQL from Appendix 3.

  1. Copy DDTEMPLT and DDVIEWS folders from source to target location as needed if files have changes.

Appendix 1

?

Appendix 2

?

Appendix 3

?

BROWSER BEWARE – Modern browsers to start assuming internal apps are insecure

SOLUTION

To comply with modern security, servers should be compliant with HTTPS standards, which includes signing web bindings with a valid SSL certificate. This requires that you update the configuration on several servers including database and web/app servers in addition to configuring any networking appliances between those servers and client machines (e.g., load balancers). Please see the sections below for guidance when configuring your environment with appropriate SSL bindings.

      - HOW TO CONFIGURE HTTPS ON AN EXPERT FRAMEWORK APPLICATION SERVER - To confirm and configure HTTPS on Aderant Expert framework application servers

      - HOW TO IMPORT CERTIFICATES INTO IIS - To import certificate files onto application servers, including Aderant Expert framework application servers

      - HOW TO CONFIGURE HTTPS FOR SECURE ACCESS TO REPORTS VIA SSRS - To confirm and configure HTTPS on your SQL Server Reporting Services servers

 

HOW TO CONFIGURE HTTPS ON AN EXPERT FRAMEWORK APPLICATION SERVER

To ensure your binding is configured correctly for application servers using IIS as a web host, follow the steps below:

     1.      Open IIS Manager on an Aderant Expert Application Server (Start menu, Run, "inetmgr")

IIS Manager - Main window

     2.      Select the web site host for your application services, in this case the "Default Website" under the Server > Sites node

     3.      Click on the "Bindings..." option under Actions on the right of your window

IIS Manager - Bindings

     4.      Verify that you see an HTTPS entry. This confirms that an https binding on 443 is enabled

Site Bindings - Bindings list

             a.      If there is an HTTPS entry

                      i.     Confirm that the binding is using a valid SSL certificate by selecting the HTTPS item and clicking on the "Edit" button

                      ii.     On the Edit Site Binding screen, ensure an SSL certificate is selected and click "View..."

Edit Site Bindings

                      iii.    Ensure the certificate attached is valid, non-expired, and not a self-signed certificate

                                   1)     If your certificate is not valid, choose a valid certificate from the dropdown

                                   2)     If there are no valid certificates listed, see the "HOW TO IMPORT CERTIFICATES INTO IIS" section to import your company's certificates.

             b.     If there is no HTTPS entry

                      i. Click on the "Add..." button

                      ii. On the Edit Bindings Screen, enter the following and click "OK"

                               - Type = HTTPS

                               - Port = 443

                               - IP Address = use the value from your HTTP entry (either "*" or a specific IP address)

                               - SSL Certificate = choose a valid certificate from the drop-down

                                  Note. If there are no valid certificates listed, see the "HOW TO IMPORT CERTIFICATES INTO IIS" section to import your company's certificates.

     5.      Open a PowerShell or Command Prompt in Administrator mode, type "IISRESET"(no quotes), and hit Enter

      NOTE. If the certificate used is a local, self-signed certificate, it will NOT be trusted by another machine even on the same LAN as this setup is intended for non-production, single-server scenarios.

HOW TO IMPORT CERTIFICATES INTO IIS

For a test or production server that accepts traffic from other machines, you would need to associate the binding with your company's appropriate SSL certificate. To do that, follow the steps below:

      1.      Open IIS Manager on the Application Server (Start menu, Run, "intemgr")

      2.      Select the server node in the navigation area on the left

      3.      Double-click Server Certificates item from the central menu

IIS Manager - Server settings list

      4.      Click the Import option in the right-hand menu

              This will present the Certificate Import Wizard that allows you to import the certificate.

              NOTE. It is considered best practice to NOT allow certificate exporting on a non-certificate store server, so our recommendation would be to uncheck the “Allow certificate to be exported” box when prompted.

Certificate Import Wizard

      5.      Follow the Certificate Import Wizard until successful completion, selecting your certificate file, and providing other details as required

      6.      Open PowerShell as an administrator and issue the command “iisreset” to ensure that incoming traffic is handled appropriately

      7.      Return to your IIS bindings settings from the section "CONFIRM OR CONFIGURE HTTPS ON AN EXPERT FRAMEWORK APPLICATION SERVER" to select your newly imported certificates for use in the HTTPS binding (Step 4 a iii 1)

     NOTE. It is considered best practice to NOT allow certificate exporting on a non-certificate store server, so our recommendation would be to uncheck the “Allow certificate to be exported” box when prompted.

 

HOW TO CONFIGURE HTTPS FOR SECURE ACCESS TO REPORTS VIA SSRS

 

From the SSRS Server desktop

     1.      Click the Start menu and search for “Manage Computer Certificates” to launch the certIm mmc snap-in

     2.      Right-click on the “Personal” node (as of this writing, this is the location required by Microsoft) and choose “All Tasks -> Import” from the menu.

              This will present the Certificate Import Wizard that allows you to import the certificate.

              NOTE. It is considered best practice to NOT allow certificate exporting on a non-certificate store server, so our recommendation would be to uncheck the “Allow certificate to be exported” box when prompted.

     3.      Follow the Certificate Import Wizard until successful completion, selecting your certificate file, and providing other details as required

     4.      Open the Report Server Configuration Manager application and connect to your SSRS server.

     5.      Perform a Stop and Start the SSRS service

     6.      Navigate to the Web Service URL item in the Report Server Configuration Manager and associate your certificate with port 443 for HTTPS by selecting it from the HTTPS Certificate dropdown

     7.       Navigate to the Web Portal URL page and click the “Advanced” button

     8.      Click “Add” under HTTPS Identities and associate the appropriate certificate with port 443: