Support more date formats in CSV import

Use this forum to suggest new features, language support, documentation, etc. for OpenEMM's roadmap

Moderator: moderator

anondev
Posts: 11
Joined: Wed May 18, 2011 5:33 pm

Support more date formats in CSV import

Post by anondev »

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.
maschoff
Site Admin
Posts: 2596
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Support more date formats in CSV import

Post by maschoff »

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.
OpenEMM Maintainer
maschoff
Site Admin
Posts: 2596
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Support more date formats in CSV import

Post by maschoff »

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/
OpenEMM Maintainer
Post Reply