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)
Iron Wraith	Posted - 2006.01.26 18:55:00 - [91] Originally by: FireFoxx80 Originally by: Iron Wraith thanks t20, you make us nerds very happy I think we prefer to be called application developers. lol, thats what we put on official forms. but i'm far enough through my therapy to admit the truth 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.
Zoon	Posted - 2006.01.26 19:32:00 - [92] Originally by: Pouah I know I'll look like a total newb but, what are we suppose to do with those files? If ya hafta ask, then you have no need for it __________________________________ Are you a mission runner? Have you tried Zoon's Agent Tool? You should!
Skyran	Posted - 2006.01.26 19:58:00 - [93] Originally by: Jack Tau The new SQL feed kicks ass, thank you very much T20. Throws out all his import scripts P.S. for peeps asking where data is, and if they can have extra data. Everything you need is in the feed, you just need to read through it and figure out how it all links together. Agents, bps, min requirements, module reqs., etc, etc. Its all in there. I'm sure that it is, but after running the TSQL batches into MSDE, applying relationships, and sifting through the data to the best of my ability, I am unable to determine where the data that says if a module is a Hislot, Midslot, or Lowslot... I would expect it to be linked in the invTypes->dgmTypeAttributes<-dgmAttributeTypes links, but I'm just not seeing it. Maybe I'm just a sub-standard nerd... err... Application Developer
Jack Tau	Posted - 2006.01.27 00:20:00 - [94] Edited by: Jack Tau on 27/01/2006 00:22:44 Originally by: Skyran Edited by: Skyran on 26/01/2006 22:13:49 Originally by: Jack Tau The new SQL feed kicks ass, thank you very much T20. Throws out all his import scripts P.S. for peeps asking where data is, and if they can have extra data. Everything you need is in the feed, you just need to read through it and figure out how it all links together. Agents, bps, min requirements, module reqs., etc, etc. Its all in there. I'm sure that it is, but after running the TSQL batches into MSDE, applying relationships, and sifting through the data to the best of my ability, I am unable to determine where the data that says if a module is a Hislot, Midslot, or Lowslot... I would expect it to be linked in the invTypes->dgmTypeAttributes<-dgmAttributeTypes links or maybe even the invGroups->invTypes link, but I'm just not seeing it. Maybe I'm just a sub-standard nerd... err... Application Developer [Edited for clarity] Well App developers aren't suppose to understand complicated database structures, thats for us SQL geeks ;) (Allthough you're not far wrong, so no offense ment) I've got all the data linked up now, and tomorrow at work I'll put it all into a lovely diagram and post the MDF & a JPG of it on my website to download. {edit} Ohh and there is some T-SQL to go with it as well, as the data sometimes dictates the structure too(/edit) Enkidu Production Manager If you dont understand this sig, you need to get out less ;)
Brad Stone	Posted - 2006.01.27 11:32:00 - [95] Got the CSV files downloaded and I'm looking at the agents stuff (dbo_agtAgents.csv, dbo_agtAgentTypes.csv and dbo_agtConfig.csv) Where are the agent's names? I can't find any of the csv files that list their names, only the id's
Skyran	Posted - 2006.01.27 15:40:00 - [96] Originally by: Brad Stone Got the CSV files downloaded and I'm looking at the agents stuff (dbo_agtAgents.csv, dbo_agtAgentTypes.csv and dbo_agtConfig.csv) Where are the agent's names? I can't find any of the csv files that list their names, only the id's I've been unable to find that information as well. In addition, I've been unable to find the NPCCorporation names as well as what fitting type a given module is. If anyone else knows where this infomation can be found within either the CSV or SQL files, letting us know would be greatly appreciated.
Jack Tau	Posted - 2006.01.27 15:40:00 - [97] I haven't had time to do all I planned, but I have got a diagram ready for items database(Missing the simple stuff such as factions and races), and some code to get out the atributes of any object(Using the typeID from the invTypes table). DataDiagram GetAttributes.sql As for the bloke asking about agents, I'm afraid the names were missed out of the data feed. T20, you listenin'? Enkidu Production Manager If you dont understand this sig, you need to get out less ;)
jide	Posted - 2006.01.27 15:55:00 - [98] Originally by: Skyran Edited by: Skyran on 26/01/2006 22:13:49 Originally by: Jack Tau The new SQL feed kicks ass, thank you very much T20. Throws out all his import scripts P.S. for peeps asking where data is, and if they can have extra data. Everything you need is in the feed, you just need to read through it and figure out how it all links together. Agents, bps, min requirements, module reqs., etc, etc. Its all in there. I'm sure that it is, but after running the TSQL batches into MSDE, applying relationships, and sifting through the data to the best of my ability, I am unable to determine where the data that says if a module is a Hislot, Midslot, or Lowslot... I would expect it to be linked in the invTypes->dgmTypeAttributes<-dgmAttributeTypes links or maybe even the invGroups->invTypes link, but I'm just not seeing it. Maybe I'm just a sub-standard nerd... err... Application Developer [Edited for clarity] The slot type is an effect, not an attribute. And dbo_dgmTypeEffects is missing.
Skyran	Posted - 2006.01.27 18:15:00 - [99] Originally by: jide Originally by: Skyran Edited by: Skyran on 26/01/2006 22:13:49 Originally by: Jack Tau The new SQL feed kicks ass, thank you very much T20. Throws out all his import scripts P.S. for peeps asking where data is, and if they can have extra data. Everything you need is in the feed, you just need to read through it and figure out how it all links together. Agents, bps, min requirements, module reqs., etc, etc. Its all in there. I'm sure that it is, but after running the TSQL batches into MSDE, applying relationships, and sifting through the data to the best of my ability, I am unable to determine where the data that says if a module is a Hislot, Midslot, or Lowslot... I would expect it to be linked in the invTypes->dgmTypeAttributes<-dgmAttributeTypes links or maybe even the invGroups->invTypes link, but I'm just not seeing it. Maybe I'm just a sub-standard nerd... err... Application Developer [Edited for clarity] The slot type is an effect, not an attribute. And dbo_dgmTypeEffects is missing. Ah-HAAAaaa! So the data IS missing as opposed to my data mining skills being inadequate. Thanks for the heads up so I can stop beating my head against the wall trying to figure out why I can't find the info.
Jack Tau	Posted - 2006.01.28 00:37:00 - [100] Originally by: Skyran Ah-HAAAaaa! So the data IS missing as opposed to my data mining skills being inadequate. Thanks for the heads up so I can stop beating my head against the wall trying to figure out why I can't find the info. There not completely missing, just well hidden as always ;) In the CSV export, the file is present and contains the new data. The agent data is unfortunately flawed in both feeds though :( Enkidu Production Manager If you dont understand this sig, you need to get out less ;)
jide	Posted - 2006.01.28 04:29:00 - [101] Originally by: Jack Tau Originally by: Skyran Ah-HAAAaaa! So the data IS missing as opposed to my data mining skills being inadequate. Thanks for the heads up so I can stop beating my head against the wall trying to figure out why I can't find the info. There not completely missing, just well hidden as always ;) In the CSV export, the file is present and contains the new data. The agent data is unfortunately flawed in both feeds though :( The slot type is given by dgmtypeeffects. effectID 11 is for a low power slot, 12 for a high power slot and 13 for a medium. This is not to be confused with the attributeID of 11, 12 and 13 that list the number of low, high and med slots of a ship. Are you saying that the slot type of a module is in data_misc_csv.rar ? It doesn't look that way to me. Feel free to prove me wrong though.
Jack Tau	Posted - 2006.01.28 09:59:00 - [102] Originally by: jide Originally by: Jack Tau Originally by: Skyran Ah-HAAAaaa! So the data IS missing as opposed to my data mining skills being inadequate. Thanks for the heads up so I can stop beating my head against the wall trying to figure out why I can't find the info. There not completely missing, just well hidden as always ;) In the CSV export, the file is present and contains the new data. The agent data is unfortunately flawed in both feeds though :( The slot type is given by dgmtypeeffects. effectID 11 is for a low power slot, 12 for a high power slot and 13 for a medium. This is not to be confused with the attributeID of 11, 12 and 13 that list the number of low, high and med slots of a ship. Are you saying that the slot type of a module is in data_misc_csv.rar ? It doesn't look that way to me. Feel free to prove me wrong though. Yup, thats what Im saying. Got the CSV file dbo_dgmEffects.csv open right now, and I can see those effects. Enkidu Production Manager If you dont understand this sig, you need to get out less ;)
Vessper	Posted - 2006.01.28 11:26:00 - [103] Originally by: Jack Tau Yup, thats what Im saying. Got the CSV file dbo_dgmEffects.csv open right now, and I can see those effects. I have to agree with Jide here, I can't find any file with the above name or any field in the other .csv or .sql files that indicates the slot type of a module. Any chance of sharing that file?
Arx Nemesis	Posted - 2006.01.28 20:02:00 - [104] you are my hero t20 ----------------------------------------- The price of freedom is eternal vigilance
jide	Posted - 2006.01.28 20:07:00 - [105] Originally by: Jack Tau Yup, thats what Im saying. Got the CSV file dbo_dgmEffects.csv open right now, and I can see those effects. Oh, I downloaded the rar files again and dbo_dgmEffects is in there now. It wasn't before.
jide	Posted - 2006.01.28 20:09:00 - [106] dbo_eveNames has been added too. And it has the names for the agents.
Jack Tau	Posted - 2006.01.29 11:22:00 - [107] Originally by: jide Originally by: Jack Tau Yup, thats what Im saying. Got the CSV file dbo_dgmEffects.csv open right now, and I can see those effects. Oh, I downloaded the rar files again and dbo_dgmEffects is in there now. It wasn't before. That would explain it! I only bother with the construction part of the download, so I only looked for effects after it was found to be missing.. Enkidu Production Manager If you dont understand this sig, you need to get out less ;)
fahman dude	Posted - 2006.01.29 11:43:00 - [108] Thanks a bazillion dudes
Iavia	Posted - 2006.01.29 13:54:00 - [109] I'em teh SQL nub, so pardon the questions. I've not had any problems getting the files in to MySql beyond some CHARs that where > 255 and they where easy enough to fix. And one table that had .csv in it's name I was curious if any one had noticed if what the NPC corps where buying/selling is hiding in here some where I'm not seeing it. Also I'm having trouble finding any good information on building good indexes. I've built some, and they've helped the speed of many of my selects by many orders of magnitude, but I think I could do better. Can anyone point me at something to read?
Sulfiro Domonas	Posted - 2006.01.29 15:41:00 - [110] totally off-topic: t20 are you who I think you are? (ex (maybe still) FL.be - FL.net crew member )
Gal'tashec	Posted - 2006.01.29 17:47:00 - [111] select * Just curious.. I can't seem to find the capacity of the cargo bay on a ship.. the drone bay capacity is there but not cargo. Very simple test query from dbo.dbo_dgmTypeAttributes join dbo.dbo_dgmAttributeTypes on dbo.dbo_dgmAttributeTypes.attributeID = dbo.dbo_dgmTypeAttributes.attributeId join dbo.dbo_eveUnits on dbo.dbo_eveUnits.unitId = dbo_dgmAttributeTypes.unitId where typeId in ( select typeid from dbo.dbo_invTypes where typeName = 'vexor' ) isn't it exported or am I missing something?
Skyran	Posted - 2006.01.29 18:20:00 - [112] Originally by: jide Originally by: Jack Tau Yup, thats what Im saying. Got the CSV file dbo_dgmEffects.csv open right now, and I can see those effects. Oh, I downloaded the rar files again and dbo_dgmEffects is in there now. It wasn't before. Just to confirm, the data is located in the files as Jide has said. Just need to redownload. Thanks T20! -------------------------------------- Nope... no sig here... move along.

t20	Posted - 2006.01.29 19:30:00 - [113] Originally by: Sulfiro Domonas totally off-topic: t20 are you who I think you are? (ex (maybe still) FL.be - FL.net crew member ) the very same


t20	Posted - 2006.01.29 19:32:00 - [114] Originally by: jide Oh, I downloaded the rar files again and dbo_dgmEffects is in there now. It wasn't before. Originally by: jide dbo_eveNames has been added too. And it has the names for the agents. my ad for not mentioning this before, but these two files have been added now in both the csv amd sql packages. have fun with the goodies

Zoon	Posted - 2006.01.29 22:48:00 - [115] Now that I've imported all the original zip and the two newly added tables, I am quite gobsmacked at just what can be done with the data. If I can find the time, I'm going to do everything!! Expand my agent tool, ice belt searches, NPC database, ship fittings maybe? It's making me dizzy just thinking __________________________________ Are you a mission runner? Have you tried our Agent Tool and Mission Guides? You should!
Ayla Vanir	Posted - 2006.01.30 04:19:00 - [116] Been having a problem updating a mysql db with the new dbo_dgmEffects.sql file. At this point, I think the file is corrupted with a non-printing character somewhere between the start of the file and the start of the 2nd record. Haven't really got the experience to confirm, so I've entered in the table definition and first couple of records manually. For my own sanity though, I'm curious if anyone else was having trouble with this dbo_dgmEffects.sql file. Escrow Market Revamp
Gal'tashec	Posted - 2006.01.30 09:35:00 - [117] Ayla Vanir, I imported that table into a SQL Server 2000 database last night without any problems. Now to find out where I can find the cargo capacity of a ship

t20	Posted - 2006.01.30 10:53:00 - [118] Originally by: Gal'tashec Ayla Vanir, I imported that table into a SQL Server 2000 database last night without any problems. Now to find out where I can find the cargo capacity of a ship dbo_invTypes > capacity

Jack Tau	Posted - 2006.01.30 12:02:00 - [119] I've updated my diagram with the new tables, so it should all be there now. I've excluded the names table because its another simple join, and one of the links has a label on it, because its an "IF NOT NULL" that you'll need to code around. Linking Diagram Enkidu Production Manager If you dont understand this sig, you need to get out less ;)
Jack Tau	Posted - 2006.01.30 12:09:00 - [120] Originally by: Iavia I'em teh SQL nub, so pardon the questions. I've not had any problems getting the files in to MySql beyond some CHARs that where > 255 and they where easy enough to fix. And one table that had .csv in it's name I was curious if any one had noticed if what the NPC corps where buying/selling is hiding in here some where I'm not seeing it. Also I'm having trouble finding any good information on building good indexes. I've built some, and they've helped the speed of many of my selects by many orders of magnitude, but I think I could do better. Can anyone point me at something to read? Is this in MySQL? Indexes work slightly differently in all databases, so it would have to be specific advice. Generally you should try to keep the indexes as small as possible, and run an execution plan(Can you do that in mySQL? If not get a tool to do it) to spot where your queries are slowing down and alter your indexes to help. Enkidu Production Manager If you dont understand this sig, you need to get out less ;)

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.