Non-Homecare Import SFTP and File Requirements

Users need a Secure FTP client software to access their HHAeXchange SFTP account. Any standard SFTP client software should be able to connect to the HHAeXchange SFTP (such as Filezilla, CuteFTP, and WINSCP).

HHAeXchange provides SFTP credentials once an Agency has validated their file format.

HHAeXchange does not endorse or technically support any particular 3rd Party software. Some examples and images used within this document are exclusively for demonstration purposes.

The following information is needed to connect to the SFTP location.

  • HOST/IP/URL: sftpprod.hhaexchange.com

  • Username: Enter the Username received from HHAeXchange

  • Password: Enter the password received from HHAeXchange

  • Port: 2222

  • Connection: SSH/SFTP

SFTP Configuration Settings (Sample SFTP Application)

When transferring files via SFTP, select the BINARY mode in your FTP client application. Binary Mode in Advanced Settings sample shown.

Binary Mode in Advanced Settings (Sample)

Folders are used to organize the files exchanged through SFTP as follows:

  • Inbox – Used to import a file into HHAeXchange. Users can place files into the Inbox folder for automated import into the HHAeXchange system.

  • Outbox – For imports, the Response File for each import is placed in the Outbox in a subfolder (after processing) where users can view successful/unsuccessful files.

The following guidelines address how long files are retained by HHAeXchange before removal from the HHAeXchange SFTP server.

  • Files in Inbox folders are retained until successfully processed and moved to the Processed folder.

  • All files size 50 MEGABYTES or larger in the Processed, Saved, or Outbox SFTP folders are retained for 3 days.

  • All other files in the Processed, Saved, or Outbox SFTP folders are retained for 15 days.

The following table contains a brief description as well as direction and location of each Import interface.

Interface File Direction SFTP Folder Description
Non-Homecare Services Import Inbox Creates/Updates Non-Homecare Rendered Services
Response File Response Outbox Folder to hold Response Files for processed files

File Type

CSV

Text Qualifier

Double Quotes

Headers are included?

Yes

Delimiter for end of row

CRLF (Carriage Return/Line Feed)

A tabbed text editor application (such as Notepad ++) visually organizes information allowing users to view data as well as hidden formats (such as double quotes and CRLF) to easily identify and correct errors.

Tabbed Text Editor Application (editor sample)

HHAeXchange Non-Homecare Import Interface File Information File Name and Frequency
Interface SFTP Location File Name Frequency (SFTP Import Only)
HHAeXchange Non-Homecare Import Interface File Information File Name and Frequency
Non-Homecare Services Inbox

Incremental File:

LTDIN_AgencyID_NHCServices_YYYYMMDDHHMMSS.CSV

Full File:

LTDIN_AgencyID_NHCServices_YYYYMMDDHHMMSS_Full.CSV

Incremental: As/When desired by Agency Full File: Every Weekend (Optional)

To minimize errors and ensure system processes are running efficiently, HHAeXchange requests for Agencies to upload the entire file (ALL records starting from go-live date) only on the initial load (first time). Thereafter, all future import files should only contain incremental changes.