Contents tagged with Export
today I want to leave a short note about Acumatica Architecture. Take a look on this picture:
As you can see from the schema business logic controllers is kind of single source of truth. Acumatica doesn't have dependencies between UI and Web services. Also it means, if you hide something from UI on the page, it will be also hidden from Mobile app.
But want to say about few exceptions as well.
Suppose following scenario. You make a graph, and you know for sure, that from UI standpoint, it's logicall to load some visualization data, but from API call there is no reason to call some piece of code. How to inform Acumatica about it?
For this purpose you can use … more
I want to describe how to export data from Acumatica.
To export data (Customers for instance) to .xlsx format output we need to make 3 actions:
Create a Data Provider
Create an Export Scenario
Make an Export by Scenario
1. First of all, before we will start do all those steps, we need to create .xlsx file with such fields at least on the first row as a heading row:
After that when we’ve created Customers.xlsx file, click on the menu button and choose Integration tab.
Afterwards on the Profiles subheading click Data Providers:
In the *Name field type the name of the future Data Provider to Excel format (Import/Export Customers to Excel) and in … more