{"id":24175,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/fields-4\/"},"modified":"2025-02-14T10:26:26","modified_gmt":"2025-02-14T18:26:26","slug":"fields-4","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/fields-4\/","title":{"rendered":"Fields"},"content":{"rendered":"<h2>\n\tMulti-Valued Fields<\/h2>\n<p>Fields to be imported that are of a multi-value type require special preparation within the import file. All the values to be imported must exist in between the delimiters of the file (tabs or commas), yet ExtraView must be able to distinguish between the different values. This is accomplished by using the system-wide delimiter in the behavior setting named DEFAULT_TEXT_REPORT_DELIMITER. This has a default value of the colon character \u201c:\u201d. Use this delimiter to distinguish values. For example, you may have a list with days of the week (<em>Sun, Mon, Tue, Wed, Thu, Fri, Sat<\/em>). If you need to indicate that the valid values of data within the record are <em>Tue, Fri<\/em> and <em>Sat<\/em>, you would use an entry of <em>Tue:Fri:Sat<\/em> on your spreadsheet:<\/p>\n<p><img decoding=\"async\" src=\"\/v25\/extraview-media\/images\/ag\/import_export\/importing_multi_valued_fields.png\" width=\"90%\" \/><\/p>\n<p><span class=\"imageCaption\">Importing multi-valued fields<\/span><\/p>\n<h2>\n\tText Fields<\/h2>\n<p>Fields that are to be mapped to Text Area, Log Area and Print Text display types have special treatment, to allow you to import values that contain a return character (ASCII 13). This character is normally used by many applications to indicate the end of data of a row. This implies that the data following the return character is a new record. Unfortunately, when you export a comma or tab delimited file from Excel or other applications, these return characters are treated as an end of record. To counteract this in a way acceptable to Excel and the import facility in ExtraView:<\/p>\n<ol>\n<li>\n\t\tEnsure new lines separated by a return character appear inside quoted strings (double quotes only). They will be transferred over into the record as is. In detail, carriage returns are discarded by ExtraView because they are non-existent within Unix files, and browsers behave correctly when they only receive a linefeed character<\/li>\n<li>\n\t\tTab characters may be inserted into the record inside quotes (if tab-delimited) or anywhere (if comma-delimited). They will be carried over to the record as is.<\/li>\n<li>\n\t\tTo get a double quote into a field, you need double it. Thus, &#8220;&#8221; represents one quote character. However, you can also put a double quote into a field if it is NOT the first non-whitespace character in a word. Thus, abc&#8221;def will carry across without modification, but \u201cabcdef\u201d will require modification.<\/li>\n<\/ol>\n<h2>\n\tUser Name Fields<\/h2>\n<p>ExtraView expects to find user name in the import file in the same format as specified by the behavior setting USERNAME_DISPLAY. For example, this may be FIRST, LAST or ID. We recommend that for large imports where there may be more than one person with the same first and last name, that you import data using the ID setting. This will ensure that all users can be identified uniquely.<\/p>\n<h2>\n\tMaximum Field Sizes<\/h2>\n<p>Fields that are imported are subject to the maximum size constraints of their field types, and are as follows \u2013<\/p>\n<table class=\"border\">\n<tbody>\n<tr class=\"tableHeaderRow\">\n<td>\n\t\t\t\tField \/ Field Type<\/td>\n<td>\n\t\t\t\tMaximum size<\/td>\n<\/tr>\n<tr>\n<td>\n\t\t\t\tList field titles (loaded as metadata)<\/td>\n<td>\n\t\t\t\t100 bytes<\/td>\n<\/tr>\n<tr>\n<td>\n\t\t\t\tUser ID (loaded as metadata)<\/td>\n<td>\n\t\t\t\t30 bytes<\/td>\n<\/tr>\n<tr>\n<td>\n\t\t\t\tUser First Name (loaded as metadata)<\/td>\n<td>\n\t\t\t\t128 bytes<\/td>\n<\/tr>\n<tr>\n<td>\n\t\t\t\tUser Last Name (loaded as metadata)<\/td>\n<td>\n\t\t\t\t128 bytes<\/td>\n<\/tr>\n<tr>\n<td>\n\t\t\t\tSHORT_DESCR<\/td>\n<td>\n\t\t\t\t255 bytes<\/td>\n<\/tr>\n<tr>\n<td>\n\t\t\t\tALT_ID<\/td>\n<td>\n\t\t\t\t128 bytes<\/td>\n<\/tr>\n<tr>\n<td>\n\t\t\t\tUDF text field display types<\/td>\n<td>\n\t\t\t\t256 bytes<\/td>\n<\/tr>\n<tr>\n<td>\n\t\t\t\tUDF text area, log area, print text display types<\/td>\n<td>\n\t\t\t\tApprox&nbsp;10MBytes.&nbsp; Note that if you are using Microsoft Excel to prepare your input file, there is a 31k limit on the size of a cell.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Multi-Valued Fields Fields to be imported that are of a multi-value type require special preparation within the import file. All the values to be imported must exist in between the delimiters of the file (tabs or commas), yet ExtraView must be able to distinguish between the different values. This is accomplished by using the system-wide&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":24172,"menu_order":2,"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-24175","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>Fields - 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\/fields-4\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fields - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"Multi-Valued Fields Fields to be imported that are of a multi-value type require special preparation within the import file. All the values to be imported must exist in between the delimiters of the file (tabs or commas), yet ExtraView must be able to distinguish between the different values. This is accomplished by using the system-wide...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/fields-4\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-14T18:26:26+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=\"3 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\/fields-4\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/fields-4\/\",\"name\":\"Fields - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-02-14T18:26:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/fields-4\/#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\/fields-4\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/fields-4\/#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\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"Fields\"}]},{\"@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":"Fields - 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\/fields-4\/","og_locale":"en_US","og_type":"article","og_title":"Fields - Product Documentation","og_description":"Multi-Valued Fields Fields to be imported that are of a multi-value type require special preparation within the import file. All the values to be imported must exist in between the delimiters of the file (tabs or commas), yet ExtraView must be able to distinguish between the different values. This is accomplished by using the system-wide...","og_url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/fields-4\/","og_site_name":"Product Documentation","article_modified_time":"2025-02-14T18:26:26+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 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\/fields-4\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/fields-4\/","name":"Fields - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-02-14T18:26:26+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/fields-4\/#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\/fields-4\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/fields-4\/#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","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/file-import-issue-data-1\/"},{"@type":"ListItem","position":6,"name":"Fields"}]},{"@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\/24175","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=24175"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24175\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24172"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=24175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}