Our vendor is requiring us send files which are exported from Acumatica to them by SFTP in daily basis. Yes, this can be done manually, I can export the file to my local computer and then I use a SFTP client to send the file. However, I am wondering can this be done in an automation way? Thanks in advance.
On the File Synchronization (SM202530) Page, you can set up a clock to create an Automation Schedule (SM205020).
Note that synchronization needs to be enabled on the file maintenance to display on the File Synchronization page.
@schneur96 Thank you. It is a bright idea. However, in this way, it is a semi-automation not a full automation. The key question here is how can I get the “file” in an automation way. The way you suggested is in the precondition that we already have a file in system, and then define the sync schedule based on that file. Can we also to generate that kind of file like from a GI or from a report run in an automatically way? thank you in advance.
@vkumar wonderful, wonderful, fantastic, amazing, super. I don’t know how to choose the words to express how I feel about the workflow you pointed out. This is why I love Acumatica so much, it is powerful, strong, efficient tool. And with so many nice people to help us with. Thank you. Thank you very much, it is the best solution I can imagine. Wish you a happy and safe thanksgiving day.
@vkumar I have repeated your steps, all is OK. however, in your steps, you didn’t mention the File Synchronization screen, ScreenId=SM202530. The only scheduler I set is on “process export scenarios” screen, will the export of file automatically trigger the synchronizaion file? or I still have to add a scheduler maybe 1 to 2 minutes later on “file synchronizaion” screen after the scheduler on “file exporting”. Please advise, thank you.
Glad to know its working. Yes, you need to set the scheduler on ‘file synchronization’ as well. Did not get a chance to respond to your previous question sooner.
I did not manage to get a data provider using SFTP working correctly. Is it possible to have a sample/screenshots of the data provider you created ? just want to check how you specified it.
Here are the couple steps to automate the export of the file to the FTP server.
Once the file is created via the export scenario you can go into the File Maintenance and setup the synchronization tab. You can test the sync by clicking on the Synchronization > Export File action to test if it works.
Once the sync is working manually it can be automated via the File Synchronization processing screen by setting up an automation schedule.
I have never tried to do what you need using Export Scenarios but I can tell you that my approach in most of the cases is a 2 step procedure:
I use Export Scenarios to extract the required data ;
I use ETL tools to read , transform and distribute the data according to multiple business rules (by order/invoice, all together by customer, etc.) , multiple media formats (csv, Excel, pdf, etc.) and multiple destinations (upload to SFTP or other sites, copies via email, and so on)
I believe this approach gives me the best and fastest results as extracting the data from Acumatica database using Export Scenarios saves me a great deal of time and by using ETL tools I can add distributing rules, schedules, business rules and media choice that I would not be able to add to Export Scenarios. There are other indirect benefits as well such as: transferring all that secondary workload from Acumatica to an external application or even environment; higher flexibility to adapt the distribution of data to new requirements; it is a solution that fits very well to instances running in cloud.
The standard Acumatica export scenario and FTP sync is not able to name a file specifically based on the order number. We looked at the AcuSync product for a couple clients in the Acumatica marketplace. It has a lot of features and could easily support your custom file names.
Hey guys, thanks for all the answers on this. I have a scenario where we do have to ftp a file out and I’ve done all the steps outlined. Everything is working when I do the steps manually. The file is exported and the sync puts the file out on the ftp server. great. My issue is this will need to be run nightly and when I setup the automations to test this, it didn’t work. The automation history said it was all completed successfully, but I don’t see any evidence that the export scenario was prepared, exported, or the file was sent out. What I’m noticing or seeing now, is that even if I just go into the Process Export Scenario screen, pick the scenario and choose either just Prepare, or Prepare and Export, nothing seems to happen. No error, but nothing changes. The status of the export scenario doesn’t change to Prepare if I just do Prepare, etc. I’m thinking that maybe that is why the automations also didn’t seem to do anything. Any thoughts or ideas on why the Process Export Scenario screen doesn’t seem to do anything or what else I can try? Thanks.
Thanks for replying Kurt. I have double and tripled check things. I did discover that if the data did not change, mine is from a GI of some stock item data, since the last time a prepare and export are done, that it will not generate a new version of the file and based on what you said, then the file sync will not occur. I thought that was going to be my issue, but that would be way to easy to explain!! After playing around with it some more, it’s just that the Process Export Scenario screen is simply not processing the export scenario no matter what I try and at the moment, I’m doing this outside of the automation, just doing it directly on the screen. I am changing an item, before trying so that the data is different from the previous try, and whether I do either prepare or prepare and export, nothing happens The screen seems to be behaving a little weirdly too although I haven’t had any experience with the screen before. When I check the box and click process (after saving), I am seeing the checkbox become unchecked. From what I remember from other screens, that seemed strange. Even did the prepare on the Export by Scenario screen and just tried the Export on the Process screen and again, it just doesn’t do anything. The status doesn’t change and there is no sign that anything happened.
Thanks for replying Kurt. I have double and tripled check things. I did discover that if the data did not change, mine is from a GI of some stock item data, since the last time a prepare and export are done, that it will not generate a new version of the file and based on what you said, then the file sync will not occur. I thought that was going to be my issue, but that would be way to easy to explain!! After playing around with it some more, it’s just that the Process Export Scenario screen is simply not processing the export scenario no matter what I try and at the moment, I’m doing this outside of the automation, just doing it directly on the screen. I am changing an item, before trying so that the data is different from the previous try, and whether I do either prepare or prepare and export, nothing happens The screen seems to be behaving a little weirdly too although I haven’t had any experience with the screen before. When I check the box and click process (after saving), I am seeing the checkbox become unchecked. From what I remember from other screens, that seemed strange. Even did the prepare on the Export by Scenario screen and just tried the Export on the Process screen and again, it just doesn’t do anything. The status doesn’t change and there is no sign that anything happened.
Did you ever figure out how to get that Process Export (or Import) Scenarios screen to work? I’m seeing the same behavior you are w the checkbox check disappearing and nothing happening.
Once you run the Process Export scenario screen if there is any new data to export it will be exported and attached as a new revision to the file on the export scenario.
So in my scenario below, once the export is run, you can click on the file attachement (1) to see the files. Then click edit (2) to show the file maintenance window. There you can see all the revisions of the file from running th export (3). Then if you setup the synchronization as I mentioned above in the synchronization tab (4), you can then use the file synchronization screen to schedule the SFTP of the file.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.