To Import Data from a Local File to a Table

You can import data from an Excel spreadsheet or a CSV file to an MYOB Advanced table when you see the Load Records from File () button on the table toolbar.

Attention: Acumatica ERP uses the spreadsheet format introduced in Microsoft Office 2007, so if you use an earlier version of Microsoft Office, you should install the appropriate plug-in.

For more information, see Table Toolbar and Integration with Excel.

To Import Data from a Local File

  1. Open the appropriate form, and select the record to which you want to import data or add a new record.
  2. On the table toolbar, click Load Records from File ().
  3. In the File Upload dialog box, click Choose File and select the file you want to import.
  4. Click Upload to upload the file to the system.

    After the file is uploaded, the Common Settings dialog box is opened.

  5. To import an Excel spreadsheet, do the following in the Common Settings dialog box:
    1. If an atypical null value is used in the uploaded file, specify the value in the Null Value box.
    2. In the Culture box, select the region whose measurement settings have been used in the uploaded file.
    3. In the Mode box, select the option that determines which data will be imported into the table:
      • Update Existing: To update the rows that are already present in the table and add new rows that are not present in the table.
      • Bypass Existing: To import only new rows that were not present in the table. The existing rows will not be updated.
      • Insert All Records: To add all rows from the file to the table.
        Attention: If you select this option, you may get duplicated rows because the system won't check for duplicates when importing rows from the file.
    4. Click OK.
  6. To import a CSV file, do the following in the Common Settings dialog box:
    1. If an atypical separator character is used in the uploaded file, specify it in the Separator Chars box.
    2. If an atypical null value is used in the uploaded file, specify the value in the Null Value box.
    3. Select the encoding of the uploaded file in the Encoding box.
    4. In the Culture box, select the region whose measurement settings have been used in the uploaded file.
    5. In the Mode box, select the option that determines which data will be imported into the table:
      • Update Existing: To update the rows that are already present in the table and add new rows that are not present in the table.
      • Bypass Existing: To import only new rows that were not present in the table. The existing rows will not be updated.
      • Insert All Records: To add all rows from the file to the table.
        CAUTION: With a CSV file, the uploaded file must contain only rows that have not already been imported. If the system encounters a row that already exists in the table, the import process will be terminated. To resolve the situation, click Cancel on the form toolbar, and then try to import data in another mode.
    6. Click OK.
  7. In the Columns dialog box, match the columns of the imported file (displayed in the Column Name column) to the columns in the MYOB Advanced table to which you want to import data (displayed in the Property Name column).
  8. Click OK to import data to the table.
  9. After the data is successfully imported, click Save on the form toolbar.

After the data is imported and the document is saved, you can continue processing the document according to your organization's workflow.