166 views

Description

When using a foreign language pack, easy import fails due to a translated sys_id column name in the Excel template.

Steps to Reproduce

  1. Enable French language support.
    1. Navigate to System Definition > Plugins.
    2. Select I18N: French Translations.
    3. Under Related Links, click Activate/Upgrade.
    4. Click Activate.
  2. Change the interface language to French.
    1. Navigate to System Properties > Localization.
    2. In Default language for the system (two character values), specify fr.
  3. Navigate to a list to export.
  4. Right-click on the header and select Importer > Mettre A jour.
  5. Select Creer un model excel.
  6. Click Telecharger (download).
  7. Open the created file and verify that all headers are in French, including sys_id (id systeme).
  8. From the Easy Import menu, click Importer.
  9. Choose the generated file.
    The following error is generated:
    "Importing Excel Workbook Processor
    100% (danger)
    The following columns need to exist in the imported Excel Workbook: Sys ID"

Workaround

  1. Generate the template.
  2. Open the Excel file.
  3. Rename the ID système header to Sys ID.
  4. Import the file.

Related Problem: PRB639648

Seen In

Fuji Patch 5
Geneva Patch 3 Hot Fix 2

Fixed In

Istanbul

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-02-06 01:31:45
Published:2016-04-21