Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • TREP APIs /
  • RFA /
avatar image
REFINITIV
Question by jessie.lin · Jul 20, 2017 at 03:12 AM · rfa java

FID 1010 Format

Hi Sir

One of my client , when they use RFA API to retrieve CNH= -> FID 1010, they find the date display is with 2 format : XX:XX:XX and XX:XX. They want to understand in what kind of situation TREP will delivery XX:XX .

Meanwhile when we check with Data team, they feedback all date they delivered is with XX:XX:XX format.

Below is the screen shot for XX:XX format. and log is attached;

fid.png (4.6 KiB)

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

5 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by umer.nalla · Jul 25, 2017 at 06:38 AM

hi @jessie.lin

Did your developer get this resolved?

Looking at the sample code you provided, my guess above applies.

Their is a parseData() method which calls ps.println(data) and this should make use of the stringTo() methods of the data.

To be honest the above is not really RFA specific, it is standard Java functionality.

Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
jessie.lin · Jul 25, 2017 at 07:03 AM 0
Share

Thank you , let me double confirm with developer.

avatar image
REFINITIV
Answer by jessie.lin · Jul 20, 2017 at 05:34 AM

LINK: https://pan.baidu.com/s/1geUaQ7x PWD: i7pm

please download log from here, Thank you!

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Answer by umer.nalla · Jul 20, 2017 at 06:22 AM

Hi @jessie.lin

I just checked your output file and searched for FID 1010 values and below is an extract.

Line 4705: 	FIELD_ENTRY 1010/VALUE_TS1: 09:47:59
Line 4805: 	FIELD_ENTRY 1010/VALUE_TS1: 09:47:59
Line 4909: 	FIELD_ENTRY 1010/VALUE_TS1: 09:47:59
Line 5009: 	FIELD_ENTRY 1010/VALUE_TS1: 09:47:59
Line 5116: 	FIELD_ENTRY 1010/VALUE_TS1: 09:47:59
Line 5220: 	FIELD_ENTRY 1010/VALUE_TS1: 09:48
Line 5324: 	FIELD_ENTRY 1010/VALUE_TS1: 09:48
Line 5428: 	FIELD_ENTRY 1010/VALUE_TS1: 09:48
Line 5528: 	FIELD_ENTRY 1010/VALUE_TS1: 09:48
Line 5632: 	FIELD_ENTRY 1010/VALUE_TS1: 09:48
Line 5736: 	FIELD_ENTRY 1010/VALUE_TS1: 09:48
Line 5836: 	FIELD_ENTRY 1010/VALUE_TS1: 09:48
Line 5936: 	FIELD_ENTRY 1010/VALUE_TS1: 09:48
Line 6036: 	FIELD_ENTRY 1010/VALUE_TS1: 09:48
Line 6140: 	FIELD_ENTRY 1010/VALUE_TS1: 09:48
Line 6244: 	FIELD_ENTRY 1010/VALUE_TS1: 09:48:01
Line 6348: 	FIELD_ENTRY 1010/VALUE_TS1: 09:48:01
Line 6452: 	FIELD_ENTRY 1010/VALUE_TS1: 09:48:01
Line 6556: 	FIELD_ENTRY 1010/VALUE_TS1: 09:48:01
Line 6656: 	FIELD_ENTRY 1010/VALUE_TS1: 09:48:01
Line 6760: 	FIELD_ENTRY 1010/VALUE_TS1: 09:48:01
	<br>

If you look through the file and also based on the extract above, the VALUE_TS1 is being returned with hh:mm:ss and displayed as such. The only time you see hh:mm format is when the seconds are '00'.

So, it would appear that the application code that extracts the Time value or Prints the time value is choosing not to print the seconds part if it is 0 / blank / empty.

Update:

I modified one our RFA Java examples to explicitly output hh:mm:ss:ms regardless of value and I see the following

....
if (entry.getFieldId()==1010)
{
        ps.print("/");
        OMMData data = entry.getData(def.getOMMType());
        OMMDateTime dt = (OMMDateTime)data;
        int hr = dt.getHour();
        int min = dt.getMinute();
        int sec = dt.getSecond();
        int msec = dt.getMillisecond();
        ps.print(hr + "::" + min + "::" + sec + "::" + msec);
}
....
Output:

FIELD_ENTRY 1010/10::24::51::0/VALUE_TS1: 10:24:51
FIELD_ENTRY 1010/10::25::0::0/VALUE_TS1: 10:25
FIELD_ENTRY 1010/10::25::4::0/VALUE_TS1: 10:25:04

So, as you can see when seconds are blank my code displays ::0 - but the existing example code does not display the seconds value.

Comment
jirapongse.phuriphanvichai

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Answer by jessie.lin · Jul 21, 2017 at 05:44 AM

LINK: https://pan.baidu.com/s/1dFEMnbN PWD: a2ui

The application is in link, actually it is the source code provided by Technical solution trainer of TR, could you help have a look where is the problem to lead this display hh:mm issue ? Thank you!

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Answer by umer.nalla · Jul 21, 2017 at 05:57 AM

I am on leave for a few days now. I would guess it is the toString() method that is being used to output the field value to the screen or file.

The developer should replace that with their own code, similar to my snippet above

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
7 People are following this question.

Related Questions

RFA versions

How to know when my SSL consumer application is disconnected from the server?

Under OMM model, does MarketDataItemEvent can be triggered?

NIP with 2 sessions

How can I detect a failure to connect to RFA?

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges