Page tree
Skip to end of metadata
Go to start of metadata

Use the table below to troubleshoot common errors that can occur when using AroFlo's bulk data import feature.

ProblemCauseSolution

You get the error message, 'Unsupported File Type'

The wrong file type has been used.

Re-save your file as either a comma separated values (.csv) file, or an Excel 97-2003 Workbook (*.xls) and start the import again.

You may like to use one of our Bulk Data Import templates to prepare your data.

A file saved as .xlsx or in any other format will not upload into AroFlo.


The top row of your data appears as a heading row.

Click to enlarge


If your spreadsheet does not contain a heading row, AroFlo will take the top row of data and use it as a heading row.

Click the checkbox at the top of the Bulk Data Import window to switch off the Use First Row As Headings option.

The Bulk Data Import window hangs.

The data file could be too large.

Check that your data does not exceed our recommended data limits.
The data file may contain multiple tabs or worksheets.Split the file so that it only contains one tab or worksheet.
QuickBooks data does not align with template columns.QuickBooks inserts a blank column between each data column.Before importing your data, remove all the blank columns from between the data columns in your .csv or .xls file.

You receive a report that there were Download Issues:

Click to enlarge

There are different things that can cause this. Click the 'Download Issues' button to view the details of each issue.

Here are some examples of the types of issues that can occur, and how to fix them.

  • [Record name] already exists. AroFlo does not upload records that already exist in the system. It gives this message for your information only; there is no action you need to take.
  • Surname cannot be blank. In AroFlo, 'Surname' is a mandatory field for client and supplier contacts. If your data does not contain surnames, you could enter the word 'Accounts' in the Surname column of your data file so that AroFlo has a value to import. For example, you could have a contact called Joe Accounts.
    Note: 'Surname' maps to 'Primary Contact Last Name'.
  • First name cannot be blank. In AroFlo, 'First Name' is a mandatory field for client and supplier contacts. If your data does not contain first names, you could enter the name 'Accounts' in the First Name column and 'Payable' in the Surname column, so your contact would be 'Accounts Payable'.
    Note: 'First Name' maps to 'Primary Contact First Name'.
  • 7 [or Net 30, or some other value] is not a valid transaction term: Make sure the transaction terms in your data file use the exact same format as the transactions terms you have set up in AroFlo.
  • The 'orgname' field exceeded the size limit of 50: Abbreviate any names that are longer than 50 characters and try the upload again.
Your issue is not listed here and you'd like some help.-Please Submit a Support Request or give us a call.