Every detamoov account has the ability to receive data via SFTP for processing. To read more about this, visit our SFTP Maintenance article.
For isolved users, configuring System Level Data Transmission settings is a key area to instruct isolved to SFTP reports to detamoov for processing. In isolved, you access this by navigating to the Production Utilities \ Data Transmission link.
Configuring a Data Transmission Setting in isolved
When creating a new data transmission setting, you'll want to follow the guide below for each data element:
Field | Value |
---|---|
Transmission Description | detamoov |
Protocol | SSH FTP |
Connection URL | sftp.prod.detamoov.com/{8}_{1}.{3} |
User Name | SFTP username you created in detamoov (see our SFTP Maintenance article) |
Password | SFTP password you created in detamoov (see our SFTP Maintenance article) |
Allow for Client Transmission | Checked |
You do not need to worry about any other areas on the screen including Private Key, Web Service Parameters, PGP Encryption Public Key or PGP Private Key.
FAQ's
What are those funny values that use the { } in the Connection URL?
isolved calls these placeholders. These will be replaced with values about the company, payroll or report which ran. In the isolved Help Docs, the following placeholder values are value:
Placeholder | Placeholder Value |
---|---|
{1} | Report Title |
{2} | Date Stamp - you can format in month, hour, day, year, minutes and seconds with {2:MMDDYYYYhhmmss} |
{3} | File Extension |
{4} | Pay Date |
{5} | Period End Date |
{6} | Run Number |
{7} | Pay Period Number |
{8} | Legal Company Code |
{9} | Legal Company Name |
{10} | Pay Group |
How do I configure a data transmission setting so isolved SFTP's the generated IIF file to detamoov?
One of detamoov's great features is our QuickBooks Online integration. To configure a data transmission setting from isolved to detamoov, set your data transmission settings with the values below:
Field | Value |
---|---|
Transmission Description | detamoov - QBO |
Protocol | SSH FTP |
Connection URL | sftp.prod.detamoov.com/{8}_{6}_{4}_{10}.IIF (NOTE: please capitalize the IIF as we've seen lowercase iif cause issues) |
User Name | SFTP username you created in detamoov (see our SFTP Maintenance article) |
Password | SFTP password you created in detamoov (see our SFTP Maintenance article) |
Allow for Client Transmission | Checked |
The image below is a sample provided by one of our customers.