The Actions panel is shown to the right.
The panel contains the following button, which is enabled or disabled in accordance with the current status of the data project:
•Upload, validate and load: this button initiates the following activities:
A Windows file system dialog is displayed, within which you can locate a file to upload. By default, only text files (*.txt, *.csv) are shown. You can change the default filter to display compressed files (*.zip, *.rar, *.7z), or all files.
As soon as you select a file and click Open, the upload process begins.
If the selected file is a text file, RPI performs a quick analysis of 100 of the file’s rows. This “sanity check” is used to determine whether the file appears to be legitimately delimited or fixed-width. Following the sanity check, a sample of 20 records from the file is displayed in the File Upload Preview dialog.
The sanity check results are shown as follows:
§ If the file is delimited or fixed-width: “No major issues were found with this file”.
§ If RPI was unable to identify the file as delimited or fixed-width: “It is not recommended that you upload this file as the file type could not be determined”.
§ If an error occurred during analysis: “An unexpected error occurred while analyzing the file”.
Based on the information at your disposal, you can then invoke Start or Cancel Upload (note that you can still proceed with upload if RPI failed to identify the file’s type).
If you elect to proceed, the file is compressed before uploading, and decompressed on the server when fully uploaded. The Compress file and Decompress file progress checkpoints are updated accordingly. During compression, the progress bar is updated, and the legend “Compressed [x] bytes out of [y]” is shown.
If the selected file is compressed, RPI proceeds without showing a preview of the file (note that RPI supports the following compressed file types: .7z, .gz, .pkg, .rar, .sit, .sitx, .zip and .zipx). The following message is displayed at the Compress file progress checkpoint: “File already compressed; no further compression needed”.
You can upload both unprotected and password-protected compressed files (RPI decrypts using the password value stored in system configuration setting ZipPassword; if the password is incorrect, the Acquisition process step’s status becomes Upload Failed).
For unknown file types RPI displays a message indicating that the file extension was not recognized and it is likely that analysis will fail. You are still at liberty to proceed with uploading the file if you so choose.
The file is uploaded from your local file system or network, via a secure link, to a folder on the RPI server defined by system configuration setting DataIntakeLandingDirectory.
If you attempt to upload a file with a size larger than the maximum permitted (as defined by system configuration setting MaximumDirectUploadFileSize), a warning message is displayed and you are unable to upload the file.
o The file is validated against the data project’s definition. If either of the validation thresholds (soft or hard) are breached, you can view details of the validation failures in the Validation panel. Note that if the hard threshold is breached you cannot proceed with loading the file.
o The file is loaded into the database table that was created during data project definition.
•Cancel current upload: causes cessation of the current upload.