| Author |
Topic |
CCP Stillman
 |
Posted - 2011.04.01 11:12:00 - [ 1]
Hi everyone, Here's a heads-up on the patch notes for Incursion 1.4. Exact schedule for when that will go out is to be announced, but following changes will be made when it goes live: - Fixing breakages in the Wallet Journal walker marking itself as consumed prematurely. Walker should now always allow for a full month of data and will just display the "first page" in the history if it receives weird input.
- Raising the maximum rowCount to 2560
- Changing the MarketTransaction calls to behave just like the Journal Transactions. Should also be fully backwards compatible.
- Renaming Character Sheet element "unpublished" to "published" to conform with the Skill Tree API. All skill rows should contain all elements now.
- Fixing an error with displaying the alliance of characters in new player corporations.
|
Andy Rogerson |
Posted - 2011.04.01 15:15:00 - [ 2]
April Fools?
Seriously though, nice to see API updates continue to come out. Now... on that API for the S&I BPO/BPC list :) |
CCP Stillman
|
Posted - 2011.04.01 21:54:00 - [ 3]
 Originally by: Andy Rogerson
April Fools?
Seriously though, nice to see API updates continue to come out. Now... on that API for the S&I BPO/BPC list :)
If I had put the S&I BPO/BPC list on the OP, then it'd have been April Fools. Why is everybody on the internet so suspscious of everything on this particular day of the year. I don't understand. I'd never fool anybody.  But this is definitely legit  |
Cyerus
Galactic Dominion
Eternal Strife |
Posted - 2011.04.02 00:25:00 - [ 4]
Will the Incursion 1.4 release include a new database dump which will fix the meta level issues that the current database dump has? |
Catari Taga
Centre Of Attention
Middle of Nowhere |
Posted - 2011.04.02 01:24:00 - [ 5]
Originally by: Cyerus
Will the Incursion 1.4 release include a new database dump which will fix the meta level issues that the current database dump has?
Without having any inside information I can nevertheless give you a confident: No! |
Cyerus
Galactic Dominion
Eternal Strife |
Posted - 2011.04.02 13:54:00 - [ 6]
Originally by: Catari Taga
Originally by: Cyerus
Will the Incursion 1.4 release include a new database dump which will fix the meta level issues that the current database dump has?
Without having any inside information I can nevertheless give you a confident: No!
Situation is explained in the link below. Although the query works in about 90% of the cases, it's a work around for the wrongly filled fields in the DB-dump. http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1483568 |
Hel O'Ween
Men On A Mission
EVE Trade Consortium |
Posted - 2011.04.06 12:56:00 - [ 7]
Hi CCP Stillman, Originally by: CCP Stillman
- Changing the MarketTransaction calls to behave just like the Journal Transactions. Should also be fully backwards compatible.
can you please be a bit more specific with that one? Does "behaves like journal" mean - there's a new (optional) parameter "rowCount" with a max. value of 2560? - the parameter "beforeTransID" is now named "fromID" Thx in advance for a clarification. |
Catari Taga
Centre Of Attention
Middle of Nowhere |
Posted - 2011.04.06 16:08:00 - [ 8]
Originally by: Hel O'Ween
Hi CCP Stillman,
Originally by: CCP Stillman
- Changing the MarketTransaction calls to behave just like the Journal Transactions. Should also be fully backwards compatible.
can you please be a bit more specific with that one? Does "behaves like journal" mean
- there's a new (optional) parameter "rowCount" with a max. value of 2560?
- the parameter "beforeTransID" is now named "fromID"
Thx in advance for a clarification.
Would like to know this, too. None of rowCount, beforeTransID, beforeOrderID or fromID seem to have any effect. |
CCP Prism X
Gallente
C C P
C C P Alliance |
Posted - 2011.04.06 17:49:00 - [ 9]
Originally by: Catari Taga
Would like to know this, too. None of rowCount, beforeTransID, beforeOrderID or fromID seem to have any effect.
Well, that sounds exactly like peoples experience with the new journal transactions call so.. mission accomplished, eh?  But I, obviously, jest. Essentially the rowCount controls the number of transactions returned. A supplied fromID / beforeRefID will be used to page backwards in time starting with, but not including, the transactionID passed in. Not passing in a fromID / beforeRefID (they are the same argument) will fetch the oldest rowCount transactions that are new (similar to the journal) although this is very likely to change soon because nobody likes it refreshing the oldest newest records first rather than the newest newest.. if that makes sense. Either way if this isn't working I'll sit down and fix it first thing tomorrow. |
Catari Taga
Centre Of Attention
Middle of Nowhere |
Posted - 2011.04.06 23:24:00 - [ 10]
Originally by: CCP Prism X
Either way if this isn't working I'll sit down and fix it first thing tomorrow.
I just tried again with rowCount=50 and received the full list as usual. |
CCP Prism X
Gallente
C C P
C C P Alliance |
Posted - 2011.04.07 09:31:00 - [ 11]
Stillman tells me he cannot reproduce any issues with the transaction walker. I'm not quite sure what to make of your last post Catari so: "Is there an issue here and if so can I get a description of reproduction steps (or just a bug report)?".  |
Catari Taga
Centre Of Attention
Middle of Nowhere |
Posted - 2011.04.07 11:30:00 - [ 12]
Edited by: Catari Taga on 07/04/2011 11:35:36Um, actually there is no issue, I just realized you are actually referring to WalletTransactions when you say MarketTransactions. My bad, that call works fine, sorry for creating extra work. |
Hel O'Ween
Men On A Mission
EVE Trade Consortium |
Posted - 2011.04.07 13:43:00 - [ 13]
Originally by: CCP Prism X
A supplied fromID / beforeRefID will be used to page backwards in time starting with, but not including, the transactionID passed in. Not passing in a fromID / beforeRefID (they are the same argument) will fetch the oldest rowCount transactions that are new (similar to the journal) although this is very likely to change soon because nobody likes it refreshing the oldest newest records first rather than the newest newest.. if that makes sense.
OK, if the beforeRefID in your above answer is a typo and you actually meant beforeTransID (which is/was the parameter name for Wallet Transactions), I'm fine with that. |
CCP Prism X
Gallente
C C P
C C P Alliance |
Posted - 2011.04.07 15:02:00 - [ 14]
Originally by: Hel O'Ween
OK, if the beforeRefID in your above answer is a typo and you actually meant beforeTransID (which is/was the parameter name for Wallet Transactions), I'm fine with that.
Yeah sorry, crossed wires with the wallet journal there. beforeTransID it is! |
Matthew
Caldari
BloodStar Technologies
|
Posted - 2011.04.09 23:42:00 - [ 15]
Is anyone else seeing the following with WalletJournal?
1) Walker is not going back for the full month of data, seems to only go back to when Incursion 1.4 was applied.
2) Even using Rowcount=2560, the "fill forward" technique in place for fetching new records is still only fetching 256 new records at a time, therefore removing the most useful reason for increasing the maximum rowcount. |
Somerset Mahm
Somer's Omnibus Exploration and Reclamation
Cognitive Distortion |
Posted - 2011.04.10 19:27:00 - [ 16]
Edited by: Somerset Mahm on 10/04/2011 19:59:29Edited by: Somerset Mahm on 10/04/2011 19:45:21I am having a horrid time with the WalletJournal lagging behind during periods of intense journal activity. I pull every 27 minutes, so as often as I can. During that time I might have 100-150 wallet entries. Most recent example: I pulled at 19:00. cachedUntil says "cached until 19:27". The most recent entry in the journal that I get back is 2011-04-10 18:28:00, and so I'm missing about 60 journal entries from 18:29 to 19:00. I can tell you now that when I pull at 19:27, I'm going to get most or all of those 60, but no new ones (no entries since 19:00). Then on the pull at 19:54 I'll get most of the data from 19:00 to 19:27, and so on. This will continue until activity dies down to 20-30 wallet journal entries per 27 minutes, at which point the API will catch back up. It's highly frustrating because I can't rely on the API to provide data at the times it's supposed to. Edit: Pull at around 19:29 got me data until 2011-04-10 19:11:00, with cachedUntil = 2011-04-10 19:56:21 Edit 2: I am highly late to the party I guess. Specifying a very high rowcount does fix the problem; I was not aware that the behavior had changed from showing the newest new entries to the oldest new entries. Gah :P |
woddel
Gallente
Canis Industries Ltd
Avaricious Cartel |
Posted - 2011.04.11 12:59:00 - [ 17]
hia prism
a big issue i just found out is that in every cell 'reason' with some content in it, there seems to be an extra chr(13) or chr(10). if you open the file in notepad, they don't display, but when opened in an advanced editor it looks like this:
2011-03-18 09:17:00,4077997905,Player Donation,woddel,XXX,,-200000000.00,875450057.65,DESC: zealot
,,
2011-03-12 12:17:00,4050286332,Player Donation,woddel,XXX,,-100000000.00,1025450057.65,DESC: skills
,,
2011-03-11 20:22:00,4047197965,Player Trading,woddel,XXX,Rens VI - Moon 8 - Brutor Tribe Treasury,0.00,1125450057.65,,,
2011-03-11 19:31:00,4046977885,Player Trading,XXX,woddel,Dodixie IX - Moon 20 - Federation Navy Assembly Plant,0.00,1125450057.65,,,
last two lines are ok, for reference.
this breaks my whole importer in eve commander because it sees extra line feeds and throws me an error with 'Incorrect number of columns in row. ' (coldfusion 8 as application server used).
can you dig into this? do something like a 'trim(reason)' or so when generating the export.
many thanks in advance!, woddel |
woddel
Gallente
Canis Industries Ltd
Avaricious Cartel |
Posted - 2011.04.11 13:31:00 - [ 18]
Edited by: woddel on 11/04/2011 13:32:19
detail about advanced editor: it even works in word - simply drag it into word and you see what i mean.
and last : what is the 'DESC: ' for in the reason field? i don't remember seeing this before. |
Lutz Major |
Posted - 2011.04.11 13:44:00 - [ 19]
Originally by: woddel
a big issue i just found out is that in every cell 'reason' with some content in it, there seems to be an extra chr(13) or chr(10). if you open the file in notepad, they don't display, but when opened in an advanced editor it looks like this
It's an additional line feed and is represented as '&# xA;'. It first occured on 7th of April. I think it has something to do with normalizing the XML attribute data. The DESC was introduced not long ago to differentiate between no description and an empty description. |
woddel
Gallente
Canis Industries Ltd
Avaricious Cartel |
Posted - 2011.04.11 13:51:00 - [ 20]
what do you mean with '&# xA;' ? this does not seem to be a proper formated asci-html-conversion thingy. do you have the numeric ascii-code for it?
and i hope it gets removed again... it's got no reason to be there in a csv file with return as delimiter when some apps interpret this character as a return or line feed... :) |
Lutz Major |
Posted - 2011.04.11 14:04:00 - [ 21]
Originally by: woddel
what do you mean with '&# xA;' ? this does not seem to be a proper formated asci-html-conversion thingy. do you have the numeric ascii-code for it?
and i hope it gets removed again... it's got no reason to be there in a csv file with return as delimiter when some apps interpret this character as a return or line feed... :)
Sorry, I should have mentioned, that between the # and the x is no space, but then the forum will display the character as what it is: a Line feed  Please visit your user settings to re-enable images. |
Sua Vis |
Posted - 2011.04.11 17:40:00 - [ 22]
Originally by: Matthew
Is anyone else seeing the following with WalletJournal?
1) Walker is not going back for the full month of data, seems to only go back to when Incursion 1.4 was applied.
Yes, I'm acknowledge this behave for corporation walletJournal accountID=1002. No matter of what fromID I add its only the last entries at maximum going back to 2011-04-10 01:00 Originally by: Matthew
2) Even using Rowcount=2560, the "fill forward" technique in place for fetching new records is still only fetching 256 new records at a time, therefore removing the most useful reason for increasing the maximum rowcount.
Can't acknowledge this .. as I do get more entries, but limited by 1) I could go back in time in steps of 50 is the past .. now I cant even do that ... CCP Prism X, any hints? |
Matthew
Caldari
BloodStar Technologies
|
Posted - 2011.04.11 23:40:00 - [ 23]
Originally by: Sua Vis
Originally by: Matthew
2) Even using Rowcount=2560, the "fill forward" technique in place for fetching new records is still only fetching 256 new records at a time, therefore removing the most useful reason for increasing the maximum rowcount.
Can't acknowledge this .. as I do get more entries, but limited by 1)
I can get more than 256 entries in total (once enough data had populated into the API cache) but it never adds more than 256 new entries in a single caching period. So it appears that ROWCOUNT can be 2560 for the purposes of how many records the API returns, but I assume that when the API cache derives FILLFORWARDCOUNT, that it still caps this value at 256. |
Firesh
Etoilles Mortant Ltd.
Solyaris Chtonium |
Posted - 2011.04.14 15:57:00 - [ 24]
Originally by: woddel
a big issue i just found out is that in every cell 'reason' with some content in it, there seems to be an extra chr(13) or chr(10). if you open the file in notepad, they don't display, but when opened in an advanced editor it looks like this:
yep. this extra char broke our statistics tools as well. replaced a lot of mysql statements with "LIKE" instead of "=" over the last day. ah well ;) |
Sua Vis |
Posted - 2011.04.14 16:10:00 - [ 25]
Don't know how it's applying to you.
For my part, I could query all missing data the "wanted" way today.
Needs to be approved, whats happening the next days. The 2560/256 problem seems solved.
Hopefully :) |
hankey
Minmatar
The xDEATHx Squadron
Legion of xXDEATHXx |
Posted - 2011.04.15 13:43:00 - [ 26]
I think issue with extra line break after DESC field is still presents.
CCP Stillman, do you guys have plans to sort it out?
|
hankey
Minmatar
The xDEATHx Squadron
Legion of xXDEATHXx |
Posted - 2011.04.16 11:34:00 - [ 27]
Tried to export wallet journal in cvs format, it also contains line breaks after reason field |
woddel
Gallente
Canis Industries Ltd
Avaricious Cartel |
Posted - 2011.04.20 16:13:00 - [ 28]
any news on the csv wallet journal export, ccp? we really really would appreciate the, i assume, like 15 minutes it takes to fix this very important issue. pleeeeeaaaase... :)
regards, woddel |
Mark Hamill
Amarr
Galactic Waste Management
EVE Trade Consortium |
Posted - 2011.04.27 19:48:00 - [ 29]
Originally by: hankey
I think issue with extra line break after DESC field is still presents.
CCP Stillman, do you guys have plans to sort it out?
Could we please get an answer to this???? CSV exports look like this now 2011-04-24 12:45:00,4246641101,Planetary Construction,Mark Hamill,CONCORD,Planet IV,-250000.00,4424711487.48,"Construction on EveLocation ID: 40344524, ""Planet IV"": 1 x Gas Storage Facility ",, with lots of extra line breaks. Is CCP gonna fix this or do I once again start writing anti-ccp-borked code to straighten out your messes??? |
woddel
Gallente
Canis Industries Ltd
Avaricious Cartel |
Posted - 2011.05.04 05:29:00 - [ 30]
important bump... |
All Channels
EVE Technology Lab