[CONNECTORS-1617] Date format extraction problem in XLS/XLSX

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: ManifoldCF 2.10
• Fix Version/s: ManifoldCF 2.16
• Component/s: Tika extractor, Tika service connector
• Assignee: Karl Wright
• Reporter: Zoltan Farago
• Created: 13/Aug/19 10:40
• Updated: 13/Feb/20 12:05
• Resolved: 06/Feb/20 11:49

Description

Currently TIKA/ManifoldCF 2.10 extracts dates from the attached file tis way:

2018.05.10 -> 10/05/18
2002.02.02 -> 2/2/2

We need this format:

2018.05.10 -> 2018-05-10

2002.02.02 -> 2002-02-02

This occurs only when the field type is date. When the field type is text then the output is fine.

 

Please help us with a recommendation with any settings in the pipeline (Tika configs, excel setting, OS local settings, etc.), or provide a fix.