{"id":24300,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/evimport-1\/"},"modified":"2025-02-17T10:37:50","modified_gmt":"2025-02-17T18:37:50","slug":"evimport-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/command-line-interface-1\/evimport-1\/","title":{"rendered":"evimport"},"content":{"rendered":"<p>This command enables the user to import a tab-delimited file from which records can be parsed and added to the database.<\/p>\n<h3>\n\tSYNOPSIS<\/h3>\n<p class=\"fixedWidthFont\">evimport [-c] [-n] [-a attachment_dir -o field_name] file.txt<\/p>\n<p class=\"fixedWidthFont\">evimport -u file.txt<\/p>\n<p class=\"fixedWidthFont\">evimport -ui file.txt<\/p>\n<p class=\"fixedWidthFont\">evimport -n file.txt<\/p>\n<h3>\n\tNOTES<\/h3>\n<ul>\n<li>\n\t\tThe issues will be added to the business area and project set by the <span class=\"fixedWidthFont\">evproj<\/span> command<\/li>\n<li>\n\t\tOnly fields on the ADD_PROBLEM layout for the nominated business area and project can be included within the import, and the user must have write permissions to these fields<\/li>\n<li>\n\t\tReads in a text file composed of tab delimited fields. Saving a spreadsheet in a tab-delimited format typically composes this file<\/li>\n<li>\n\t\tThe first (non-blank non-comment) line contains titles for database items that must match exactly what is returned from <span class=\"fixedWidthFont\">evaddlist<\/span>. This line specifies which column should be inserted into which database field inside ExtraView<\/li>\n<li>\n\t\tThe rest of the tab-separated rows in the file are read and an issue record is created within ExtraView for each row. If a line contains only <span class=\"fixedWidthFont\">__END__<\/span> all lines after it are ignored. This allows for storing titles and other values without affecting the running of the command.<\/li>\n<li>\n\t\tIf a title in the first line begins with an asterisk (*), that column is skipped entirely. This is useful in case the original file has additional columns of data irrelevant to the import<\/li>\n<li>\n\t\tIf a line contains only the text <span class=\"fixedWidthFont\">__END__<\/span>, then this line and all following lines will be ignored<\/li>\n<li>\n\t\tBlank lines and those beginning with a hash mark (#) are ignored<\/li>\n<li>\n\t\tIf one or more records cannot be imported because of data errors, they are written to a file named <span class=\"fixedWidthFont\">errors.txt<\/span>. This file may be edited, renamed and used again with the evimport program. Note that the same filename is used for each set of errors, so be sure to rename this before running the command again<\/li>\n<li>\n\t\tThe <span class=\"fixedWidthFont\">-n<\/span> option suppresses the sending of email to users as each issue is entered into the database<\/li>\n<li>\n\t\tWhen the <span class=\"fixedWidthFont\">-c<\/span> option is used, the file is processed, without updating ExtraView. This is good for error verification before actually doing the inserts. Typical errors are values that are not valid for an unknown release or category<\/li>\n<li>\n\t\tThe <span class=\"fixedWidthFont\">-u<\/span> option presents a list of titles to the user and asks which ones you wish to find unique fields for. Then the file is parsed in its entirety. The parser will search for uniquely occurring values within the requested fields. This is useful for preparing ExtraView metadata before doing the actual <span class=\"fixedWidthFont\">evimport<\/span><\/li>\n<li>\n\t\tThe <span class=\"fixedWidthFont\">-ui<\/span> option is similar to the <span class=\"fixedWidthFont\">-u<\/span> option, except that after showing the set of unique values, the program asks if the invalid ones (marked with an asterisk) should be inserted into ExtraView as valid values for this field. After saying <span class=\"fixedWidthFont\">y<\/span> to all of these questions <span class=\"fixedWidthFont\">evimport -c<\/span> should succeed<\/li>\n<li>\n\t\tIf the data being imported contains text fields with multiple lines, the end of line character(s) within the import file must be changed before the import is commenced. If this is not done, the end of the first line is interpreted as the end of the record. To overcome this, change the end of line character(s) within the text fields to <span class=\"fixedWidthFont\">&lt;&lt;EV_DELIM_EOL&gt;&gt;<\/span>. The evimport command will alter the data as it is being imported to reinstate the new lines within the data. The <span class=\"fixedWidthFont\">&lt;&lt;EV_DELIM_EOL&gt;&gt;<\/span> value can be altered with an assignment, to be a different character string like so:<\/p>\n<p>\t\t<span class=\"fixedWidthFont\">EOL = **<\/span><br \/>\n\t\t&nbsp;<\/li>\n<li>\n\t\tIf the data being imported contains tab characters they can be handled in a similar fashion to the EOL character. If a field value contains <span class=\"fixedWidthFont\">&lt;&lt;EV_DELIM_TAB&gt;&gt;<\/span>, this string or an equivalent value will be translated into a tab character as the import is performed. To replace the <span class=\"fixedWidthFont\">&lt;&lt;EV_DELIM_TAB&gt;&gt;<\/span> value, use:<\/p>\n<p>\t\t<span class=\"fixedWidthFont\">TAB = REPLACE_ME_WITH_A_TAB<\/span><br \/>\n\t\t&nbsp;<\/li>\n<li>\n\t\tThe <span class=\"fixedWidthFont\">-a<\/span> option is always used with the <span class=\"fixedWidthFont\">-o<\/span> option. Should these be present, they indicate that attachments will be uploaded with the issues in <span class=\"fixedWidthFont\">file.txt<\/span>. The <span class=\"fixedWidthFont\">attachment_dir<\/span> is the name of the directory where the attachments are stored. Within this directory, there will be sub-directories whose name is derived from the value of the import field, field_name. For example, if the <span class=\"fixedWidthFont\">attachment_dir<\/span> is <span class=\"fixedWidthFont\">\/mydir\/attachments<\/span>, and the import field is this_field then the attachment files for the issue will be found under the directory named <span class=\"fixedWidthFont\">\/mydir\/attachments\/this_field<\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This command enables the user to import a tab-delimited file from which records can be parsed and added to the database. SYNOPSIS evimport [-c] [-n] [-a attachment_dir -o field_name] file.txt evimport -u file.txt evimport -ui file.txt evimport -n file.txt NOTES The issues will be added to the business area and project set by the evproj&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":24277,"menu_order":40,"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-24300","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>evimport - 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\/command-line-interface-1\/evimport-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"evimport - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"This command enables the user to import a tab-delimited file from which records can be parsed and added to the database. SYNOPSIS evimport [-c] [-n] [-a attachment_dir -o field_name] file.txt evimport -u file.txt evimport -ui file.txt evimport -n file.txt NOTES The issues will be added to the business area and project set by the evproj...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/command-line-interface-1\/evimport-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-17T18:37:50+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=\"4 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\/command-line-interface-1\/evimport-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/command-line-interface-1\/evimport-1\/\",\"name\":\"evimport - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-02-17T18:37:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/command-line-interface-1\/evimport-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/extraview-25\/command-line-interface-1\/evimport-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/command-line-interface-1\/evimport-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\":\"Command Line Interface\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/command-line-interface-1\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"evimport\"}]},{\"@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":"evimport - 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\/command-line-interface-1\/evimport-1\/","og_locale":"en_US","og_type":"article","og_title":"evimport - Product Documentation","og_description":"This command enables the user to import a tab-delimited file from which records can be parsed and added to the database. SYNOPSIS evimport [-c] [-n] [-a attachment_dir -o field_name] file.txt evimport -u file.txt evimport -ui file.txt evimport -n file.txt NOTES The issues will be added to the business area and project set by the evproj...","og_url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/command-line-interface-1\/evimport-1\/","og_site_name":"Product Documentation","article_modified_time":"2025-02-17T18:37:50+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/command-line-interface-1\/evimport-1\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/command-line-interface-1\/evimport-1\/","name":"evimport - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-02-17T18:37:50+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/command-line-interface-1\/evimport-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/extraview-25\/command-line-interface-1\/evimport-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/command-line-interface-1\/evimport-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":"Command Line Interface","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/command-line-interface-1\/"},{"@type":"ListItem","position":4,"name":"evimport"}]},{"@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\/24300","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=24300"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24300\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24277"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=24300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}