German date formats seem supported, and also semi-ISO date formats. But there are other formats, like for example french/american formats (DD/MM/YYYY or MM/DD/YYYY) which are widely used but unsupported, which could force transformations on some CSV files before feeding them to the Recipients Importer.
Is there a way to parse more formats? Like for example using some kind of DateParser?
Thank you in advance.
Support more date formats in CSV import
Moderator: moderator
-
- Site Admin
- Posts: 2628
- Joined: Thu Aug 03, 2006 10:20 am
- Location: Munich, Germany
- Contact:
Re: Support more date formats in CSV import
Adding new date formats for the import profiles simply means
1. expanding enumeration DateFormat in package org.agnitas.util.importvalues with values supported by java.text.SimpleDateFormat and
2. putting the new value into file messages.properties like key "import.date.format.MMDDyyyy" and value "MM/DD/yyyy".
And if you provide us with an extended enumeration we will put it in the mainline for the next release.
1. expanding enumeration DateFormat in package org.agnitas.util.importvalues with values supported by java.text.SimpleDateFormat and
2. putting the new value into file messages.properties like key "import.date.format.MMDDyyyy" and value "MM/DD/yyyy".
And if you provide us with an extended enumeration we will put it in the mainline for the next release.
OpenEMM Maintainer
-
- Site Admin
- Posts: 2628
- Joined: Thu Aug 03, 2006 10:20 am
- Location: Munich, Germany
- Contact:
Re: Support more date formats in CSV import
Install Guide for OpenEMM 2011 was updated with new section 6.6 explaining the creation of customized date formats:
https://sourceforge.net/projects/openem ... rsions%29/
https://sourceforge.net/projects/openem ... rsions%29/
OpenEMM Maintainer