FTP Upload

From NewHaven Software Wiki

Revision as of 02:55, 15 April 2009

Here are the instructions for making a backup copy of your CMS database files and and how to upload these files to our FTP server using a secure TLS/SSL connection.

NOTE: This is accomplished on the CMS Server computer.

1. MAKE A BACKUP IMAGE OF CMS DATABASE FILES
   1. Select the Admin menu.
   2. Select Database Maintenance. (Note the settings on the Daily Backup tab so you can restore them, if necessary.)
   3. Select 'Perform the daily backup'
   4. Select and delete any text in the 'Folder in which to create a backup...' field.
   5. Click the Browse button, select Desktop in the window that opens, and click OK.
   6. Click the 'Immediately create a Backup Image...' button. This will create a copy of your database and log files onto the Windows desktop.
   7. Click the Close button.
   8. Quit CMS if it is still open.
2. COMPRESS YOUR CMS BACKUP IMAGE FILES
   1. On the Windows Desktop, there should be two files with the same name as your CMS database (SoloData for Solo users). Depending on how you have Windows configured, you may or may not see the .db and .log file extensions.
   2. Compress these two files together
      1. In windows select both files using your mouse and then right click and select 'Send To -> Compressed (zipped) Folder"
   3. Rename the compressed file with your company name if it's not already.

For the protection of your data we required all FTP transfers to be sent over a TLS/SSL connection.

In order to setup FTP over SSL you need an FTP client that supports this. IE does not support FTPS. For the time being we recommend Filezilla, it’s an open source ftp client: http://filezilla-project.org/ Please follow their directions for installing. Once installed continue with the instructions below:

• open Filezilla
• goto File->Site Manager
• Click on New Site
• Type NHS FTP or similar
• On the right side enter the following:
  • Host: ftp.newhavensoftware.net
  • Port: 990
  • Servertype: FTPS - FTP over implicit TLS/SSL
  • Logontype: Normal
  • User: uploads
  • password: east!circle
• Click Connect
• a window will pop up once connected called Unknown certificate this window shows you details of the SSL certificate. The host should read ftp.newhavensoftware.net:990
• Check the box Always trust certificate in future sessions
• Click OK

This will save your settings, and you can open that site anytime to connect again by going back to the site manager. Please be aware the uploads password changes from time to time. If you need to regularly update information on our FTP server please send an email to support@newhavensoftware.com requesting a permanent FTP account. If all settings are accurate, you will be connected to the server over TLS/SSL, securing all data being sent and retrieved from our FTP server.

1. Locate your file on your desktop in the left window pane.
2. Right click on the compressed file and select Upload
3. This will start the upload process and you will see the progress near the bottom of the screen.
4. Please email us at support@newhavensoftware.com when the file has been successfully uploaded so that we can move it off of the FTP Server for added security.