Troubleshooting and FAQ

Import and export

The following are some common issues our users have reported while using our import/export tool and how to fix them!


You attempted to import an empty value into required field Name

ERROR:You attempted to import an empty value into required field ______. This column cannot contain any empty values.

What's wrong?

This error appears when a field that requires a value (hence required) does not have a value. This will be a column on your csv or Excel file which has an empty cell.

How do I fix it?

Since the field is listed as required, you will have to go back to the csv or Excel and update the appropriate column(s) to ensure each row has a data value. When done, save the file and re-attempt the import process.


Value which you tried to insert into column

ERROR:Value ______, which you tried to insert into column ______ of type ______ could not be interpreted as a ______.

What's wrong?

This error appears any time your data doesn't match the field type.

In our example above, the DueDateStart field is expecting a value that is of type DateTime. However, the value "Now" is of type Text.

How do I fix it?

In the Prepare Data step, make sure the data you want to import can be accommodated by the field type where you choose to import.

  • If you want to import to an existing field, take a look at the fields available in the destination table and make sure the field you choose will accept the data you’re trying to import.
  • If you want to import to a new field, make sure you choose a field type that can accommodate your data.

For more information on field types and their restrictions, please see this document.


You attempted to import values without having the required field

ERROR:You attempted to import values into table ______ without having the required field ______ as one of your columns. Please return to step 'Prepare Data' of the import and make sure that field ______ is one of the columns selected for importing.

What's wrong?

Your data is missing a field that is required by the table to which you’re importing.

Some tables in Method have required fields, which means a field that must be filled out in order for Method to save the record.

For example, the Customers and Leads table requires the name field to be filled out. If your data does not have a name column when you import it, you will get this error.

How do I fix it?

  1. Before you import your data, go to the table you’re importing to and check which fields are marked required(has a checkbox). Then, make sure that field exists as a column header in your spreadsheet.
    If using one of our templates, columns highlighted in green are required fields.
  2. Once you have created and populated all required fields for the destination table, save your data file. You will now be able to import your data!

Value longer than maximum allowed

ERROR:Value ______, which you tried to insert into column ______ was longer than the maximum allowed length of ______.

What's wrong?

Data you imported is longer than the maximum allowed length for the field.

In Method tables, some fields restrict the number characters.

For example, in the Customer table, the Name field will only allow a maximum of 41 characters in order for the data to successfully sync to QuickBooks. If you try and exceed this length, you will encounter this error and be asked to fix it.

How do I fix it?

You can fix this by editing the record to be less than the maximum amount.


Save Warning: Could not be sent to QuickBooks.

After importing data, you may encounter this:

ERROR:Save Warning: The ______ could not be sent to QuickBooks. This ______ is already in use. Please edit the ______ so that it is unique and save again.

I successfully imported my data to a table in Method, but I have encountered an error that looks like this:

What's wrong?

Some of the data you have imported is not unique.

In Method tables, some fields require a unique value to be inputted.

For example, in the Customer table, all names in the Name field must be unique in order for the data to successfully sync to QuickBooks. This means you can’t have two records with the name “Tim Smith”. If you try, you will encounter this error and be asked to fix it by editing the record to make it unique.

How do I fix it?

This screen, the Fixing Errors screen, allows you to make changes directly. You can fix this error by editing the record to make it unique, but how you do so depends on the data.

  • Select Do Not Import to eliminate the duplicate record altogether (for example, if you had two records for “Red” in a field for “Favorite Color” you could just get rid of one of them).
  • In cases of a duplicate name, for example two Tim Smiths, they may actually be two different customers named Tim Smith. In this situation, you can choose to include additional information (for example, a middle initial like Tim J. Smith versus Tim B. Smith) – anything to make the record unique.

Once you do, click Fix Errors to complete your import!


Data could not be found as a possible value to insert

After importing data, you may encounter this:

ERROR: ______ could not be found as a possible value to insert.

What's wrong?

You tried to import a value that does not exist in a dropdown field.

A dropdown field in Method displays information that is being pulled from another table.

For example, the Edit Customer screen allows you to assign a Lead Source to a lead by providing a dropdown list of options to choose from. In our example above, we tried to assign the lead source “Conference” to one of our customer records. Since “Conference” doesn’t exist in the LeadSource table, we couldn’t import the value.

This error can also be caused if you misspelled the value in your data. The error prompts you to check the spelling of the value, and if you have misspelled it, you can fix it from this screen and click Fix Errors to implement the change.

How do I fix it?

If the error is caused by a value that’s missing from the dropdown, you will need to add the value to the dropdown table.

For example, to add a new lead source, there is a New / Edit Lead Source link which is in the Lead Source dropdown itself when adding a new lead.

Alternatively, you could import the new value into the dropdown table itself.

Once the new lead source has been saved, you will be able to retry your import and it should work perfectly!


Currently we support importing of files only in CSV

ERROR:Currently we support importing of files only in comma delimited format - .csv or tab delimited format - .txt

What's wrong?

The data file you’re trying to import is an unsupported file type.

Currently, the import/export tool only supports certain types of data files: specifically the comma delimited format ( or .csv) and tab delimited format (or .txt).

How do I fix it?

Make sure the file you want to import is saved as one of the two accepted file types.

For example, in Excel, when saving your file:

  1. Go to Save as and change the Save as type to .csv.
    If you are using our template, you will have downloaded it as an .xlsx file. When you re-save it as a .csv file, all styling will be lost, but this will not influence your data.
  2. Then, on the Import/Export menu, click Choose File and choose the .csv file for import.

[top]

Was this article helpful?

Can’t find what you’re looking for?

Contact Us