| 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 2020 | 09: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:- Added file upload capability to IinkWEB in menu "Integration ~> File Import". Users can upload file extensions with DAT, CSV, TXT
- When a file is uploaded, each line is created in a table. The user can then review, validate and post the file data
- We have a DropDown that defines the data type. This will have values such as
- Customer Masterfile
- Employee Masterfile
- TNA Data - to be discussed
Next Step: - Review and Create necessary procedures for "LT_SYS_IntegrationFileData_Select/Update/Delete"
- Review and Create necessary procedures for "LT_SYS_IntegrationFileDataDetails_Select/Update/Delete"
- Review and Create necessary procedures for "LT_SYS_IntegrationFileData_Validate"
- Review and Create necessary procedures for "LT_SYS_IntegrationFileData_POST"
|
|
| 23 Apr 2020 | 03: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): - Created the framework objects required for File Data import
- 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: - Integration ~> File Import view
3. The issue was caused by: - New feature
4. Notes:
5. Next Step: UAT |
|
| 28 Apr 2020 | 03: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 2020 | 04:52PM Comment 4 by Sanjay (Link Technologies) ETC was changed from 24/04/2020 to 28/04/2020 |
| 29 Apr 2020 | 10: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. - 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 2020 | 02: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 - Create a timesheet record for employee E073 with total hours as 10.
- Import the time into Linkweb from "Integration - File Import"
- The file should be imported under "File Import View".
- Set the "Import Type to "Payroll Timesheet".
- Data should be successfully imported and updated under "Time & Attendance - Payroll Timesheet" - Pass
Test Environment - Database - LINKSOFT-DEMO-11-RASHNA
- Server - LinkQA4
- Version - 11.5.0284
Next Step Documentation
|
|
| 02 Jun 2020 | 09: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 |
|