Company: Link Technologies
Case No: L12812. Project: 14.30: LinkSOFT Version 14.30 - December 2022
Logged By: Sanjay (Link Technologies) on 31 Oct 2022 06:01PM
Priority: Medium
Product: Framework
Group: New Feature
Time Taken: 26.00 (Weight: 30.00)
Assigned To: Development
Circulation: Development, Sanjay, Sitla
Resolve By: Wednesday, 30 November 2022 10:26 AM [752 days since logged date]
Status: Closed
Subject: Add Custom FTP Upload for Database Backups
Summary:    

Add the ability for Backups to be transferred to a custom FTP address

Audit Notes:Edited by sanjay on 07/11/22 14:53. Edited by sanjay on 07/11/22 14:50. Edited by sanjay on 07/11/22 14:50. Edited by sanjay on 07/11/22 14:49. Edited by sanjay on 03/11/22 14:15. Edited by sanjay on 03/11/22 13:20. Edited by sanjay on 03/11/22 13:19. 
03 Nov 202201:25PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 10-11-2022 01:20 PM Time Taken: 16.00
PART A - Development work for this case has been completed.

1. The change will be available in version:14.30

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

  1. Process SYS004 added a new option to "FTP Upload to custom FTP server". Configuration items are:
    1. FTP Server address
    2. FTP Server username
    3. FTP Server password
    4. FTP Server - Use Passive Mode
  2. If this option is enabled, backups will be flagged to upload to the FTP address defined
  3. The scheduled task "Maintenance tasks" in the menu "Global Administration ~> Process Setup" will upload data to the FTP server
  4. The Delete function is not enabled for Custom FTP. The delete is designed for FTP Upload only (Link Cloud Backup)

3. Affected Areas:

  1. Database Backup
  2. Maintenance task to upload backups to FTP

4. The issue was caused by:

  1. Change request

5. Other Relevant Notes: 
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT


03 Nov 202201:32PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 10-11-2022 01:25 PM Time Taken: 6.00
The following tests were performed: (System Test)

Test Setup Instructions:
  1. Configure FTPCUSTOM with a valid FTP Address, Username and Password
Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Enable process SYS004
Bacup should be created and marked for Custom FTP. FTP Upload should complete successfully
Pass
Verify upload using "UPLOAD Date" on the form "Database Backups"
2Enable  Link Technologies FTP Upload and start SYS004
One backup entry should be created with UPLOAD to LinkSOFT FTP and Custom FTP. Both FTP addresses should receive the backup file
Pass
Error logs should be available in both the "Event Log" as well as the "Database Backup" Log columns.
3Mark item 2 above as Deleted
FTP backup at the Link Technologies repository should be deleted. Custom FTP should remain on the server
Pass

4Resend item 3 above to Custom FTP and Link Technologies
Both servers should receive the backup file
Pass

5SET an incorrect FTP server address and resend backup
The error message should be available on the logs
Pass
Backup is marked as "Completed" when uploaded to Link Technologies FTP Server even if CUSTOM FTP fails. To verify Custom FTP, review "FTP Custom Upload Date" and Error Logs

Environment Details

  1. OS version: Win11
  2. Application version: 14.30
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


07 Nov 202202:49PM Comment 3 by Sanjay (Link Technologies) ETC was changed from 03/11/2022 to 30/11/2022
10 Nov 202201:06PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 17-11-2022 01:05 PM Time Taken: 4.00
The following tests were performed:

Test Setup Instructions:
  1. Configure FTPCUSTOM with a valid FTP Address, Username and Password
Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Enable process SYS004
Bacup should be created and marked for Custom FTP. FTP Upload should complete successfully
Pass
Verify upload using "UPLOAD Date" on the form "Database Backups"
2Enable  Link Technologies FTP Upload and start SYS004
One backup entry should be created with UPLOAD to LinkSOFT FTP and Custom FTP. Both FTP addresses should receive the backup file
Pass
Error logs should be available in both the "Event Log" as well as the "Database Backup" Log columns.
3Mark item 2 above as Deleted
FTP backup at the Link Technologies repository should be deleted. Custom FTP should remain on the server
Pass

4Resend item 3 above to Custom FTP and Link Technologies
Both servers should receive the backup file
Pass

5SET an incorrect FTP server address and resend backup
The error message should be available on the logs
Pass
Backup is marked as "Completed" when uploaded to Link Technologies FTP Server even if CUSTOM FTP fails. To verify Custom FTP, review "FTP Custom Upload Date" and Error Logs

Environment Details

  1. OS version: Win11
  2. Application version: 14.30
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12812 in the subject line of all emails regarding this issue.

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