Company: Link Technologies
Case No: L11745. Project: 11.40: LinkSOFT Version 11.4
Logged By: Sanjay (Link Technologies) on 15 Oct 2019 08:29AM
Priority: High
Product: Framework
Group: Enhancement
Time Taken: 63.00 (Weight: 63.00)
Version: 11.4.0302
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay, Sitla
Resolve By: Friday, 04 October 2019 12:00 AM [1864 days since logged date]
Status: Closed
Subject: Add ability for customers to Upload Databases to a Secure FTP Location for safe storage
Summary:    

In order to provide a better service to our valued customers, we have agreed to build a secure FTP storage system for our client databases so clients can feel safe that their data is frequently backed up to a secure location.

The requirements are as follows:

  1. Add a simple mechanism where clients can upload a database to a secure location
  2. Use AZURE Cloud services with an encrypted username and password known only to the Key Development Personal
  3. Clients will receive this service as part of their Annual Maintenance Package. There will not be any additional fee for this service
  4. The upload needs to be simple to use
  5. The upload will be manually executed as the database size and bandwidth needs to be taken into account.
Audit Notes:Edited by sanjay on 15/10/19 08:29. Edited by sanjay on 29/09/19 01:10. Edited by sanjay on 24/09/19 09:05. 
24 Sep 201901:11AM Comment 1 by Sanjay (Link Technologies) Case 11745 added to project 11.004.BETA
24 Sep 201901:22AM Comment 2 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 24-09-2019 01:22 AM Time Taken: 16.00 Notes: Edited by sanjay on 28/09/19 23:38. Edited by sanjay on 24/09/19 01:25. 

Development work for this case has been completed.

The change will be available in version:11.004

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

  1. Configured AZURE Cloud services to receive FTP Backups through a secure channel
  2. Added a new utility on the POS Main menu
  3. Select the "FTP Upload" Option. The FTP Address and other credentials are encrypted in the application.
  4. Select the backup to upload using the Browse Button
  5. Upload using the "Upload" button
  6. Review uploaded files list
User has full control and there is currently no limit to the upload functionality.

2. Affected Areas:

  1. New functionality via POS form

3. The issue was caused by:

  1. Improvement

4. Notes:

  1. In the initial phase of this implementation, we chose "POS Main" form as we have all the required controls and user access to handle large files. A web implementation will be considered in the next release.
  2. We need to consider how we upload backups where POS is not used. Maybe move this functionality to Database Utilities.

5. Next Step: System test and UAT

  1. Test file sizes up to 30GB. Maybe we should limit this - to be discusses
  2. Break internet connection and retry
  3. Disable user credentials on cloud services are retry
  4. End Task while the backup is in progress
  5. What happens if user wishes to delete all backups - e.g. An "OPT-OUT" option.
  6. Should we put a limit on how much data a user can upload?


24 Sep 201909:05AM Comment 3 by Sanjay (Link Technologies) Case 11745 removed from project 11.004.BETA
24 Sep 201909:05AM Comment 4 by Alvis (Link Technologies) Case 11745 added to project 11.004.BETA
25 Sep 201907:52PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 25-09-2019 07:52 PM Time Taken: 24.00

Development work for this case has been completed.

The change will be available in version:11.4

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

  1. Moved the FTP upload to Database Utilities as some customers may not have POS
  2. Added Integration configuration on License Portal to manage:
  1. FTP Address
  2. FTP Username and Password
  3. FTP Single file size limit
  4. FTP limit by customer
Added delete capability so customers can remove databases they do not want to be stored on the FTP serverChanged file name to have MachineName-UserName-DateTimeStamp-SelectedFileName structureAdded licence check for module "SYS"Merged Database Copy Utility into Database Tools

2. Affected Areas:

  1. New Functionality

3. The issue was caused by:

  1. Improvement

4. Notes: 
5. Next Step: UAT


28 Sep 201908:36AM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 28-09-2019 08:36 AM Time Taken: 8.00

Added the following improvements:

  1. Changed FTP address from AZURE cloud to link247.com.au
  2. Added "In Progress" to file name while uploading
  3. Added file size on the progress bar
  4. Added FTP server address to the title bar of the form
  5. Corrected progress bar position

28 Sep 201911:37PM Comment 7 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 28-09-2019 11:37 PM Time Taken: 12.00

Development work for this case has been completed.

The change will be available in version:11.4.0929

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

  1. Added "Additional field" to Licence Portal to store UploadLimitPerCustomer
  2. Added "Additional field" to Licence Portal to store UploadLimitPerFile
  3. Added functionality where FTP file Limits are picked up from Customer Record. If a customer record doesn't exist, the Default Integration values are used
  4. Added user validation
  5. Added licence validation
  6. Added Upload limits to the title bar

2. Affected Areas:

  1. FTP Upload functionality

3. The issue was caused by:

  1. Improvement

4. Notes: 
5. Next Step: UAT


29 Sep 201901:10AM Comment 8 by Sanjay (Link Technologies) Case 11745 removed from project 11.004.BETA
29 Sep 201901:10AM Comment 9 by Sanjay (Link Technologies) Case 11745 added to project 11.004.BETA
29 Sep 201901:10AM Comment 10 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 29-09-2019 01:10 AM
SYstem tests required to resolve connectivity breaks and large file upload

30 Sep 201901:08PM Comment 11 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 04-10-2019 12:00 AM Time Taken: 2.00
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
1Disable access for "FTP Upload" for user admin. Open the "FTP File Upload" utility upload should not be allowedPass
2

Validate "Server and Database" section

  1. Login with server "Local" and database - "LINKSOFT". This should be allowed
  2.  Login with server "Local" and database - "LINKSOFT".  
Pass
3

Validate "User and Password"

  1. Login as username = "admin" and password = "admin". This should be allowed
  2. Login as username = "admin" and password = "1234". This should not be allowed, password is invalid.
  3. Login as username = "sera" and password = "1234". This should not be allowed, username is invalid.
Pass
4Reduce the "SYS" licence count to 0. Log into "FTP File Upload" utility  this should not be allowed as licence is invalid Pass
5
set the UploadLimitPerCustomer to "Null" for customer "LinkTechologies - Demo"
set the UploadLimitPerFile to "Null" for customer "LinkTechologies - Demo" 

Log into the "FTP File Upload" utility, the title bar should pick the default upload size  

Pass (Default size is 6000MB)
6
set the UploadLimitPerCustomer to "90" for customer "LinkTechologies - Demo"
set the UploadLimitPerFile to "85" for customer "LinkTechologies - Demo" 

Log into the "FTP File Upload" utility, the title bar should pick the default upload size  as 90 and 85

Pass
7Upload file with size 75MB. This should be uploaded without errorsPass
8Upload second file with size 149 MB. This should not be allowed as upload limited has beenPass
9Delete the file in 7 above. It should be deleted without errors.Pass
10Upload a file, during the process Ënd Task. The upload should be stopped without errorsPass (Status of the file is "In -Progress) 

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 11.0.0506
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-11-RASHNA

Next Step: 

  1. Documentation



    15 Oct 201908:29AM Comment 12 by Sanjay (Link Technologies) Case 11745 removed from project 11.004.BETA
    15 Oct 201908:29AM Comment 13 by Sanjay (Link Technologies) Case 11745 added to project 11.004.BETA
    04 Dec 201908:08AM Comment 14 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 04-12-2019 11:42 AM Time Taken: 1.00

    Hi Sanjay, 

    Documentation has been updated at "Installation - FTP Backups and Storage"

    Thanks
    Rashna


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

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