Kalpa SFTP Connect
End Midnight CSV Uploads. Automate Any SFTP Feed into Acumatica
Still babysitting nightly SFTP drops and CSV imports in Acumatica? Imagine partner files such as orders, bank statements, and inventory feeds importing automatically every 15 minutes through a secure SFTP connection. Kalpa SFTP Connect erases 40 hours of manual uploads each month.
Book your strategy call now and turn file drops into hands-free Acumatica data flows
Key Product Features
-
Scheduled jobs run every 15 minutes (or custom cron) automatically, turning midnight CSV uploads into hands-free data flows.
-
CSV, XML, XLSX, fixed-width, and proprietary formats all supported
-
Pull partner files in; push Acumatica export data out to the same SFTP host for seamless partner workflows.
-
Payloads exceeding 25,000 rows auto-split and process sequentially; 100 MB file support via parallel threads and resume logic.
-
Credentials stored in Acumatica’s vault; keys never leave your tenant.
-
Bad files move to /Failed folder automatically; email alerts fire and dashboard shows red status for quick remediation.
-
Every SFTP transfer logged in Acumatica for compliance evidence; full transfer history retained for regulatory review.
-
Any CSV column feeds any Acumatica standard or custom field via Import Assistant mapping; no scripting required.
-
Monitor scheduled runs, view transfer status, flag errors, and track data lineage without leaving Acumatica.
-
All files processed entirely within Acumatica; zero reliance on external middleware, warehouses, or data lakes.
| Challenge | How Kalpa Fixes It |
|---|---|
| Manual nightly CSV uploads | Scheduled SuiteScript jobs run every 15 min, or any cron you set. |
| Partners still send flat files, not APIs | SSH-key SFTP channel ingests any file type (CSV, XML, XLSX, fixed-width) and can push return files the same way. |
| Audit & security headaches | Keys live in Acumatica’s credential store; every transfer is logged for SOX/GDPR review. |
| Import errors go unseen | Bad files auto-quarantine to a /Failed folder, email alerts fire, and a dashboard flags the run. |
Why Sales Ops & Finance Choose Kalpa
Frequently Asked Questions
-
All communication happens using either SSH key or basic user authentication, which is securely stored in Acumatica and can only be accessed by authorized users
-
Yes, any Acumatica Export Scenario can post to the same SFTP host.
-
Kalpa auto-splits the payload and processes sequentially.
-
Files move to /Failed, an email alert fires, and the dashboard shows red status.
-
Ops or AR managers champion, Acumatica admins configure, CFOs approve ROI.
-
Any column can feed a Acumatica custom field via Import Assistant mapping.