These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Matching Journal And Transaction Entries
Author
Previous Topic Next Topic
Valda Abia
Science and Trade Institute
Caldari State
#1 - 2013-10-30 17:40:58 UTC
Does anyone have the updated algorithm to match API journal entries to API transaction entries? It used to be that journal.refID = transaction.journalTransactionID.

That doesn't seem to be the case anymore as a bunch of my entries now resolve to NULL. Looking at the API data, the journal RefID is off by 2-3 in some cases from the corresponding transaction JournalTransactionID.

It doesn't feel all that secure to match up client ID and time, as a large buying volume by one person might confuse the system. Is this an API bug, or just how we have to do things now?

Thanks in advance; fly safe
Paka-Tegat Birshiri
Paragon Material Extraction and Processing
#2 - 2013-10-30 18:57:42 UTC
I derped on the answer to this for a while.

As far as I can tell, transactions.journalTransactionID only matches one of the journal refIDs. If you're selling to someone, for example, you get a journal entry, they get a journal entry, and I think you also get a taxation journal entry. Each of these have different refIDs. The entry in the transactions dump only matches (I think) the buyer's refID, so as a seller, it doesn't match up.

However, you can go the other way. If you look at journal.argName1, you'll have a code. That corresponds to the transaction.transactionID. A little SQL magic can make that a rock-solid join to merge journal entries to transaction entries! Enjoy!

(Now, taxes and broker fees? That's a whole different animal. In theory, it's possible. In practice, you're better off just estimating, because the time you'll spend isn't worth it.)