Difference between revisions of "Workstation Installation Instructions"

From Agency Systems Wiki
Jump to navigation Jump to search
(→‎Setup the Agency Systems Icon: added note about 64 bit microsoft office)
 
(48 intermediate revisions by 3 users not shown)
Line 1: Line 1:
[[Category:Installation]][[Category:Pervasive]]
+
[[Category:Installation]][[Category:Pervasive]]  
Adding Newton by Agency Systems to a workstation requires the installation of Pervasive.   The instructions below reference the most current version of pervasive, however your office may be running an older version. Since all versions of Pervasive on the same network must match, please contact [http://www.agencysystems.com/support Agency Systems Support] to verify the installed version before proceeding.
+
<table class="infobox" cellspacing="5" style="background-color: #FFFFFF; width:27em; text-align:left; border-spacing: 2px; line-height:1.5em;">
 +
<tr>
 +
    <td>[[File:Ic_description_black_24dp.png|link=Newton User Guide#Installation]] Newton User Guide: [[Newton User Guide#Installation|Installation]]</td>
 +
</tr>
 +
<tr style="background-color: #bdbdbd; text-align: center; font-weight:bold;">
 +
    <td>Related Pages</td>
 +
</tr>
 +
<tr>
 +
<td>
 +
<ul>
 +
<li>[[Backup Information]]</li>
 +
<li>[[Hardware Recommendations]]</li>
 +
<li>[[Installation Environment and Network Requirements]]</li>
 +
<li>[[Make Text and Other Items Larger or Smaller]]</li>
 +
</ul>
 +
</td>
 +
</tr>
 +
<tr style="background-color: #d3d3d3; text-align: center; ">
 +
    <td>Related Categories</td>
 +
</tr>
 +
<tr>
 +
<td>
 +
<ul>
 +
<li>[[:Category:Installation|Installation]]</li>
 +
</ul>
 +
</td>
 +
</tr>
 +
</table>
 +
*Verify the workstation is running: Microsoft Windows 10 or higher
  
== Windows 8 / 7 / Vista ==
+
*Review the [[Installation Environment and Network Requirements]] and [[Hardware Recommendations]].
 +
 +
*You will need to be logged in as a local Administrative user.
 +
 
 +
*Install the [[#Newer MariaDB Version Build 9200+|MariaDB]] '''OR''' the [[#Older Pervasive Client Installation|Pervasive]] version, not both.
 +
 
 +
 
 +
 
 +
== Map the Network Drive ==
 +
'''Map the drive as an Admin'''
 +
#Click the Microsoft Windows Start Menu.
 +
#Enter '''cmd''' in the start search box.
 +
#Right-click '''cmd.exe'''
 +
#Select '''Run as Administrator'''. This step is critical, even if you are already logged into the machine as Administrator.
 +
#:[[File:WorkstationInstall1.jpeg]]
 +
#You will see the Command Prompt box open with Administrator.
 +
#:[[File:WorkstationInstall2.jpeg]]
 +
#Enter the following commands where X: is the drive letter for your office & "servername" is your actual server's name.
 +
#Verify '''The command completed successfully.'''
 +
'''net use x: \\servername\APPS'''
 +
:[[File:WorkstationInstall3.jpeg]]
 +
'''Map the drive as a User'''
 +
#Click the Microsoft Windows Start Menu.
 +
#Enter '''cmd''' in the start search box.
 +
#Left-click to open the command prompt.
 +
#Enter the following commands where X: is the drive letter for your office & "servername" is your actual server's name.
 +
'''net use x: \\servername\APPS'''
  
Verify the workstation is running one of the following:
 
Microsoft Windows 8 / Windows 7 / Windows Vista
 
  
Review the [[Network Requirements]] and [[Hardware Recommendations]].
+
== Newer MariaDB Version Build 9200+ ==
+
Open a '''new''' command prompt as Administrator.
You will need to be logged in as a local Administrative user.
+
  '''x:'''
+
'''cd empire'''
==== Map the Network Drive ====
+
  '''Adduser.exe'''
Map a network drive to the share directory containing the empire folder on the Server/Master machine. It is recommended to use the same drive letter on every machine in the officeFor the examples below the letter X: will be used. Substitute X: with your drive letter as needed.  
+
Close the command prompt
 +
Launch Newton from the newly created desktop shortcut
  
;Example:<tt>
 
:Server Name: SERVERNAME
 
:Shared Folder: APPS
 
:Mapped Path: X:\APPS\ </tt>
 
  
[[File:Mapnetworkdrive-gui.png]]
 
  
Optionally, the drive can be mapped from a cmd.exe prompt.
 
net use X: \\SERVERNAME\APPS
 
  
==== Install the Pervasive Client ====
+
== Older Pervasive Client Installation ==
Browse to X:\Empire\ and run the pervasive installer PSQ11.3Client32.exe.   The version number of 11.3 may be different if you are using an older version of Pervasive.  
+
Open a '''new''' command prompt as Administrator.
+
'''x:'''
If the file does not exist, download it from the following location and save it to the X:\Empire\ folder on the server.
+
'''cd empire'''
 +
'''PSQL11.3Client32.exe'''
 +
#Select '''Yes'''
 +
#:[[File:WorkstationInstall4.jpeg]]
 +
#Select '''Unzip'''
 +
#:[[File:WorkstationInstall5.jpeg]]
 +
#Select '''Ok'''
 +
#:[[File:WorkstationInstall6.jpeg]]
 +
#Select '''Install'''
 +
#:[[File:WorkstationInstall7.jpeg]]
 +
#Select '''Next'''
 +
#:[[File:WorkstationInstall8.jpeg]]
 +
#Select '''I accept...'''
 +
#Select '''Next'''
 +
#:[[File:WorkstationInstall9.jpeg]]
 +
#Select '''Run as a Service'''
 +
#Select '''Next'''
 +
#:[[File:WorkstationInstall10.jpeg]]
 +
#Select '''Complete'''
 +
#Select '''Next'''
 +
#:[[File:WorkstationInstall11.jpeg]]
 +
#Select '''Install'''
 +
#:[[File:WorkstationInstall12.jpeg]]
 +
#Select '''Finish'''
 +
#Select '''Exit'''
 +
*Disregard and Close the internet window.
 +
:[[File:WorkstationInstall13.jpeg]]
  
http://www.asfiles.com/PSQL/PSQL11.3Client32.exe
+
=== Configure Pervasive Settings ===
+
Close the old command prompt & Open a '''new''' command prompt as Administrator.
Take all of the defaults except, select "Install as Service" when prompted.
+
'''PCC'''
+
#Select '''Tools''' > '''ODBC Administrator or 32bit ODBC Administrator''' (Not 64bit).
==== Setup Client Data Source Name (DSN) ====
+
#Select the '''System DSN''' >  '''Add''' (If Agyforms is not already configured).
#Select the Microsoft Windows Start Menu.  
+
#Choose '''Pervasive ODBC Client Interface''' and select Finish.
#Enter '''PCC''' in the start search box then select Ok.
+
#Type '''AGYFORMS''' in the Data Source Name field.
#Select '''Tools -> ODBC Administrator''' or '''32-bit ODBC Administrator''' if using a 64-bit operating system.
+
#Enter '''Your''' Server Name in the Server Name/IP field.
#Select the '''System DSN''' tab and then select Add.
+
#Select '''Get List'''.
#Highlight '''Pervasive ODBC Client Interface''' and select Finish.
+
#Verify '''Agyforms''' is selected in the drop down box named Database Name.
#Under Data Source Name enter '''AGYFORMS'''
+
#Select '''Test''' and select '''OK''' once the Connection Successful box appears.
#Enter the full server name in the Server Name/IP: field and select Get List.
+
#Select '''OK''' to create the Client DSN.
#Verify AgyForms is selected in the drop down box named Database Name.
+
#'''Exit''' the ODBC Administrator.
#Select Test and select Ok once the Connection Successful box appears.
 
#Select Ok to create the Client DSN.
 
#Exit the ODBC Administrator.
 
  
==== Setup the Agency Systems Icon ====
+
=== Create Agency Systems Icon and Install Crystal Reports ===
When installing from a mapped network drive, the drive mappings are lost when the Administrator account is elevatedThis is a function of the User Access Control (UAC) in Windows. The elevated and non-elevated administrator accounts have different logon tokens and can therefore have different drive mappings.
+
Close the old command prompt & Open a '''new''' command prompt as Administrator.
 +
'''x:'''
 +
'''cd empire'''
 +
  '''Adduser.exe'''
 +
#If the workstation will have 64 bit Microsoft Office installed (Office, Not Windows), replace '''Adduser.exe''' with '''Adduser.exe /64'''.
 +
#Select '''Run'''.
 +
#Select '''Begin'''.
 +
#Select '''Finish'''.
  
#Select the Microsoft Windows Start Menu.
+
== Test Agency Systems ==
#Enter CMD in the start search box.  
+
#'''Double click''' the Agency Systems icon.
#Right-click and select Run as Administrator.  '''This step is critical, even if you are already logged into the machine as Administrator.'''
+
#Agency: '''95'''
#Enter the following commands where X: is the drive letter for your office:
+
#Operator: '''DCS'''
net use X: \\SEVERNAME\SHAREDFOLDERNAME
+
#Password: '''EMPYRE'''
X:
 
cd Empire
 
Adduser.exe
 
  
If the workstation will have 64 bit Microsoft Office installed (Office, not Windows), replace Adduser.exe with the following:
+
Once the application opens, click on one of the tabs to make sure it loads data.
Adduser.exe /64
 
  
Select Run, Begin, then Finish.
+
[[File:Ic_info_black_24dp.png]] See [[#Troubleshoot Error Codes and Other Considerations|the troubleshooting section above]] for any errors.
  
If prompted to reboot the machine select Yes.
+
== Troubleshoot Error Codes and Other Considerations ==
 +
[[:Category:Error|Category: Error Codes]]
 +
*[[Error: Crpe32.dll not found]]
 +
*[[Error: 501 Job Failed]]
 +
*[[The Easy MAPI COM Server is needed to use MAPI in a "Cross-Bitness" environment]]
  
== Potential Error Codes After Installation ==
+
Display Issues
[[Error: Crpe32.dll not found]]
+
*[[Display Issues Printing Forms or Viewing Window Buttons]]
 +
*[[Make Text and Other Items Larger or Smaller]]
 +
*[[Transaction Number Or Code Default Text Blank]]
  
[[Error: 501 Job Failed]]
+
Other
 +
*[[Open File Security Warning]]

Latest revision as of 22:28, 17 November 2021

Ic description black 24dp.png Newton User Guide: Installation
Related Pages
Related Categories
  • Verify the workstation is running: Microsoft Windows 10 or higher
  • You will need to be logged in as a local Administrative user.


Map the Network Drive

Map the drive as an Admin

  1. Click the Microsoft Windows Start Menu.
  2. Enter cmd in the start search box.
  3. Right-click cmd.exe
  4. Select Run as Administrator. This step is critical, even if you are already logged into the machine as Administrator.
    WorkstationInstall1.jpeg
  5. You will see the Command Prompt box open with Administrator.
    WorkstationInstall2.jpeg
  6. Enter the following commands where X: is the drive letter for your office & "servername" is your actual server's name.
  7. Verify The command completed successfully.
net use x: \\servername\APPS
WorkstationInstall3.jpeg

Map the drive as a User

  1. Click the Microsoft Windows Start Menu.
  2. Enter cmd in the start search box.
  3. Left-click to open the command prompt.
  4. Enter the following commands where X: is the drive letter for your office & "servername" is your actual server's name.
net use x: \\servername\APPS


Newer MariaDB Version Build 9200+

Open a new command prompt as Administrator.

x:
cd empire
Adduser.exe

Close the command prompt Launch Newton from the newly created desktop shortcut



Older Pervasive Client Installation

Open a new command prompt as Administrator.

x:
cd empire
PSQL11.3Client32.exe
  1. Select Yes
    WorkstationInstall4.jpeg
  2. Select Unzip
    WorkstationInstall5.jpeg
  3. Select Ok
    WorkstationInstall6.jpeg
  4. Select Install
    WorkstationInstall7.jpeg
  5. Select Next
    WorkstationInstall8.jpeg
  6. Select I accept...
  7. Select Next
    WorkstationInstall9.jpeg
  8. Select Run as a Service
  9. Select Next
    WorkstationInstall10.jpeg
  10. Select Complete
  11. Select Next
    WorkstationInstall11.jpeg
  12. Select Install
    WorkstationInstall12.jpeg
  13. Select Finish
  14. Select Exit
  • Disregard and Close the internet window.
WorkstationInstall13.jpeg

Configure Pervasive Settings

Close the old command prompt & Open a new command prompt as Administrator.

PCC
  1. Select Tools > ODBC Administrator or 32bit ODBC Administrator (Not 64bit).
  2. Select the System DSN > Add (If Agyforms is not already configured).
  3. Choose Pervasive ODBC Client Interface and select Finish.
  4. Type AGYFORMS in the Data Source Name field.
  5. Enter Your Server Name in the Server Name/IP field.
  6. Select Get List.
  7. Verify Agyforms is selected in the drop down box named Database Name.
  8. Select Test and select OK once the Connection Successful box appears.
  9. Select OK to create the Client DSN.
  10. Exit the ODBC Administrator.

Create Agency Systems Icon and Install Crystal Reports

Close the old command prompt & Open a new command prompt as Administrator.

x:
cd empire
Adduser.exe
  1. If the workstation will have 64 bit Microsoft Office installed (Office, Not Windows), replace Adduser.exe with Adduser.exe /64.
  2. Select Run.
  3. Select Begin.
  4. Select Finish.

Test Agency Systems

  1. Double click the Agency Systems icon.
  2. Agency: 95
  3. Operator: DCS
  4. Password: EMPYRE

Once the application opens, click on one of the tabs to make sure it loads data.

Ic info black 24dp.png See the troubleshooting section above for any errors.

Troubleshoot Error Codes and Other Considerations

Category: Error Codes

Display Issues

Other