Contents tagged with import

  • Acumatica Application Architecuture

    Hello everybody,

    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

  • Import data in Acumatica

    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