Send Database Via FTP

The Send Database Via FTP form contains many options for easily sending required information to the Collect! support team. There are several options provided. You can send your entire Collect! folder, your working database, or particular files and folders as requested by the Collect! Technical Services team.

This is much more efficient for support issues and a much easier process for you. After you have made your selection, you simply select the Send Database button. Data is encrypted and uploaded to Comtech's secure FTP site.

You can use this utility in multi- user mode while your operators continue with their work.

Encryption And Security

To safeguard the security of your data, Collect! uses strong encryption methods to automatically encrypt files before they are uploaded to Collect!'s secure FTP site. Collect! uses a 64-bit block cipher with a variable-length key. Key expansion converts a key of up to 448 bits into several subkey arrays totaling 4168 bytes.

Accessing Send Database Via FTP

The Send Database Via FTP form may be accessed only one way. Providing you have access to the various menus and forms, you can get to the Send Database Via FTP as follows.

1. Using the menu bar at the top of Collect! select System to display the drop-down menu.

2. Select Send Database Via FTP to display the Send Database Via FTP form.

Send Database Via FTP form

Typically, Technical Services will have requested that you send a particular selection from the available options. To select an option, use your spacebar or mouse to put a dot in the radio button beside your choice. You may only select one option.

Log Files

Select this option to transfer your Collect! log files. These are all the files in the CV11\bin\log files folder. These logs contain system messages and error messages for diagnosing and tracking events. There may be only one collect_log_01.txt or many numbered collect_log files. They will all be zipped and sent as one file, Logs.tgz. Please refer to Collect! Log Viewer for details about log files.

Database Without Subfolders

Select this option to transfer your collect.cfg file and your database files without subfolders.

Database With Subfolders

Select this option to transfer your collect.cfg file and your complete database with subfolders.

Whole Collect! Folder

Select this option to transfer your entire Collect! application and data. Every database and subfolder will be transferred.

Report Libraries

Select this option to transfer your report libraries. When the Report Libraries options is selected for file transfer, Collect! sends all report databases for the database you are in, including Web Host, and external report libraries as well.

Import Libraries

Select this option to transfer your import libraries. When you select Import Libraries, Collect! sends all the impex databases for the database you are in, including Web Host, and all alternate external import libraries.

User Database

Select this option to transfer your nxuser files to Technical Services. Collect! sends all d00_nxuser files for the database you are in. These files contain all your operator and access rights settings.

FTP Server Name

This is the Hostname of the FTP server that you will be connected to for the file transfer procedure. The default Hostname is "ftp.collectsystem.cc." This is the Hostname for Comtech Systems Inc.

Username

This is the Username that will be used to authenticate with the FTP server. This must be a valid Username for an account created for you on the FTP server.

The default Username is an account set up by Comtech Systems for data transfers using the Send Database Via FTP utility.

Password

This is the Password that will be used to authenticate with the FTP Server. This must be a valid Password that matches the Username account created for you on the FTP server.

The default Password is an account set up by Comtech Systems for data transfers using the Send Database Via FTP utility.

Send Database

Select this button to upload the files you have selected to the Collect! ftp site. Please refer to Steps To Send Database below.

View Log

Select this button to view the results of the transfer process written to the CV11\bin\ftpdata.log. This log is useful for system and technical support use. It logs the transfer process and the name of the file that is uploaded.

Help

Select this button for help on the Send Database Via FTP form and other related topics.

Close

Select this button to close the Send Database Via FTP form and return to the previous form.

Steps To Send Database

Select an option to send files and folders to the Collect! FTP site, and then select the Send Database button to begin the file transfer.

1. You will be prompted to confirm the file transfer.

Confirming Sending Database

Select NO to cancel the file transfer process.

Select YES to proceed with the file upload and transfer.

2. Accumulating and compressing data. First data is gathered and compressed.

Send Database Via FTP - Phase 1

You may see the black DOS window as the bsdtar utility compresses the data to be sent. This utility ships with Collect!.

3. Encrypting data. Second, data is encrypted. You may see the black DOS window as the openssl utility encrypts the data to be sent. This utility ships with Collect!.

4. Transferring data via FTP. Finally, data is uploaded to the Collect! FTP site. You may see the black DOS window as the ftp utility initiates the transfer.

ftp.exe is an operating system file. It does not ship with Collect!.

5. When the process is completed, you will be notified that the transfer succeeded.

Send Database Via FTP - Phase 3

Data transfer is logged to an ftpdata.log in the database directory. This log is useful for system and technical support use to examine the transfer process and filename created. If your transfer fails, please see Troubleshooting below.

Troubleshooting Send Database Via FTP

Working Directory in CV11 Shortcut

Please ensure that there is a valid working directory entered for the Start In: field in the CV11 Desktop Shortcut so that the FTP Utility can work properly.

FTP Upload Processes

The three phases of the Send Database via FTP functionality spawn external command line programs. Collect! can only determine success or failure based on the return result from those commands. Any failure will result in a generic failure message.

Send Database via FTP Failure

The following programs and files are used for transferring:

Phase 1: bsdtar.exe, zlib1.dll, bzip2.dll, libarchive2.dll
Phase 2: openssl.exe
Phase 3: ftp.exe

Make sure you have the files bsdtar.exe, zlib1.dll, bzip2.dll, libarchive2.dll, and openssl.exe in your CV11/bin folder.

Make sure you have the Windows ftp.exe program. This is a default installed program for Microsoft Windows operating systems.

Are you blocking any outbound Internet traffic at your firewall?

The Send Database Via FTP utility creates a temporary unencrypted file named database.tgz. You may need to delete this and/or give access to it to allow overwrite and/or create.

The Send Database Via FTP utility creates a log file named ftpdata.log in the database directory. You may be asked to send this to Collect! Technical Services if your transfer fails.

Known issues:

The Send Database Via FTP utility may return success in certain cases where failure should be reported. An example of this would be a bad Username and/or Password.