Open Data

The Open Data action opens the following databases:

  • Access 97-2003 Database (*.mdb)

  • Access 2007-2010 Database (*.accdb)

  • dBase III Table (*.dbf)

  • Comma-Delimited Text File (*.csv, *.txt)

Note: The Actions Quick Reference provides a complete list of actions that you can print for easy reference.

  1. Click Data in the Actions menu.

    The Actions list expands.

  2. Click Open Data.

    The Action Builder opens.

  3. Select the Source Database File.

  4. If you selected a dBase III Table (*.dbf) file, click OK to save the action.

  5. If you selected an Access Database (*.accdb, *.mdb) file, enter or select the Table to open and then click OK to save the action.

  6. If you select a Comma-Separated Value file (*.csv, *.txt) file, follow these instructions:

    Note: Because Nintex RPA LE does not work directly with Comma-Separated Value (*.csv, *.txt) files, you must import the data into a Microsoft Access Database file (*.accdb) through the bot wizard.

    1. (Optional) Select a template.

    2. Specify the delimiter . This is how Nintex RPA LE knows where to split the data. The default is Comma.

    3. Click Next.

    4. Select the Start and End rows for parsing the data.

    5. (Optional) Select to Include the field names in the original data source.

    6. (Optional) Select the columns that you want to remove.

    7. Click Next.

    8. (Optional) Deselect the fields that you want to exclude.

    9. Click Next.

    10. Select the location to save the Access Database. The default is the same as the source data file with the .accdb file extension. If the file already exists and you want to overwrite it, select the Overwrite check box.

    11. Click Next.

    12. (Optional) Import a template.

    13. Click Done. Your data will import.

  7. If the action is inside of a Before Task, from the Run drop-down list, select to run All records or to run Once when the action is executed. If the action is outside of a Before Task, inside of an After Task, or inside of a Normal Task, it will only run once when it is executed.

  8. If needed, adjust the Run Error Task settings to fine tune how the action runs:

    1. Click Run error task.
    2. Open the On Error drop-down list and select the required setting:
      • Run error task: A botflow containing an error task automatically runs the error task in the event of an error. If the botflow does not contain an error task, the botflow stops in the event of an error.
      • Stop on error: The botflow stops in the event of an error.
      • Ignore errors: The action is skipped in the event of an error and the botflow attempts to execute the next action.
    1. Click X to close the drop-down and save the setting.