The Downloads tab in the Data Management provides an interface for users to create, manage, and monitor data downloads.
Below is an overview of the functionalities and table columns available:
Buttons
Create Data Download: This button allows you to create a new Data Download job, which prepares a ZIP file containing the desired table for download. For more details about creating the download job refer to the How to Download Data from Partition how-to article.
Table
Columns
Name: Lists the names of the various data download jobs. Each entry corresponds to a specific download task. Click the name to open the Available Files dialog - a table with a list of files created by the given download job.
Entity Type/Name: Shows the type and name of the entity associated with each download job. The entity type displays the type code of the table (e.g., P, CX), while the name provides the name of the specific table. See also https://pricefx.atlassian.net/wiki/spaces/PMDEV/pages/1760788580/Data+Upload#Supported-Entities.
Number of SFTP Users: This column indicates the number of SFTP users who have access to download the respective data. This helps track and manage user permissions.
Created at: This column provides the timestamp for when each download job was created, helping users keep track of the timeline of their data management tasks.
Created by: This column lists the email addresses of the users who created each download job. It helps in identifying the responsible parties for each task.
Downloaded at: This column indicates when the data was last downloaded, providing a log of the most recent activity for each download job.
Actions – 3-dots menu
The 3-dots menu located to the right of each download job name provides quick access to several actions that can be performed on the desired download.
Available options
Run Download: Triggers the corresponding Data Download job immediately. After the job is finished, the link is provided within the Notifications.
Edit Download: Opens the Edit Data Download dialog, allowing you to modify the parameters of the download job, such as name, filters, or destination. See the How to Download Data from Partition how-to article.
Available Files: Opens a table with a list of files created by the given download job. You can view all files that have been created and are available for download. Click the file name to download the file, without needing to run the download job again.
SFTP User Management: This option directs you to a overview page where you can create, edit, or delete SFTP users that have access to the files generated by the download job. See the SFTP User Management section below.
Delete Download: This option permanently deletes the selected download job and removes all associated files. A confirmation dialog will be shown.
If the Data Download is referenced in a workflow or a scheduler, a dependency check will prevent its deletion. You will receive a notification if the workflow cannot be deleted.
Table Functionalities
Search and Filter: Each column features a search bar at the top, allowing users to quickly filter and find specific data download jobs based on name, entity type, creation date, creator, and last download date.
Sorting: Clicking on the column headers allows you to sort the entries based on that column's data (e.g., alphabetically by name, chronologically by creation date).
SFTP User Management
The SFTP User Management within the Data Management is designed to manage the Secure File Transfer Protocol (SFTP) user accounts associated with specific data downloads. This is needed when the PlatformManager option as Download destination has been selected when creating the Data Download.
Buttons
Add User: Allows you to create a new SFTP user account. Clicking this button opens the “Add User” / “Edit User” dialog. See the Add User / Edit User section below.
Overview and Functionalities
SFTP Server Details:
Address: Displays the server address where the SFTP users will connect to access the files.
Port: The port number used for the SFTP connection.
User List:
Username: Lists the usernames of all SFTP accounts associated with the current partition.
Actions (3-Dots Menu):
Edit: Opens the Add User / Edit User dialog that allows you to change the SFTP user settings. See the Add User / Edit User section below.
Delete: Removes the corresponding SFTP user account. A confirmation dialog will be shown.
“Add User” / “Edit User”
The Edit User dialog within the SFTP User Management page is designed for administrators to configure and manage the details of individual SFTP user accounts. This interface allows for specifying authentication methods, managing SSH keys, and setting up email notifications for file uploads. Below is a detailed overview of the fields and options available in the Edit User dialog.
Fields and Options:
Name: Displays the username of the SFTP account. The name typically contains the partition name. This field is pre-filled and cannot be edited.
Password: Here you can set, or reset the password for the SFTP user. The password must meet specific security criteria.
Note: The Password field can be left empty if the user is authenticated via SSH key instead.
Fingerprint: Lists the SSH public keys associated with the user. Each key is identified by its fingerprint and a label.
Add SSH Key button: Allows you to add a new SSH public key for the user. This key will be used for password-less authentication to the SFTP server enhancing security.
Other Notification Emails: Email addresses that will receive notification when a Data Download job is completed. Multiple emails can be added by clicking the Add another email button.