Company: Link Technologies
Case No: L09298. Project: 09.40: LinkSOFT Version 9.4
Logged By: Alvis (Link Technologies) on 16 May 2018 03:28PM
Priority: High
Product: Financial & Asset Management
Group: New Feature
Time Taken: 7.00 (Weight: 7.00)
Version: 9.496.1128
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Wednesday, 16 May 2018 12:00 AM [2170 days since logged date]
Status: Closed
Subject: Merge FMSPORTAL to LinkSOFT database
Summary:    

Merge FMSPORTAL to LinkSOFT database

Justification:

  1. Clients using JIWA 7.1 integration to LinKSOFT 9.4 are not able to use FMSPORTAL 8.15.
  2. Integration to JIWA uses the same framework in FMSPORTAL and LINKSOFT. Both these applications must be released together so that clients can be upgraded without compatibility issues.
Audit Notes:
16 May 201803:28PM Comment 1 by Alvis (Link Technologies) Case 9298 added to project 09.4
16 May 201803:51PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 16-05-2018 03:51 PM Time Taken: 4.00
Development work for this case has been completed.
The change will be available in version: 9.4 Beta3

1. The following changes were made(Include Database object names, Program classes and any other relevant information):|

  1. Added FMSPORTAL application to LINKSOFT database
  2. Prepared data import utility to pull data from FMSPORTAL database. 
    1. Use script to import data:

      EXEC [dbo].[LT_FMS_UTILITY_ImportDataFromDatabase]

      @Username = '' --Enter username

      ,@Password = '' --Enter password

      ,@ServerName = '' --Servername where FMSPORTAL database is located. Leave blank if LINKSOFT and FMSPORTAL databases are on the same SQL instance.

      ,@DatabaseName = '' --FMSPORTAL database Name

      ,@FMSPortalCompanyID = '' --Company ID in FMSPORTAL database

      ,@LinkSOFTCompanyID = '' --Company ID in LinkSOFT database

      ,@ImportAsset = 0 --Import Asset data flag

      ,@ImportFMS = 0 --Import Debtors, Purchase data flag

      ,@ImportIntegrationTransactions = 0 --Import integration transactions flag. Set this to 0 if FMSPORTAL database is version 8.15 and below.


    2. After importing data, configure the following:

      1. Configuration Next numbers

      2. Other configuration settings

      3. Integration to JIWA

2. The issue was caused by:

  1. N/A

    3. Next Step

    1. UAT

    24 May 201802:56PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 24-05-2018 02:56 PM Time Taken: 1.00

    System test completed.

    Verified the following:

    1. Link Web installs the FMSPortal site
    2. Utility script imports data from the FMSPortal database into the LinkSOFT database.

    regards
    Alvis


    24 May 201802:57PM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 24-05-2018 02:57 PM Time Taken: 1.00

    System test completed.

    Verified the report "Licence Revenue Analysis Report" shows data in FMSPortal.

    regards
    Alvis


    05 Jun 201803:43PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 06-06-2018 12:00 AM Time Taken: 1.00

    Hi Sanjay, 

    This case has been successfully tested.

    Documentation is not required for the case.

    Test Environment

    Test Plan

    1. FMSPortal is successfully installed with the Link Installation.
    2. FMSPortal was successfully hosted and browsed.
    3. FMSportal and JIWA integration was successfully created.
    4. Reports were successfully generated in FMSportal
    Thanks

    Rashna


    06 Jun 201806:15PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-06-2018 06:15 PM
    Thanks Rashna 

    09 Oct 201908:14AM Comment 7 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019
    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L09298 in the subject line of all emails regarding this issue.

    Document size: 8.2 KB
    For call complaints, please contact the Managing Director of the company using this form.