About import and export scenarios

To upload data to and from Visma Net, you can use import scenarios and export scenarios, which define the data import and data export instructions, respectively, for the system. An import or export scenario is a sequence of actions to be executed for a data record as if the record is being manipulated by user through an Visma Net window.

When you enter data into the system manually, you perform a sequence of actions.
You open the needed data entry window and start entering data.
To add a new record, you use the UI elements one by one or you type text, select values from combo boxes, clear or select check boxes, and click buttons.
In the corresponding scenario, you compose exactly the same sequence of actions, you specify a command for each user action in the window.
Just as you cannot perform multiple actions simultaneously in the window, the scenario executes commands successively.
To construct the scenario, you reflect the actions you make in the window in the sequence of commands for the scenario.

Because in these scenarios you either save data to an external system or file, or upload data from an external system or file to Visma Net, you must define in Visma Net the format of the external system or file. For this purpose, you set up a data provider in the system.
A data provider is an entity that defines the structure of the external data source; Visma Net then uses the data provider to transfer data from and to the external system or file.

Therefore, to use an integration scenario, you have to define the data provider and the needed import or export scenario.
An integration scenario works as if the data is being manually processed in a Visma Net window.

Manual input and integration scenarios input

When you are creating an integration scenario, you first create the needed data provider, which defines the type and schema of the data source.
For example: The type can be an Excel file, and the schema of an Excel data source consists of the names of spreadsheets that should be used for data import or export and the list of columns on the spreadsheets.
If the external data source has changed (for example, if a new column has been added to an Excel spreadsheet), you have to update the data provider in Visma Net to be able to use the new column in scenarios for which the data provider is specified.

After you have prepared the data provider, the second step is to define the scenario, including the scenario mapping.
You can construct a scenario for any data entry window. In the scenario, you use internal fields, which are the fields of Visma Net, and external fields, which are defined in the specified data provider. In the scenario, you map internal fields to external fields and specify commands.
An integration scenario is specific to the Visma Net window and the external data schema.

After the scenario is ready, you can run the import or export for the scenario to get the result.
You can also schedule scenarios to be run, so that you can import and export data on a regular basis.