Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with FTP.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from FTP, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for FTP Stored Procedures
| Name | Description |
| DeleteFile | Deletes a specific file from the connected FTP server, which is useful for removing outdated or unwanted files during automated file management processes. |
| Download | Retrieves a file from the FTP server to the local system as a backup, or transfers a file from the FTP server for remote data ingestion. |
| MoveFile | Transfers a file from one directory to another on the FTP server. This is useful for organizing files into appropriate folders or for archiving after processing. |
| RenameFile | Renames a file on the FTP server without altering its location. This helps standardize naming conventions and resolve conflicts. |
| SendCommand | Executes a raw FTP command directly against the server, providing flexibility for advanced operations not covered by standard stored procedures. |
| Upload | Sends a file from the local system to the FTP server, often for the purpose of publishing new files, updates, or reports to remote environments. |