English

Troubleshoot import and export

Find solutions to some common import and export questions. Importing means loading data into Anaplan models from text files, other Anaplan models, databases, spreadsheets, and other accounting and reporting systems.

This article is for all users.

Import 

Error “Import Connector: Failed to retrieve data from remote server”

This error can happen when there's no response from the source model for the import. Try running the import action again.

If retrying the import action is not successful, create a support case in Case Portal and include the following information:

  • A screenshot of the error.
  • The names of the source and target models.
  • The process or action name.
  • The time the process failed.

Learn more about Imports and exports as actions.

An import process is stuck at X% and is still processing

Note how long the process takes to run. Then open a support case in Case Portal and include the following information:

  • The type of process, such as a model to model, module to module, or list to module process.
  • The names of the model, module, and process.
  • Whether you run the action from a dashboard.
  • The purpose of the action, such as deleting records, updating data, or adding data.
  • The number of actions in the model that are affected.

Learn more about processes.

Errors importing data with APIs

The kinds of errors you get depend on whether you're importing data into a module or into a list.

Some errors you might see when you import data into a module are caused by:

  • Spelling mistakes in the import file. For example, if you try to import a date with a spelling error into a Time dimension. This displays the error: “Invalid date or timescale identifier.”
  • Trying to import into calculated line items. This displays an “Ignored” error.
  • Trying to import into consolidated level. This displays an “Ignored” error.

Some errors you might see when importing data into a list are caused by:

  • Importing duplicate codes. This error displays a message such as “Another row has already been processed with this key.”
  • Importing invalid codes. This error displays a message such as “Invalid name: CODE”.

To learn more, go to Understanding errors and rejected lines when importing data via APIs.

Model-to-model import errors

You can import data from one Anaplan model into another.

If you have issues when you're importing from one model into another, try these steps:

  1. Remove the original data source from the target model:
    1. In the model settings bar, select and then select Import data sources.
    2. Select the data source and then select Delete.
Import data sources image
  1. Try to import the data again. Refer to Import data from another model.

If those steps don't fix the problem, try these steps:

  1. In Anaplan Home, select Models > Manage models > Manage tasks.
  2. Select each task and select Cancel task.
  3. In the target model, delete the source file from the model.
  4. Try importing again.

Learn more about model to model import in this lesson.

Also refer to Access constraints in model-to-model imports.

Error: Failed to locate model (source model)

This error can occur when you create an import between two models within the same workspace, then copy the target model to another workspace. If you try to run the import in the new model or create a new import using the original data source, you may get the error.

To correct the error, follow these steps:

  1. In the model with the error, select Source models in the model settings bar.
  2. Select the model that is the source of the import. 
  3. Select Edit mapping. The error message "Original source model is not available." displays
  4. Select the workspace for the source model from the dropdown, then the source model, then OK.
  5. Retry the import action. 

Export

An export action does not create a file

This issue happens when the file for export is unavailable on the server. The cause might be that the file is private. A private export file can only be accessed by the user who originally exported the data from the model. When you create an export action, you can save the export definition, and select who can access the file. If you select Myself (keep private), only you can access the file.

To learn more, go to Overview of private and default files.

Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.