PageElementPropertiesImportWizDefinition_ImportTemplateIDMatchFunction Property

Property Value

Type: String
Specify a function that will be used in a DBLookup to return a template ID that matches the signature of the selected spreadsheet and the mapper. At a minimum, your function should return TWO fields.1) A template ID - from the xot_import_template table (see property, ImportTemplateIDMatchField)2) A matching score value - so the import wizard can order the results and choose the best matching import template (See property, ImportTemplateIDMatchSort)This function will be used in combination with the property ImportTemplateIDMatchField (the template ID field) ImportTemplateIDMatchSort (how to select the best matching import template).By default, the platform will use the functiondbo.xof_import_template_matches(!fnUserGUID$(), !fnTenantID$(), {{signature}}, {{mapperkey}})If you override this function it should be configured to take, at a minimum, two parameters.{{signature}} - representing the signature of columns in the import spreadsheet{{mapperkey}} - representing the mapper you are importing intoThese two parameters are substituted at run time based on the import selections a user makes.The platform function also takes an additional two parameters!fnUserGuiD$() - representing the current user!fnTenantID$() - representing the current user's companyThese two parameters are passed in order to select the correct template based on template permissions.Your function to match the import template to a spreadsheet should also take into consideration your custom permissions. If you override the properties ImportTemplatePicklist, and ImportTemplateDupeCheckFilter and they use different permissions logic to the default platform logic, your function should also contain that same permission logic.