Skip to main content
Solved

Integrate Data from SFTP

  • October 16, 2024
  • 4 replies
  • 135 views

Forum|alt.badge.img

Requirement is something like we need to read files from given SFTP credential and path. (Need to read files 4 times per day)

After reading file we need to create stock item in Acumatica.

I try to search this type of requirement but cannot get success.

I found some help from various blog / question. According to that we need scheduler process and custom data provider.

But I don’t know flow. 

Can anyone explain me steps? 

Best answer by Patrick Chen

Hello, it’s not clear what you are looking for, but broadly speaking it sounds like you will need to create a Process screen for acumatica that accesses a ftp folder, brings in files, processes those files, and potentially creates inventory items.  Once you have a process screen that you can manually run, it’s a fairly trivial task to create an automated schedule for that process screen so that it can be run according to a schedule you devise.  I hope that helps, best of luck

View original
Did this topic help you find an answer to your question?

4 replies

Patrick Chen
Jr Varsity III
Forum|alt.badge.img+2
  • Jr Varsity III
  • 51 replies
  • Answer
  • October 16, 2024

Hello, it’s not clear what you are looking for, but broadly speaking it sounds like you will need to create a Process screen for acumatica that accesses a ftp folder, brings in files, processes those files, and potentially creates inventory items.  Once you have a process screen that you can manually run, it’s a fairly trivial task to create an automated schedule for that process screen so that it can be run according to a schedule you devise.  I hope that helps, best of luck


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 25 replies
  • October 17, 2024
Patrick Chen wrote:

Hello, it’s not clear what you are looking for, but broadly speaking it sounds like you will need to create a Process screen for acumatica that accesses a ftp folder, brings in files, processes those files, and potentially creates inventory items.  Once you have a process screen that you can manually run, it’s a fairly trivial task to create an automated schedule for that process screen so that it can be run according to a schedule you devise.  I hope that helps, best of luck

Basically Vendor place new catalog (Stock Item) in FTP (In form of CSV file). We need to create stock item in Acumatica.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 25 replies
  • October 22, 2024

@Patrick Chen 

I tried to add 3rd party library (SSH.Net) to connect SFTP.

I cannot find any way to add dll in package.

 

Is there any way to add 3rd party dll?


Patrick Chen
Jr Varsity III
Forum|alt.badge.img+2
  • Jr Varsity III
  • 51 replies
  • October 23, 2024

Hey @bjani23  I tried adding a 3rd party dll and could find it with the custom files menu you picture above.  Out of curiosity I checked out one of my current installations and it looks like Renci.SshNet.dll is part of the standard installation which explains why it wasn’t listed in the add files menu.  You just need to reference this dll from your custom project.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings