EVE Search - EVE data export, rmr edition

All Channels

EVE General Discussion

EVE data export, rmr edition

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Pages: 1 [2] 3 4 5 6 7 8 9 10 11 12 13 .. 13 :: one page
Author	Thread Statistics \| Show CCP posts - 12 post(s)
Darmed Khan	Posted - 2006.01.05 19:58:00 - [31] Originally by: Vaux Not to be picky, but in the type table, some of the descriptions of items are surrounded by quotes, while others are not. This is throwing off my script. I haven't finished downloading the files yet to see how well formatted the CSV data is, but it is perfectly acceptable for some entries to be quoted strings and others to be unqouted. I suggest you upgrade your CSV parser http://www.ietf.org/rfc/rfc4180.txt (I did find a simpler explanation when writing a parser once, but I guess that one will do)
Dowser	Posted - 2006.01.05 20:16:00 - [32] t20, two things. First, all description fields appear to be truncated at 255 characters in miscData. Second, can we get additional data for the ship bonuses. For example, Apocalypse has the shipBonusAB attribute with a value of -10. There is no way to programmatically correlate the value of shipBonusAB with the attribute it affects (in this case large energy turret capacitor use). A really hacky way would be to use the ship description, but the description is truncated.
Zydigo	Posted - 2006.01.05 22:25:00 - [33] Oh hell yes. I've been working on a script/webapp combo that uploads the exported market data csv files to a webapp which dumps them into a mysql db. If the station and system IDs match up between the two, I am set.
Sigillum Diaboli	Posted - 2006.01.05 22:59:00 - [34] Looks great, but the stations table seems to contain test data for Outposts, instead of information about the actual ones in the game. I was starting to wonder who this duperTum Corp was and how they got so rich ...
Dale Cussler	Posted - 2006.01.05 23:21:00 - [35] Many thanks Mr. t20 :D
Deliz Seemack	Posted - 2006.01.06 00:54:00 - [36] Thanks god, I'll be able to get my data fix. __________________________________________________ -He conquers who endures. -Never underestimate game companies' greed.
Dale Cussler	Posted - 2006.01.06 01:50:00 - [37] Small request for the next dump, if possible, to have it in XML format? The CSV files work fine to load into Excel, but any other tools I use to manipulate CSV files just plain out choke on it, mostly due to unescaped commas inside quoted strings. To get the data in XML format would be even nicer since that'll save me from having to do a few conversions.
jide	Posted - 2006.01.06 05:09:00 - [38] Originally by: Nyphur Originally by: Jack Tau Originally by: Nyphur Originally by: Jack Tau Originally by: Nyphur Any chance on getting the NPC data? It was apparantly removed from the eve game files. Or could we get at least a word on why it was removed? I was making heavy use of it and now I can't even check what damage types NPCs do any more. It's all in there, if you understand relational databases. I do. Which files is it in? The guys at http://www.evegames.hostingbig.com/eve/data/ told me it was removed. I ment no offense, sorry if it came out wrong :) I'm not going to sit here and explain exactly where it all is, it is a fairly big schema(And I havent made a sensibly formatted export for this latest feed yet), but I will say it all starts off with the main item type, which links via the Type ID to all the data you need. The two main files in the old feeds were "dgmAttributeTypes.csv" and "dgmTypeAttributes.csv". HTH, I'm still looking through the new feeds myself, but those should still be the right files. Thanks, I'll have a look at that later and inform the guys at http://www.evegames.hostingbig.com/eve/data/ if the data is still there. There's only one of me :P Anyway, I still don't think the data is in the cache files in the client. If they are they are very well hidden. They are in the dgmTypeAttributes.CSV from data_misc.rar though. I'll use it to complete what I have when I get a little more time on my hands.
Sigillum Diaboli	Posted - 2006.01.06 05:21:00 - [39] Originally by: Dale Cussler Small request for the next dump, if possible, to have it in XML format? The CSV files work fine to load into Excel, but any other tools I use to manipulate CSV files just plain out choke on it, mostly due to unescaped commas inside quoted strings. To get the data in XML format would be even nicer since that'll save me from having to do a few conversions. Commas don't need to be escaped inside quoted strings. That's the point of quoting the string.
Nightblade	Posted - 2006.01.06 05:23:00 - [40] It seems there are a few problems with the invTypes data. I tried opening in both Excel and OO.o 2 and both have some strange data. Couple of examples, Kernite has a volume of '1-Feb' and Carbonized Lead S has a volume of 8e+13. Anyone else see this or is it just me?
jide	Posted - 2006.01.06 06:08:00 - [41] Originally by: Nightblade It seems there are a few problems with the invTypes data. I tried opening in both Excel and OO.o 2 and both have some strange data. Couple of examples, Kernite has a volume of '1-Feb' and Carbonized Lead S has a volume of 8e+13. Anyone else see this or is it just me? It's not just you.
elFarto	Posted - 2006.01.06 09:49:00 - [42] Originally by: jide They are in the dgmTypeAttributes.CSV from data_misc.rar though. I'll use it to complete what I have when I get a little more time on my hands. It appears all the information that was hidden from the local cache files is here, including damage the NPC's do and the chance/range/strength of all their new abilities. \/ Regards elFarto Stratego > 2005.10.22 14:15:17 combat Imperium Alliance petitions you, glancing off causing no real damage.
Jack Tau	Posted - 2006.01.06 09:50:00 - [43] Originally by: Nightblade It seems there are a few problems with the invTypes data. I tried opening in both Excel and OO.o 2 and both have some strange data. Couple of examples, Kernite has a volume of '1-Feb' and Carbonized Lead S has a volume of 8e+13. Anyone else see this or is it just me? This is the same problem that was in the last feeds, there are commas inside the text fields... Obviously a CSV file relies on commas, so its all screwed up. Load the file up in a text editor and take all the commas out of text field, or surround all the text fields with speech marks. Enkidu Production Manager If you dont understand this sig, you need to get out less ;)
Ms Freak	Posted - 2006.01.06 13:07:00 - [44] Ok, I've just downloaded all the files EXCEPT the data_map.rar (the 200mb one) - i can see all the descriptions of items and stations and the map data etc thats all sweet. However i want to be able to see what each item (say a shield booster) does to what attributes. Where is this data stored?? Its prolly just me but i cant see it? some pointers would be nice :)
Phyra	Posted - 2006.01.06 13:17:00 - [45] t20: great stuff! could you include the NPC ships in your next update too pls? Shipname, Shiptype, rank (like in TomB's post, just complete) would suffice for me, although more info would be welcome. regards Phyra
Tanya Kovacs	Posted - 2006.01.06 13:19:00 - [46] Hey thanks alot for this data. Finally I can build my own little tools
Jaabaa Prime	Posted - 2006.01.06 18:41:00 - [47] Problem miscData_RMR.xls seems to be incorrectly formatted. All of the "Float/Real" fields are text fields and I can't get them to format correctly either. e.g. basePrice - ".0000" mass - "2500.0" "," would be the correct display for my NLS settings, so it's not as though the fields are even the correct type The last excel was ok, this one is broken. Any chance of getting one that is correctly formatted ? -- Mini Skill Planner
Nightblade	Posted - 2006.01.06 21:07:00 - [48] Originally by: Jack Tau This is the same problem that was in the last feeds, there are commas inside the text fields... Obviously a CSV file relies on commas, so its all screwed up. Load the file up in a text editor and take all the commas out of text field, or surround all the text fields with speech marks. The CSV files in this pull are fine. If you looked at the data, the table I was talking about is in the XLS file.
Nyphur	Posted - 2006.01.07 13:50:00 - [49] Originally by: jide There's only one of me :P Anyway, I still don't think the data is in the cache files in the client. If they are they are very well hidden. They are in the dgmTypeAttributes.CSV from data_misc.rar though. I'll use it to complete what I have when I get a little more time on my hands. Are you sure? I could have sworn there were at least eight jides :p. Thanks so much for getting the info back up. You're a lifesaver.
Netrunner	Posted - 2006.01.07 19:47:00 - [50] Great start for me, I was just looking to see if anyone had information like this!!! Does anyone know if there has ever been a data export for the ship and equipment information (Attributes, Manufacturing and Fittings Tabs for everything) and if so, can you post a link?? I've been gone a long time. Have ran some searches but not finding anything on this and I'm anxious to start some coding
Elissen	Posted - 2006.01.07 20:28:00 - [51] It's all in there I think Netrunner. Building information for sure as I use that, but I've seen tables of damage attrobutes. Download the files and take a very close look at them. ---- ICSC Red Moon Rising edition: Jumpplanner tool - Routeplanner for all jumpcapable ships!
Iron Wraith	Posted - 2006.01.08 15:09:00 - [52] alloha! agents have now moved. any idea when were gonna get the new data export? once again, thanks for this t20, really gonna help me find my new agent home Because sometimes you just have to go back to your roots: [2005.02.20 01:08:03] (combat) Your Civilian Light Electron Blaster perfectly strikes Serpentis Smuggler, wrecking for 20.3 damage.
Somatic Neuron	Posted - 2006.01.10 12:57:00 - [53] t20, can you please update for the new stuff that was released today? Also, on the materialForActivity tab, can you add columns for at least includeInWaste, and preferrably categoryID? ----------
Warner Caslet	Posted - 2006.01.11 01:55:00 - [54] The security column in the systems table confuses me. Why do some systems have nonsensical-seeming security values like -5755146957592.38 or 144366682.05? It doesn't seem to be just a decimal shift, as lots of 0.0-named systems have positive strange securities. Further, what is the meaning of the security class column?
Nightblade	Posted - 2006.01.11 02:17:00 - [55] Originally by: Warner Caslet The security column in the systems table confuses me. Why do some systems have nonsensical-seeming security values like -5755146957592.38 or 144366682.05? It doesn't seem to be just a decimal shift, as lots of 0.0-named systems have positive strange securities. This whole data pull is riddled with problems like this. I hope that they're fixed when the next version (with the updated agents) comes out, because in its current state this data is useless for most applications.
Somatic Neuron	Posted - 2006.01.11 12:57:00 - [56] Warp Disrupt Probe Blueprint info is missing from the Item Database, as is the graphic for both the Blueprint and the Probe itself. ----------
Jaabaa Prime	Posted - 2006.01.12 08:08:00 - [57] t20, I appreciate the effort made in releasing the data dump but could you please redo the excel sheet with the correct formatting so that it is useful. Thanks. -- Mini Skill Planner
elFarto	Posted - 2006.01.12 12:38:00 - [58] The dgmTypeAttributes.csv file is a bit odd too. Lots of values seem to have precision issues: Originally by: dgmTypeAttributes.csv 22000,930,NULL,0.14999999999999999 24146,930,NULL,1.4999999999999999E-2 24145,930,NULL,1.2500000000000001E-2 Any chance of getting an export without these problems? Regards elFarto Stratego > 2005.10.22 14:15:17 combat Imperium Alliance petitions you, glancing off causing no real damage.
Nightblade	Posted - 2006.01.12 17:09:00 - [59] Originally by: elFarto The dgmTypeAttributes.csv file is a bit odd too. Lots of values seem to have precision issues: Originally by: dgmTypeAttributes.csv 22000,930,NULL,0.14999999999999999 24146,930,NULL,1.4999999999999999E-2 24145,930,NULL,1.2500000000000001E-2 Any chance of getting an export without these problems? Regards elFarto That's not a problem. That's just normal floating point precision, and when I checked them out those are the proper values for double-precision numbers. What I mean is if you do: double x = 0.015; in C, what you get really is x = 1.4999999999999999E-2. When you print out the numbers just restrict the number of decimal places you use.
Gigi Barbagrigia	Posted - 2006.01.13 14:36:00 - [60] Originally by: Jaabaa Prime t20, I appreciate the effort made in releasing the data dump but could you please redo the excel sheet with the correct formatting so that it is useful. Acctually, I'd prefer each sheet as separate CSV file. ----- 42

Pages: 1 [2] 3 4 5 6 7 8 9 10 11 12 13 .. 13 :: one page
First page \| Previous page \| Next page \| Last page

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.