FAQ ID # 84
Last Update : 2016/03/15
Print this FAQ

Question / Issue
DataPlus WebForm Basic 4.0 - Configuration

Answer / Solution

PROGRAM: DataPlus WebForm Basic - Configuration
Table of Contents


    DataPlus WebForm Basic - Configuration
      SQL Management Studio (SSMS)
    1. Open SQL Management Studio
    2. Choose and expand dpWebForm Database
    3. Expand Tables

      Sample Data - SQL Tables

    4. wf.FRM_ContactUs is a sample table
      Sample Data - SQL Views
    1. There are 2 files related with the wf.FRM_ContactUs database
    2. wf.vl_FRM_ContactUs
      This view reads the table. Your view would relate with your table or linked server data.
    3. wf.afu_FRM_ContactUs
      This view reads the wf.vl_FRM_ContactUs view. It formats the column names and outlines what is to be imported into Act.
      Sample Data - SQL Procedures
    1. wf.spAct_WF_100_FRM_ContactUs procedure reads the wf.afu_FRM_ContactUs view
    2. There are extended properties associated with each procedure created
      Extended Properties
    1. @name='ActType', @value='MasterContact' ... Used for contact primary fields
    2. @name='ExecuteOrder', @value='100' ... Used to determine order of import
    3. @name='FriendlyName', @value='(100) Act Contact' ... Used to determine friendly name
    4. @name='SourceView', @value='wf.afu_FRM_ContactUs' ... SQL view source for procedure

      Additional Extended Properties

    1. @name='ActType', @value='Company' ... Used for company primary fields
    2. @name='ActType', @value='CompanyInformation' ... Used for additional company information
    3. @name='ActType', @value='CompanyFinancial' ... Used for additional company financial information
    4. @name='ActType', @value='ContactInformation' ... Used for additional contact information
    5. @name='ActType', @value='ContactFinancial' ... Used for additional contact financial information
    6. @name='ExecutionTies', @value='wf.afu_FRM_CompanyContactUs' ... Used to tie procedure to a prior procedure to be executed


    DataPlus WebForm Basic - Connections

      MySQL Connection

    1. Server=IP ADDRESS;
    2. Port=3306;
    3. Database=databasename_identifier_string;
    4. User=username;
    5. Password=Password;
    6. Option=3;'


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

    Back to Top