{"id":24169,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/metadata-import-1\/"},"modified":"2025-02-14T10:19:46","modified_gmt":"2025-02-14T18:19:46","slug":"metadata-import-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/metadata-import-1\/","title":{"rendered":"Metadata Import"},"content":{"rendered":"

Note: Again, we strongly recommend that you backup your data before you use the import facility, using your database\u2019s standard facilities. Importing metadata, layouts, reports and user data is irreversible, and it is possible that a failure can occur during the process.<\/b><\/p>\n

The import menu is situated within the Import\/Export tab of the administration menu, and allows the administrator to specify the file to load.<\/p>\n

The import function reads a flat image file (which is in XML format) and updates the tables as required by the administrator\u2019s selection of objects to load. The utility takes into account the relational dependencies and all internal sequence renumbering as needed, ensuring consistent and correct instance updates.<\/p>\n

Validity checking for data adherence to new rules is performed as early as possible, thereby minimizing the impact of some validity failure that may cause termination of the import.<\/p>\n

Most imports will utilize the Update \/ Merge operation. This will update records that exist, and merge into the database the new records that were part of the file being imported.<\/p>\n

Although it is possible to create your own file to be used as an import file to ExtraView, extreme care should be taken before attempting to do this, and it is essential that you have a complete and thorough knowledge of the ExtraView schema. Often, it may appear straightforward to compose an XML file, or to edit an existing file that was created by ExtraView\u2019s own Export feature, but there are many relationships described in the file that are not obvious and that must be maintained for an import to be successful. We suggest that before attempting to create your own import file by modifying an existing file or creating it from scratch, that you consult with ExtraView support. In any case, always back up your target database before performing any import.<\/strong><\/p>\n

<\/p>\n

Starting the importing process <\/cite><\/p>\n

Follow the instructions on the screen. As displayed, the principal import methods are:<\/p>\n\n\n\n\n\n
\n\t\t\t\tUpdate \/ Merge<\/b><\/td>\n\n\t\t\t\tThis combines operations of update and merge, Records that already exist in the target schema are updated, and a new record is inserted if record being imported does not exist.<\/td>\n<\/tr>\n
\n\t\t\t\tMerge<\/b><\/td>\n\n\t\t\t\tThis leaves existing records in the target schema alone, and adds new ones from the file that is being imported. ExtraView will use new sequence numbers for the operation within the database.<\/td>\n<\/tr>\n
\n\t\t\t\tLocalization Update\/Merge<\/b><\/td>\n\n\t\t\t\tThis mode only imports the localized messages from the import file, and does not touch the remainder of the metadata. This is typically used to move localized messages from one installation to another, providing just the updated localized messages to the target installation.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

If you have altered metadata such as the titles of objects in lists, within the destination database, and these same modifications to the data were not made in the source database from which the export was taken, ExtraView gives you an opportunity to remap the fields, as opposed to creating new fields from the import file, and inserting these into the destination database. To perform this check, make sure the Map unmatched titles<\/b> prompt is checked.<\/p>\n

When you perform the check, the import is split into two parts. First the uploaded file is preprocessed, and each list value in the import is checked against the target destination database. If there are any values in the import file that do not exist in the destination database, then you will be shown the values from the import file that do not have a matching value, and you will be able to select from the values in the target database that do not have a value specified in the import file. After selecting the values to map, if there are discrepancies, you then proceed to the second part of the import. The file is processed again, the destination database is updated, and the mappings you selected are applied.<\/p>\n

When importing data into a business area, if the import process is able to create a project with an ID numbered 0, and the project ID in the import file is 0, then a project ID of 0 is used and mapped into the target database. If a project ID of 0 already exists in the target business area, the project ID of 0 in the import file is mapped to a new non-zero project ID. In any case, the matching project title within the business area and the mapped project overrides these decisions.<\/p>\n

This is important, as a project ID of 0 is used for inheritance of layouts, permissions and other objects for the non-zero project ID\u2019s within the business area, and ExtraView is trying to ensure that a project ID of 0 always exists for the inheritance to be allowed to work.<\/p>\n

There is one circumstance in which the import process may have difficulty in resolving all the data from the export file. If you are not importing user data, and the information in the import file contains references to users that do not exist in the target database, then import errors may result. This is especially noticed if the missing user was the person who created or last updated items such as layouts. These will not be imported, as ExtraView must maintain referential integrity of the users who are connected to its internal objects.<\/p>\n

In general, allowed value lists that have an invalid current value in parent or child will cause an import error and will not be imported. This may result in incomplete allowed value lists.<\/p>\n

<\/p>\n

Results from preprocessing the import file<\/span><\/p>\n

While data is being preprocessed or imported, a status bar is shown as follows:<\/p>\n

<\/p>\n

Progress bar during the importing process<\/span><\/p>\n

Note<\/b>: Importing the data can take some time, from ten minutes in smaller installations, to thirty minutes or more in larger installations. It is dependent upon the size of the file being processed, factors such as the number of fields, layouts and permissions, and the speed of the server loading the data. Due to the inherent limitations of browsers, there is little feedback during the initial part of the process, when the browser is uploading the import file from the client machine to the server. It is recommended that you prohibit users from using ExtraView during this time, especially if you are importing layouts. You can do this by locking users out of the system while you are importing the data. You can achieve this with the Disable and Enable User Access<\/b> on the Users<\/b> tab of the administration menu.<\/p>\n

Note<\/b>: You can improve the time to execute the import operation, by zipping the import file. Exported files compress significantly (perhaps to less than 10% of their original size). ExtraView will look for the XML file contained within a zip file as long as the name of the zip file and the name of the import file are the same.<\/p>\n

Note<\/b>: Once the import operation is started, you must not interrupt it. Once the actual import has begun, ExtraView will not cancel the server operation, even if you close your browser.<\/p>\n

Note<\/b>: When your file is imported, there is additional information within the file, termed a manifest. This manifest is used as a check against the data that you import, and provides a report if there are any unanticipated differences between the imported information and the database into which it is being imported.<\/p>\n

After the import is complete, you will see a summary screen that shows the number of records imported into each database table. Any errors encountered will be displayed here. Note that the results of the import vary according to the exact tables imported from the file you uploaded. There may be anything from a few to more than one hundred tables displayed in the results.<\/p>\n

<\/p>\n

Summary screen of the imported data<\/span><\/p>\n

\n\tHandling User Data<\/h3>\n

Users frequently change their personal settings when using ExtraView. For example, users may change their Home Page reports, their display format for the timestamp, their password, or one of many other attributes. If you export the metadata from a development system, wait some time and then import this metadata to a production system, you may overwrite recent changes made by users in their personal data. A behavior setting named OMITTED_IMPORT_USER_COLUMNS allows the administrator to set up specific columns that will be ignored upon the import of the metadata. The value of this field is a comma-separated list of column names. Note that you set this in the target system, not the system from which you are exporting the data. The possible values you can add to this list are as follows:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n\t\t\t\tColumn Name<\/td>\n\n\t\t\t\tMeaning<\/td>\n\n\t\t\t\tNotes<\/td>\n<\/tr>\n
\n\t\t\t\tADDITIONAL_EMAIL<\/td>\n\n\t\t\t\tThe user’s secondary email address<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tADDITIONAL_EMAIL_ON<\/td>\n\n\t\t\t\tSwitch to indicate whether the user’s secondary email address is turned on or off<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tADDRESS_LINE1<\/td>\n\n\t\t\t\tAddress line 1<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tADDRESS_LINE2<\/td>\n\n\t\t\t\tAddress line 2<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tCELL_PHONE<\/td>\n\n\t\t\t\tCell phone number<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tCHART_FONT<\/td>\n\n\t\t\t\tChart font<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tCITY<\/td>\n\n\t\t\t\tCity<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tCOMPANY_NAME<\/td>\n\n\t\t\t\tCompany name<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tCOUNTRY<\/td>\n\n\t\t\t\tCountry<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tCREATED_BY_USER<\/td>\n\n\t\t\t\tThe user ID of the person who created this user’s account<\/td>\n\n\t\t\t\t <\/td>\n<\/tr>\n
\n\t\t\t\tDATE_CREATED<\/td>\n\n\t\t\t\tThe date the user’s account was created<\/td>\n\n\t\t\t\t <\/td>\n<\/tr>\n
\n\t\t\t\tDATE_FORMAT<\/td>\n\n\t\t\t\tFormat to display dates<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tDRILLDOWN_REPORT<\/td>\n\n\t\t\t\tWhere does the user drill down to for reports?<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tEMAIL<\/td>\n\n\t\t\t\tThe user’s email address<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tEMAIL_CHARSET<\/td>\n\n\t\t\t\tThe character set of the email<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tEMAIL_FORMAT<\/td>\n\n\t\t\t\tFormat for received email<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tEMAIL_ON<\/td>\n\n\t\t\t\tSwitch to indicate whether a user’s email is turned on or off<\/td>\n\n\t\t\t\tRecommend this fields omission<\/td>\n<\/tr>\n
\n\t\t\t\tENABLED_USER<\/td>\n\n\t\t\t\tIndicates whether the user is enabled or disabled<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tFAX<\/td>\n\n\t\t\t\tFax number<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tFILE_ATTACH_CHARSET<\/td>\n\n\t\t\t\tThe user’s default character set for their attachments<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tFIRST_NAME<\/td>\n\n\t\t\t\tUser\u2019s first name<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tHOME_TELEPHONE<\/td>\n\n\t\t\t\tHome telephone number<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tHTTP_CHARSET<\/td>\n\n\t\t\t\tBrowser character set<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tJOB_TITLE<\/td>\n\n\t\t\t\tUser\u2019s job title<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tLANGUAGE<\/td>\n\n\t\t\t\tDisplay language<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tLAST_ACCESS_DATE<\/td>\n\n\t\t\t\tTimestamp the user last accessed ExtraView<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tLAST_DATE_UPDATED<\/td>\n\n\t\t\t\tThe date of the last update to the user’s record<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tLAST_NAME<\/td>\n\n\t\t\t\tUser\u2019s last name<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tLAST_UPDATED_BY_USER<\/td>\n\n\t\t\t\tThe user ID of the person who last updated the record<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tLDAP_UPSERT_TIME<\/td>\n\n\t\t\t\tThe last date \/ time the user’s account was synchronized with a LDAP server<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tLOGIN_ID<\/td>\n\n\t\t\t\tThe alternative user ID<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tLOGIN_MSG_DT<\/td>\n\n\t\t\t\tNot used<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tMS_OFFICE_CHARSET<\/td>\n\n\t\t\t\tCharacter set output to MS Office applications<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tNEW_PANELS<\/td>\n\n\t\t\t\tSelects whether user created a new workspace panel or uses the same panel for each new Quicklist report when drilling down from queries and reports<\/td>\n\n\t\t\t\tRecommend this fields omission<\/td>\n<\/tr>\n
\n\t\t\t\tNOTIFY_ON_OWN_UPDATES<\/td>\n\n\t\t\t\tUser notification when making an update<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tPAGER<\/td>\n\n\t\t\t\tPager number<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tPANEL_AUTOSCROLL<\/td>\n\n\t\t\t\tUser auto-scrolls to workspace panels when they click on them<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tPASSWORD_EXPIRY_DATE<\/td>\n\n\t\t\t\tPassword expiry date<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tPASSWORD_INTERVAL<\/td>\n\n\t\t\t\tThe interval between password expiries<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tPASSWORD2<\/td>\n\n\t\t\t\tThe current, encrypted password of the user. All password changes use this field. There is a field named SECURITY_PASSWORD which contains the legacy password, if it has not been updated since version 7.0<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tPOSTAL_CODE<\/td>\n\n\t\t\t\tPostal code or Zip code<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tRECORDS_PER_PAGE<\/td>\n\n\t\t\t\tThe default number of records on each report output page<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tREGION<\/td>\n\n\t\t\t\tLocale region<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tREPORT_1_ID<\/td>\n\n\t\t\t\tHome page report 1<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tREPORT_2_ID<\/td>\n\n\t\t\t\tHome page report 2<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tREPORT_3_ID<\/td>\n\n\t\t\t\tHome page report 3<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tSCROLL_PANELS<\/td>\n\n\t\t\t\tAllows the user to scroll the workspace canvas or any workspace panel or element within that panel when the mouse pointer is over the respective area<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tSECURITY_PASSWORD<\/td>\n\n\t\t\t\tUser\u2019s password. Note that since version 7.0, the field PASSWORD2 is used for the purpose of holding the encrypted password<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tSECURITY_USER_ID<\/td>\n\n\t\t\t\tThe User’s ID<\/td>\n\n\t\t\t\t <\/td>\n<\/tr>\n
\n\t\t\t\tSOUNDEX_LAST_NAME<\/td>\n\n\t\t\t\tThe soundex code for the user’s last name<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tSTART_PAGE_ID<\/td>\n\n\t\t\t\tThe ID of the start page the user is using<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tSTATE<\/td>\n\n\t\t\t\tState<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tSTYLESHEET<\/td>\n\n\t\t\t\tSize of text in browser<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tTIMEZONE<\/td>\n\n\t\t\t\tUser\u2019s time zone<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tTWENTY_FOUR_HOUR_TIME<\/td>\n\n\t\t\t\tDisplay of times in 12 or 24 hour format<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tUSER_FIELD_1 to USER_FIELD_10<\/td>\n\n\t\t\t\tThe user defined fields<\/td>\n\n\t\t\t\tRecommend these fields omission<\/td>\n<\/tr>\n
\n\t\t\t\tUSER_ROLE<\/td>\n\n\t\t\t\tUser\u2019s current role<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tVARIANT<\/td>\n\n\t\t\t\tLocale variant<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tWORK_TELEPHONE<\/td>\n\n\t\t\t\tWork telephone number<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n
\n\t\t\t\tWORKSPACE_1_ID<\/td>\n\n\t\t\t\tThe ID of the default workspace of the user<\/td>\n\n\t\t\t\tRecommend this field’s omission<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n\tAllowed Value Conflicts<\/h3>\n

Importing allowed values presents some challenges, when the data in the target database has changed significantly from the data in the source database. An entry in allowed values is unique for a given Title, Parent and Child value.<\/p>\n

    \n
  • \n\t\tFor any given combination of a Parent and Child, only 0 or 1 entry can be set to be Enabled<\/em><\/li>\n
  • \n\t\tFor any given Parent and Child there can be any number of entries set to Disabled<\/em><\/li>\n
  • \n\t\tFor each allowed value, there can be entries in the Allowed Values database table with allowed values for that type<\/li>\n<\/ul>\n

    The points to observe during an import of allowed values are:<\/p>\n

      \n
    • \n\t\tMaking sure that only one entry for a given Parent and Child is set to enabled. This means importing an enabled row requires a check that there is no other entry enabled. If there is another entry enabled for the given Parent and Child combination, then the import entry is set to disabled and imported<\/li>\n
    • \n\t\tMatching imported allowed value entries to existing allowed value entries. The Title, Parent and Child are used to find a matching row. If none is found, the imported entry is inserted. If a matching row is found, it is updated and the value lists are merged<\/li>\n
    • \n\t\tThe allowed value lists for allowed value types are only added to; they are never reduced<\/li>\n
    • \n\t\tGiven the import of an enabled allowed value type is not allowed if another allowed value type is enabled in the database, if the import wants to change which entry is enabled, it must first disable the currently enabled entry and then import the enabled entry from the import file. This implies that the export process should export its disabled entries before exporting its enabled entry. When imported they will then be in the correct order. The values list is merged in either case<\/li>\n<\/ul>\n\n\n\n\n\n\n
      \n\t\t\t\t <\/td>\n\n\t\t\t\tImported Value of Allowed Value Type Enabled<\/em><\/td>\n<\/tr>\n
      \n\t\t\t\tDisabled<\/td>\n\n\t\t\t\tEnabled<\/td>\n<\/tr>\n
      \n\t\t\t\tCurrent Value of Allowed Value Type Enabled<\/em><\/td>\n\n\t\t\t\tDisabled<\/td>\n\n\t\t\t\tOK<\/td>\n\n\t\t\t\tOK only if enabled count = 0<\/td>\n<\/tr>\n
      \n\t\t\t\tEnabled<\/td>\n\n\t\t\t\tOK \u2013 AVT will become disabled<\/td>\n\n\t\t\t\tOK<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

      \n\tImporting List fields with Aliases<\/h3>\n

      If an existing list field is not an alias of another list field, the import logic maintains this, and keeps the list field non-aliased in the target database. The import cannot make a non-aliased list field an aliased field during the import because it cannot guarantee that the lists are intended to be the same. For this same reason, the import will not change an aliased list field to be the aliase of a different list field. In normal operation, ExtraView checks these conditions and only allows valid operations, therefore the import must also make the same checks. In the context of this section, list fields include all fields with a display type of list, popup, tab, and radio button.<\/p>\n

      The import rules for the Alias of<\/em> field values are as follows:<\/p>\n

        \n
      • \n\t\tIf the list field entry being imported is not an aliased field, it is imported and the list remains non-aliased after import. The imported list values are merged for these fields<\/li>\n
      • \n\t\tIf the list field entry being imported is an aliased field, it is imported only if the imported aliased field definition is the same in both the file being imported and in the target database. The imported list values are merged<\/li>\n
      • \n\t\tA non-aliased list cannot be aliased by the import process<\/li>\n
      • \n\t\tThe values within an aliased list cannot be changed by the import process<\/li>\n<\/ul>\n\n\n\n\n\n\n\n
        \n\t\t\t\t <\/td>\n\n\t\t\t\tImported Alias Field Name<\/td>\n<\/tr>\n
        \n\t\t\t\tNone<\/td>\n\n\t\t\t\tList A<\/em><\/td>\n<\/tr>\n
        \n\t\t\t\tCurrent Alias Field Name<\/td>\n\n\t\t\t\tNone<\/td>\n\n\t\t\t\tOK<\/td>\n\n\t\t\t\tNo<\/td>\n<\/tr>\n
        \n\t\t\t\tList A<\/em><\/td>\n\n\t\t\t\tOK<\/td>\n\n\t\t\t\tOK<\/td>\n<\/tr>\n
        \n\t\t\t\tList B<\/em><\/td>\n\n\t\t\t\tOK<\/td>\n\n\t\t\t\tNo<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        \n\tError Logging During Import<\/h3>\n

        A text log of errors is created on the server, as the XML updater executes. Each error entry will contain as much useful information as possible, including the table, row number, the data being used at the time, and the exception message, if any. This error log is echoed to the summary screen in the browser.<\/p>\n

        The error file is stored in the system temp directory under the name: <time_in_ms>_<user_id>_XML_ERRORS.txt<\/span><\/p>\n

        for example:<\/p>\n

        1026520070671_JEFF.SYKES_XML_ERRORS.txt<\/span><\/p>\n

        All error messages begin with<\/p>\n

        ::XML_UPDATE_ERROR<\/span>::<\/p>\n

        plus a new line, and end with ::END_XML_UPDATE_ERROR<\/span>:: followed by two new line characters.<\/p>\n

        Here is an example of an error:<\/p>\n\n\n\n
        \n

        ::XML_UPDATE_ERROR::
        \n\t\t\t\t\tAn error occurred updating row 125 of ITEM_MODULE with this data: {blah = blah, this = that, you = them} <\/span><\/p>\n

        Exception: java.sql.SQLException: ORA-00904: invalid column name
        \n\t\t\t\t\t::END_XML_UPDATE_ERROR:: <\/span><\/p>\n

        ::XML_UPDATE_ERROR::
        \n\t\t\t\t\tAn error occurred updating row 126 of ITEM_MODULE with this data: {blah = blah, this = those, you = me} Exception: java.sql.SQLException: ORA-00904: invalid column name
        \n\t\t\t\t\t::END_XML_UPDATE_ERROR:: <\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        In order to be able to store multi-byte characters within the error file, note that the error file is not created as standard text. If you open the file in a standard editor, you will notice that what looking at most of the metadata in the file, every second character is null.<\/p>\n

        \n\tHandling rejected records during the import of metadata<\/h3>\n

        As ExtraView processes the XML import file and fires the updating routines, if errors prevent an update are generated, the problematic XML nodes’ data is captured, and used to generate a new XML file. This file is of the same structure as the original file, but only includes those items that could not be properly updated. If there are no errors generated during the upload process, this file is deleted at the end of the update process, as it is empty.<\/p>\n

        This file is saved under the system temp directory under the name:<\/p>\n

        <time_in_ms>_<user_id>_XML_REJECTS.xml<\/span><\/p>\n

        for example<\/p>\n

        1026520070671_JEFF.SYKES_XML_REJECTS.xml<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

        Note: Again, we strongly recommend that you backup your data before you use the import facility, using your database\u2019s standard facilities. Importing metadata, layouts, reports and user data is irreversible, and it is possible that a failure can occur during the process. The import menu is situated within the Import\/Export tab of the administration menu,…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":24165,"menu_order":3,"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-24169","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\nMetadata Import - 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\/metadata-import-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Metadata Import - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"Note: Again, we strongly recommend that you backup your data before you use the import facility, using your database\u2019s standard facilities. Importing metadata, layouts, reports and user data is irreversible, and it is possible that a failure can occur during the process. The import menu is situated within the Import\/Export tab of the administration menu,...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/metadata-import-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-14T18:19:46+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=\"16 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\/metadata-import-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/metadata-import-1\/\",\"name\":\"Metadata Import - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-02-14T18:19:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/metadata-import-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/metadata-import-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/metadata-import-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\":\"Metadata Import\"}]},{\"@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":"Metadata Import - 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\/metadata-import-1\/","og_locale":"en_US","og_type":"article","og_title":"Metadata Import - Product Documentation","og_description":"Note: Again, we strongly recommend that you backup your data before you use the import facility, using your database\u2019s standard facilities. Importing metadata, layouts, reports and user data is irreversible, and it is possible that a failure can occur during the process. The import menu is situated within the Import\/Export tab of the administration menu,...","og_url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/metadata-import-1\/","og_site_name":"Product Documentation","article_modified_time":"2025-02-14T18:19:46+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"16 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/metadata-import-1\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/metadata-import-1\/","name":"Metadata Import - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-02-14T18:19:46+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/metadata-import-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/metadata-import-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/import-export-1\/metadata-import-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":"Metadata Import"}]},{"@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\/24169","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=24169"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24169\/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=24169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}