Pages: 1 2 :: [one page] |
|
Author |
Thread Statistics | Show CCP posts - 5 post(s) |
|

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
|
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. -- EVEWalletAware - an offline wallet manager |

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)?". 
~ CCP Prism X EVE Database Developer and Acting API Dude |
|

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:36 Um, 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
|
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. -- EVEWalletAware - an offline wallet manager |
|

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!
~ CCP Prism X EVE Database Developer and Acting API Dude |
|

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. ------- There is no magic Wand of Fixing, and it is not powered by forum whines. |

Somerset Mahm
Somer's Omnibus Exploration and Reclamation Cognitive Distortion
|
Posted - 2011.04.10 19:27:00 -
[16]
I 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. --- SOMER Lotteries SOMER Blink - new! SOMER Escrow Services |

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 --- creator and maintainer of eve commander - complete web based character information tool and ec agent finder |

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. --- creator and maintainer of eve commander - complete web based character information tool and ec agent finder |

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... :) --- creator and maintainer of eve commander - complete web based character information tool and ec agent finder |
|

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
|

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. ------- There is no magic Wand of Fixing, and it is not powered by forum whines. |

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 --- creator and maintainer of eve commander - complete web based character information tool and ec agent finder |

Mark Hamill
Amarr Galactic Waste Management
|
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???
EVETycoon Marketing, trading and reprocessing tool. |

woddel
Gallente Canis Industries Ltd Avaricious Cartel
|
Posted - 2011.05.04 05:29:00 -
[30]
important bump... --- creator and maintainer of eve commander - complete web based character information tool and ec agent finder |
|

Mark Hamill
Amarr Galactic Waste Management EVE Trade Consortium
|
Posted - 2011.05.07 17:54:00 -
[31]
Edited by: Mark Hamill on 07/05/2011 17:54:46
Originally by: Mark Hamill
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???
Oh the hell with it. Tired of waiting on responses to this and bugreports. Go play with your CQ. New features with bugs are ALWYAS more important than fixing what's broken. I'll do the same thing I did when you guys decided to change the way marketlog exports were named (i.e. Tash-Murkon-Small YF-12a Smartbomb-08302010.txt. What idiot uses the same token for field separators that are found in field names? NO. DON'FIX IT NOW. I've already made a workaround for this too). I'll yet again rewrite EVETycoon to unscrew your inability to stick to one format.
EVETycoon Marketing, trading and reprocessing tool. |

Etil DeLaFuente
|
Posted - 2011.05.18 09:07:00 -
[32]
Would it be possible to get an xsd for each of the API ? also, What is the purpose of having CharacterSheet and CharacterInfo ? If i want to have all the details about a character, i need to query both and aggregate the results. Resource and time consuming, not good.
CharacterSheet has some info missing in CharacterInfo (ancestry, DoB, gender, cloneName, cloneSkillpoints), and CharacterInfo has some info missing in CharacterSheet (skillpoints, security status, ship type, ship name). Both using the same api key level (full in this case).
CharacterInfo should be the header of CharacterSheet. Therefore, if i want all details, skills, certificates etc.. i'd only need to query CharacterSheet. If i don't care about skills and such, i'd only need to query CharacterInfo.
|

Dragonaire
Caldari Corax. Everto Rex Regis
|
Posted - 2011.05.18 14:54:00 -
[33]
I've made XSDs for many of the APIs which you can find in Yapeal. They are hiding in the cache/ directory for lack of a better place to put them for now I planned on extracting them into a separate download but having gotten around to that yet. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Etil DeLaFuente
|
Posted - 2011.05.18 22:06:00 -
[34]
Originally by: Dragonaire I've made XSDs for many of the APIs which you can find in Yapeal. They are hiding in the cache/ directory for lack of a better place to put them for now I planned on extracting them into a separate download but having gotten around to that yet.
Thanks, i'll have a look, but a better place would be on ccp's server and an xsd schema uri included in each XML content returned by the APIs. It's not like it's a brand new thing around...
|

Dragonaire
Caldari Corax. Everto Rex Regis
|
Posted - 2011.05.19 04:27:00 -
[35]
I'd like to see CCP use them during testing when they are making changes to the APIs so they'd catch some of the more glaring mistakes they always seem to have like misplaced <cachedUntil/> elements that keep breaking everyone's libraries/apps etc.
Be glad to have them use mine for that matter if it would help as I know it takes some time and testing to make the XSDs and insure they are validating things correctly Nice thing with XSDs are they should be all be one time work and only need a little TLC when changes are plan on one of the APIs. I even did a genetic one for all APIs that is used until I get around to making one for an API. You know with it that at least the basic structure is correct even if the core data part isn't. It insures everything is inside <eveapi/> that starts with a <currentTime/> and either a <error/> or <result/> element followed by <cachedUntil/> which isn't inside <result/> or missing and that the date/times are in the correct format. If they had been using something like that all along nearly 50% of the API errors I've seen would have been caught before it was released.  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
|
|
|
Pages: 1 2 :: [one page] |