| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Johnathan Walker
Caldari
Frontier Elements
   |
Posted - 2010.03.29 12:11:00 -
[1]
Hello! 
I've been scouring the forums (and loveable Google) for a solution to a puzzling challenge: making sense of the corporate assets XML imported into Excel. While I am able to retrieve the XML and get a nice pretty table with lots of rows and columns, the data is pretty much meaningless.
I'm specifically looking for the ability to import the amount of ore/minerals from a container within a corporate hangar at an NPC station; the container does not move or get repackaged (it's there to stay).
If there's any kind soul who could help me out in pulling this data, I would greatly appreciate it; this would save me from having to input it manually (yikes!).
Warmly
"The Bear" JW
|
Johnathan Walker
Caldari
Frontier Elements
|
Posted - 2010.03.30 11:43:00 -
[2]
Edited by: Johnathan Walker on 30/03/2010 11:44:38
Thanks for the replies folks, but to be honest... what are you talking about?  I don't speak Greek
Would either of you or the community at large mind explaining this linking and converting business?
Warmly,
"The Bear" JW
|
Johnathan Walker
Caldari
Frontier Elements
|
Posted - 2010.03.30 16:41:00 -
[3]
 Originally by: Dragonaire
If that doesn't make sense to you you might want to learn more about them by looking at some of the links of the first page I gave you as well as this Wikipedia article about http://en.wikipedia.org/wiki/Hierarchical_database_modelHierarchical database model[/url.
FYI: The DBSMAG URL's at the Yappeal wiki are outdated and do not connect.
Originally by: Dragonaire
and if you're still confused after look at soght think about finding an existing application
Good luck
Tried to do just that, but I have not found an application/spreadsheet that can tell me how many units of pyerite I have in our corporate hangar; hence the post. If you know of something that would prove this to be false, by all means I am all ears and eyes.
In short what it sounds like is this:
1) Download the corporate asset XML
2) Create references between each entry's ID to their corresponding values in the data dump, whether via Yappeal, Access, or (worst case scenario) a VLOOKUP.
3) Make useful presentation of the data obtained, for example, a pivot table.
Warmly,
"The Bear" JW
|
Johnathan Walker
Caldari
Frontier Elements
|
Posted - 2010.03.31 01:13:00 -
[4]
Originally by: Sidrat Flush
if you just want to know what minerals you've got in your corp hangar - just use Eve HQ
simple as.
While not exactly what I was looking to do, EveHQ opens up so much more functionality that I never even thought of to begin with. Brilliant suggestion Sidrat; thank you kindly!
Warmly,
"The Bear" JW
|
| |
|