Question

excel importer defenition template date mask error

0

Hi all, i have a excel document with a date time value in it, if i import this with mapping to atribute it has a specific date time mask: dd.MM.yyy HH:mm This goes well if you create the import defenition on its own, but the problem is when i export the defenition and import it again. the mask gets lost in the export → import action: Is there a workaround for this?

asked 2020-02-10

Reinier Stam

1 answers

Maarten Bongers · Accepted Answer · 2020-02-11

In the XML mappings for the export and import( DomToXML_ExcelTemplate & XMLToDom_ExcelTemplate) the input mask is missing.

If you want this to be added, it might be best to contact Mendix, because its there module and ask them to add the field(maybe create a support ticket for this(https://support.mendix.com/hc/en-us)

As a workaround you could create a message definition(starting from the importer template object) and from this derive the correct export and import templates and use those.