Method CRM Try it FREE
 Method CRM Help Center
 Search  
Overview
Getting Started Checklist
Customization
Method FAQ


collapse all | expand all
Troubleshooting and FAQ
Solution No. 681

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

Field types reject user data[top]

I’m trying to import my data to a new or existing field, and when I click Import Data…, I receive an error that looks like this:

What am I doing wrong?

This error appears if you pair your data with the wrong field type.

In our example above, the values for the Car Make column are text values (Volvo, BMW, etc.) and we’ve tried to insert them into a DateTime field. Since the values aren’t in DateTime format, they can’t be imported. You will see this error any time your data doesn’t match the field type you’re trying to use:

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

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.

File type not supported[top]

I’m trying to import my data to a new or existing field, and when I click Import Data…, I receive an error that looks like this:

What am I doing 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).

In our example above, we attempted to import data saved in a regular Excel file (extension .xlsx). Since the tool doesn’t support that file type, we’re not able to import! Here is the error:

ERROR: Currently we support importing of files only in comma delimited format - .csv or tab delimited format - .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.

Your import should work properly now!

Missing required fields[top]

I’m trying to import my data to a new or existing field, and when I click Import Data…, I receive an error that looks like this:

What am I doing 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 that a name field be filled out. If your data does not have a name column when you import it, you will get this error:

ERROR: You attempted to import values into table ______ without having the required field name ______ 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.

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. Then, make sure that field exists as a column header in your data.
    There must be values associated with this field. For example, if you create the column header name but leave the column blank otherwise, you will not be able to proceed.
  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!

Field is not unique[top]

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

What am I doing 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 that you can’t have two records for a 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. This is what the error looks like commonly:

ERRORSAVEWARNING: The ____________ could not be sent to QuickBooks. The _______ is already in use. Please edit the _______ so that it is unique and save again.

How do I fix it?

You can fix this by editing the record to make it unique, but how you do so depends on the field.

  • In some cases, you can 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 like our example above, you might actually have two 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.
  • In both cases, you can make these changes directly on the Fixing Errors screen.

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

Value missing from dropdown[top]

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

What am I doing 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 customer 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.

ERROR: ________ could not be found as a possible value to insert. Please check the spelling.

How do I fix it?

If the error is caused by a value that’s missing from the dropdown, you will need to update the dropdown with that value by creating it. You can do this by going to the screen and clicking the ellipses button (...) next to the dropdown field to access the “Create New” screen.

For example, to add a new lead source, navigate to Customer > Edit Customer and click the ellipses next to the Lead Source dropdown, then follow the on-screen instructions and save the new lead source.

Once the new lead source has been saved, Method will recognize it in your data. You will be able to retry your import and it should work perfectly!

[top]

Was this article helpful?