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
+2Hello, 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
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.
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?
+2Hey
Hey
You can use the following to solve your problem:
Sprinterra File Integration Framework https://www.acumatica.com/acumatica-marketplace/sprinterra-file-integration-framework/
or
Sprinterra File Processing https://www.acumatica.com/acumatica-marketplace/sprinterra-file-processing/
Both frameworks are 100% capable of retrieving files from an SFTP server.
After retrieving the files, you will need to write a handler for these files (creating a stock item in Acumatica) or an import scenario that implements similar functionality.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
