Data import

After you have created an import scenario, you should test it on one record. If the scenario is not working as you expected, the first way to troubleshoot the scenario is to reproduce the mapping instructions manually on the window to which you want to import the data. In most cases, this troubleshooting step helps you quickly identify the reason why the scenario is not working, so that you can fix the scenario and continue.

After you have tested an import scenario, you can use it to import data in the Import by scenario (SM206036) window. To import external data to Visma Net by using a scenario that has already been created, you should perform the steps, which are described in this topic.

1. Selecting an import scenario

In the Import by scenario (SM206036) window, you first select the name of the scenario that has been created for data import.

You can select a scenario from only the scenarios that work with windows in which you can enter data. If you do not have the access rights to enter data in the window, you cannot use a scenario that imports data to this window either. If you do not have access rights to a particular window, you will not see any scenarios for this window listed among the other scenarios. You can view the access rights to particular windows in the Access rights by window (SM201020) window.

2. Uploading a new file version

If you are not using a file for importing data, skip this step.

If you are importing data from a file, decide whether you need to upload a new version of the file. The file that is used for data import is attached to the window; you can click Files in the title bar to view the file. This file is attached to each of the following windows: Data providers, Manage import scenarios (SM206025), and Import by scenario (SM206036).

If you need to use a new version of the file when importing data, you can upload the new file to the Import by scenario (SM206036) window by clicking Upload file version in the window toolbar. The schema of the uploaded file must match the schema defined in the data provider and used in the import scenario. If you have changed the file structure, you have to update the data provider and the import scenario, and only then can you use the new file to import the data.

If there is no file attached to the Import by scenario (SM206036) window, you have to upload the file either by dragging the file to the window or by using the Files menu. Do not use the Upload file version button to upload the file. After the file is uploaded to the window, you can update the version of the file by clicking Upload file version.

3. Preparing the data for import

You prepare records by uploading them in the Import by scenario (SM206036) window. To prepare the data for import, you click the Prepare button in the window toolbar. The data is displayed on the Prepared data tab; no data is yet imported into the system.

4. Importing the prepared data

To import data to the system, you click the Import button in the window toolbar of the Import by scenario (SM206036) window. The system tries to import the records with the Active check box selected one by one.

After a record has been successfully processed, the system selects the Processed check box for this record. If an error occurs during the processing of a record, the process stops on the record that caused the error.

5. Correcting any errors

If an error occurred during the import process, you have to review the error; you then do one of the following: correct the record that caused the error, or exclude the wrong record from import, or modify the import scenario. Then you have to run the import process again to process the remaining records.

If you need to correct only a small number of records, you can correct them directly on the Prepare data tab, click Save, and click Import again. You can exclude an incorrect record by clearing the Active check box, saving your changes, and clicking Import again.

If you need to correct a large number of records or all records, you can correct the records in the source, upload a new file version if you are importing data from a file, and prepare and import the data again.

If you need to correct the import scenario itself, make changes to the scenario in the Manage import scenarios (SM206025) window, and prepare and import the data again in the Import by scenario (SM206036) window. You can clear the history of scenario execution and clear the prepared data by clicking Roll back on the History tab of the Import by scenario (SM206036) window. The Roll back action doesn’t reverse records that have already been imported.

Summary of data import

After you have imported data, open the destination window and make sure that the imported records appear among the records.