Working with Saved CSV Imports
The Import Assistant can save import settings so that you can reuse them for later jobs. You can review mappings for your previously completed import jobs on the Saved CSV Imports page. If you are an administrator, you can review mappings for all previously completed import jobs in your account.
To work with a previously saved CSV import:
-
Go to Setup > Import/Export > Saved CSV Imports.
-
The Saved CSV Imports page lists all of the saved import mappings to which you have access. These include mappings you have saved as well as those saved by others that include you in the audience.
-
This page includes the following columns:
-
ID – unique internal ID for saved mapping
-
Name – name given to the field mapping in the Import Assistant
-
Translate – link to CSV Import Map Translation dialog (only in accounts where the Multi-Language feature is enabled)
-
Field Map – link to popup view of field mappings
-
Description – description entered in the Import Assistant
-
Type – record type of field mappings
-
Owner – user who created the field mapping in the Import Assistant, or another user selected in the Share Import dialog
-
Created – date when mapping was first saved
-
Script ID – unique ID defined on the Save Mapping & Start Import page, used to reference the import map in SuiteScript
Note:By default, import jobs created before Version 2012 Release 2, when this field was added, do not have script ID values. Import jobs created as of that release or later default to a script ID of CUSTIMPORT. If a script ID is set, it is prefixed with CUSTIMPORT.
-
Last Modified - date when mapping was last changed
-
Access - indicator of whether mapping is private, shared, or public, and link to Share Import dialog
-
Delete - button to delete mapping, available only if you are the owner
-
-
On the Saved CSV Imports page, you can do the following:
-
Select from the Record Type list to display mappings for a single record type.
-
Open the saved import in the Import Assistant to edit its settings or rerun it, by clicking the link in the Name column. See Editing a Saved Import.
-
In accounts where the Multi-Language feature is enabled, enter translations for a saved import's name and description. See Translating Import Map Name and Description.
-
Review the import's mappings by clicking View in the Field Map column. A popup opens displaying the mapped source and target fields, helping you to identify the correct import without having to go through the pages of the Import Assistant.
-
Make an import mapping available to other users, or define a different owner for it, by clicking the link in the Access column. For more information, see Sharing Imports.
-
Delete a saved import mapping, by clicking the button in the Delete column. This button is available only for mappings that you own. Only an administrator can delete saved CSV imports owned by other users.
-
Click the New button to start the Import Assistant and create another import job.
-
The popup available from the View link in the Field Map column looks like the following:
You can use SuiteBundler to include CSV import maps in customization bundles. See Including Import Maps and CSV Files in SuiteBundler.
The SuiteCloud Development Framework (SDF) supports saved CSV imports. You can create, modify, import, and export saved CSV imports, and move your saved CSV imports between accounts. For more information, see savedcsvimport.