[1]Please process UserGuide\SM__How_to_configure_file_FTP_HTTP_synch.dita before you process my edits in this topic; I explain some things there that apply here too.2024/11/0613:53:48-05:00To Configure File Synchronization Through SFTP
Synchronization through Secure File Transfer Protocol (SFTP) is similar to File Transfer Protocol (FTP) synchronization but is more secure because it provides data exchange only when the file storage and MYOB Acumatica have matching SSH keys. Therefore, you first should generate an Secure Shell (SSH) key pair and upload the keys to the SFTP server and MYOB Acumatica; you then configure file synchronization by using the File Maintenance (SM202510) form. These tasks are be described below:
To Generate SSH Keys
- Install and launch the PuTTY Key Generator.
- In the Parameters pane, select the RSA type.
- Press Generate and perform the requested actions to generate SSH keys.
- Specify a passphrase in the Key passphrase and Confirm passphrase boxes.
- Press Save public key and store the public key in some temporary location.
- In the main menu, select Conversions → Export OpenSSH
Key, specify a
.txtextension, and store the private key in some temporary location.
Upload SSH Keys
- Upload the public key to your SFTP server.
- Upload the private key to MYOB Acumatica. To do this:
- Open the File Upload Preferences
(SM202550) form and verify that
.txtis on the list of allowed extensions. Ensure the check box in the Forbidden column is cleared for this extension. - Open the Encryption Certificates (SM200530) form.
- On the form toolbar, click Add row.
- Specify the certificate name in the Name column.
- Specify the certificate's passphrase in the Password column.
- On the form toolbar, click Save.
- Click the paper clip icon in the Files column of the row with the certificate.
- In the Files dialog box, click Browse, and select
the
.txtfile with the private key you want to upload. - Click Upload to import the certificate.
- Close the Files dialog box.
- Open the File Upload Preferences
(SM202550) form and verify that
To Configure File Synchronization (SFTP)
- Open the Search in Files (SM202520) form.
- [2]It seems that this form has been redesigned since the original drafting of the text. There's no longer a left pane and a right pane on the form--just a single table. I have changed this across the three files to fit what the form now looks like.2024/11/0615:32:34-05:00To find the file, in the Selection area, specify criteria to help you find the file. These criteria can include the file name (or part of the file name), the time interval of the import, and the name of the user who imported the file or checked it out. The table lists the files that match the criteria you have specified.
- In the table, click the file to open the File Maintenance (SM202510) form for this file and view information about the file.
- On the Synchronization tab, select the Synchronize check box.
- In the Synchronization Type box, select [3]See the intro to the Conventions and Tags page for the basic info about tag usage. To summarize, for the contents of a box or column, we use userinput tags IFF the user must type the content. In all other circumstances (system-inserted values, existing values, and options that can be selected by the user), we use italics.2024/11/0615:46:18-05:00SFTP.
- In the Path box, enter the path to the shared folder on a local network computer.
- In the Login and Password boxes, type the username and password of an account with sufficient rights to allow system access to the shared folder.
- In the SSH Authentication Key box, select the certificate that you have imported. Its key will be used to interact with the SFTP server.
- On the form toolbar, click Save.
