Using the Excel Import Wizard
Excel import enables creation of new objects and modification of existing objects through an Excel file. You can use an Excel file which has been previously exported using HOPEX.
Launching the Excel Import Wizard
To import Excel data in HOPEX:
1. Check your import options. See Checking the Excel import/export access options and Checking the Excel import/export usage options.
2. From:
• HOPEX Windows Front-End, click File > Import > Excel (*.xls ; *xlsx).
• HOPEX Web Front-End, click Main Menu > Import > Excel.
• the Administration desktop (Web Front-End): in the Tools pane, select the Excel > Import sub-folder.
The import wizard opens. See Importing Excel data in HOPEX.
Importing Excel data in HOPEX
To import Excel data in HOPEX using the import wizard:
1. Run the import wizard. See Launching the Excel Import Wizard.
2. To the right of the Excel Import File field, click Browse 
.
.3. Indicate the file type and file to be imported.
For more information on the creation of the Excel file to be imported, see Export Wizard.4. (Optional) Select the Import in the default library check box.
5. Click Next.
The list of sheets in the imported Excel table appears.
If you select a worksheet, the list of imported fields appears in the Worksheet Columns section.
6. Click Next.
The wizard provides a report of import results.
7. To obtain a detailed report of import errors, click the Open Report button.
The .xls (or .xlsx) file opens indicating in color red the problem data. See Import error file.
8. Click:
• OK so that imported data will be visible in HOPEX.
• Previous to modify import parameters.
• Cancel to discard the report.
Import error file
This file opens automatically, indicating in red any data that poses a problem. In the following example, the file has identified an application that exists in HOPEX but of which the identifier has been modified in the import file.
The first two lines of an Excel worksheet are reserved for file configuration. Ensure that the first two lines of the imported file remain identical to those obtained after an export.Technical limitation of the import
When you want to import Enumeration type attribute values (values available in a drop-down list), you must ensure that the data language in HOPEX and the language of the Excel file are identical.
If for example your Excel file is in French and the data language in HOPEX is English, on import you receive a message of the type: value_name outside “table”.
The data language and the interface language are two different concepts.