Topics > DataPlus Microsoft Accounting Integration > DataPlus 4.0, 3.0 Microsoft Dynamics GP > FAQ ID # 15

FAQ ID # 15
Last Update : 2014/02/07
Print this FAQ

Question / Issue
DataPlus 4.0, 3.0 for Microsoft Dynamics GP - Server Installation

Answer / Solution
PROGRAM: DataPlus for Microsoft Dynamics GP - Server Installation
What you need prior to installation.
  1. MS SQL Server or MS SQL Express instance
    - SQL 2008 Microsoft Download
    - SQL 2005 Microsoft Download
  2. SQL Server Management Studio
  3. Understanding roles in SQL Server security
    - Database-Level Roles msdn
    - Security TechRepublic
  4. Microsoft Dynamics GP
    - Note: SQL instance for DataPlus must be installed on same SQL instance that Microsoft Dynamics GP is installed on.
  5. ACT! Prem 2013 (for DataPlus 4.0)
    - Installed on server or workstation
    - ACT! Database configured
    - Note: DataPlus ACT! database should be downloaded and restored.
  6. ACT! Prem 2012, 2011, 2010 (for DataPlus 3.0)
    - Installed on server or workstation
    - ACT! Database configured
    - Note: DataPlus ACT! database should be downloaded and restored.

What you need for installation.
  1. DataPlus for Microsoft Dynamics GP
    - DataPlus-MDGP-Install.exe
  2. ACT! Software
    - ACT! Premium for Web (if you are using it)
    - ACT! Premium
  3. DataPlus ACT! Database for Microsoft Dynamics GP
    - or your custom database

Where do you install DataPlus for Microsoft Dynamics GP.
  1. When Microsoft Dynamics GP and ACT! are on the same server
    - Install: Server and Client components.
  2. When ACT! is on a different server than Microsoft Dynamics GP
    - Install: Server and Client components on server where ACT! is installed
    - When you perform the Server install, configure pointing to the Microsoft Dynamics GP server
  3. When ACT! is installed on a Client machine
    - Install: Client component

Summary Steps.
  1. Microsoft Dynamics GP must be installed
  2. ACT! should be installed
  3. ACT! database should exist or if your using DataPlus ACT! database, it should be restored
  4. Install DataPlus Server & Client components
  5. Configure DataPlus Server & Client
  6. Import "Employee Update" only
  7. Create ACT! users based on Employee and ACT! user count
  8. Import all

Approximant Time Table
  • 10 minutes - Documentation Review
  • 10 minutes - Approximant Time for Server Installation
  •   2 minutes - Approximant Time for Server Configuration
  • 22 minutes - Total Approximant Time for Server Installation & Configuration
Table of Contents
DataPlus 3.0 Server & Client Installation

DataPlus Installation
    Welcome Screen
  1. Right click 'DataPlus-MDGP-Install.exe' and Run as administrator
  2. Click on Next >
    License Agreement
  1. If you agree, click on "I accept the terms in the license agreement"
  2. Click on Next >
    Choose Components
    Condition
    ACT! not installed on this server

    Server Components

  1. Check Master Database
  2. Check MDGP Server
  3. Click on Next >

    If ACT! is installed on this server go to next step

    Choose Components
    Condition
    ACT! is installed on this server

    Client Components

  1. Check DataPlus Client
  2. Check MDGP Client

    Server Components

  3. Check ACT! Import
  4. Check Master Database
  5. Check MDGP Server
  6. Click on Next >
    Choose Location
  1. Choose the folder in which to install DataPlus
  2. Click on Install
    Installing
    Server Credentials
    Server Settings
  1. Server Name: ServerName\Instance SQL Instance if applicable
  2. Database Name: dpMDGP database name

    Credential Settings

  3. User: sa
  4. Password: password
  5. Check if you want integrated security
  6. Click on Next >
    Notice of Installation
  1. Click on Yes
    Database Create
  1. Click on Yes
    Database Create Finished
  1. Click on Finish
    Microsoft Dynamics GP Installer
    Microsoft Dynamics GP Setting
  1. Company DB: TWO
    Note: Microsoft Dynamics GP database name

    DataPlus Server Settings

  2. Server Name: ServerName\Instance SQL Instance if applicable
  3. Database Name: Database DataPlus database name
  4. User: sa SQL or Windows user name
  5. Password: password user name password
  6. Check if you want integrated security
  7. Next >
    Notice of Installation
  1. Click on Yes
    Microsoft Dynamics GP Installer Complete
  1. Click on Finish
    Installation Complete
  1. Click on Next

DataPlus Server Setup and Configuration
    Server Configuration
  1. CHECK to run Server Configuration
  2. Click on Finish
Perform configuration if ACT! is not installed on this server.

    Server Configuration Manager
  1. Click on Close

 You have completed the Server installation and configuration with ACT! not installed on server.

 If you do have ACT! installed on this server, then proceed to next stop.

DataPlus Server/Client Setup and Configuration
    Server Configuration
  1. CHECK to run Server Configuration
  2. Click on Finish
    Server Configuration Manager
  1. Click on Configure Applications >>
    Configuration
    Application Profiles
  1. Click on MDGP
    Application Settings
    ACT Credentials
  2. Database; ActDatabaseName click on [..] to browse to database
  3. User Name: ActUserName must be an ACT! administrator
  4. Password: ActPassword
  5. Confirm: ActPassword
  6. Test Connection
  7. Click on OK

    Database Configuration

  8. Database: dpMDGP DataPlus database name
  9. Server: ServerName\Instance SQL Instance if applicable
  10. SQL User: sa
  11. SQL Password: password
  12. Check if you want integrated security
  13. Test Connection
  14. Click on OK
  15. Click on Update

    ACT Import Settings

  16. Import Options: Click on [ ... ] to open options
    Import Options
    General Options
  1. Check Disable Database Locking
  2. UnCheck Limited Notices
  3. UnCheck Ignore Warnings
  4. UnCheck Skip Date Check
  5. UnCheck Exclude Sample Data
  6. UnCheck Disable ACT time globalization
  7. UnCheck Disable SQL time globalization
  8. Set Server Timeout (minutes) (default = 2 +)

    Entity Options

  9. UnCheck Disable creation of ACT! Contacts
  10. UnCheck Disable creation of ACT! Companies
    Check "Disable creation of ACT! Companies" if you do not want to import Companies in the "Company Level" in ACT!
  11. UnCheck Only Import Primary Contacts
    Check "Only Import Primary Contacts" if you only want to import primary contacts. Contacts that are not listed in the e-automate Company "Attn To" field will not import.
  12. UnCheck Create Fields Only

    Import Selection

  13. UnCheck Only Run Selected Items
  14. UnCheck Remove Selected Items (greyed out, unless Selected Items are checked)

    Advanced Options

  15. UnCheck If you are not using Limited Access in ACT!
  16. Check If you are using Limited Access in ACT!

    Select Users and Teams
    If you are using ACT! Limited Access, you can choose:

  17. Specific ACT! Team(s)
  18. Specific ACT! User(s)
  19. Click Okay

    IMPORTANT:
  • If you are not using the ACT! database provided by Hogan Data, for Microsoft Dynamics GP, when the first import is performed, additional fields may be required. Therefore, uncheck "Disable Database Locking" in order for the additional fields to be created.
  • By default, if the "Sales Representative" in Microsoft Dynamics GP equals the ACT! User Name in ACT!, the Sales Representative name will populate the "Sales Representative" field in ACT!, and will also be the ACT! "Record Manager". The names have to be an exact match.
    Configure Profiles
    Application Profile
  1. Right click MDGP
    Configure Profiles
    Application Profile
  1. Right click MDGP
  2. Click on Generate Sample Import Command
    Sample Command Line
  1. Logs entire line details (We recommend "Verbose Logging")
    Verbose Logging
  2. Click on Copy
  3. Click on Close

    Or

    Limited Logging

  4. Log summary details
  5. Click on Copy
  6. Click on Close
    Import-PT.bat
  1. In Windows, browse to:
    C:\Program Files\Hogan Data\DataPlus 4.0
    or
    C:\Program Files (x86)\Hogan Data\DataPlus 4.0
  2. You will find 2 bat files
    Import-MDGP (TSD32BIT).bat
    Import-MDGP (TSD64BIT).bat
  3. By default the bat file will import the "Default" setting created.

    OR

  4. Create new file "Import-MDGP.bat"
  5. Right click on Import-MDGP.bat
  6. Click Edit
  7. Right click Paste

    IMPORTANT

  8. Change DataPlus-Import-Console.exe path to FULL PATH within Quotes(")
    "C:\Program Files\Hogan Data\DataPlus 4.0\DataPlus-Import-Console.exe"
  9. Change Logs path to FULL PATH within Quotes(")
    "C:\Program Files\Hogan Data\DataPlus 4.0\Logs\MDGP.log"
  10. Save file File/Save
  11. Open Microsoft Scheduler and schedule time to execute the "Import-MDGP.bat" file.

Sample Line
"C:\Program Files\Hogan Data\DataPlus 4.0\DataPlus-Import-Console.exe" /s /co:"MDGP" /pr:"Default" > "C:\Program Files\Hogan Data\DataPlus 4.0\Logs\MDGP.log"

    Configure Profiles
  1. Click on Close

DataPlus ACT! Manual Import
    Manual Import
  1. Open ACT!
  2. Click OK
    Note: DataPlus menus have not been configured. We will address this later in KB.
    Manual Import
  1. Tools/DataPlus 3.0/Manual Import
    Manual Import
  1. Click on MDGP
  2. Click on Browse
    Employee Only Import
  1. Uncheck Disable Database Locking There may be additional fields to be created
  2. Check Only Run Selected Items
  3. Check MDGP: (160) Employee
  4. Click Okay
    Manual Import
  1. Click on Import Selected
    Import Complete
  1. Click on Close

    Create Users in ACT! from Employees

  2. In ACT
  3. Tools/Manage Users
  4. Create New User
  5. Create User from Contact - Create a new User from an existing Contact.

    Manual Import All
  1. Rerun DataPlus 3.0 Manual Import
  2. Uncheck Disable Database Locking There may be additional fields to be created
    Import Complete
  1. Click on Close

DataPlus ACT! User Configuration
    Manual Import
  1. Open ACT!
  2. Click OK

 Note: DataPlus menus have not been configured. When DataPlus is configured in the following steps, this message will be disabled.

    Manage Permissions
  1. In ACT!
  2. Tools/DataPlus 3.0/Manage Permission
    View Permissions
    Current Connections
  1. Click MDGP

    Permissions

  2. Click View Permissions
  3. Check Box for each "View Name" that will be accessed by "ACT! User"
    You can double click the header or row to check or uncheck all
    Misc Permissions

    Permissions

  1. Click Misc Permissions
  2. Check Box for each "Task" that will be accessed by "ACT! User"
  3. View - enable views in ACT! DataPlus tab (overrides View Permissions)
  4. Export - export view to excel
  5. Report - currently not available
  6. MDGP Push - create/edit customers from ACT! to Microsoft Dynamics GP
    Note: You can double click the header or row to check or uncheck all
    Sales Representative Permissions

    Permissions

  1. Click Sales Representative
  2. Check Box for each sales representative for view permissions
    Note: You can double click the header or row to check or uncheck all
  3. Click Save
  4. Click Close
  5. Click Yes
  6. Click OK

Note:

  • Most views have the "Sales Representative" from Microsoft Dynamics GP listed. Each Sales Representative will only be able to see view where they are the Sales Representative.
  • You can also enable Sales Representative to see other Sales Representative information. Example, sales manager may need to view each Sales Representative's views on their team.
  • DataPlus Tab should be available for each DataPlus Client after "DataPlus Client Install".

Related FAQs
DataPlus 4.0, 3.0 Microsoft Dynamics GP - Client Installation
Error connecting to SQL Server. A network-related or instance-specific error occured while establishing a connection to SQL server!

Direct Link to This FAQ
http://kb.hogandata.com/?f=15

Back to Top