{"id":24172,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/file-import-issue-data-1\/"},"modified":"2025-02-28T16:44:01","modified_gmt":"2025-03-01T00:44:01","slug":"file-import-issue-data-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/","title":{"rendered":"File Import &#8211; Issue Data"},"content":{"rendered":"<p>The file import utility allows the administrator to upload a tab-delimited or comma-delimited file from their client computer, for the fields and values within this file to be mapped to ExtraView values, to validate the data and to finally import the data. Data can be uploaded as new issues or can be used to update existing issues. Access to this feature is via the security permission key named CF_FILE_IMPORT. The import works as a separate process for each business area and project therefore your import files will only target a single business area and project. For a record to be imported and inserted as new, it must exist on the appropriate <em>add<\/em> layout or one of its embedded layouts for the business area and project. For a record to be imported and update an existing record, it must exist on the appropriate <em>edit<\/em> layout or one of its embedded layouts for the business area and project.<\/p>\n<div style=\"background-color: #d3d3d3;\"><strong>Note<\/strong>: The Add \/ Update task must be configured and running for the file import utility to work.\u00a0 This is because the performance is optimized when the utility is running in the background.\u00a0 Further, this allows multiple copies of the utility to run at one time, further increasing the performance of the import.<\/div>\n<p>Typically, the files to be imported will contain data from other systems that is to be inserted into ExtraView. Microsoft Excel is a good tool that can be used to prepare data in the appropriate format for the import. The process followed is:<\/p>\n<ul>\n<li>Create a template for the import and upload the file<\/li>\n<li>ExtraView automatically provides mappings for fields that are both in the uploaded file and within the ExtraView database<\/li>\n<li>ExtraView automatically provides mappings for field values that are both in the uploaded file and within the ExtraView database<\/li>\n<li>You can see the results of the mapping and alter the mapping of any field or field value<\/li>\n<li>You may then validate the uploaded data, ensuring the file is error free before performing the upload<\/li>\n<li>On the validation screen, there is an alternative to download the file that was uploaded. This is in addition to being able to observe the errors on the screen. If there were errors in the uploaded data found by the validation process, these errors will be shown within the file you can download. This simplifies the process of finding, fixing, re-uploading and re-validating the data before you perform the import<\/li>\n<li>Finally, you can perform the import and insert the records.<\/li>\n<\/ul>\n<p class=\"textGreyBg\"><b>Note<\/b>: ExtraView will ignore whether fields are or are not mandatory when importing data. It will also ignore whether fields have the correct allowed value relationships when importing data. It will not ignore read-only fields and later in this section, you will find how to import fields that are read-only on your <em>edit<\/em> screen layout. However, when you edit any of these records in the web-interface or via the CLI, and attempt to update, the appropriate validations will be performed, and you must correct any errors of these types at this time. Fields with default values defined in the data dictionary will have the default value created, unless there is a value provided in the import file.<\/p>\n<h3>Import Templates<\/h3>\n<p>When you use the File Import Utility, you create a template that may be reused as many times as needed. This aids the repetitive process of validating and correcting your data. You can set up the field and value mappings once and upload your import file as often as is required, validating the data as you progress. This also aids the routine uploading and importing of data from other sources, as the same mappings can be used each time, without the need to set these up.<\/p>\n<p>There are three import modes from which to select, when you create the import template:<\/p>\n<ol>\n<li><b>Insert Issues<\/b> &#8211; New issues are created from each record in the import file.<\/li>\n<li><b>Update Issues<\/b> &#8211; Existing issues are updated from each record in the import file. There must be an <b>ID<\/b> column within the import file, and this must contain the <b>ID<\/b> of the issue to be updated<\/li>\n<li><b>Update and Insert Issues<\/b> &#8211; New issues may be created and existing records may be updated. To facilitate this, there must be an <b>ID<\/b> column within the import file, and this must contain the <b>ID<\/b> of issues to be updated. If the field is left blank, then the record will be inserted. Note that the corresponding <em>add<\/em> layout for the business area and project is used for validation purposes, when inserting issues, and the <em>edit<\/em> layout is used when updating issues<\/li>\n<\/ol>\n<h3>Importing Issues Directly from an <em>Add<\/em> or <em>Edit<\/em> Screen<\/h3>\n<p>As part of an end-user workflow, the administrator can configure a button that is invoked on an <em>add<\/em> or <em>edit<\/em> screen.\u00a0 This will pop up a window into which the user provides the details of a file to upload.\u00a0 Note that this will use a predefined import template set up by an administrator.\u00a0 When the file has been uploaded, there is an optional feature to define a report that is run on the <em>add<\/em> or <em>edit<\/em> screen.\u00a0 This is typically used to display the results of the import.\u00a0 Instructions on configuring this feature are found <a href=\"v25\/importing-issues-within-add-and-edit-screens-0\/\">here<\/a>.<\/p>\n<h3>Large Volume Imports<\/h3>\n<p>Special consideration may be made when you have tens of thousands or more records that must be imported in a short space of time.\u00a0 You may configure multiple import files, and these can be imported in parallel.\u00a0 Please see the section on <a href=\"v25\/large-volume-imports-1\/\">large volume imports<\/a> for more information.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The file import utility allows the administrator to upload a tab-delimited or comma-delimited file from their client computer, for the fields and values within this file to be mapped to ExtraView values, to validate the data and to finally import the data. Data can be uploaded as new issues or can be used to update&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":24165,"menu_order":6,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"no","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-24172","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>File Import - Issue Data - Product Documentation<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"File Import - Issue Data - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"The file import utility allows the administrator to upload a tab-delimited or comma-delimited file from their client computer, for the fields and values within this file to be mapped to ExtraView values, to validate the data and to finally import the data. Data can be uploaded as new issues or can be used to update...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-01T00:44:01+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/\",\"name\":\"File Import - Issue Data - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-03-01T00:44:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ExtraView 25\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Administration Guide\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Import \/ Export\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"File Import &#8211; Issue Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"name\":\"ExtraView Product Documentation\",\"description\":\"ExtraView Documentation\",\"publisher\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\",\"name\":\"ExtraView Corporation\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"contentUrl\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"ExtraView Corporation\"},\"image\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"File Import - Issue Data - Product Documentation","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/","og_locale":"en_US","og_type":"article","og_title":"File Import - Issue Data - Product Documentation","og_description":"The file import utility allows the administrator to upload a tab-delimited or comma-delimited file from their client computer, for the fields and values within this file to be mapped to ExtraView values, to validate the data and to finally import the data. Data can be uploaded as new issues or can be used to update...","og_url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/","og_site_name":"Product Documentation","article_modified_time":"2025-03-01T00:44:01+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/","name":"File Import - Issue Data - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-03-01T00:44:01+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":2,"name":"ExtraView 25","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":3,"name":"Administration Guide","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/"},{"@type":"ListItem","position":4,"name":"Import \/ Export","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/"},{"@type":"ListItem","position":5,"name":"File Import &#8211; Issue Data"}]},{"@type":"WebSite","@id":"https:\/\/docs.extraview.com\/v25\/#website","url":"https:\/\/docs.extraview.com\/v25\/","name":"ExtraView Product Documentation","description":"ExtraView Documentation","publisher":{"@id":"https:\/\/docs.extraview.com\/v25\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.extraview.com\/v25\/#organization","name":"ExtraView Corporation","url":"https:\/\/docs.extraview.com\/v25\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/","url":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","contentUrl":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","width":512,"height":512,"caption":"ExtraView Corporation"},"image":{"@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"carl.koppel","author_link":"https:\/\/docs.extraview.com\/v25\/author\/carl-koppel\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24172","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/comments?post=24172"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24172\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24165"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=24172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}