Company: Link Technologies
Case No: L11953. Project: 12.10: LinkSOFT version 12.1
Logged By: Sanjay (Link Technologies) on 23 Apr 2020 09:31AM
Priority: High
Product: Framework
Group: Enhancement
Time Taken: 19.00 (Weight: 21.00)
Version: 12.10.1020
Assigned To: Rashna (Edge Business Solutions)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Tuesday, 28 April 2020 07:27 PM [1456 days since logged date]
Status: Closed
Subject: Add File upload and processing functionality to LinkWEB now that we do not have direct Database access on Cloud Setup
Summary:    

Now that we allow Cloud implementations, users will not have direct database access. We need to find a way for users to upload master files, TNA files and other uploads previously imported vis EXCEL.


Audit Notes:Edited by sanjay on 28/04/20 16:53. Edited by sanjay on 28/04/20 16:52. 
23 Apr 202009:37AM Comment 1 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 23-04-2020 01:31 PM Time Taken: 12.00
Completed the following:
  1. Added file upload capability to IinkWEB in menu "Integration ~> File Import". Users can upload file extensions with DAT, CSV, TXT
  2. When a file is uploaded, each line is created in a table. The user can then review, validate and post the file data
  3. We have a DropDown that defines the data type. This will have values such as
    1. Customer Masterfile
    2. Employee Masterfile
    3. TNA Data - to be discussed

Next Step:

  1. Review and Create necessary procedures for "LT_SYS_IntegrationFileData_Select/Update/Delete"
  2. Review and Create necessary procedures for "LT_SYS_IntegrationFileDataDetails_Select/Update/Delete"
  3. Review and Create necessary procedures for "LT_SYS_IntegrationFileData_Validate"
  4. Review and Create necessary procedures for "LT_SYS_IntegrationFileData_POST"

23 Apr 202003:01PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-04-2020 06:59 PM Time Taken: 4.00

Development work for this case has been completed.

The change will be available in version:11.5

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

  1. Created the framework objects required for File Data import
  2. Added file import specifications for "Payroll Timesheet".
    File format needs to be a "CSV" file with the following columns:

    CompanyID,EmployeeCode,Date,Total Hours,Normal,Time x 1/2,Time x 2,Holiday

2. Affected Areas:

  1. Integration ~> File Import view

3. The issue was caused by:

  1. New feature

4. Notes
5. Next Step
: UAT


28 Apr 202003:28PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 28-04-2020 07:27 PM
Ready for UAT

28 Apr 202004:52PM Comment 4 by Sanjay (Link Technologies) ETC was changed from 24/04/2020 to 28/04/2020
29 Apr 202010:20AM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 29-04-2020 01:37 PM Time Taken: 1.00

Hi Alvis, 

As per comment 2, I imported the timesheet for employee E073. Please find attached the csv file.

  1. Upon validation the file import failed. I could not find notes to state why validation fails. The event log is also not updated. Refer to Figure 1.

Figure 1: Validation Failure. 

Thanks
Rashna


29 Apr 202002:52PM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 29-04-2020 05:03 PM Time Taken: 1.00

As per the GTM session, the column labels should be as below for all "Payroll Timesheet" upload.

CompanyID,EmployeeCode,Date,Total Hours,Normal,Time x 1/2,Time x 2,Holiday

  1. Create a timesheet record for employee E073 with total hours as 10.
  2. Import the time into Linkweb from "Integration - File Import" 
  3. The file should be imported under "File Import  View".
  4. Set the "Import Type to "Payroll Timesheet".
  5. Data should be successfully imported and updated under "Time & Attendance - Payroll Timesheet" - Pass

Test Environment

  1. Database - LINKSOFT-DEMO-11-RASHNA
  2. Server - LinkQA4
  3. Version - 11.5.0284
Next Step

Documentation


    02 Jun 202009:14AM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 01-06-2020 05:34 PM Time Taken: 1.00

    Hi Sanjay, 

    Documentation has been updated at

    • Framework\Integration\File_Import.htm
    • Framework\Integration\File_Import_View.htm

    Thanks
    Rashna


    Attachments:
    General Documents - Case: L11953:E073Time.csv
    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L11953 in the subject line of all emails regarding this issue.

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