FTP Dashboard

Supported users have the ability to view a log of files that they have uploaded to the FTP for import and the status for each file. This information can be found by heading to account settings > data > FTP and clicking “View FTP Log.”

From the FTP Log Dashboard, there are 2 different statuses that will display:

  • Success
  • Unsuccessful

Clicking on the status will bring up a log file which gives more information about what was successful or unsuccessful about the import. It is important to note that an import may show as “Success”, but still have important considerations in the log file.

💡 Tip: The Dashboard will only display files that have been processed via FTP by the logged-in user. Files imported by other supported users will not display.

Log Files

The Log File has two different types of messages that display within it:

  • Primary Status Messages
  • Secondary Status Messages

In both of these messages, information in brackets { } will be replaced with data related to the import associated with the status that was clicked.

Primary Status Messages:

  • Successful Import Message
  • Unsuccessful Import Message

Primary status messages are high level and include holistic information about the status of your import. This message is associated with the status that displays on the dashboard. Therefore, if the user clicks a “Success” status in the dashboard, the log file is going to start with the Successful Import Message.

💡 Tip: Users will see a success status for any import where at least 1 record was successfully added/updated.

Alternatively, if the user clicks an “Unsuccessful” status from the dashboard, the log file will start with the Unsuccessful Import Message.

Unsuccessful import messages typically have an import failure reason. The available reasons that may display are as follows:

  • No Contact Status - displayed when no contact status was included in the file name.
  • Invalid Contact Status in file name - displayed when an incorrect contact status was included in the file name. (New contact statuses will not be created from file names.)
  • There are no records in the import file - displayed when there are no rows included in an import file.
  • Required Number of Columns not included - displayed when there were not at least 2 columns included for x and t files.
  • No column names match - displayed when the system was unable to map columns in the file.

The only unsuccessful import message that does not include an import failure reason is if something went wrong on the technical side of the import and BenchmarkONE was unable to process the file at all (and therefore, could not identify an import failure reason).

This is not common, but could happen if the database lost connectivity to the server, for example. If a user receives this message, they should try to re-import their file.

Secondary Status Messages

  • Duplicate Contact Message
  • Spam Complaint Message
  • Exceeded Contacts Message
  • Data Truncation Message

Secondary status messages are appended to the end of the primary status message and provide additional detail about the import. The two messages are separated by “\r\n” in the log file. In the case there is more than one secondary status message, each will be separated by “\r\n”.

Duplicate Contact Message –

Spam Complaint Message –

Exceeded Contacts Message –

Data Truncation Message –

💡 Tip: BenchmarkONE does not store previously processed files on the back-end and therefore, will not be able to research issues within data import files. If there are questions surrounding an unsuccessful import, please reach out to our Support Team at support@hatchbuck.com and provide your import file.

Did this answer your question?