These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

XML Excel Creator Full Item and Solar System Data Table Included
Author
Previous Topic Next Topic
Denbover Athonille
Edge Dancers
Pan-Intergalatic Business Community
#1 - 2013-01-15 23:19:00 UTC  |  Edited by: Denbover Athonille
Have you ever wanted to keep track of your items, and market prices within an Excel spreadsheet? Yet you never could figure out how to get the XML URL's to work?

Well today I am sharing my private XML creator for Excel.

It has every item id available online, and every solar system included in the database.

Simple instructions are provided within the document.

Please let me know if you have any questions or concerns, and I hope that some of you out there find this helpful.

Below is the file, and please know this is still a work in progress, and will be finished as I finish some other items on my agenda.

Take care, and fly safe.

Den

Excel Data Sheet - Rapidshare.com

Sheet was protected, this sheet has no protection on it.
Alex Grison
Grison Universal
#2 - 2013-01-15 23:25:02 UTC
Yes, let me just download some random Excel file, that came from who-knows-where.
That seems safe.

yes
Benjamin Arthie
Federal Navy Academy
Gallente Federation
#3 - 2013-01-16 00:42:39 UTC  |  Edited by: Benjamin Arthie
Make it a better download site and i might try it.

I'm not a low-sec roamer, i just need to blow off some steam every now and then.
Denbover Athonille
Edge Dancers
Pan-Intergalatic Business Community
#4 - 2013-01-16 03:07:40 UTC  |  Edited by: Denbover Athonille
Benjamin Arthie wrote:
Make it a better download site and i might try it.


Any suggestions? I'll upload to whatever site. Just looking to help others out with importing XML to Excel. As of now I changed the file share link to rapidshare.com. Let me know if you have another site you'd like it uploaded to.

Den
SinTeryx
Ministry of War
Amarr Empire
#5 - 2013-01-16 03:54:33 UTC
.xml files are scary, keyloggers ect. Source code my be a viable choice.

These may as well be farts in the wind but I have had a few beers since the start of this thread.
Kara Books
Deal with IT.
#6 - 2013-01-16 04:42:22 UTC
Im actually scared of puting my API key into one of those programs, the last one, lets just say to many coincidences happened.

This one, just run through kaspasrki website, 24-48 hours we will know.
Denbover Athonille
Edge Dancers
Pan-Intergalatic Business Community
#7 - 2013-01-16 06:53:51 UTC
Kara Books wrote:
Im actually scared of puting my API key into one of those programs, the last one, lets just say to many coincidences happened.

This one, just run through kaspasrki website, 24-48 hours we will know.



No API Key is required, this spreadsheet just allows you to search for an item and system where you'd like the price from and it gives you the eve-central xml url to use.

I'll post some screenshots sometime tomorrow.

Den
Denbover Athonille
Edge Dancers
Pan-Intergalatic Business Community
#8 - 2013-01-16 07:34:41 UTC
I decided to add some screenshots tonight with an explanation as to what is in the screenshot. All screenshots were uploaded to imgur.

Image One Myself downloading the file from RapidShare, as well as showing the file in my RapidShare Documents.

Image Two The first page of the Excel sheet. The item has a drop down list where you can pick your item, or type in the exact name as in game (Example 10MN Microwarpdrive II). The same goes for Solar System, every system in the game is in the drop down list. Or again you may enter your own with exact spelling as the game (Example from screenshot is 006-L3). As you can tell by the screenshot, when you change the item and the solar system the url for eve-central changes so you can upload the data as xml to your excel sheet.

Image Three Is the solar system master data. Nothing but a bunch of solar systems and id's.

Image Four Is the item master data. Again every item which I could find with an ID is in this list. I believe every item in the game is within this list, or almost every item. Big smile
Vera Algaert
Republic University
Minmatar Republic
#9 - 2013-01-16 09:37:47 UTC
SinTeryx wrote:
.xml files are scary, keyloggers ect. Source code my be a viable choice.

wut

.
Maurizio Chef
Direwolf-Rayet
#10 - 2013-01-16 14:12:05 UTC
SinTeryx wrote:
.xml files are scary, keyloggers ect. Source code my be a viable choice.


Huh?

Xml files are structured text files.

-- Pain Yields.
SinTeryx
Ministry of War
Amarr Empire
#11 - 2013-01-16 17:38:52 UTC  |  Edited by: SinTeryx
Maurizio Chef wrote:
SinTeryx wrote:
.xml files are scary, keyloggers ect. Source code my be a viable choice.


Huh?

Xml files are structured text files.


And? .xml files can contain executable commands...I am not saying Den has any intention of doing this but I am still wary of anything downloaded from a site like rapidshare. Just my personal opinion!
-Sin

EDIT: Den I will be downloading this on my laptop I don't play Eve on and testing it for visuses and giving it a shot, as I don't mean to tear apart you're attempt at something that can be very helpful :)
-Sin

These may as well be farts in the wind but I have had a few beers since the start of this thread.
Denbover Athonille
Edge Dancers
Pan-Intergalatic Business Community
#12 - 2013-01-16 18:30:51 UTC
SinTeryx wrote:
Maurizio Chef wrote:
SinTeryx wrote:
.xml files are scary, keyloggers ect. Source code my be a viable choice.


Huh?

Xml files are structured text files.


And? .xml files can contain executable commands...I am not saying Den has any intention of doing this but I am still wary of anything downloaded from a site like rapidshare. Just my personal opinion!
-Sin

EDIT: Den I will be downloading this on my laptop I don't play Eve on and testing it for visuses and giving it a shot, as I don't mean to tear apart you're attempt at something that can be very helpful :)
-Sin


In today's world everyone has the right to be afraid of the internet. I figure once people start testing it and I make it more presentable, it will help at least a few out.

Take care,

Den
Domin Ique
Team Pizza
Good at this Game
#13 - 2013-01-17 17:20:26 UTC
Download not available
Download permission denied by uploader. (0b67c2f5)

Sad
Aphelion Thunderclap
Caldari Provisions
Caldari State
#14 - 2013-01-17 17:25:39 UTC
noticed that as well yesterday sry for not posting been busy
Denbover Athonille
Edge Dancers
Pan-Intergalatic Business Community
#15 - 2013-01-17 17:56:02 UTC
Link is updated sorry for the problems, thanks for trying it out though Big smile.

Should work now, booting up the laptop to test it out.