Import and export resources pageDescription .mce-toc { background-color: #f7f7f7; padding: 10px; border-radius: 5px; border: 1px solid #dedede; width: 50%; min-width: 500px; } Table of Contents Product documentationFeature description/How toTroubleshooting Import IssuesTroubleshooting Export IssuesExport ProblemsExport SolutionsVideos ImportExport Community (Import/Transform)Community (Export) Product documentation Import setsExport sets Feature description/How to Developer blog: Import Series Part 1 - Getting Started with Import SetsDeveloper blog: Import Series Part 2 - Anatomy of an Import Set Troubleshooting import issues KB0867752: Import/Transform Execution Flow and Table Reference If you are a novice, this KB will help you understand the feature.If you are an expert in import/transform, then this KB may serve as a reference or cheat sheet. KB0870045: Import/Transform Summary Tool This is a helpful tool when troubleshooting Imports. This tool will give you the configuration and runtime summary for an Import Set. KB0793356: Import Set Performance Brief summary of import/transform execution flow and troubleshooting slow import/transform issues. KB0814735: Troubleshooting Slow Import Sets Tips and Tricks when working on slow import set issues KB0538436: Troubleshooting an import that is taking a long time to completeKB0538437: Troubleshooting an import that does not complete or is missing dataKB0538434: Troubleshooting an import that failsKB0564204: Troubleshooting inbound integrations performance Tips and tricks when troubleshooting slow imports using Web Services Import Set API KB0720801: Understanding Concurrent Import Sets Overview of how hierarchical scheduled and concurrent imports work in Madrid KB0832611: Concurrent Import Sets are not created even with the "Concurrent Import" option selected on the Scheduled Import Set recordKB0753011: Concurrent import set running synchronously Users may complain that they have enabled a concurrent import set but that it is running under one Import Set or not at all. KB0755790: Import Deleter schedule job doesn't clean up 7 days older data in ImportSet tables If this cleaner job fails to delete data in the import set tables, follow this procedure to run the table cleanup job manually KB0538459: Troubleshooting issues with transform maps Landing page for issues during the transform phase KB0747613: When importing data, some staging table records are duplicating or an Import set row is duplicatingKB0818304: How to identify slow data import due to coalesce?KB0793315: For a Large Volume of REST Import Set API Calls, Which Import Set Mode is Recommended for Best Performance Synchronous or Asynchronous? Best practice is to use Asynchronous mode. Let the platform accept any number of import REST calls, then perform a bulk transform at a later time. KB0781666: Making import sets created for Import Set API calls "Asynchronous" to prevent Synchronous transform, for specific imports Tip for making web service import sets a bit faster by performing transform at a later time. KB0538460: Troubleshooting Import - Missing data when importing from JDBC source via MID serverKB0538154: Determining if all columns are mentionedKB0538132: Determining if the coalesced field is configuredKB0538161: Determining if a business rule is running on top of the transform mapKB0786280: Impossible to Import a CSV file with duplicate column names in header Troubleshooting Export Issues Export FAQKB0538458: Troubleshooting export issues Landing page for troubleshooting export issues. KB0538304: Troubleshooting export - Determine if there is a custom script manipulating data at the record levelKB0518655: Export Limit/Max Overview (Excel, CSV, PDF, Database Views)Export Sets: KB0727047: Export set "Scheduled Data Exports" intermittent 'Completed with errors'KB0860033: Export Set are not placing the Files in the Expected Mid Server Export Problems KB0791852/PRB1366882: Users are unable to export from a list view if the user id is longer than 40 charactersKB0676116: Export "Active Transactions (All Nodes)" on v_cluster_transaction table fails with 0 rowsExport Sets KB0860658/PRB1434384: "No sensors defined" Error for Export Set ExportSetResult ECC Queue input records, because skip_sensor=true is missing from the StreamPipeline ECC queue output recordKB0694628/PRB1237002: Export Definition Preview UI action doesn't work when List V3 is enabled Export to PDF KB0746820/PRB1321127: Exporting a Multi-Level Pivot table type report to PDF failedKB0967318/PRB1504794: Exporting a Pivot Table Report to PDF produces a blank report...KB0745494/PRB1319548: Multilevel report export to PDF is broken with unexpected errorKB0622686: Exporting to PDF a record with a journal field with HTML tags will display themKB0725032/PRB602070:PDF exported knowledge articles is losing formatting of how it appears in ServiceNowKB0522719/PRB575855: Activity information is not available on PDF exportKB0853013/PRB1416199: Exporting record with lots of data to pdf is taking too long to process in OrlandoKB0827963: Total page numbering is wrong when exported in PDFKB0755229: PDF Export is not available to normal users even if they are able to see the recordKB0869769/PRB1434927: "OutOfMemoryError: Java heap space java.lang.OutOfMemoryError"while exporting a big report to PDF Export to XML KB0715440/PRB1311273: Export/Import XML of a KB Article containing images does not show the images in the target instance Export to CSV KB0695242/PRB963728: CSV Export fails for large reports data causing an out of memory Java error Export to Excel KB0724250: Export stopped due to excessive size. Use CSV for a complete exportKB0678177/PRB645055: Users With user_name Over 40 Characters Cannot Download Exported Excel FilesKB0621801/PRB864664: Japanese currency field is exported with additional decimalsKB0596007/PRB682833: Export to Excel creates a corrupt Excel file if there is a currency field in the list Export Solutions KB0788372: Currency conversion on Export [XML/PDF/Excel] doesnt show user's locally set currency as expected in any instances exports.KB0712564: Right click on form header missing options such as Configure or ExportKB0676119: How to restrict the Export option on lists to not show for certain tablesKB0791043: How to export work notes information for incident?Export Sets KB0687104: Export Sets not running for missing MID Server record in ecc_agent_status Export to PDF KB0752531: Export Variables in RITM (to PDF)KB0694524: Troubleshooting Report Export - Resolve connection refused error when exporting a reportKB0754273: PDF export is showing the error "An unexpected error has occured . Please see the instance logs for more details"KB0696160: How to modify or remove the table details on the exported PDFKB0818411: Export to PDF functionality for Knowledge articlesKB0715653: Some Fields Excluded from PDF Export of FormKB0675016: Report export shows message "Too much data to export"KB0815422: Export of list view reports to PDF does not display the list column headers Export to XML KB0858692: What's Needed to Export/Import Additional Comments and Worknotes between Instances KB0622059: Currency field value on a table is not exported via XML exportKB0852765: Unable to export to XML for non-admin users such as ITIL Export to CSV KB0621445: When exporting from a list view or export set using CSV, column lengths are restricted to 32,000 charactersKB0684580: Unable to export reports as csv files Export to Excel KB0748698: Export of more than 32000 records to Excel results in creation of more than one worksheet Videos Import Import Sets: Troubleshooting Truncated DataImport Sets: Troubleshooting Missing Data in Date Fields Export Troubleshooting ServiceNow Export Limits Community (Import/Transform) Transform Map Best Practices Community (Export) Increasing the Export Limit for ExcelExporting large data sets into ExcelUsing export sets for SFTP file transfer