Open Source Document Management System | OpenKM

Hi,
I have recently installed OpenKM 6.2 (nightly build) and managed to configure everything from 5.1.11 - apart from MySQL repository.

But when I access custom metadata tab an error pops up relating to the date field.

Can you please guide me to solve this issue.

Further information,

From 5.1.11 the exported metadata value is:
But on 6.2.1 the exported metadata value is:
I may be wrong but I believe the export and import for date function in custom property values doesn't match, thus the error as per my previous post.

Please help me to overcome this issue.

Thanks with regards,
OkmUser

There's a problem between 5.1.11 date format and 6.2 format but can be easilly solved after importing on 6.2

At 5.1.X the date format is String ISO8601_PATTERN = "yyyy-MM-dd'T'HH:mm:ss.SSSZZZ";
At 6.X the date format is String BASIC_PATTER = "yyyyMMddHHmmss";

Values on version 6.x are stored at table OKM_NODE_PROPERTY: Simply build a query to transform older format to newer, for example:
1- replace character "-" to ""
2- replace character : to ""
now you get something like yyyyMMddTHHmmss.SSSZZZ
3 - get first 8 digits yyyyMMdd with digits from 10 to 16 HHmmss
and you'll get the actual format yyyyMMddHHmmss

Thanks, worked like a charm,

cheers

I have added the example in migration guide section.