DataImporter - Import Value Lists

Overview

This article presents the method to import Value Lists used in Web forms.

When creating a Web form, you can aid data entry with Combo boxes or Radio buttons. The values for these lists can be created or modified via an import with DataImporter. 


References

 

What you need to know:

The reference template files (.xlsx et .xml) to prepare imports are included in the IncidentTemplate.zip file.

Required Fields

  • NameFR - Text (255)
    • Indicates the name of the list in French.
  • ​​NameEN - Text (255)
    • Indicates the name of the list in English.

  • ValueFR - Text (1000)
    • Name of the value in French.
  • ValueEN - Text (1000)
    • Name of the value in English.

Optional Fields

  • Rank - Whole number
    • Indicates the value position in the list.

    • If no rank is specified, the values will be presented to the user in alphabetical order, according to his language. 

Configuration File (XML)

The declaration of the source is done by indicating CustomLookupGroup in the <Content> tag.

NOTE: The XML file used in this example is for an import done using Excel version 2007 or 2010. To explain the tags used in all types and to find out more about the different versions of file types, please refer to the XML Configuration File article
<?xml version="1.0" encoding="utf-8" ?>
<Sources>
      <Source Name="Liste valeurs" >
             <ConnectionString>Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\Import\IncidentTemplate.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";</ConnectionString>
             <ViewName>[Importation Liste Valeurs$]</ViewName>
             <Content>CustomLookupGroup</Content>
      </Source>
</Sources>
X
Help us improve our articles








Help us improve our articles