Pages: 1 2 3 4 5 6 [7] 8 9 10 |
121. Reprocess formula. - in EVE Technology Lab [original thread]
I did Quote: Ships/mods would just be affected by default base facility level and Scrap metal Processing skill. Upgrades on citadels/stations do not affect it, nor do implants. So would be like Base_Facility_Refine * (1 + Scrapmeta...
- by Blacksmoke16 - at 2017.01.25 02:50:18
|
122. ESI Mail Endpoint - in EVE Technology Lab [original thread]
https://developers.eveonline.com/blog/article/esi-mail-endpoints Now.
- by Blacksmoke16 - at 2017.01.24 19:36:03
|
123. Reprocess formula. - in EVE Technology Lab [original thread]
Rounding: http://cdn1.eveonline.com/www/newssystem/media/66437/1/rounding.png Ore: Base_Facility_Refine * ((1 + Reprocessing_Skill * 0.03) * (1 + Reprocessing_Efficiency_skill * 0.02) * Refining_Implant) On Ores you would also have ...
- by Blacksmoke16 - at 2017.01.24 19:32:40
|
124. Trying to setup backend, get & save? - in EVE Technology Lab [original thread]
Ruby on Rails \o/ with rake files and Whenever gem to handle the scheduled tasks :)
- by Blacksmoke16 - at 2017.01.24 06:29:05
|
125. ESI. Mass market orders. - in EVE Technology Lab [original thread]
Or just cache the marketable items to its own table, update those prices every 15-30min then query the db prices vs using the ESI endpoint. This is what i do, there are around 11,000 marketable items. Takes about a minute or so to update prices ...
- by Blacksmoke16 - at 2017.01.23 01:26:56
|
126. having proble with this formulas on Google Sheet - in EVE Technology Lab [original thread]
You have no xPath. Make it like, and can change the paidUntil to get what element text you want. =IMPORTXML("https://api.eveonline.com/account/accountStatus.xml.aspx?keyID="&N1&"&"&"vCode="&O1,"//paidUntil")
- by Blacksmoke16 - at 2017.01.23 01:24:54
|
127. I need help with market data in excel. - in EVE Technology Lab [original thread]
And no, if you don't specify typeIDs it returns nothing. Best way to do it would be like get a list of all typeIDs you want, then do a query from Steve's api in group of 100 or so. Would be better than doing each item 1 by 1.
- by Blacksmoke16 - at 2017.01.22 22:54:23
|
128. xpath formula for parsing assets - in EVE Technology Lab [original thread]
Ok few things. typeName isn't included in the assetList endpoint so you would have to preimport a list from the SDE or something like that then usevLookup to get the names for each value. Best bet would be to just load in all of the data using t...
- by Blacksmoke16 - at 2017.01.22 16:11:38
|
129. (need help) XML import to spreadsheet from skill attributes and rank - in EVE Technology Lab [original thread]
Here you go =IMPORTXML("https://api.eveonline.com/eve/SkillTree.xml.aspx?keyID="&N1&"vCode="&O1,"//rowset[@name='skills']//rank") The rank is just text in an element not an attribute so you do not need the @ symbol.
- by Blacksmoke16 - at 2017.01.22 16:04:30
|
130. having proble with this formulas on Google Sheet - in EVE Technology Lab [original thread]
This works, just have to put in your xpath to get what element you want. =IMPORTXML("https://api.eveonline.com/account/accountStatus.xml.aspx?keyID="&N1&"&"&"vCode="&O1,"XPATH_HERE")
- by Blacksmoke16 - at 2017.01.22 05:47:50
|
131. having proble with this formulas on Google Sheet - in EVE Technology Lab [original thread]
Think you are missing some & signs, try this: =IMPORTXML("https://api.eveonline.com/account/AccountStatus.xml.aspx?keyID="&B3&"&"&"vCode="&C3,")
- by Blacksmoke16 - at 2017.01.22 04:39:17
|
132. Does ESI work with google sheets? - in EVE Technology Lab [original thread]
https://github.com/nuadi/googlecrestscript/blob/dc6b6e80ae9545f4d54490d1c217c3595757e4c4/MarketScript.gs Is the same script Steve linked but when he first made it and the endpoint required authorization.
- by Blacksmoke16 - at 2017.01.21 21:29:13
|
133. Add names to Corp Market Orders - in EVE Technology Lab [original thread]
Some tips that might be better are to just create an array with all the typeIDs from the marketOrders API and then do them all in a big batch. This will lead to faster load times as less requests will be required. Another option and probably bett...
- by Blacksmoke16 - at 2017.01.19 05:27:50
|
134. import from character standings in spreadsheet - in EVE Technology Lab [original thread]
I'm pretty sure there is a CREST endpoint for that? However i never used it so not sure if it is a thing or even implemented. If it is you would have to get into SSO and tokens however.
- by Blacksmoke16 - at 2017.01.18 23:15:14
|
135. ESI HTTP code 500 ({"error": "uncaught exception"... - in EVE Technology Lab [original thread]
Create an issue on the ESI github. Would at least make them aware if there is an issue. https://github.com/ccpgames/esi-issues/issues
- by Blacksmoke16 - at 2017.01.18 21:44:27
|
136. ESI Error 500 - in EVE Technology Lab [original thread]
https://github.com/ccpgames/esi-issues/issues/222 It is a known error that relates to a planet with an extractor with no specified resource for extraction.
- by Blacksmoke16 - at 2017.01.18 15:18:00
|
137. import from character standings in spreadsheet - in EVE Technology Lab [original thread]
If you look at the structure in your original xpath. "eveapi/result/rowset[@name='factions']/row/@standing" The structure from outermost node to inner most is: eveapi result characterNPCStandings rowset row You have the eveapi and resu...
- by Blacksmoke16 - at 2017.01.17 00:26:07
|
138. import from character standings in spreadsheet - in EVE Technology Lab [original thread]
You are missing the 'characterNPCStandings' in your xpath. This works as well: //rowset[@name='factions']/row/@standing
- by Blacksmoke16 - at 2017.01.16 23:47:37
|
139. An existing connection was forcibly closed by the remote host. - in EVE Technology Lab [original thread]
Thanks for the tip. It seems the issue only happens in ruby development environment. If i switch to production it works fine. I will continue to mess around with it and see if i can figure out why.
- by Blacksmoke16 - at 2017.01.16 15:50:32
|
140. An existing connection was forcibly closed by the remote host. - in EVE Technology Lab [original thread]
I have a strange issue when developing with the XML API. Whenever making a request to retrieve XML API data I get this error: 'An existing connection was forcibly closed by the remote host.' The strange thing about it is: Only happens with the X...
- by Blacksmoke16 - at 2017.01.16 14:01:32
|
Pages: 1 2 3 4 5 6 [7] 8 9 10 |
First page | Previous page | Next page | Last page |