Data Import

With the Data Import automation, data can be exported as a CSV file from an external source which can then be uploaded automatically to Vasion and the data mapped into a table You can then set the frequency for when and how often to run the automation. The first time the automation runs, it creates a new table where to store the data, which is then updated every time the automation runs.

Data Import supports local and UNC A standard for identifying servers, printers and other resources in a network. A UNC path uses double slashes or backslashes to precede the name of the computer. paths.

Requirements

Before you create the Data Import automation, you must already have the following:

  • A data file in CSV format
  • The location of where the file is located

To create a new Data Import automation you must configure:

  1. General Settings
  2. Build Lookup

1. General Settings

  1. In the Automation app click on Data Import in the side navigation.

  2. Click on the New Data Import button.

    Automation - Data Import page

  3. In the General tab, enter the name for the new Data Lookup automation in the Import Name field.

  4. If you have an on-premises instance of Vasion, you may enter a value on the Run On Machine filed otherwise leave blank.

    General Data Imporr Configuration

    The value in this field determines the server used to run the automation and is only required where there are multiple Vasion clients and / or client services running for the environment.

  5. Use the Perform drop-down to select the frequency you want the automation to run. The next fields that display depend on what you select here.
    1. Once — use this option to only run the automation once. The next field display updates to Start Date, and you can type the date in the format shown or click on the Calendar icon Calendar icon to pick the date.
    2. Daily — use this option to run the automation every day. The only remaining option is the Start Time.
    3. Weekly — use this option to run the automation once a week. The next field updates to Weekdays and you can use the drop-down to select one or more days of the week by checking the appropriate box.
    4. Monthly — use this option to run the automation once a month. The next field updates to Months and you can use the drop-down to select one or more months by checking the appropriate box.
    5. Frequency — use this option to run the automation at a specified time interval in minutes. In the next field, type in the number of minutes for the time interval.
  6. In the Start Time, enter the time of day to run the automation in the format shown or click on the Clock icon Clock icon to pick the time.
  7. If the Monthly option is selected, a Day of Month field is shown. Type in the day of the selected month(s) when you would like to run the automation.

2. Build Data Import

  1. Use the Import From drop-down to select whether the import file is stored in a Vasion drive or in an external location.

    1. Vasion Folder — click Browse to navigate to the location where the file is stored.

      Import from a Vasion folder fields

    2. Cloud Storage — click Browse to navigate to the cloud storage location where he file is stored.

      Cloud storage option

    3. External Source — enter the UNC path in the Folder field.

      Import from external location fields

  2. Select Import to New Table and complete the following:.

    Currently Data Import cannot import into an existing table.

    1. New Table Name — enter the name for the new table.
    2. File Format — use the drop-down to select CSV.

      1. In the Delimiter field enter the character to use as delimiter.

        Select file format drop-down and delimiter character

    3. This is an optional step if you would like to map the data. In Sample File, upload a CSV file with sample column headers and data to use for mapping and click on Configure Mapping.

      Upload a sample file to configure mapping

    4. In the Mapping Configuration modal complete the following:
      1. In the Column Name field, enter the name you would like to assign to the column in your new table.
      2. In the Map to drop-down select a column name from the sample CSV file to associate the new name to the existing column.

      3. Repeat the above two steps until all the fields are mapped.

  3. Select from one of the following options:
    1. Delete All Rows in Destination Table — use this option if your CSV file contains all the records you want in the table and you would like to override the existing data in the table every time the automation runs.
    2. Append rows to Destination Table — use this option if your CSV file only contains updated information and you would like to add the records to at the end of the table every time the automations runs.

  4. Move to Completed Folder — check this box if you want Vasion to move the file to a new location once it has finished processing. When this option is selected, click on he Browse button to navigate to location. If importing from an external source enter the path to where you want to save the file.

  5. Delete File Upon Import — check this box if you would like Vasion to delete the source file after the automation runs.

  6. Send Report via Email — check this box if you would like to receive a summary report that shows the results of the file process. When you check this box, enter an email address. You can add multiple email addresses by clicking the Add Report Email button to see a new field.

The recipients receive a summary email that shows how many files were processed, the number of records imported and details if any records fail to import.

Permissions

You can change who can see or edit the automation by assigning user or group permissions. If you leave all users and groups in the left column, then the automations can be seen by all users and groups by default.

  1. Click on the Permissions tab at the top of the screen.
  2. Select the users and / or groups you would like to have permission to access the folder and click the right arrow button Right arrow icon.
  3. You can also add or remove all users or groups by clicking on the Add All or Remove All buttons above each column.

Automation permissions

The roles that a user has can also limit which users can see and run this job. See Roles for more information on what roles do and how they may affect what you are trying to do.

When the configuration is complete, click Save at the top of the page to save your automation and run automatically based on the specified settings.

Run Manually

You can run the Data Import automation at any time by selecting Run Manually from a selected data import.

Run Manually option in automation menu