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.
 

Importing assets into Excel.
Author
Previous Topic Next Topic
Horiz Rin
Homebase69
#1 - 2015-08-01 08:26:12 UTC
Hi,

Is there a quick and easy way to bring some of my Eve possessions into Excel?

I'm an industry player, and I have a 'warehouse' that holds stock. I'd like to be able to get Excel to automatically retrieve the amount of (eg) Hammerheads in the hanger at station 'X'

I'm fairly good with Excel (I already have a decent spreadsheet that pulls data from eve-central) , but that's about the limit of my programming skills.

Failing an easy answer, any hints or tips on how to proceed would be really appreciated.


Thanks :)
Hel O'Ween
Men On A Mission
#2 - 2015-08-04 16:38:42 UTC
Assets is one of the more tricky APIs, as it needs recursion ("a thing in a thing in a thing located at") to fully resolve the location of an item.

Without VBA, I'm afraid you're out of luck with your request.

If you're just after "what's where?", have a look at jEveAssets.

If you want to work with your assets in Excel, have a look at my EVEWalletAware (see my signature). It allows manual exports to Excel. But unlike jEveAssets, my EWA isn't specialized in asset tracking. I'm also not sure if the export is of much help to you.

EVEWalletAware - an offline wallet manager.
Golden Gnu
Lobach Inc.
#3 - 2015-08-04 22:24:17 UTC
jEveAssets can export to CSV, that should be easy to import in excel
It has the added bonus that you don't have to resolve all the typeIDs, locationIDs etc.
Disclaimer: I'm the dev of jEveAssets

Drop me a note in the jEveAssets thread if you need any help with it...

Creator of jEveAssets - the asset manager

"Download is the meaning of life, upload is the meaning of intelligent life"
Horiz Rin
Homebase69
#4 - 2015-08-11 10:17:18 UTC
Thanks for the tips - and sorry for the delay in my posting, for some reason I'm not getting notifications of replies.

I've been using JEveAssets for a while but never thought of the csv approach. I was hoping for an 'integrated into Excel' solution (pure laziness I'll admit), but I'll give that a go.

Thanks once again :)

Steve