Difference between revisions of "Date and Time formats in Content Manager OnDemand"

Jump to navigation Jump to search

Date and Time formats in Content Manager OnDemand (view source)

Revision as of 21:07, 19 January 2022

687 bytes added ,  21:07, 19 January 2022
m
→‎ODWEK Java API Date Formats
(Added ODWEK Date Format.)
Line 83: Line 83:
=== ODWEK Java API Date Formats ===
=== ODWEK Java API Date Formats ===


When using the Content Manager OnDemand Web Enablement Kit ("ODWEK") Java API version v9.5 or higher to load reports into IBM CM OnDemand with the [https://cmod.wiki/dox/ODapiDoc/v10.1/com/ibm/edms/od/ODServer.html#loadInit() ODServer.loadInit()], [https://cmod.wiki/dox/ODapiDoc/v10.1/com/ibm/edms/od/ODServer.html#loadAddDoc(int,%20java.util.Hashtable,%20byte%91;%93;) ODServer.loadAddDoc()] and [https://cmod.wiki/dox/ODapiDoc/v10.1/com/ibm/edms/od/ODServer.html#loadCommit(java.lang.String,%20java.lang.String) ODServer.loadCommit()] calls, date and date & time fields *must* be in ISO format.
When using the Content Manager OnDemand Web Enablement Kit ("ODWEK") Java API version v9.5 or higher to load reports into IBM CM OnDemand with the [https://cmod.wiki/dox/ODapiDoc/v10.5/com/ibm/edms/od/ODServer.html#loadInit-- ODServer.loadInit()], [https://cmod.wiki/dox/ODapiDoc/v10.5/com/ibm/edms/od/ODServer.html#loadAddDoc-int-java.util.Hashtable-byte:A-  ODServer.loadAddDoc()] and [https://cmod.wiki/dox/ODapiDoc/v10.5/com/ibm/edms/od/ODServer.html#loadCommit-java.lang.String-java.lang.String- ODServer.loadCommit()] calls, date and date & time fields can either be in the format specified in the Application that you are loading data into, or can be in ISO format.


The ISO format is supported directly by the database engine, and isn't subject to any conversion or reformatting as per the Application definition.  Dates must be provided in the "YYYY-MM-DD" format, or for Date and Time formats, "YYYY-MM-DD HH:MM:SS.FFFFFF".
Since the date field format in the Application can easily be changed inside the CMOD Admin Client, it's highly recommended that any tools developed to use the ODWEK Load API calls be written to use the ISO date or date/time format.
 
NOTE:  Any character removal specified in the Application configuration (in the Load Information tab, Character Removal pane) will be applied to the data submitted -- which can cause loads to fail if you are removing embedded spaces from incoming data, since the ISO format specifies a space character between the date and the time.
 
CMOD attempts to parse date metadata as described in the Application definition (in the Load Information tab) first, and if the date format doesn't match the configured format, then it defaults to the ISO date or date/time format. If neither format matches an acceptable format, then the load will fail.


== History ==
== History ==
Retrieved from "https://CMOD.wiki/index.php?title=Special:MobileDiff/1054"

Navigation menu