Contents tagged with import
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
To import data (Customers for instance) from .xlsx format we need to make 3 actions:
Create Data Provider
Create an Import Scenario
Make an Import by Scenario
1: First of all, before we will start do all those steps, we need to have .xlsx file with customers and such fields at least on the first row as a heading row:
After that when we’ve checked 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/from Excel format (Import/Export Customers to Excel) and in the next field - * Provider Type: choose … more