![](\"\/v25\/extraview-media\/images\/ag\/import_export\/importing_files_spreadsheet.png\")
<\/p>\nThe purpose of this feature is to create new fields in the data dictionary from a spreadsheet. When creating a large ExtraView installation, there is often a significant amount of replication with similar fields, but with different names<\/b>. You are able to create a spreadsheet with a set of fields plus their attributes from a comma- or tab-delimited file, and upload this file into ExtraView. Note that the template that you download is a Microsoft Excel spreadsheet. This allows the use of validation within the spreadsheet while preparing the input file. You must save the file as a comma-delimited or tab-delimited file before you import it back into ExtraView.<\/b><\/p>\n
Significant validation is performed on the file you upload, with a similar two-step process as in uploading issue data. You are also able to save the templates you create for future use, allowing you to prepare fields in batches, and upload them as and when you are prepared.<\/p>\n
<\/p>\n
Importing fields from a spreadsheet<\/span><\/p>\n Use Microsoft Excel or a similar spreadsheet tool to create your input data. An empty spreadsheet for use as an input file can be downloaded from within the utility. You must save the file as a comma-delimited or tab-delimited file before you import it back into ExtraView<\/b> See the previous screenshot for details of how to download an empty spreadsheet.<\/p>\n Similar to the web-based input for the data dictionary, the following fields are available for input:<\/p>\n This utility is very similar in usage to importing issue data. Please see the previous section in this guide for full instructions.<\/p>\n Importing fields into the data dictionary<\/span><\/p>\n The key difference in using this utility and using the import issue data feature is that there is a prompt on the screen, Override existing field<\/b>. If you check this, then you may update the properties of the field given in the Fixed name<\/b> column.<\/p>\n","protected":false},"excerpt":{"rendered":" The purpose of this feature is to create new fields in the data dictionary from a spreadsheet. When creating a large ExtraView installation, there is often a significant amount of replication with similar fields, but with different names. You are able to create a spreadsheet with a set of fields plus their attributes from a…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":24165,"menu_order":8,"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-24182","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\n\n\tPreparing the import file<\/h3>\n
![](\"\/v25\/extraview-media\/images\/ag\/import_export\/preparing_import_file.png\")
<\/p>\n\n\n
\n \n\t\t\t\tField Name<\/td>\n \n\t\t\t\tDescription<\/td>\n<\/tr>\n \n \n\t\t\t\tArea<\/td>\n \n\t\t\t\tThe title of the Business Area for the field. If the field is to be global, use * Global Area<\/b> *. This field is required<\/td>\n<\/tr>\n \n \n\t\t\t\tProject<\/td>\n \n\t\t\t\tThe title of the Project within the Business Area to which you want to load the fields. If you are creating a global field, this will be * Master Project<\/b> * If you are loading the fields for use across a single Business Area, this will be the default Project for the Business Area. If you want the field to only be visible within a single Project, then you will use the title of that Project. This field is required<\/td>\n<\/tr>\n \n \n\t\t\t\tField belongs to<\/td>\n \n\t\t\t\tThis must be set to Issue records<\/b> if you want the field to be available to the main body of issues, or to Repeating row records<\/b> if you want to use the field on a repeating row. This field is required<\/td>\n<\/tr>\n \n \n\t\t\t\tFixed name<\/td>\n \n\t\t\t\tThis is the fixed name for the field. Names can only consist of the characters A to Z, 0 to 9, and \u2018_\u2019. The first character of a fixed name must be alphabetic and the name can be up to 30 characters in length. Names cannot contain characters from non-English alphabets. A further restriction is that you may not have two underscore characters together in a name. This field is required<\/td>\n<\/tr>\n \n \n\t\t\t\tTitle to display<\/td>\n \n\t\t\t\tThe display title for the field. This may be up to 100 characters long and may contain any characters such as punctuation. This field is required<\/td>\n<\/tr>\n \n \n\t\t\t\tDisplay type<\/td>\n \n\t\t\t\tThis must map to a valid display type within ExtraView. This field is required. The valid entries are:<\/p>\n \n
\n \n\t\t\t\tAlias of<\/td>\n \n\t\t\t\tIf the field is to be created as an alias of another field, and the other field is of type list, tab, or radio button then place the other field name in this column<\/td>\n<\/tr>\n \n \n\t\t\t\tAllow Selection on reports<\/td>\n \n\t\t\t\tCreate as Yes or No<\/td>\n<\/tr>\n \n \n\t\t\t\tTotal field on reports<\/td>\n \n\t\t\t\tCreate as Yes or No<\/td>\n<\/tr>\n \n \n\t\t\t\tRemember last value<\/td>\n \n\t\t\t\tCreate as Yes or No<\/td>\n<\/tr>\n \n \n\t\t\t\tMultiple value<\/td>\n \n\t\t\t\tCreate as Yes or No<\/td>\n<\/tr>\n \n \n\t\t\t\tFilter criteria<\/td>\n \n\t\t\t\tCreate as Yes or No<\/td>\n<\/tr>\n \n \n\t\t\t\tIs sortable<\/td>\n \n\t\t\t\tCreate as Yes or No<\/td>\n<\/tr>\n \n \n\t\t\t\tDisplay as URL<\/td>\n \n\t\t\t\tCreate as Yes or No<\/td>\n<\/tr>\n \n \n\t\t\t\tURL<\/td>\n \n\t\t\t\tIf you are using the field as a display as URL, then provide the URL here<\/td>\n<\/tr>\n \n \n\t\t\t\tHelp Text<\/td>\n \n\t\t\t\tThe help text for the tooltip on the field<\/td>\n<\/tr>\n \n \n\t\t\t\tHelp URL<\/td>\n \n\t\t\t\tThe URL to use if you are providing your own help on the field<\/td>\n<\/tr>\n \n \n\t\t\t\tCurrency unit<\/td>\n \n\t\t\t\tThe currency unit for the field<\/td>\n<\/tr>\n \n \n\t\t\t\tCurrency symbol<\/td>\n \n\t\t\t\tThe currency symbol to be used for the field<\/td>\n<\/tr>\n \n \n\t\t\t\tThousands separator<\/td>\n \n\t\t\t\tCreate as Yes or No<\/td>\n<\/tr>\n \n \n\t\t\t\tNegative sign<\/td>\n \n\t\t\t\tCreate as Yes or No<\/td>\n<\/tr>\n \n \n\t\t\t\tInternal precision<\/td>\n \n\t\t\t\tA number from -24 to 10 indicating how many digits of precision should be maintained for internal computations with this field<\/td>\n<\/tr>\n \n \n\t\t\t\tReport precision<\/td>\n \n\t\t\t\tA number from -24 to 10 indicating how many digits of precision should be displayed on reports or read-only displays of this field<\/td>\n<\/tr>\n \n \n\t\t\t\tRounding mode<\/td>\n \n\t\t\t\tSelect from one of the following list:<\/p>\n \n
\n \n\t\t\t\tPercentage type<\/td>\n \n\t\t\t\tCreate as Yes or No<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n \n\tUploading the File and Providing any Mappings<\/h3>\n
![](\"\/v25\/extraview-media\/images\/ag\/import_export\/importing_fields_data_dictionary.png\")
<\/p>\n