Difference between revisions of "Edi Create Time Format"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
[[Category:How_To]] | [[Category:How_To]] | ||
+ | [[Category:Fusion Registry Install]] | ||
By default, reading an EDI data file does not convert the TIME_FORMAT into an attribute in the output data file, however an option exists in Fusion Registry to perform this. To enable this behaviour the system property "''edi.forceTimeFormatSeriesAttr.enabled''" needs to be specified and the Data Structure must have a series attribute with the id of "TIME_FORMAT". | By default, reading an EDI data file does not convert the TIME_FORMAT into an attribute in the output data file, however an option exists in Fusion Registry to perform this. To enable this behaviour the system property "''edi.forceTimeFormatSeriesAttr.enabled''" needs to be specified and the Data Structure must have a series attribute with the id of "TIME_FORMAT". |
Latest revision as of 07:46, 4 September 2023
By default, reading an EDI data file does not convert the TIME_FORMAT into an attribute in the output data file, however an option exists in Fusion Registry to perform this. To enable this behaviour the system property "edi.forceTimeFormatSeriesAttr.enabled" needs to be specified and the Data Structure must have a series attribute with the id of "TIME_FORMAT".
If both of these conditions are met, then the EDI values are converted in the following manner:
Time Format | EDI Value | ISO Format |
---|---|---|
Yearly | 602 / 702 | P1Y |
Half Yearly | 604 / 704 | P6M |
Quarterly | 608 / 708 | P3M |
Monthly | 610 / 710 | P1M |
Weekly | 616 / 716 | P1W |
Daily | 101 / 102 | P1D |
Minutely | 201 / 203 | PT1M |